Welcome! Log In Create A New Profile

Advanced

How To Remove: Table 'sph_search.query_log' doesn't exist

Posted by Rubel 
How To Remove: Table 'sph_search.query_log' doesn't exist
May 02, 2013 01:56PM
When I search any word the search result shows but at the top shows "Table 'sph_search.query_log' doesn't exist". How to solve this Problem. Please Help.



Edited 1 time(s). Last edit at 05/02/2013 02:01PM by Rubel.
Tec
Re: How To Remove: Table 'sph_search.query_log' doesn't exist
May 02, 2013 06:12PM
As it seems, your Sphider Installation is corrupted. Just run the script
.../admin/install.php
to add the missing table into your database.

Eventually it might be helpful to create a completely new set of tables with a prefix like
sph_search_
Eventually the dot as final character in your current table prefix will not be excepted by any of the original Sphider scripts.


Tec
Re: How To Remove: Table 'sph_search.query_log' doesn't exist
May 03, 2013 06:18PM
Thanks for your Solution. I already solved this problem.
Re: How To Remove: Table 'sph_search.query_log' doesn't exist
July 10, 2013 03:20PM
Tec Wrote:
-------------------------------------------------------
> As it seems, your Sphider Installation is
> corrupted
. Just run the script
> .../admin/install.php
> to add the missing table into your database.
>
> Eventually it might be helpful to create a
> completely new set of tables with a prefix like
> sph_search_
> Eventually the dot as final character in your
> current table prefix will not be excepted by any
> of the original Sphider scripts.
>
>
> Tec

I faced the same problem and also solved it after some digging. In the install.php file, the mysql_query that creates the query_log table has a size for the timestamp field ("time timestamp(14),"winking smiley which is syntactically incorrect. Due to this, mysql comes back with an error for this particular table.

I downloaded this pkg around a week back and it had this error. So, Sphider team, please correct this error so that others don't face this issue.

Thanks,
Amrita
Re: How To Remove: Table 'sph_search.query_log' doesn't exist
June 12, 2014 09:43AM
I appreciate this question was posted some time ago but have just joined the forum and had the same problem. The create table query_log section of the sql/tables file needs altering to

create table query_log (
query varchar(255),
time timestamp,
elapsed float(2),
results int
)

Thanks to stackoverflow for the soluition.

Hope this helps anyone else with the same problem until Sphider get around to correcting the original script.
Re: How To Remove: Table 'sph_search.query_log' doesn't exist
October 22, 2014 02:59PM
A big Jambo! to all.

To solve the issue of "Table 'sph_search.query_log' doesn't exist", use the following:

create table sites(
site_id int auto_increment not null primary key,
url varchar(255),
title varchar(255),
short_desc text,
indexdate date,
spider_depth int default 2,
required text,
disallowed text,
can_leave_domain bool) ENGINE = MYISAM;
create table links (
link_id int auto_increment primary key not null,
site_id int,
url varchar(255) not null,
title varchar(200),
description varchar(255),
fulltxt mediumtext,
indexdate date,
size float(2),
md5sum varchar(32),
key url (url),
key md5key (md5sum),
visible int default 0,
level int) ENGINE = MYISAM;
create table keywords (
keyword_id int primary key not null auto_increment,
keyword varchar(30) not null,
unique kw (keyword),
key keyword (keyword(10))) ENGINE = MYISAM;
create table link_keyword0 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword1 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword2 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword3 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword4 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword5 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword6 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword7 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword8 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyword9 (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyworda (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keywordb (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keywordc (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keywordd (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keyworde (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table link_keywordf (
link_id int not null,
keyword_id int not null,
weight int(3),
domain int(4),
key linkid(link_id),
key keyid(keyword_id)) ENGINE = MYISAM;
create table categories(
category_id integer not null auto_increment primary key,
category text,
parent_num integer
) ENGINE = MYISAM;
create table site_category (
site_id integer,
category_id integer
) ENGINE = MYISAM;
create table temp (
link varchar(255),
level integer,
id varchar (32)
) ENGINE = MYISAM;
create table pending (
site_id integer,
temp_id varchar(32),
level integer,
count integer,
num integer) ENGINE = MYISAM;
create table query_log (query varchar(255),
time TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
elapsed float(2),
results int,
key query_key(query));
)
create table domains (
domain_id int auto_increment primary key not null,
domain varchar(255)
) ENGINE = MYISAM;
Sorry, only registered users may post in this forum.

Click here to login