Enchanted_Poetry Module Questions and error

New Member Joined: Jan 06, 2007 Posts: 8

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:

Only registered users can see links on this board! Get registered or login!

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

Sells PC To Pay For Divorce Joined: Posts: 5661

so you dont have access to the mysql by phpmyadmin to have a look ?

registered · Posted: Wed May 16, 2007 5:55 pm

Does sound to me like a mySQL version issue. My guess is that the script was written for 3.x, 4.0.x or 4.1.x, but you are using maybe 5.x.

If you can isolate the specific INSERT statement that is causing this and post the structure (only - no data) here (can get from phpMyAdmin as hitwalker suggests), we might be able to spot the issue.

If I had to guess, we could probably fix this with adding a simple default to the field or fields.

Posted: Fri May 18, 2007 9:39 am

hitwalker wrote:

so you dont have access to the mysql by phpmyadmin to have a look ?

Yes, I do have access to mysql and I've looked there, but I don't know exactly what to look for. I also have the sql tables that I added. I'll post them here in a quote, but you can also download the mod and you will see the sql tables in a text file.

Enchanted_Poetry sql wrote:

--
-- Table structure for table `nuke_poetry`
--

CREATE TABLE `nuke_poetry` (
`poemid` int(11) NOT NULL auto_increment,
`author` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`title` varchar(100) NOT NULL default '',
`cat` varchar(10) NOT NULL default '',
`poem` text NOT NULL,
`rating` varchar(100) NOT NULL default '0',
`ratingtot` varchar(100) NOT NULL default '0',
`hits` int(100) NOT NULL default '0',
`ratings` varchar(10) NOT NULL default '',
`style` varchar(10) NOT NULL default '',
UNIQUE KEY `id` (`poemid`)
) TYPE=InnoDB AUTO_INCREMENT=3 ;

--
-- Dumping data for table `nuke_poetry`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_poetry_categories`
--

CREATE TABLE `nuke_poetry_categories` (
`poemcid` int(11) NOT NULL auto_increment,
`catname` varchar(150) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
UNIQUE KEY `id` (`poemcid`)
) TYPE=InnoDB AUTO_INCREMENT=23 ;

--
-- Dumping data for table `nuke_poetry_categories`
--

INSERT INTO `nuke_poetry_categories` VALUES (1, 'Love', '');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_poetry_comments`
--

CREATE TABLE `nuke_poetry_comments` (
`pcomid` int(11) NOT NULL auto_increment,
`author` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`poemid` varchar(255) NOT NULL default '',
UNIQUE KEY `jcomid` (`pcomid`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nuke_poetry_comments`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_poetry_options`
--

CREATE TABLE `nuke_poetry_options` (
`pmid` varchar(10) NOT NULL default '1',
`poemsppage` varchar(20) NOT NULL default '',
`poemstoprated` varchar(20) NOT NULL default '',
`poemspopular` varchar(20) NOT NULL default '',
`minpnamelength` varchar(10) NOT NULL default '',
`maxpnamelength` varchar(10) NOT NULL default '',
`minptextlength` varchar(10) NOT NULL default '',
`maxptextlength` varchar(10) NOT NULL default '',
`allow_comments` varchar(10) NOT NULL default '',
`validate` char(1) NOT NULL default '',
`guestpost` char(1) NOT NULL default '',
`cattype` char(1) NOT NULL default '',
`alignpoem` char(1) NOT NULL default '0'
) TYPE=InnoDB;

--
-- Dumping data for table `nuke_poetry_options`
--

INSERT INTO `nuke_poetry_options` VALUES ('1', '25', '10', '10', '4', '100', '5', '100000', '1', '0', '0', '0', '0');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_poetry_styles`
--

CREATE TABLE `nuke_poetry_styles` (
`poemsid` int(11) NOT NULL auto_increment,
`stylename` varchar(150) NOT NULL default '',
UNIQUE KEY `id` (`poemsid`)
) TYPE=InnoDB AUTO_INCREMENT=7 ;

--
-- Dumping data for table `nuke_poetry_styles`
--

INSERT INTO `nuke_poetry_styles` VALUES (1, 'Rhyme');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_poetry_unvalid`
--

CREATE TABLE `nuke_poetry_unvalid` (
`poemuid` int(11) NOT NULL auto_increment,
`author` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`cat` varchar(10) NOT NULL default '',
`poem` text NOT NULL,
`style` varchar(10) NOT NULL default '',
UNIQUE KEY `id` (`poemuid`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nuke_poetry_unvalid`
--

Hopefully this will help you.

I was told that this was made originally for 7.4 and after the changes made to the tables in phpnuke after 7.5, that that is what's causing the problem. If someone here is interested in perhaps trying to adapt the table changes for the newer nuke sites, then I would appreciate that.

montego wrote:

If you can isolate the specific INSERT statement that is causing this and post the structure (only - no data) here (can get from phpMyAdmin as hitwalker suggests), we might be able to spot the issue.

Hopefully, the above information can help you determine what I should be looking for in regards to the "specific INSERT statement". These are the tables that I added to mysql by hand. Everything works fine except for the errors above and there was one more error that I found.

I get the error after I hit the validation key, which is the information I posted in the original post. But 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.

If you need any more information that I haven't provided here, please let me know. I'm not all that handy with mysql. I can add and delete tables and that's about it, so whatever you can do to help me with this mod, I'd be grateful!!!

Posted: Sat May 19, 2007 9:13 am

Quote:

I was told that this was made originally for 7.4 and after the changes made to the tables in phpnuke after 7.5, that that is what's causing the problem. If someone here is interested in perhaps trying to adapt the table changes for the newer nuke sites, then I would appreciate that.

Well, this bit of information leeds me to believe that it is not an issue with the mySQL version, so never mind that. Unfortunately I do not have the time right now to just fix this for you. I have never used the module, so don't even know how it works. Sorry. Sad

IF you register at that site, do they provide any support forums?

Posted: Sat May 19, 2007 9:28 am

montego wrote:

Well, this bit of information leeds me to believe that it is not an issue with the mySQL version, so never mind that. Unfortunately I do not have the time right now to just fix this for you. I have never used the module, so don't even know how it works. Sorry. Sad

IF you register at that site, do they provide any support forums?

Well, I tried registering at the site in question, but they have something wrong with it where when I register, it says DEBUG MODE and that it can't place my registration information into the tables.

I emailed the owner with my questions and let them know that I couldn't register, but have heard nothing back.

At any rate, thanks for taking a look and trying to figure something out. I do appreciate your time.

Grazie tante!!!!