Natan Beckman
Well-Known Member
You solved the problem:
execute in phpmyadmin
execute in phpmyadmin
PHP:
alter table `accounts` add `vip_time` INT NOT NULL;
alter table `accounts` add `vip_time` INT NOT NULL;
Execute solved!alter table `accounts` add `vip_time` INT NOT NULL;
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'in_war_with' in 'field list'' in C:\xampplite\htdocs\pot\OTS_Guild.php:327 Stack trace: #0 C:\xampplite\htdocs\pot\OTS_Guild.php(327): PDO->query('SELECT `in_war_...') #1 C:\xampplite\htdocs\guilds.php(2246): OTS_Guild->getCustomField('in_war_with') #2 C:\xampplite\htdocs\index.php(122): include('C:\xampplite\ht...') #3 {main} thrown in C:\xampplite\htdocs\pot\OTS_Guild.php on line 327
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'image_gallery' in 'field list'' in C:\xampplite\htdocs\pot\OTS_Guild.php:327 Stack trace: #0 C:\xampplite\htdocs\pot\OTS_Guild.php(327): PDO->query('SELECT `image_g...') #1 C:\xampplite\htdocs\guilds.php(1633): OTS_Guild->getCustomField('image_gallery') #2 C:\xampplite\htdocs\index.php(122): include('C:\xampplite\ht...') #3 {main} thrown in C:\xampplite\htdocs\pot\OTS_Guild.php on line 327
STEP 4
Add samples to DB:
News ticker sample is already in database. New sample is not needed.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'world_id' in 'field list'' in C:\xampplite\htdocs\RRoT\install.php:515 Stack trace: #0 C:\xampplite\htdocs\RRoT\install.php(515): PDO->query('INSERT INTO `pl...') #1 {main} thrown in C:\xampplite\htdocs\RRoT\install.php on line 515
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampplite\htdocs\RRoT\pot\OTS_Account.php:237 Stack trace: #0 C:\xampplite\htdocs\RRoT\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampplite\htdocs\RRoT\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampplite\htdocs\RRoT\pot\OTS_Account.php on line 237
alter table `name_table` add `world_id` INT(32) NOT NULL;Hey there, this is my first time back to OT's (last one that I used properly was 8.1, messed with 8.4 and the AAC to match)
I'm trying to set this one up.
When I'm at step 4:"Add samples to DB"
I get this
Code:STEP 4 Add samples to DB: News ticker sample is already in database. New sample is not needed. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'world_id' in 'field list'' in C:\xampplite\htdocs\RRoT\install.php:515 Stack trace: #0 C:\xampplite\htdocs\RRoT\install.php(515): PDO->query('INSERT INTO `pl...') #1 {main} thrown in C:\xampplite\htdocs\RRoT\install.php on line 515
And if I try to goto the next step, I then get.
Any help please?Code:Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampplite\htdocs\RRoT\pot\OTS_Account.php:237 Stack trace: #0 C:\xampplite\htdocs\RRoT\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampplite\htdocs\RRoT\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampplite\htdocs\RRoT\pot\OTS_Account.php on line 237
alter table `name_table` add `world_id` INT(32) NOT NULL;
in name_table write name where you want the world_id
18/03/2011 23:35:09] > MySQL ERROR mysql_real_query: SELECT `ip`, `mask`, `time` FROM `bans` WHERE `type` = 1; Unknown column 'ip' in 'field list'
[18/03/2011 23:35:09] > MySQL ERROR mysql_real_query: SELECT `id`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 654654 LIMIT 1; Unknown column 'type' in 'field list'
you're using TFS 0.3 or higher, but you've imported a mysql schema of TFS 0.2I get this error in my console when i try to log in :
Some one know how to fix it ? :s
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rlserver.z_news_tickers' doesn't exist' in C:\xampp\htdocs\install.php:505 Stack trace: #0 C:\xampp\htdocs\install.php(505): PDO->query('SELECT * FROM z...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 505