, Guest!
Already a Member? Login or Register.

Menu



Showcase


Due to the volume of spam happening on our forums, posting is now restricted to verified members only.  If you're not verified, drop us a note with your username.

Home > FlexCMS Support Forum > User Help > General Support Requests > Install Problem SQL syntax error

FlexCMS Support Forum


Install Problem SQL syntax error
Started February 19, 2005 @ 9:46am by zebrahost
Post Message 
zebrahost


Posts: 5
 
Install Problem SQL syntax errorFebruary 19, 2005 @ 9:46am
I set up the database and got as far as "Database settings successfully save" Then I got You have an error in your SQL syntax near '; ' at line 1

Please advise,
Many Thanks.
 
otter
Administrator



Posts: 177
 
February 19, 2005 @ 10:38am
Hi Zebrahost!

The first thing to check is whether or not you uploaded the FlexCMS files in binary/ascii mode. I am pasting the info below, but you will also find it in our forum here:

http://www.flexcms.com/index.php/forum/thread/13.html


Quote

A common problem for installing FlexCMS is the uploading of actual FlexCMS files.

Please make sure your FTP program is uploading the .data and .map files in binary mode, or you will encounter errors during the installation process.

The install.php file should still be uploaded in ascii mode.


Bascially, you'll need to start the process all over again. Delete the FlexCMS install files from your server and re-upload them again in the proper format as described above. From the point the installer is giving an error it doesn't sound like it's created any database tables or data yet, but if it has you'll need to delete them as well.

If this doesn't fix your problem, please give us more info so we can further assist you. In that case, we will need to know if you rent space on a server (hosting company may place restrictions), your server os, as well as your php and mysql versions.

Otter


ONLINE TRAINING CLASSES FOR FLEXCMS IN MAY: FlexCMS Basics (101), Sat., May, 15, 2010 & FlexCMS Blocks (Mon., May 10, 2010).
 

Last Edit: February 19, 2005 @ 10:40am by otter
zebrahost


Posts: 5
 
Install ErrorFebruary 19, 2005 @ 10:54am
I used cuteFTP Pro and made sure that I uploaded the install.php in ASCII and the other two files in binary mode.

Is there anything else I should check?
 
otter
Administrator



Posts: 177
 
February 19, 2005 @ 11:11am
Hi Zebra,

Am going to need more info from you to assist. Can you please tell me what version of PHP and MySQL your server is running?

Thanks!

Otter


ONLINE TRAINING CLASSES FOR FLEXCMS IN MAY: FlexCMS Basics (101), Sat., May, 15, 2010 & FlexCMS Blocks (Mon., May 10, 2010).
 
zebrahost


Posts: 5
 
Install ProblemFebruary 19, 2005 @ 4:13pm
Hi Otter:

I tried deleting and resinstalling. Same problem. I am running PHP Version 4.3.10 with MySQL 3.23.58.

If I can get it running I would like to offer the reseller version to my hosting clients.

Thanks,

Clive
 
otter
Administrator



Posts: 177
 
February 19, 2005 @ 4:42pm
Hi Clive,

I'll contact you via email for more info shortly.

Thanks!

Otter

NOTE: Problem was due to server constraints and resolved by FlexCMS. If you are experiencing similar difficulty, please email us at or complete our contact form online.

UPDATE: GET THE ALTERNATE INSTALL PACKAGE HERE.




ONLINE TRAINING CLASSES FOR FLEXCMS IN MAY: FlexCMS Basics (101), Sat., May, 15, 2010 & FlexCMS Blocks (Mon., May 10, 2010).
 

Last Edit: March 10, 2005 @ 3:27pm by otter

Post Message 




Try & Buy FeedForAll - Easy to use RSS Feed Creator - great for iTunes users!

MEMBERS




All Contents, Code, Scripts and Technologies Copyright 2003-2009 FlexCMS.
All Rights Reserved. Software License Agreement

Processing Time: 0.07187 seconds.
 
Management Login

Powered By FlexCMS
Powered By FlexCMS