Xirian wrote:

I hope that someone here can help me out with this mod I added to my site. I tried to go straight to the source, but they have issues with their own SQL that won't allow me to register at their site.

I will try to be as detailed as possible in my question, but if you need more information in order to assist me, please let me know.

I installed the mod both recommended ways in the install file. They both worked and I was able to add poetry and everything seems to be working fine except in the admin area.

When I go to validate a poem that has been submitted, I get the errors, but the poems do get validated and everyone who is a registered member can read them.

I submitted 5 poems today and this is what I see everytime I go to the Admin panel and click on the poetry icon:

Quote:

Current Poems (click on names to EDIT) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I'm not exactly sure what the problem is or exactly where to look for the problem to fix it. I know it has something to do with MySql, but when I went there and looked at things there, I didn't know what exactly I should do after that.

I run a phpnuke 7.8 website.

I installed the Enchanted_Poetry module which you can find:
Enchanted Poetry for php-nuke 7.4 and above

Any assistance from anyone here would be extremely appreciated!!!

Posted: Tue May 15, 2007 5:08 pm

Xirian wrote:

admin wrote:

hi, do you get the errors before or after the you click to validate the poems? I have a copy of the module now and I am taking a look at the codes.

Hello, I get the error after I hit the validation key. Also, I've found another similar error when I'm in the admin panel and I click on "View Categories" and then click on "Page 2" since I have three pages of categories.

The error I receive when I click on "Page 2" or "Page 3" is the following:

Quote:

Current Categories You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15, 15' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15, 15' at line 1

However, if I just click on "Next" and not the page numbers, I don't get the error at all.

I hope this answers your question. Please let me know if you need more information and I thank you so much for responding so quickly!!!

Posted: Tue May 15, 2007 6:23 pm

Xirian wrote:

Hello again,

I did as you suggested and I got the same error.

Quote:

Current Poems (click on names to EDIT) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Sadly, I'm sure it's something extremely simple, but I just don't know what it is. I hope something can be figured out and I appreciate you taking the time to help me with this tonight.

Posted: Tue May 15, 2007 7:18 pm