Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules
Author Message
joslynn
New Member
New Member



Joined: Jan 06, 2007
Posts: 8

PostPosted: Wed May 16, 2007 8:03 am Reply with quote

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!!!
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661

PostPosted: Wed May 16, 2007 12:32 pm Reply with quote

so you dont have access to the mysql by phpmyadmin to have a look ?
 
View user's profile Send private message
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Wed May 16, 2007 5:55 pm Reply with quote

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.

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
joslynn







PostPosted: Fri May 18, 2007 9:39 am Reply with quote

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!!!
 
montego







PostPosted: Sat May 19, 2007 9:13 am Reply with quote

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?
 
joslynn







PostPosted: Sat May 19, 2007 9:28 am Reply with quote

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!!!!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©