Распространенная ошибка. SQL Error line 486
SQL Error: Table 'web11db1.prefix_topic' doesn't exist at /var/www/web11/web/classes/modules/topic/mapper/Topic.mapper.class.php line 486
Array ( [code] => 1146 [message] => Table 'web11db1.prefix_topic' doesn't exist [query] => SELECT count(t.topic_id) as count FROM prefix_topic as t, prefix_blog as b WHERE 1=1 AND t.topic_publish = 1 AND t.topic_date_add >= '2009-06-14 11:00:00' AND b.blog_type in ('open') AND t.blog_id=b.blog_id; [context] => /var/www/web11/web/classes/modules/topic/mapper/Topic.mapper.class.php line 486 )
Как устранить?
Array ( [code] => 1146 [message] => Table 'web11db1.prefix_topic' doesn't exist [query] => SELECT count(t.topic_id) as count FROM prefix_topic as t, prefix_blog as b WHERE 1=1 AND t.topic_publish = 1 AND t.topic_date_add >= '2009-06-14 11:00:00' AND b.blog_type in ('open') AND t.blog_id=b.blog_id; [context] => /var/www/web11/web/classes/modules/topic/mapper/Topic.mapper.class.php line 486 )
Как устранить?
- -1
- 15 июня 2009, 20:01
- Index
Я же сказал — полностью… лучше уж так. Чистите базу, накатывайте по-новой, так же с файлами.
- MaxSvargal
- 15 июня 2009, 21:32
- ↑
- ↓
выполните в ручную код в базу
CREATE TABLE `prefix_topic` (
`topic_id` int(11) unsigned NOT NULL auto_increment,
`blog_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned NOT NULL,
`topic_type` enum('topic','link','question') NOT NULL default 'topic',
`topic_title` varchar(200) NOT NULL,
`topic_tags` varchar(250) NOT NULL COMMENT 'tags separated by a comma',
`topic_date_add` datetime NOT NULL,
`topic_date_edit` datetime default NULL,
`topic_user_ip` varchar(20) NOT NULL,
`topic_publish` tinyint(1) NOT NULL default '0',
`topic_publish_draft` tinyint(1) NOT NULL default '1',
`topic_publish_index` tinyint(1) NOT NULL default '0',
`topic_rating` float(9,3) NOT NULL default '0.000',
`topic_count_vote` int(11) unsigned NOT NULL default '0',
`topic_count_read` int(11) unsigned NOT NULL default '0',
`topic_count_comment` int(11) unsigned NOT NULL default '0',
`topic_cut_text` varchar(100) default NULL,
`topic_forbid_comment` tinyint(1) NOT NULL default '0',
`topic_text_hash` varchar(32) NOT NULL,
PRIMARY KEY (`topic_id`),
KEY `blog_id` (`blog_id`),
KEY `user_id` (`user_id`),
KEY `topic_date_add` (`topic_date_add`),
KEY `topic_rating` (`topic_rating`),
KEY `topic_publish` (`topic_publish`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Комментарии (9)
RSS свернуть / развернуть