Page 1 of 1

phpBB Arcade Mod issue...

Posted: Mon Feb 08, 2010 10:55 am
by spaceace
it has come to my attention that my mod causes an error with JRSweets Arcade Mod

the error is an sql error. here's the error that i have produced on my localhost machine
General Error
SQL ERROR [ mysql4 ]

Column 'topic_status' cannot be null [1048]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, topic_status) VALUES (2, 1265642987, 1265642987, '3', 0, 1, '[GAME RELEASE] Crash Test Dummy High Jump', 'spaceace', 'AA0000', 0, 0, 0, NULL)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1965
CALL: dbal_mysql->sql_query()

FILE: includes/arcade/arcade_admin_class.php
LINE: 1745
CALL: submit_post()

FILE: includes/acp/acp_arcade_games.php
LINE: 106
CALL: arcade_admin->create_announcement()

FILE: includes/acp/acp_arcade_games.php
LINE: 45
CALL: acp_arcade_games->add_games()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_arcade_games->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
this error only happens if the arcade is set to announce game releases by making a release post

thanks to Ashley.S.'s post here http://www.jeffrusso.net/forum/viewtopi ... 523#p21523 there is a fix already available :D

open includes/arcade/arcade_admin_class.php
find
Code: Select all
'topic_title'       => $subject,
after add
Code: Select all
'topic_status'		=> false,