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.
Database Problems
Subject: Re: Database Problems
You should upgrade to Icy Phoenix 1.3...
Anyway, try to run this from phpMyAdmin:
Anyway, try to run this from phpMyAdmin:
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`)
);
`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`)
);
Page 1 of 1
You cannot post new topicsYou cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Powered by Icy Phoenix based on phpBB
Generation Time: 0.1042s (PHP: 15% SQL: 85%)
SQL queries: 10 - Debug Off - GZIP Enabled