phpBB.de

Code: Alles auswählen

Could not delete user from user pets table

DEBUG MODE

SQL Error : 1054 Unknown column 'owner_id' in 'where clause'

DELETE FROM phpbb_rabbitoshi_users WHERE owner_id = 233

Line : 230
File : admin_users.php

Code: Alles auswählen

ALTER TABLE phpbb_rabbitoshi_users (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` text NOT NULL,
  PRIMARY KEY  (`word_id`)
) TYPE=MyISAM;

CREATE TABLE phpbb_rabbitoshi_users (
  owner_id int(8) NOT NULL default '0',
  owner_last_visit int(11) NOT NULL default '0',
  owner_creature_id smallint(2) NOT NULL default '0',
  owner_creature_name varchar(255) NOT NULL default '',
  creature_hunger int(8) NOT NULL default '0',
  creature_thirst int(8) NOT NULL default '0',
  creature_health int(8) NOT NULL default '0',
  creature_hygiene int(8) NOT NULL default '0',
  creature_age int(11) NOT NULL default '0',
  creature_hotel int(11) NOT NULL default '0',
  owner_notification tinyint(1) NOT NULL default '0',
  owner_hide tinyint(1) NOT NULL default '0',
  owner_feed_full tinyint(1) NOT NULL default '1',
  owner_drink_full tinyint(1) NOT NULL default '1',
  owner_clean_full tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (owner_id)
) TYPE=MyISAM;

Code: Alles auswählen

ALTER TABLE phpbb_rabbitoshi_users(

`word_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`word` text NOT NULL ,
PRIMARY KEY ( `word_id` ) 
) TYPE = MYISAM ;



MySQL meldet:  

#1064 - 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 '( 
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,