crackerboy wrote:And i cant figure out how to enable the modules it doesnt say anything in the install.xmlCode: Select all
SQL ERROR [ mysql4 ] 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 ') ORDER BY t.topic_last_post_time DESC LIMIT 5' at line 47 [1064] SQL SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_last_post_time, t.topic_time, t.topic_title, t.topic_attachment, t.topic_views, t.poll_title, t.topic_replies, t.forum_id, t.topic_poster, u.username, u.user_id, u.user_type, u.user_colour, p.post_id, p.post_time, p.post_text, p.post_attachment, p.enable_smilies, p.enable_bbcode, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid, f.forum_name FROM phpbb_topics AS t LEFT JOIN phpbb_users as u ON t.topic_last_poster_id = u.user_id LEFT JOIN phpbb_forums as f ON t.forum_id=f.forum_id LEFT JOIN phpbb_posts as p ON t.topic_last_post_id = p.post_id WHERE ( t.topic_type != 2 ) AND ( t.topic_type != 3) AND t.topic_status <> 2 AND t.topic_approved = 1 AND () ORDER BY t.topic_last_post_time DESC LIMIT 5 BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 205 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 157 CALL: dbal_mysql->_sql_query_limit() FILE: portal/includes/functions.php LINE: 312 CALL: dbal->sql_query_limit() FILE: portal/block/news.php LINE: 35 CALL: phpbb_fetch_posts() FILE: portal.php LINE: 100 CALL: include('portal/block/news.php')
Is this fixed in 0.2.1 ?? or is there a way to make it handle more chars by editing the database ? if so tell me how..FlexyClown wrote:Looking good. Would be nice if the Welcome message could be longer than 160 characters and allow bbcode in it. Currently there is no checking of the length so anything over 160 chars gives a database insert error.
Now fixedFloyds wrote:Is this fixed in 0.2.1 ?? or is there a way to make it handle more chars by editing the database ? if so tell me how..FlexyClown wrote:Looking good. Would be nice if the Welcome message could be longer than 160 characters and allow bbcode in it. Currently there is no checking of the length so anything over 160 chars gives a database insert error.
Thx