 | [Solved] "2 Warning(s) reported by the SQL Parser" |  |
 Posted: 06/14/2007 3:53 AM |
 |
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
 |
I Had to correct a few things with this MOD (http://www.phpbbhacks.com/download/5363)
The problems were the Author had "BEFORE ADD" insted of
BEFORE, ADD" and "AFTER ADD" insted of "AFTER, ADD"
and the author had included in the .txt file the code for adding it into lang_polish so I deleted it.
And after I did that and uploaded the file, EM installed the commands ok but the SQL came up with "2 Warning(s) reported by the SQL Parser"
It said the following:
1. Missing semicolon, it might be an indication of further syntax errors, statement: 3
2. Non-portable syntax option(s) "TYPE=MyISAM", ignored, statement: 1, table: "phpbb_notepad"
1. Missing semicolon, it might be an indication of further syntax errors, statement: 3
2. Non-portable syntax option(s) "TYPE=MyISAM", ignored, statement: 1, table: "phpbb_notepad" |
|
|
|
|
| Back to Top |
|
|
| Re: "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/14/2007 4:50 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:03 PM
Location: St Pete, FL
|
|
|
|
|
|
The only thing here you should fix is the following. You can ignore the rest of the warning errors listed above...
OPEN
admin_notepad.txt
FIND
| Code:
|
|
ALTER TABLE `phpbb_users` ADD `user_note` varchar(255) default NULL
|
REPLACE WITH
| Code:
|
|
ALTER TABLE `phpbb_users` ADD `user_note` varchar(255) default NULL;
|
Save, upload, and try again using EM...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/15/2007 9:00 PM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
Sorry Nightrider, I forgot about this MOD 
I did the necessary changes to the MOD and it installed, I overwrote the one warning and then I went to admin index in the ACP and it came up with
Parse error: syntax error, unexpected '/' in /home/www/forum.pegasus-outpost.com/admin/index.php on line 190
on a white background |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/15/2007 10:06 PM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
| OK now this is major, I cant access the ACP, it come up with that error! I will try and use the easymod backups manually |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/15/2007 10:13 PM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
I restored the backups and now the index of the forum comes up with this:
Warning: main(./../extension.inc) [function.main]: failed to open stream: No such file or directory in /home/www/forum.pegasus-outpost.com/index.php on line 30
Fatal error: main() [function.require]: Failed opening required './../extension.inc' (include_path='.:/usr/local/php4/share/pear') in /home/www/forum.pegasus-outpost.com/index.php on line 30
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/15/2007 10:26 PM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
I got it working again, when I put the backup files back in their places i put the admin/index.php backup file in / by accident, so I put the admin/index.php backup file in admin/ and got the backup /index.php file from the today yesterday Mod I installed yesterday, now I am going to do the /index.php mod bit for today yesterday mod.
Edit: Done and everything back to normal |
|
|
|
|
| Back to Top |
|
|
| Re: "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/16/2007 3:22 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:03 PM
Location: St Pete, FL
|
|
|
|
|
|
Sorry that I'm late to the party Dan. It appears that you figured it out without my help though. That's awesome that you made all the correct moves to resolve these problems and it sounds like you managed to keep your cool throughout it all. This might have put most admins in a panic...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/16/2007 3:36 AM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
No Problems, Thanks, I'm actually a little happy that you didn't come on, because then I had to use my head and not just rely on you  |
|
|
|
|
| Back to Top |
|
|
| Re: "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/16/2007 3:51 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:03 PM
Location: St Pete, FL
|
|
|
|
|
|
Maybe I should take a little longer to respond from now on...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] "2 Warning(s) reported by the SQL Parser" | |
| Posted: 06/16/2007 5:00 AM |
|
|
|
|
|
| Hawk |
| Posts |
193 |
| Word Cnt. |
9,285 |
| BDay |
Jun 8 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 25, 2007
Local time: 7:03 AM
Location: Esperance, Australia
|
|
|
|
|
|
lol I didn't mean in like that  |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
