Problem with nuke.sql file

Nuke Cadet Joined: Jan 12, 2004 Posts: 5

I'm using the latest PHPNuke version which is 7.8, and i'm trying to import it using phpMyAdmin and I get this error:

Code:

Error

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 @ 457
STR: </
SQL:
INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '<big>�</big> <a href="admin.php">Administration</a> \r\n<big>�</big> <a href="admin.php?op=adminStory">NEW Story</a> \r\n<big>�</big> <a href="admin.php?op=create">Change Survey</a> \r\n<big>�</big> <a href="admin.php?op=content">Content</a> \r\n<big>�</big> <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

Nuke Cadet Joined: Jan 12, 2004 Posts: 5

Of course, my problems are always very unique and no one knows the answer to it.

Posted: Sun Dec 18, 2005 5:10 pm

halflife28 wrote:

Of course, my problems are always very unique and no one knows the answer to it.

That's not one of your unique problems:

make the whole line to short and dump it again.

The following is my example for you.

Code:

INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '-<a href="admin.php">Administration</a> -<a href="admin.php?op=adminStory">NEW Story</a> -<a href="admin.php?op=create">Change Survey</a> - <a href="admin.php?op=content">Content</a> -<a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '0', 'd', 0);

This will leveav you in peace.

Site Admin Joined: Aug 17, 2003 Posts: 12383

The problem is that you expect a response after only 15 minutes. Smile

This forum isn't checked on an 15 minute basis. We all have our real lives. So please wait 24 hours before bumping a thread. Thank you

- There are several problems with 7.8's nuke.sql file
I have a clean version you can download from my CVS repository

http://evaders.swrebellion.com/modules.php?name=NukeWrap&page=cvsrepos/../sql/phpNuke78_nuke.sql

Nuke Soldier Joined: Jan 06, 2006 Posts: 18

Sorry to bump.

I'm having the same problem and Evaders99 fixed .sql file doesn't work either.

How would I be able to fix it?

Site Admin Joined: Aug 17, 2003 Posts: 12383

smit, what error are you getting?

Nuke Cadet Joined: Jan 06, 2006 Posts: 3

I've got same problem and I too have tried the alternative nuke.sql file suggested by Evaders99 but that doesn't work.

My setup is;

Windows 2000 SP4
Apache 2.0.55
MySQL 5.0.18
PHP 5.1.1
phpMyAdmin 2.7.0-pl2

When importing the nuke.sql file the error reported is

Error

SQL query:

INSERT INTO nuke_blocks
VALUES ( 2, 'admin', 'Administration', '<big>�</big> <a href="admin.php">Administration</a> \r\n<big>�</big> <a href="admin.php?op=adminStory">NEW Story</a> \r\n<big>�</big> <a href="admin.php?op=create">Change Survey</a> \r\n<big>�</big> <a href="admin.php?op=content">Content</a> \r\n<big>�</big> <a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '0', 'd', 0 ) ;

MySQL said: Documentation
#1406 - Data too long for column 'content' at row 1

Any help would be much appreciated. I've spent at 2 days trying to get this to to work Evil or Very Mad

Site Admin Joined: Aug 17, 2003 Posts: 12383

Off the top, could be a problem with MySQL 5, PHP 5, or phpMyAdmin
I'm not sure why you are getting the squares in there. Could be a character set conflict

Nuke Cadet Joined: Jan 10, 2006 Posts: 1

I think it is a problem with MySQL 5 character encoding. I had those errors too and fixed them by changing default character set. I've changed my.ini file like this:
..
[mysql]
character-sets-dir="D:/Progs/MySQL/MySQL Server 5.0/share/charsets/"
default-character-set=latin2
..
[mysqld]
..
default-character-set=latin2

Nuke Cadet Joined: Feb 18, 2007 Posts: 1

I too am having the same issue, output is as follows:

Code:

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 @ 457
STR: </
SQL:
INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '<big>�</big> <a href="admin.php">Administration</a> \r\n<big>�</big> <a href="admin.php?op=adminStory">NEW Story</a> \r\n<big>�</big> <a href="admin.php?op=create">Change Survey</a> \r\n<big>�</big> <a href="admin.php?op=content">Content</a> \r\n<big>�</big> <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:

#1406 - Data too long for column 'content' at row 1

I've searched and searched to no avail.
I know what I am overlooking is probably quite simple, but I apologise for being quite new to this.

nuke 7.8
mysql 5.0
PHP 5.1.4

None of the fixes mentioned in this thread have worked for me.