• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Website [IMPORTANT]

Cypher

TwinkSoft Owner
Joined
Mar 21, 2011
Messages
834
Reaction score
16
Hey guys, i got a host for my new global server "Suphera" and it was working normal.
But when i changed the Database i got this problem on website:

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(286): OTS_Account->setCustomField('flag', 'bo') #2 C:\xampp\htdocs\index.php(147): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 811
And this:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'suphera.z_news_tickers' doesn't exist' in C:\xampp\htdocs\latestnews.php:41 Stack trace: #0 C:\xampp\htdocs\latestnews.php(41): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 41
 
table accounts is missing column `flag` and second error means that in your database is missing the table z_news_tickers.

Execute this in your SQL tag.
Code:
CREATE TABLE IF NOT EXISTS `z_news_tickers` (
  `date` int(11) NOT NULL DEFAULT '1',
  `author` int(11) NOT NULL,
  `image_id` int(3) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `hide_ticker` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `accounts` ADD `flag` varchar(255) NOT NULL;
 
Back
Top