sql_layer error with Enchanted Poetry module

Nuke Soldier Joined: Jul 05, 2004 Posts: 16

Got this error in Enchanted poetry module when going to styles to view some poetry

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in php/html/includes/sql_layer.php on line 286

Warning: Division by zero in /php/html/modules/Enchanted_Poetry/index.php on line 145

The first error message is one I got more often, can it be that in an older version then phpNuke 7.3 the includes/sql_layer.php file is so much different where for this module doesn't work properly anymore?

Can anyone help me to solve this problem?

Posted: Sat Oct 02, 2004 10:23 pm

Do you have a link to download that module, what it seems, your module is calling an SQL string that doesn't exist in your database. Did you upload/run the install script for the module?

Nuke Cadet Joined: Jun 19, 2005 Posts: 3

I could have sworn I posted here yesterday and now it's gone. I will repost again, just in case it was an error on my part. I have received no pms stating that it was deleted by someone else, so here I go again. If you do not support this mod, please just let me know and I will move on.

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 don't know what version of mod this is, but I installed the Enchanted_Poetry module download which you can find at the link below:

Enchanted Poetry for php-nuke 7.4 and above

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