Icy Phoenix

Old Support Topics - Database Problems

Zealo [ Sat 03 Apr, 2010 21:35 ]
Post subject: Database Problems

Hello

Im having trouble with the database.
Here is the error.
Everytime I click on the "New (##)" button on the header, this appears.

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1146 Table 'vocha_icy2.ip_search_results' doesn't exist

DELETE FROM ip_search_results WHERE search_time < 1270319567

Line : 1015
File : search.php

Im running IP 1.2.0.27c
The error just ocurred out of nowhere.

How could I fix this?

Thanks.

Mighty Gorgon [ Sat 17 Apr, 2010 10:22 ]
Post subject: Re: Database Problems

You should upgrade to Icy Phoenix 1.3...

Anyway, try to run this from phpMyAdmin:

Code: [Hide] [Select]

CREATE TABLE `ip_search_results` (

	`search_id` int(11) unsigned NOT NULL DEFAULT '0',

	`session_id` varchar(32) NOT NULL DEFAULT '',

	`search_array` MEDIUMTEXT NOT NULL,

	`search_time` int(11) NOT NULL DEFAULT '0',

	PRIMARY KEY (`search_id`),

	KEY `session_id` (`session_id`)

);