[MODERNAAC]Missing tables etc[Tutorial]

[Amiroslo]

Oh sorry false alarm haha i'm so stupid, i fixed it

- - - Updated - - -

Bug:

But i have Sample Character :s

They r renamed different in ur web config, thats why it cant find them

 

[Amiroslo]

[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)

Plzz HeLp

CREATE TABLE `shop_history`
(
`id` int(11) NOT NULL auto_increment,
`to_name` varchar(255) NOT NULL default '0',
`to_account` int(11) NOT NULL default '0',
`from_nick` varchar(255) NOT NULL,
`from_account` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`offer_id` int(11) NOT NULL default '0',
`trans_state` varchar(255) NOT NULL,
`trans_start` int(11) NOT NULL default '0',
`trans_real` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);
ALTER TABLE `shop_history` ADD `processed` int(11) NOT NULL default '0';

 

[Amiroslo]

Hey guys, look for my bug...
mysql_real_query(): SELECT * FROM messages WHERE `delete_it` = 1; - MYSQL ERROR: Unknown column 'delete_it' in 'where clause' (1054)

CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` int(11),
`to` int(11),
`title` varchar(120),
`text` tinytext,
`time` int(11),
`delete_from` tinyint(1),
`delete_to` tinyint(1),
`unread` tinyint(1),
PRIMARY KEY (`id`),
FOREIGN KEY (`from`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`to`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

if u already have table messages, drop it and add this again

 

[Amiroslo]

i got an error like this in guild

string(71) "SELECT `player_id` FROM `players_online` WHERE `player_id`='2' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'players_online' doesn't exist

CREATE TABLE IF NOT EXISTS `players_online` (
`player_id` int(11) NOT NULL,
PRIMARY KEY (`player_id`)
) ENGINE=MEMORY;

 

[Amiroslo]

When i try to create a character:

Error Number: 1054

Unknown column 'deleted' in 'where clause'

SELECT COUNT(*) AS `numrows` FROM (`players`) WHERE `account_id` = '2' AND `deleted` = 0

not sure, try this

ALTER TABLE `players` ADD `deleted` INT NOT NULL DEFAULT 0;

 

[bodycarcoo11]

not sure, try this

ALTER TABLE `players` ADD `deleted` INT NOT NULL DEFAULT 0;

I Got A Worest Problem When I Add A New ITem In Shop Offer the picture of the item is not avaliabe sry for bad english

 

[Ancio]

Thanks