Tables missing?

Just started to set up Sphider, and I get error messages looking like the query string is wrong somehow.

In order to try and track it down I put 'or die(mysql_error());'
after the $result = mysql_query statement.
And I get this message:

Table 'smallhol_sphider.page' doesn't exist

And sure enough, when looking at the database there's no table.

In the tables.sql file it lists:
create table sites
create table links
create table keywords
create table link_keyword0
create table link_keyword1
create table link_keyword2
create table link_keyword3
create table link_keyword4
create table link_keyword5
create table link_keyword6
create table link_keyword7
create table link_keyword8
create table link_keyword9
create table link_keyworda
create table link_keywordb
create table link_keywordc
create table link_keywordd
create table link_keyworde
create table link_keywordf
create table categories
create table site_category
create table temp
create table pending
create table query_log
create table domains

But no page.

The query string is:
"SELECT p.page_url AS url, COUNT(*) AS occurrences FROM page p, word w, occurrence o WHERE p.page_id = o.page_id AND w.word_id = o.word_id AND w.word_word = $keyword GROUP BY p.page_id ORDER BY occurrences DESC LIMIT $results"

Am I missing something here?
I must be.

Please help.

Ron

In which file do you have that query?

and what line number?

Diego Medina
Web Developer

Thanks for your reply fmpwizard.

You will never believe this.
Well maybe you will :-)

I've been searching for searches, if you see what I mean, and have tried many different solutions.
Sphider looks like 'the one', but I still had a search.php left from a previous installation, and that's where the duff query string was.

Just symptoms of not enough sleep!

Thanks again.

Ron

it happens, I'm glad you figured it out.

Diego Medina
Web Developer