Pagina 1 din 1

SQL Error : 1030 Got error 28 from table handler

Scris: 14-Mai-2005, 18:02:42
de Snappy
hopaaaa....

Cod: Selectaţi tot

Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 469 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 722
File : viewtopic.php
si asta fara sa bag vreun MOD, fara nimic... pana acum 15 min totul era OK, acum nu mai e...


HEEEEEEEEEEEEEEELPPPPPP :roll:

Scris: 14-Mai-2005, 19:09:19
de BuGsY
Nu cred că mai ai tabele phpbb_vote_desc, phpbb_vote_results şi phpbb_vote_voters în baza de dtae a forumului.

Cod: Selectaţi tot

CREATE TABLE `phpbb_vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `phpbb_vote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) TYPE=MyISAM;

CREATE TABLE `phpbb_vote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) TYPE=MyISAM

Scris: 14-Mai-2005, 22:17:30
de Snappy
multumesc frumos... problema rezolvata :)