Installation won't work

Hangin' Around Joined: Oct 25, 2003 Posts: 27

I uploaded my files and when I try the install I get:

config.php file found!
Successfully connected to localhost as user rt76 and assigned password!
Database rt76 found!

Then when I make the next selection I get:

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

I an running php database MySQL 3.23.58
HTTP Server: Apache/1.3.27 (Unix) mod_python/2.7.8 Python/2.2.2 mod_webapp/1.2.0-dev mod_perl/1.28 mod_throttle/3.1.2 PHP/4.3.10 FrontPage/5.0.2.2510 mod_ssl/2.8.14 OpenSSL/0.9.7d.

I really would appreciate some help. I posted somewhere else but think I must have got the wrong place.

Thanks for your help.

Darlene Janssen

registered · Theme Guru Joined: Nov 01, 2003 Posts: 1006

http://www.ravenphpscripts.com/postt8136.html

This will help. Your host is using an ancient mysql. I wish you the best of luck! Razz

Posted: Fri Jan 20, 2006 1:27 pm

Any ideas anyone or am I totally out of luck. Even ideas on a better more secure version as I had 2000 members and lost it all so a little hesitant to start again incase this happens again.

Darlene

Posted: Fri Jan 20, 2006 2:49 pm

The best idea I have for you is to switch to Raven for hosting.

A better more secure version? This is the best out there IMHO!

Dawg

New Member Joined: Sep 15, 2002 Posts: 3

Can I do a quick bump on this problem, I have the same error

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

Jaded your link to [ Only registered users can see links on this board! Get registered or login! ] can't be found.

Can any one help, please Crying or Very sad

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That link works perfectly well and has the answer to the issue.

Posted: Fri Feb 03, 2006 8:11 am

Your no doubt right,

but can you give me the address for the correction because this is the error I get.

graphic at [ Only registered users can see links on this board! Get registered or login! ]

This is what shows on my screen after clicking the link

Thanks

Posted: Fri Feb 03, 2006 9:50 am

That is the address Confused

Try this one [ Only registered users can see links on this board! Get registered or login! ]

Posted: Fri Feb 03, 2006 3:43 pm

Sorry Raven but I get the same error with the new address.

I've tried internet explorer instead of firefox, turning my antivirus program off, another computer, corrected my email address and even re-activated my account, all to no avail.

Could I have made a wrong selection in my profile? I can't find anything that I can see.

I've even tried uploading the tables through phpmyadmin (2.6, I think) directly but I get errors.

Should I perhaps try an earlier version and then try to upgrade?

After being hacked so many times in the past I'm keen to get as much protection for our site as possible.

Posted: Sat Feb 04, 2006 2:51 am

Try accessing the link from a proxy, like [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sat Feb 04, 2006 5:44 am

That doesn't help because once you login your bumped back to the proxify website.

Posted: Sat Feb 04, 2006 5:55 am

I think that thread got moved to 'moved posts'.

Posted: Sat Feb 04, 2006 6:11 am

I guess that explains why I can't find it Confused

Posted: Sat Feb 04, 2006 6:48 am

I think the problem was due to an ancient version of Mysql.
Try Ravens fix

Quote:

You can always use a text editor and do a search and replace on -- to ## . Note that there MUST be a space after the -- and ##.

Posted: Sat Feb 04, 2006 6:56 am

do you mean just replace the -- with ## on the mysql version # or everywhere in the rn76_core_pl31 file?

Posted: Sat Feb 04, 2006 7:27 am

Everywhere on the file.
From what I understand, these characters are suppose to signify that the line is a comment and should be ignored by mysql but some earlier versions of mysql try to execute it instead of ignoring it.

Posted: Sat Feb 04, 2006 7:27 am

Whichever method you use - the version of MySql you are running needs to interpret the comment indicator as a # instead of a -

-sting

actually, in your case it would be

#sting

Posted: Sat Feb 04, 2006 12:40 pm

- Duh - I missed that one (moved posts) - Thanks guys. Maybe we can split the moved post and put the good stuff back? I'll take care of that Smile

Posted: Sat Feb 04, 2006 1:23 pm

Okay, I have split the moved post and you should be able to access it now at [ Only registered users can see links on this board! Get registered or login! ]

Sorry about all the confusion!

Posted: Sun Feb 05, 2006 7:33 am

This is painful, my God, oh how I miss the Power Tools Confused

I actually took the time to edit the rn76-core-pl31 and changed all -- to ## and now I get an error message that says:

ERROR! The exact error message that your MySQL server reported is Query was empty.

I've been at this for a number of hours now off and on so I apologize if this is a stupid question but any idea what may be wrong?

BTW, I also updated the above file with my exact server info. taken from another db as follows:

Code:




## phpMyAdmin SQL Dump


## version 2.6.0-pl3


## http://www.phpmyadmin.net


##


## Host: localhost


## Generation Time: Dec 16, 2005 at 10:49 PM


## Server version: 3.23.58


## PHP Version: 4.3.10


##


## Database: `mysitename_com_-_testing`

Any ideas?

Thanks for your help!

Posted: Sun Feb 05, 2006 8:27 am

Wait one, I'll post a link to a revised file.

Posted: Sun Feb 05, 2006 8:40 am

Try this one. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Feb 05, 2006 9:03 am

Thanks a lot, unfortunately the file is not found:

The requested URL /rn76-core-pl31.zip was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.34 Server at [ Only registered users can see links on this board! Get registered or login! ] Port 80

Posted: Sun Feb 05, 2006 9:34 am

Oops, Imust get more coffeee.
Try [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Feb 05, 2006 12:30 pm

Cannot be found Confused