[RESOLVED] MySQL General Error When Installing Game

[Ashley.S.]

hey there, I wondered if you could help me with this error I am getting when installing games to the arcade:

General Error
SQL ERROR [ mysqli ]

Column 'topic_status' cannot be null [1048]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_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, topic_attribute) VALUES (53, 1243182085, '128', 0, 1, '[GAME RELEASE] 9 Dragons Hexa', 'Ashley.S.', 'AA0000', 0, 0, 0, NULL, '')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1911
CALL: dbal_mysqli->sql_query()

FILE: includes/arcade/arcade_admin_class.php
LINE: 1737
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: 87
CALL: p_master->load_active()

The game installs fine, I'm guessing this error is something to do with the posting of game announcement topics so do you have any suggestions as to how I can fix this?

To avoid the errors coming up again for my other admins, I have turned the option off

Thanks for any help in advance

[Jeff]

You must be using a mod that modifies the sumbit_post function.

[Ashley.S.]

The only mods I can think of that could have done it would be the advanced block mod or the ACP anti-spam mod as they are the only two mods I can think of that modifies the SQL for posting because I have been badly attacked against spammers recently

[Ashley.S.]

sorry, I know your busy and all, but could you possibly tell me what that section of the SQL should be set at?

[Jeff]

I don't have an answer. I don't know what is changed. I would review the install files for other mods you installed and see which on edited the function and then make the same change to the arcade.

Code: Select all

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

[Ashley.S.]

ok thanks for you help, I'll have a good look around after I have finished transferring my site to its new server & I have got back from my weekend away

[Ashley.S.]

sorry for the late reply back, my board went dead, and whilst re-installing the arcade to my new board, I came across the error again

I turned on debug mode and it came up with a specific line in the includes/functions_posting.php file

The Line causing the SQL error was this one:

Code: Select all

            'topic_status'         => $post_data['topic_status'],

This lead me to finally check the mods that I had to install to try and track down that line, and the Mod causing the error was with the lock new topic on submit located at: http://www.phpbb.com/community/viewtopi ... &t=1501915

The mod is now un-installed and everyone is working great again

If I can get a workaround, then that would be good, if not then not to worry because the arcade mod is more important than easy locking of new topics

[Jeff]

You would need to modify the arcades call to:

Code: Select all

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

the same way the mod has you edit the submit_post function.

[Ashley.S.]

You would need to modify the arcades call to:

Code: Select all

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

the same way the mod has you edit the submit_post function.

doing that is probably way beyond my knowledge...I think I will just go without that mod for now

Thanks for your help though

[Ashley.S.]

just to inform you, I finally fixed the issue as I managed to work out how to sort it out

[spaceace]

just to inform you, I finally fixed the issue as I managed to work out how to sort it out

i would like to know how you fixed this issue. i didn't even know my mod was conflicting with any other mod till i read it here

[Ashley.S.]

just to inform you, I finally fixed the issue as I managed to work out how to sort it out

i would like to know how you fixed this issue. i didn't even know my mod was conflicting with any other mod till i read it here

I had to open: includes/arcade/arcade_admin_class.php

and find:

Code: Select all

         'topic_title'       => $subject,

and then add the following after it:

Code: Select all

           'topic_status'        => false,

the topic prefix mod I used also caused a similar error, I'm guessing it was something to do with not knowing what to do with the selection of locking the topic or not where its not a default phpBB3 function.

[spaceace]

thank you for the fast reply

[Ashley.S.]

no problem