By wernst on

All,

This past weekend, I updated my personal site from 4.4 to 4.5, and then from 4.5 to 4.6. It went pretty OK, and I even have the image module working through the upgrade. (Note - I'm changing DSL providers this week, so the site is offline.)

Now I just have a few niggling problems. I'll attack them one at a time.

The first is a set of errors that always appears after my hourly running of cron.php. In the logs, when the cron.php job runs, I get two errors:

Table 'drupal.flood' doesn't exist query: DELETE

Table 'drupal.search_total' doesn't exist query:

Any thoughts as to what is going on and how to fix it? I assume it is clear that the mysql database name is "drupal".

Thanks,
Warr

⋅ Categories: Drupal 4.6.x

Comments

TomChiverton’s picture

TomChiverton commented

Do the two tables exist ? Does the drupal user have the correct permissions if so, and if the tables don't exist, should they (check the 4.6 install (rather than upgrade) package) ?

wernst’s picture

wernst commented

Well, I think I have the problem solved.

I think I accidentally clicked the wrong line/date on the update script. One date too new, actually.

I went back to the update script and chose what is actually the correct line, and the script added a few new tables to the database. I haven't seen any more errors in the log when searching or doing cron jobs. I'll play with it more this weekend, of course, but I think I'm good to go.

-Warr

redella’s picture

redella commented

Thanks for the advice above

After a pretty hectic upgrade from 4.5.2 to 4.6.6, I have been experiencing the same problems, but would prefer to avoid if possible installing again.

The tables 'flood' and 'search_total'didn't exist in my SQL database so I've added them from the install module of 4.6.6.

I'm now having the following error message from the search module:

Unknown column 'i.sid' in 'field list' query: SELECT DISTINCT i.sid, i.type FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND i.type = 'node' AND (i.word LIKE '%tac%') in drupal/includes/database.mysql.inc on line 66.

Would be grateful for any advice, my knowledge of SQL is pretty rudimentary.

Redella

redella’s picture

redella commented

Just uploaded all tables, search_total, search_index and flood from the sql in the drupal install and deleted the previous. Then reindexed search and it's working now.