MySQL Error.. Help?

[Naxtie]

Got a few errors in my database, I would appreciate if someone could help me get rid of em! xD
Uhm.. help?

SOLVED!

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flag' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:811 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(811): PDO->query('UPDATE `account...') #1 C:\xampp\htdocs\createaccount.php(312): OTS_Account->setCustomField('flag', 'se') #2 C:\xampp\htdocs\index.php(171): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 811

SOLVED!

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'logo_gfx_name' in 'field list'' in C:\xampp\htdocs\pot\OTS_Guild.php:327 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Guild.php(327): PDO->query('SELECT `logo_gf...') #1 C:\xampp\htdocs\guilds.php(68): OTS_Guild->getCustomField('logo_gfx_name') #2 C:\xampp\htdocs\index.php(146): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Guild.php on line 327

Not Solved.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bought' in 'order clause'' in C:\xampp\htdocs\shopsystem.php:169 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(169): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(226): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopsystem.php on line 169

 

[Cronox]

why you don't have column flag
execute this query:

ALTER TABLE accounts ADD flag varchar(255) NOT NULL

 

[Mogex]

The thing is, this error is popping up when Im trying to create an account.
Uhm.. help?

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flag' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:811 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(811): PDO->query('UPDATE `account...') #1 C:\xampp\htdocs\createaccount.php(312): OTS_Account->setCustomField('flag', 'se') #2 C:\xampp\htdocs\index.php(171): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 811

execute this query:

why you don't have column flag


If you're using znote Acc you probably didn't added flag tables

ALTER TABLE accounts ADD flag varchar(255) NOT NULL

+1

 

[Raggaer]

Hes using Gesior ACC but the query mogex sayed should work

 

[Naxtie]

Lol, ima try this. Thanks!

Edit: Oh well.. it works to create the account now, but you cant login. When youre trying to login it says at the search bar on ur web browser, ?subtopic=accountmanagement. But u wont get logged in

 

[Daniel Kopeć]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bought' in 'order clause'' in C:\xampp\htdocs\shopsystem.php:170 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(170): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(211): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopsystem.php on line 170



PLZ HELP with this problem