>>
Site Map
>>
Forums
>>
Installation [nCo Mod]
Forum module - topics in forum:
Installation [nCo Mod] - Installation Questions and Discussion
SQL Error Unknown Punctuation
Have uploaded and setup nCo Modified 7.6 Ultra more time then can remember and never ran into this.. Please help..
phpMyAdmin 2.6.2.pl1
MySQL 5.0.27
ERROR RETURNED...:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 458
STR: </
SQL: INSERT INTO `nuke_blocks` VALUES (2, 'admin', 'Administration', '<strong><big>�</big></strong> <a href="admin.php">Administration</a><br>\r\n<strong><big>�</big></strong> <a href="admin.php?op=adminStory">NEW Story</a><br>\r\n<strong><big>�</big></strong> <a href="admin.php?op=create">Change Survey</a><br>\r\n<strong><big>�</big></strong> <a href="admin.php?op=content">Content</a><br>\r\n<strong><big>�</big></strong> <a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '', '0', 'd', 0)
SQL query:
INSERT INTO `nuke_blocks` VALUES (2, 'admin', 'Administration', '� Administration
\r\n� NEW Story
\r\n� Change Survey
\r\n� Content
\r\n� Logout', '', 'l', 2, 1, 0, '985591188', '', '', 2, '', '0', 'd', 0)
MySQL said: Documentation
#1406 - Data too long for column 'content' at row 1
Well I guess I just got totally nailed by my hosting company or over night someone took my brain... I keep getting errors that never happened before and can not get any version of nuke to run, sorry about posting something about all nukes here but pertains to nCoModified also..
Nuke Versions:
nCo Modified 7.6 Ultra
PhPNuke 8.0
Platinum 7.6b4v2
Hosting providers MySQL info on Windows:
phpMyAdmin 2.6.2pl1
MySQL Client 5.0.27
Local PC Hosting MySQL info on Windows:
phpMyAdmin 2.8.0.3
MySQL Client 5.0.20
ISSUES ----- :
ON local PC hosting everything works good (problems with user reg at first but figured that out) on all 3 versions...
ON hosting provider I get errors when uploading the sql tables.. If I take the backups of my local sql and upload to the hosting provider it will not input data into the DB properly especially the user registration tables in perticular moving the data from user_temp to user after verifing reg with email and without email.. If I take the original sql file and upload it I get errors about "line to long", I have included screenshot of the errors.. I finely got the Platinum SQL to go in but then a admin loop issue which I am dealing with on their forums.. Please check out the screenshots and any help would be very appreciated...
nCo Modified 7.6 Ultra SQL Error
PhP Nuke 8 SQL Error
PhP Platinum SQL Successful
Edited: I put in the successful screenshot incase you needed it to verify anything, again thanks for any info that can help me keep my hair..
Ok I admit it.. I can not figure this one out.. Everything that I do on my end is correct and runs properly but as soon as I upload it to my host the SQL takes a dump and will not insert data into the tables..
My Question is ... " Is there any way possible that this is a nCoNuke issue or is this an issue with my host and has anyone else had any problems like this with phpMyAdmin 2.6.2pl1 and MySQL Client 5.0.27...?
It's obvious to me that it is a hosting issue if all these various versions of nuke are having sql errors
Then I guess my next questions would be....:
Is there anyone out there that is using that version of phpMyAdmin and MySQL...?
Is that version of phpMyAdmin and MySQL a stable build..?
Thanks for your response Seven, I was thinking that myself but according to my hosting company everything is right with them and it is an issue I am having.. I think I will send them a email with a link to this thread, that might get something going...
I am taking that since there is no response to this that there must not be anyone still using 2.6.2.pl1 from 2005 and unless easycgi updates there software then I am just screwed... Anyone know a great hosting company to go with.. ????
