Huge problem with gesior's forum

[Michaeel]

Hey, i have installed this forum on my OT: Simple forum script(Gesior) ? Tibia Acc Maker's and layouts

and look here, im logged in and i CAN'T do thread:

whats wrong?

 

[Michaeel]

bump?

 

[hodleo]

ehm just use the latest gesior's forum.php
http://websvn.4za.pl

 

[Michaeel]

I downloaded this: WebSVN - Gesior Acc - Rev 50 - /trunk/0.3.6/forum.php
is it good?
Because it doesn't work. ?subtopic=forum loads good but when i try enter to any thread:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sticky' in 'order clause'' in C:\xampp\htdocs\forum.php:219 Stack trace: #0 C:\xampp\htdocs\forum.php(219): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(208): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum.php on line 219

216-221 lines:

            $links_to_pages .= '<b>'.($i + 1).' </b>';
    }
    $main_content .= '<a href="?subtopic=forum">Boards</a> >> <b>'.$sections[$section_id].'</b><br /><br /><a href="?subtopic=forum&action=new_topic&section_id='.$section_id.'"><img src="images/topic.gif" border="0" /></a><br /><br />Page: '.$links_to_pages.'<br />';
    $last_threads = $SQL->query("SELECT * FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = ".(int) $section_id." AND `z_forum`.`first_post` = `z_forum`.`id` ORDER BY `sticky` DESC, `post_date` DESC LIMIT ".$threads_per_page." OFFSET ".($page * $threads_per_page))->fetchAll();  
    if(isset($last_threads[0]))
    {

whats wrong?:/

 

[hodleo]

you
believe, i wouldn't have uploaded it before testing it
you just need to execute these SQL queries in order

ALTER TABLE `z_forum` ADD `sticky` TINYINT(1) NOT NULL DEFAULT '0' AFTER `id`;

ALTER TABLE `z_forum` ADD `closed` TINYINT(1) NOT NULL DEFAULT '0' AFTER `sticky`;

 

[Michaeel]

Well i did it and now i can enter to all threads but problem wasn't solved.
It's stil the same.
"
Forum

Boards >> Poradniki



Page:
No threads in this board.
"
And i can not make new topic...

 

[hodleo]

might be the forum pics
check gesior's simple forum script for further information

 

[Michaeel]

Lmfao u are right! rep.