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

Error Xampp>Apache no localhost

eliasb1994

New Member
Joined
Jan 5, 2011
Messages
4
Reaction score
0
Hi bros

Can anyone help me with this problem on the localhost?

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

Thank you alot.
 
Last 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;

Next time, post in english.
#2. Make sure your English is readable. If your English isn't good, I suggest you
to ask your friends, nearby family to help or use a translator like Google Translate.
http://otland.net/f16/need-help-ask-properly-correctly-18402/
 
Oh sorry pple, i confused. My error. I post in some foros XD. Really sorry

Thank you limos, i will try your fixe Now.

In some minutes i report the result !

Pd: Sorry for my english, i'm argentinian xd. See us

Edit: I execute this code in the database, and now the error is :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tibia.z_forum' doesn't exist' in C:\xampp\htdocs\latestnews.php:205 Stack trace: #0 C:\xampp\htdocs\latestnews.php(205): 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 205
 
Last edited:
SQL:
CREATE TABLE IF NOT EXISTS `z_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `icon_id` int(3) NOT NULL DEFAULT '1',
  `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
 
Thank you a lot. Now i can enter in the web.

But still have some errors on Create Account, Highscores, etc.

Where can i find a guide for fix this kind of problems ? i'm bothering much.
 
looks to me that your gesior (htdocs) folders are corrupted i could give you my .php's like which ever ones you need or you can take all of them if you like?
 
Back
Top