Modern AAC Problem

[The Mike]

Hey, I'm having a problem with modern aac that I just havent been able to solve. I have reintstalled it a few times but haven't been able to fix it. This is what it looks like;

A Database Error Occurred
Error Number: 1054

Unknown column 'world_id' in 'field list'

SELECT `id`, `world_id`, `name`, `motd` FROM `guilds`

This has also happened when I try make a character after making an account and when I do other stuff like going on the guilds page or the houses page. I know that there is no information for guilds yet and possibly for houses but if it wont let me make a character then how do I fix the characters part?

 

[Christine]

Here is a query to add the column to the table ;D

ALTER TABLE `guilds` ADD COLUMN `world_id` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';

 

[Acubens]

Here is a query to add the column to the table ;D

ALTER TABLE `guilds` ADD COLUMN `world_id` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';

world_id isn't the problem, "deleted" is missing in the table

ALTER TABLE `guilds` ADD COLUMN `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';

 

[The Mike]

Thanks but where do I put this code into the database to add the guilds column. And I also need to know how to do it with the other problems. The main one I had was after I made an account it said the character sample was missing or something so I couldn't add characters. Once again though, thanks

- - - Updated - - -

So far this has happened often like when I select the guilds tab, account tab, who is online tab, high scores tab and when I make a character. I really don't know why and wan't to solve it.

 

[Acubens]

You need execute that query in your phpmyadmin Check this