Search options (Page 5 of 11)

Changes it your windows xp to Windows Vista?

The code is:  $result = $db->query('SELECT t.id, t.subject, t.num_replies, t.forum_id,  p.topic_id, p.poster, p.poster_id, p.message, p.hide_smilies, p.posted FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id AND p.posted=t.posted INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id WHERE t.forum_id='.$fid.' AND t.moved_to IS NULL AND f.redirect_url IS NULL ORDER BY t.posted DESC LIMIT '.$newslimit) or error('Unable to fetch the portal news', __FILE__, __LINE__, $db->error())

No have i cratet a new forum.
Bott a new problem The new problem is: An error was encountered
File: /home/www/pokemonfireforum.awardspace.com/index.php
Line: 38

PunBB reported: Unable to fetch the portal news

Database reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND t.moved_to IS NULL AND f.redirect_url IS NULL ORDER BY t.posted DESC LIMIT 5' at line 1 (Errno: 1064)
Help plz!

I can say how i gett the problem... Thes is how i click to gett portal news in adminstation then i click sumbit then that hapened....

Ok, go to include/parser.php delete adn somme smileys.

Oftopic: Ok,bott when 1.3 have i to edit the punbb files? Or do the extension it?

It is the same error

IS the columms on line 76?

Ok bott i have run it to day and when i runn it now i stays: An error was encountered
File: /var/www/hotserv.dk/users/pokemonfireforum1/install_mod_pms.php
Line: 77

PunBB reported: Unable to add columns to table

Database reported: Duplicate column name 'g_pm' (Errno: 1060)  Help agen plz!