View previous topic :: View next topic |
Author |
Message |
Kwith -
Joined: 18 Dec 2005 Posts: 3
|
Posted: Sun Dec 18, 2005 11:27 am Post subject: PHPNuke Issues |
|
|
If this issue has been posted before, I apologize. I tried searching for it and couldn't find anything. Secondly, I know this is going to sound like a really stupid question but this is the first time I've tried using this program and I honestly can't see the error. So here is my question:
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 @ 452
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);
Anyone have a clue as to what is causing the error there?
From what I can tell, there is no problem there. This error appears when I import the nuke.sql file. Any help would be appreciated. |
|
Back to top |
|
 |
MonkeyNation -
Joined: 05 Feb 2005 Posts: 921 Location: Cardiff
|
Posted: Sun Dec 18, 2005 7:29 pm Post subject: |
|
|
Interesting. Just as a test try removing the last login link from the html value in the query. (I.E. Without <a href="admin.php?op=logout">Logout</a>)
If that works, try rewriting that last bit by hand, there might be a hidden control character in there or something, messing it up. _________________
 |
|
Back to top |
 |
 |
Kwith -
Joined: 18 Dec 2005 Posts: 3
|
Posted: Mon Dec 19, 2005 1:03 am Post subject: |
|
|
I tried that and no dice. I also tried retyping it all by hand and I still get the same error. I'm gonna go through it character by character again, but as far as I can tell there isn't anything wrong with it. |
|
Back to top |
|
 |
Kwith -
Joined: 18 Dec 2005 Posts: 3
|
Posted: Mon Dec 19, 2005 1:12 am Post subject: |
|
|
Well, I got it working. (I think)
I copied everything from Create Table nuke_authors to the end of the file and put it into the Query box and hit Go. It all appeared to work afterwards with no error. I'll do some testing and let you know how it went. Thanks |
|
Back to top |
|
 |
|
|
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
|
|