Compiling Help With Website. (Columns)

[Super Nova]

I'm using MYSQL and Mystic Spirit 0.2.7 and Gesior for 0.3.6 =( Please help.

I get this for some reason when im searching a character

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list'' in C:\xampp\htdocs\characters.php:282 Stack trace: #0 C:\xampp\htdocs\characters.php(282): PDO->query('SELECT `id`, `d...') #1 C:\xampp\htdocs\index.php(99): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\characters.php on line 282

 

[bolero]

Try execute this in SQL

Not tested...

ALTER TABLE `accounts` ADD `type` INT NOT NULL DEFAULT 1;

 

[Super Nova]

Try execute this in SQL

Not tested...

ALTER TABLE `accounts` ADD `type` INT NOT NULL DEFAULT 1;

I did that, and it edited the accounts table, but no, i can't search players or logon. =(

 

[Super Nova]

Mainly Whole Thing Is : Unknown Column "ip" in 'field list'

 

[Diazapam]

reimport the schemas from your ot.

 

[Super Nova]

reimport the schemas from your ot.

Did that then it deleted some files then said this.

SQL query:

CREATE TABLE `house_data` (

`house_id` INT UNSIGNED NOT NULL ,
`world_id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL ,
UNIQUE (
`house_id` ,
`world_id`
)
) ENGINE = INNODB;

MySQL said:

#1050 - Table 'house_data' already exists

Now i can't even get on the website.

 

[Diazapam]

if there is no data in the database yet just delete the whole thing and make a new one.
Than import the files again.

else try to use an older gesior version that is for 0.2.X servers

 

[Super Nova]

if there is no data in the database yet just delete the whole thing and make a new one.
Than import the files again.

else try to use an older gesior version that is for 0.2.X servers

Thanks man! I love you colier! It helped alot. Rep ++ For You =)

 

[Super Nova]

But now, when i log on my account then log off and log back on, it says 'Disconnected From Server' But all ports (7171,7172,3306,80) Are open. Wtf?