Web in TFS 0.2.11

[agomez]

Im wondering how i can add a page in TFS 0.2.11, i need use modern acc, archezz acc or maybe gesior :d

 

[Calon]

u can add page in any tfs bro

 

[agomez]

when i install the web (modern acc) it appears:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theforgottenserver.killers' doesn't exist

and i cant make any account, it only appear the waiting icon :/

 

[Fendron]

I have the same Please help?

 

[Fendron]

Bumpy bump

 

[Korrex]

Just use Znote's Gesior port to 0.2.
Also bumping is NOT allowed within 24 hrs of last post.

 

[Selenotes]

add forgottenkillers table to database!

DROP TABLE IF EXISTS `theforgottenserver.killers`;

execute it in PHPMYADMIN

 

[Fendron]

That doesn't add that table.

 

[Selenotes]

My fault sorry "
CREATE TABLE IF NOT EXISTS `name`

 

[Fendron]

#1113 - A table must have at least 1 column

 

[Korrex]

CREATE TABLE IF NOT EXISTS `name` VARCHAR(60);

try that then

 

[Mark]

CREATE TABLE `killers`
(
        `id` INT NOT NULL AUTO_INCREMENT,
        `death_id` INT NOT NULL,
        `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
        `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
        PRIMARY KEY (`id`)
) ENGINE = InnoDB;

 

[Selenotes]

you can add your the collum with int(11) and tahts all

 

[Fendron]

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pk.kill_id' in 'on clause'

I just think I did something wrong at installation...

btw I use the TFS for 9.10. Don't know if it matters.

 

[Mark]

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pk.kill_id' in 'on clause'

I just think I did something wrong at installation...

btw I use the TFS for 9.10. Don't know if it matters.

The AAC you are trying to use is obviously not designed for The Forgotten Server 0.2, tell the author of the AAC to fix it.