Welcome! Log In Create A New Profile

Advanced

have an error in your SQL syntax

Posted by ezfirst 
have an error in your SQL syntax
April 04, 2015 03:21AM
hi

When I run the install.php it shows the messages:

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
Error: Table 'domains' already exists

What does that mean?
Tec
Re: have an error in your SQL syntax
April 04, 2015 08:46AM
It is always a good idea to use the search function of this forum (top right).
For example in order to find
http://www.sphider.eu/forum/read.php?2,21055,21076#msg-21076

Tec
Re: have an error in your SQL syntax
April 04, 2015 11:49AM
Thank you so much and sorry for not using the search function. smiling smiley
ddr
Re: have an error in your SQL syntax
July 13, 2015 11:00AM
Table 'jaan.pending' doesn't existTable 'jaan.pending' doesn't existFailed to parse address "" [Back to Home]

Spidering /
Table 'jaan.pending' doesn't exist
Completed at 06:49:17.

Plz help me
table name: $database="jaan"
Tec
Re: have an error in your SQL syntax
July 13, 2015 03:25PM
By means of an external tool like 'phpMyAdmin' delete all tables in your database.
Then have a look at the script
…/settings/database.php
You are asked to define the variable $mysql_table_prefix
Do it. Name it 'search1_' or whatever you like.
Afterwards run the table installation script again. Check for any error messages during table installation.

Tec
ddr
Re: have an error in your SQL syntax
July 14, 2015 08:45AM
Service Temporarily Unavailable

The server closed the connection without sending any data.

The server is temporarily unable to service your request due to maintenance downtime or capacity problems.

Due to heavy load on the server, connections may be temporarily blocked from locations that fetch an unusually high number of pages.

We apologize for the inconvenience.
Re: have an error in your SQL syntax
August 22, 2015 06:45PM
thanks so much for the script . but this is a little problem:
Notice: Undefined offset: 2 in ...

Notice: Undefined offset: 2 in C:\wamp\www\search\admin\admin.php on line 71

please, what does this suppose to mean, how can i correct this
Re: have an error in your SQL syntax
August 22, 2015 06:47PM
Warning: Missing argument 1 for showsites(), called in C:\wamp\www\search\admin\admin.php on line 1166 and defined in C:\wamp\www\search\admin\admin.php on line 378


Undefined variable: message in C:\wamp\www\search\admin\admin.php on line 397
Tec
Re: have an error in your SQL syntax
August 23, 2015 09:54AM
<<< Notice: Undefined offset: 2 in ... >>>
You may ignore this message. And all the other PHP messages starting with 'Notice', 'Warning', 'Strict' etc.
This warnings could be disabled in the php.ini script in folder …/php on your server.
If you don't have access to this script, create a script called php.ini with the following content
error_reporting = E_ALL & ~E_DEPRECATED & ~E_WARNING & ~E_NOTICE & ~E_STRICT;
Your personal php.ini will overwrite the corresponding 'error_reporting' directive of the server php.ini
Hopefully your hoster does not prevent this overwriting. You need to place your personal php.ini into all those subfolders, containing scripts causing PHP warnings, notices, etc., because your php.ini script will not be passed on to any subfolder of your Sphider installation.

By the way, these PHP messages are independent from SQL syntax. You should have created a new thread here in the forum.

Tec
Sorry, only registered users may post in this forum.

Click here to login