Solved Gesior AAC Error

[Wartio]

Hey guys!

today i tried to start gesior aac website for tfs 0.3.6 fixed config in server and in htdocs later when i try to connect to the website
then this shows up :$



please help me anyone! cuz i will start a public server, just the website left


(if the pic is to little here is the text that shows up)

Notice: Undefined index: action in C:\xampp\htdocs\index.php on line 14

Notice: Undefined index: account_login in C:\xampp\htdocs\index.php on line 40

Notice: Undefined index: password_login in C:\xampp\htdocs\index.php on line 41

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dezent.z_news_tickers' doesn't exist' in C:\xampp\htdocs\latestnews.php:7 Stack trace: #0 C:\xampp\htdocs\latestnews.php(7): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(73): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 7

 

[Ninja]

Add this to your index.php.

error_reporting(E_ALL ^ E_NOTICE);

phpMyAdmin

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;

 

[Wartio]

Where in Index.php and where in phpMyAdmin?
Sorry for asking so much but im newbie in making websites, idk where to add them (xmapp / htdocs?) or localhost/phpmyadmin?



here is the index.php file if u can edit it for me please! would be very thankfull

http://www.speedy*****malware.localhost/b6BPH/index.php

lastestnews.php too
http://www.speedy*****malware.localhost/3sgJQ/latestnews.php

if there is changes for both files

- - - Updated - - -

anyone can help? please, im really in hurry please!

 

[Ninja]

Under <?PHP in index.php

error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE);

Other one is executed in phpMyAdmin (SQL query).

 

[Wartio]

New error came up after i fixed the other ones, they works now but other 1 came up says

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dezentots.z_news_big' doesn't exist' in C:\xampp\htdocs\latestnews.php:109 Stack trace: #0 C:\xampp\htdocs\latestnews.php(109): PDO->query('SELECT image_id...') #1 C:\xampp\htdocs\index.php(74): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 109

what should i add?

 

[Ninja]

It's missing the table z_news_big.

CREATE TABLE IF NOT EXISTS `z_news_big` (
  `hide_news` tinyint(1) NOT NULL DEFAULT '0',
  `date` INT(11) NOT NULL DEFAULT '0',
  `author` VARCHAR(255) NOT NULL,
  `author_id` INT(11) NOT NULL,
  `image_id` INT(3) NOT NULL DEFAULT '0',
  `topic` VARCHAR(255) NOT NULL,
  `text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[Wartio]

Isnt there any PHP Code i should add in lastestnews.php too?
cuz i added that code you sent to me but it still says the same, i maybe need to add any code to Lastestnews.php like the other 1 ? ;o

cuz after i added that code u just sent it says like this

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'topic_df' in 'field list'' in C:\xampp\htdocs\latestnews.php:109 Stack trace: #0 C:\xampp\htdocs\latestnews.php(109): PDO->query('SELECT image_id...') #1 C:\xampp\htdocs\index.php(74): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 109

Im really sorry for asking so much but im not good at coding :$:$

 

[Ninja]

Delete table z_news_big and replace it with this one instead.

CREATE TABLE IF NOT EXISTS `z_news_big` (
  `hide_news` tinyint(1) NOT NULL DEFAULT '0',
  `date` INT(11) NOT NULL DEFAULT '0',
  `author` VARCHAR(255) NOT NULL,
  `author_id` INT(11) NOT NULL,
  `image_id` INT(3) NOT NULL DEFAULT '0',
  `topic_df` VARCHAR(255) NOT NULL,
  `text_df` text NOT NULL,
  `topic_ot` VARCHAR(255) NOT NULL,
  `text_ot` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[Wartio]

Finally i made it ;D!!, Thanks so much Ninja! !! will rep++ you