Installation failure with SQL syntax
January 31, 2015 02:12AM
Hi,
after having insert http://<www.mysite.de>/sphider/admin/install.php in IE 11, I get the error:
Sphider installation script.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), elapsed float(2), results int, key query_key(query))' at line 3
Creating tables failed. Consult the above error messages.

My provider has MySQL 5.5 and PHP 5.2.17 installed. The error is created in install.php and erroneus command is:
mysql_query("create table `".$mysql_table_prefix."query_log` (
query varchar(255),
time timestamp(14),
elapsed float(2),
results int,
key query_key(query))"winking smiley;
How to correct this command?
TIA
Gerhard
Tec
Re: Installation failure with SQL syntax
January 31, 2015 11:27AM
It is always a good idea to use the search function of this forum.
For example in order to find
http://www.sphider.eu/forum/read.php?2,20859,20868#msg-20868

Tec
Re: Installation failure with SQL syntax
February 02, 2015 12:27PM
Thank you for the information that you have shared in this post.

<a href="http://www.huntagency.com.au/Toplesswaiter/topless-waiters-sydney.php">Topless Waiter Sydney</a>
Re: Installation failure with SQL syntax
February 02, 2015 05:40PM
mysql_query("create table `".$mysql_table_prefix."query_log` (
query varchar(255),
time timestamp(14),
elapsed float(2),
results int,

time timestamp(14), -> time timestamp,
Re: Installation failure with SQL syntax
February 05, 2015 06:03PM
Thanks everybody for answering. Problem is solved.
Sorry, only registered users may post in this forum.

Click here to login