• 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!

I get this error when i try to go to my websight using local ip 127.0.1

Werewolf

Werewolf

Forbidden Ascension
Joined
Jul 15, 2012
Messages
886
Reaction score
123
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.logo_gfx_name' in 'field list'' in C:\xampp\htdocs\latestnews.php:67 Stack trace: #0 C:\xampp\htdocs\latestnews.php(67): PDO->query('SELECT `g`.`id`...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 67
 
Sort by date Sort by votes
SQL: 
ALTER TABLE `guilds` ADD `logo_gfx_name` varchar(255) NOT NULL DEFAULT '';
 
Upvote 0 Downvote
Well generly this error pops up when i try to look at the websight, it worked fine on my friends computer, then when we transferd the server and Sql to my computer, it started having alot of issues, we fixed most of them but this error stumped us both,


Also Ninja the ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR(255) NOT NULL DEFAULT ''; did not help, or i put it in wrong, Thank you anyways for the help :D
 
Last edited:
Upvote 0 Downvote
To execute the table ninja made, you have to go to phpmyadmin and open your database and execute it in the sql box.
I suggest you get uniform server instead of xampp, its more secure and stable.

Use the www folder of uniform server instead of htdocs on xampp.

The Uniform Server
 
Upvote 0 Downvote
Oh i see, after i put it in, it probly did work but now theres a new error...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgotten server.z_news_tickers' doesn't exist' in C:\xampp\htdocs\latestnews.php:145 Stack trace: #0 C:\xampp\htdocs\latestnews.php(145): 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 145
 
Last edited:
Upvote 0 Downvote
Missing the table z_news_tickers.

- - - Edited - - -

SQL: 
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;
 
Last edited:
Upvote 0 Downvote
Thank you Ninja, It worked great, however, a new error poped up,


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgotten server.z_forum' doesn't exist' in C:\xampp\htdocs\latestnews.php:277 Stack trace: #0 C:\xampp\htdocs\latestnews.php(277): PDO->query('SELECT `z_forum...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 277
 
Upvote 0 Downvote
SQL: 
CREATE TABLE `z_forum` (
  `id` int(11) NOT NULL auto_increment,
  `first_post` int(11) NOT NULL default '0',
  `last_post` int(11) NOT NULL default '0',
  `section` int(3) NOT NULL default '0',
  `replies` int(20) NOT NULL default '0',
  `views` int(20) NOT NULL default '0',
  `author_aid` int(20) NOT NULL default '0',
  `author_guid` int(20) NOT NULL default '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL default '0',
  `post_date` int(20) NOT NULL default '0',
  `last_edit_aid` int(20) NOT NULL default '0',
  `edit_date` int(20) NOT NULL default '0',
  `post_ip` varchar(32) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
 
Upvote 0 Downvote
Thank you Limos, it seemd to have worked, however another error poped up again... lol i hope this does not continue

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgotten server.z_news_tickers' doesn't exist' in C:\xampp\htdocs\latestnews.php:145 Stack trace: #0 C:\xampp\htdocs\latestnews.php(145): 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 145
 
Upvote 0 Downvote
How come you're getting the same error once again? Did you delete the table z_news_tickers?
 
Upvote 0 Downvote
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in C:\xampp\htdocs\latestnews.php:277 Stack trace: #0 C:\xampp\htdocs\latestnews.php(277): PDO->query('SELECT `z_forum...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 277


Inside my PHP admin, this is the list if have

accounts
account_viplist
Bans
environment_killers
global_storage
guilds
guild_invites
guild_ranks
houses
house_auctions
house_data
house_lists
killers
players
player_deaths
player_depotitems
player_items
player_killers
player_namelocks
player_skills
player_spells
player_storage
player_viplist
server_config
server_motd
server_record
server_reports
tiles
tile_items
z_forum
z_news_tickers

Am i missing one?

im trying to host a TFS 0.3.6 server using a xampp Version 1.7.3

www.tibiakingdoms.com
 
Last edited:
Upvote 0 Downvote
BUMP. I sincerely hope that this error is solved very soon it is most upsetting that i am unable to play on your server Master Link XD

Sincerely,
-Lucifer
 
Upvote 0 Downvote
XD hi Lucifer, nice talking with you again haha, and im surprised your still interested in the server
 
Last edited:
Upvote 0 Downvote
Back
Top