MySQL Syntax Error

Worker Joined: Sep 09, 2004 Posts: 106 Location: Canada

I I have installed RN on my dedicated server 3 times already and have to add the tables manually because I have red and red the forum but done of the discusions on the errer mesage is answering me since I have looked over and over at installSQL.php.

Therefore, I post the issue :

ERROR! The exact error message that your MySQL server reported is You have an error in your SQL syntax near '; ' at line 1.

I am running: phpMyAdmin 2.6.3-pl1
MySQL 3.23.58 and PHP PHP Version 4.4.1

What are some of the issues should I be looking for installing with: [ Only registered users can see links on this board! Get registered or login! ]

I am familar with phpMyAdmin since I have been managing all of databes from here so is able to work around things but I would like to get the remedy.

Thanks

Site Admin Joined: Jun 04, 2004 Posts: 6433

Are you trying to load the installSQL.php into phpMyAdmin?

If so, that's the issue. installSQL.php is to be executed directly, not loaded as SQL.

Posted: Mon Sep 25, 2006 3:53 pm

kguske wrote:

Are you trying to load the installSQL.php into phpMyAdmin?

If so, that's the issue. installSQL.php is to be executed directly, not loaded as SQL.

NO PEE I am installing -- Sorry, I typed the wrong thing above
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Tue Sep 26, 2006 5:49 am

I believe that the issue is your mySQL version. It is VERY old. I would try it with 4.1.x as a minimum.

Posted: Tue Apr 24, 2007 9:13 am

Quote:

I believe that the issue is your mySQL version. It is VERY old. I would try it with 4.1.x as a minimum.

Montego is right. I experienced this problem before. It just that your MySQL 3.23.58 doesnt support or not recognize special sql character syntax such as `. If u look carefully, u will noticed that this character is `, not '. To solve this prob, u can edit the sql statement and manually load it into phpmyadmin (u definitely dont want to do this. Trust me.) or u can use this all-in-one package:

Easy PHP 1.8
- Apache 1.3.33
- PHP 4.3.10
- MySQL 4.1.9
- phpMyAdmin 2.6.1

You can download at:
http://www.easyphp.org/telechargements/dn.php?F=easyphp1-8