Solved Help me !!!

[Muciz]

Hello everyone!

I got a bug with my website, i was removed my hellfire data base and created it again and now my website doesnt work how to fix it?

V
V


A Database Error Occurred
Error Number: 1146

Table 'hellfire.news' doesn't exist

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

 

[Hanoger]

It's easy to see the problem : Table 'hellfire.news' doesn't exist

 

[Muciz]

...

 

[swordman]

Try out installing the website all over again adding all tables?

 

[Vendeliko]

just make the table

 

[Muciz]

im very clumsy dont know where the table map is in xampp? :S can someone maybe help me?

 

[Cronox]

Hmmm not.. simple you remove table news.. need use this query:

CREATE TABLE IF NOT EXISTS `news` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(150) DEFAULT '',
  `body` text,
  `time` INT(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Muciz]

im very clumsy didnt know where the table map is :S where in xampp is the table map?

 

[Cronox]

not understand what you say?

 

[Muciz]

you know the document there is tables to add in sql in database cannot find the document in my xampp map :S, its to much maps + documents, so need help with find them if anyone got server then he/she maybe know where is it

 

[seleo]

re install your server website
open your htdocs folder and goto config
then edit config.ini so you can install again
and re install the website

 

[KarolkaDemolka]

please help me

A Database Error Occurred

Error Number: 1146

Table 'xanteria.news' doesn't exist

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

 

[Ninja]

please help me

A Database Error Occurred

Error Number: 1146

Table 'xanteria.news' doesn't exist

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

http://otland.net/f118/fixed-modern-aac-tibiarl-layout-169410/index9.html#post1670408

 

[KarolkaDemolka]

where i can found
SQL Code:??

- - - Updated - - -

here
C:\xampp\htdocs\system\database?

- - - Updated - - -

DB_driver??
sorry this is my first time i made modern acc

 

[Ninja]

Execute that in PMA (phpMyAdmin).

 

[KarolkaDemolka]

i go to phpMyAdmin
and where i found a table ?
thanks for help

- - - Updated - - -

Structure
SQL
Search
Query
Export
Import
Designer
Operations
Privileges
Drop

Run SQL query/queries on database xanteria:

- - - Updated - - -

SQL??

 

[Ninja]

Click on your server database and the SQL button next to "Structure".

 

[KarolkaDemolka]

yes
i do this but see

A Database Error Occurred

Error Number: 1146

Table 'xanteria.poll' doesn't exist

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()