CREATE TABLE IF NOT EXISTS `comments` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`news_id` INT(11),
`body` text,
`time` INT(11) DEFAULT '0',
`author` INT(11) DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT
CREATE TABLE IF NOT EXISTS `poll` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`question` VARCHAR(150) ,
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date_start` datetime ,
`date_end` datetime ,
`status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `question` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'old_name' in 'where clause'' in C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php:146 Stack trace: #0 C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php(146): PDO->query('SELECT `id` FRO...') #1 C:\xampp\htdocs\public_html\system\application\controllers\character.php(137): OTS_Player->find('Magician') #2 [internal function]: Character->create_character('1') #3 C:\xampp\htdocs\public_html\system\codeigniter\CodeIgniter.php(236): call_user_func_array(Array, Array) #4 C:\xampp\htdocs\public_html\index.php(165): require_once('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php on line 146
[20/05/2014 15:35:03] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:07] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:11] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)