Solved Query errors help please :P

[MadMOOK]

I use 0.3.7 crying damson 10.10, i run it on the same database as my 0.3.7 8.60.
1. How do i remove them table errors?
2. How do i fix motd and players record not loading?

::Updated New problem!

 

[Summ]

Try those:

CREATE TABLE `market_history`
(
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `player_id` int(11) NOT NULL,
    `sale` tinyint(1) NOT NULL DEFAULT '0',
    `itemtype` int(10) unsigned NOT NULL,
    `amount` smallint(5) unsigned NOT NULL,
    `price` int(10) unsigned NOT NULL DEFAULT '0',
    `expires_at` bigint(20) unsigned NOT NULL,
    `inserted` bigint(20) unsigned NOT NULL,
    `state` tinyint(1) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `player_id` (`player_id`,`sale`),
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
);

CREATE TABLE `market_offers`
(
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `player_id` int(11) NOT NULL,
    `sale` tinyint(1) NOT NULL DEFAULT '0',
    `itemtype` int(10) unsigned NOT NULL,
    `amount` smallint(5) unsigned NOT NULL,
    `created` bigint(20) unsigned NOT NULL,
    `anonymous` tinyint(1) NOT NULL DEFAULT '0',
    `price` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `sale` (`sale`,`itemtype`),
    KEY `created` (`created`),
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
);

 

[MadMOOK]

Error

SQL query:

CREATE TABLE `market_history` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`player_id` int( 11 ) NOT NULL ,
`sale` tinyint( 1 ) NOT NULL DEFAULT '0',
`itemtype` int( 10 ) unsigned NOT NULL ,
`amount` smallint( 5 ) unsigned NOT NULL ,
`price` int( 10 ) unsigned NOT NULL DEFAULT '0',
`expires_at` bigint( 20 ) unsigned NOT NULL ,
`inserted` bigint( 20 ) unsigned NOT NULL ,
`state` tinyint( 1 ) unsigned NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `player_id` ( `player_id` , `sale` ) ,
FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE
);

MySQL said: Documentation
#1050 - Table 'market_history' already exists

 

[Cronox]

add this

ALTER TABLE `market_history` ADD
`world_id` int(11) NOT NULL DEFAULT 0;

 

[MadMOOK]

How do i add that, this is new to me :\

EDIT:Oh,i got it... this happens now.

 

[MadMOOK]

 

[Summ]

Stop doubleposting.
If you now look at the last error and think about how you fixed that you can also fix the current one.
Just see what changed and use the brain.

 

[MadMOOK]

I dont know what changed :/

 

[Cronox]

just only need enter SQL in phpmyadmin
and put my query
-.- the problem you need read men
the problem is why not have colum world_id
added in table market_offers

 

[MadMOOK]

i dont know what to put in the SQL on phpmyadmin to fix it.. im no programmer,never done this.. i used to host XML servers, never had these problems

ALTER TABLE `market_offers` ADD `world_id` int( 11 ) NOT NULL DEFAULT 0
OMG YAY! lol

Thanks @Summ and @Cronox