Jump to content
Дизайн и модификация IPS Community IPBSkinsBETA
Search In
  • More options...
Find results that contain...
Find results in...
Sign in to follow this  
Gettyfilegroup

Ошибка при работе с базой данных

Recommended Posts

После взлома я воостановил бекап бд.

Все начало работать , толька одна проблема

После перехода в детали теми на форуме показуеть такую ошибку

 

SELECT pid FROM ibf_posts WHERE topic_id=457 AND queued=0 ORDER BY  DESC LIMIT 0,1

Сообщение сервера: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0,1' at line 1
Код ошибки: 1064
Время: Tuesday 15th o  December 2009 11:38:30 AM

 

Кто подсказить как воостановить ету ошибку :( .

Зарания спасибо.

Share this post


Link to post
Share on other sites

В таблице ibf_posts надо что-то чинить.

Проверьте ее.

Share this post


Link to post
Share on other sites

Вот структура

 

DROP TABLE IF EXISTS `ibf_posts`;
CREATE TABLE `ibf_posts` (
 `pid` int(10) NOT NULL auto_increment,
 `append_edit` tinyint(1) default '0',
 `edit_time` int(10) default NULL,
 `author_id` mediumint(8) NOT NULL default '0',
 `author_name` varchar(32) default NULL,
 `use_sig` tinyint(1) NOT NULL default '0',
 `use_emo` tinyint(1) NOT NULL default '0',
 `ip_address` varchar(16) NOT NULL default '',
 `post_date` int(10) default NULL,
 `icon_id` smallint(3) default NULL,
 `post` mediumtext,
 `queued` tinyint(1) NOT NULL default '0',
 `topic_id` int(10) NOT NULL default '0',
 `post_title` varchar(255) default NULL,
 `new_topic` tinyint(1) default '0',
 `edit_name` varchar(255) default NULL,
 `post_key` varchar(32) NOT NULL default '0',
 `post_parent` int(10) NOT NULL default '0',
 `post_htmlstate` smallint(1) NOT NULL default '0',
 `post_edit_reason` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`pid`),
 KEY `topic_id` (`topic_id`,`queued`,`pid`,`post_date`),
 KEY `author_id` (`author_id`,`topic_id`),
 KEY `post_date` (`post_date`),
 KEY `ip_address` (`ip_address`),
 KEY `post_key` (`post_key`),
 FULLTEXT KEY `post` (`post`)
) ENGINE=InnoDB AUTO_INCREMENT=865 DEFAULT CHARSET=utf8;

 

Найти ошибку так и не удалося. :(

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...