[RESOLVED] MySQL General Error When Installing Game

Downloads and support for phpBB Arcade.

[RESOLVED] MySQL General Error When Installing Game

Postby Ashley.S. » May 24th, 2009, 11:47 am

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

MySQL General Error wrote: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
Last edited by Ashley.S. on August 23rd, 2009, 6:28 pm, edited 1 time in total.
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am


Google
 

Re: MySQL General Error When Installing Game

Postby Jeff » May 25th, 2009, 8:08 am

You must be using a mod that modifies the sumbit_post function.
Everything ends badly, otherwise, it would never end.
Founding Member of the B.D.P.
Image
User avatar
Jeff
Site Admin
Site Admin
 
Posts: 2994
Joined: April 4th, 2004, 7:00 pm
Location: Brokeback Mountain
Highscores: 1

Re: MySQL General Error When Installing Game

Postby Ashley.S. » May 25th, 2009, 8:14 am

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.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: MySQL General Error When Installing Game

Postby Ashley.S. » May 25th, 2009, 9:09 am

sorry, I know your busy and all, but could you possibly tell me what that section of the SQL should be set at?
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: MySQL General Error When Installing Game

Postby Jeff » May 28th, 2009, 3:45 pm

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()
Everything ends badly, otherwise, it would never end.
Founding Member of the B.D.P.
Image
User avatar
Jeff
Site Admin
Site Admin
 
Posts: 2994
Joined: April 4th, 2004, 7:00 pm
Location: Brokeback Mountain
Highscores: 1

Re: MySQL General Error When Installing Game

Postby Ashley.S. » May 28th, 2009, 3:49 pm

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.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: MySQL General Error When Installing Game

Postby Ashley.S. » August 11th, 2009, 4:07 pm

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 :cry:

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 :D

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
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: MySQL General Error When Installing Game

Postby Jeff » August 17th, 2009, 3:12 pm

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.
Everything ends badly, otherwise, it would never end.
Founding Member of the B.D.P.
Image
User avatar
Jeff
Site Admin
Site Admin
 
Posts: 2994
Joined: April 4th, 2004, 7:00 pm
Location: Brokeback Mountain
Highscores: 1

Re: MySQL General Error When Installing Game

Postby Ashley.S. » August 17th, 2009, 5:03 pm

Jeff wrote: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.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: [RESOLVED] MySQL General Error When Installing Game

Postby Ashley.S. » August 23rd, 2009, 6:28 pm

just to inform you, I finally fixed the issue as I managed to work out how to sort it out :D
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: [RESOLVED] MySQL General Error When Installing Game

Postby spaceace » February 8th, 2010, 10:04 am

Ashley.S. wrote:just to inform you, I finally fixed the issue as I managed to work out how to sort it out :D


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 :shock:
User avatar
spaceace
Member
Member
 
Posts: 5
Joined: May 1st, 2008, 9:29 am

Re: [RESOLVED] MySQL General Error When Installing Game

Postby Ashley.S. » February 8th, 2010, 10:14 am

spaceace wrote:
Ashley.S. wrote:just to inform you, I finally fixed the issue as I managed to work out how to sort it out :D


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 :shock:


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.
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am

Re: [RESOLVED] MySQL General Error When Installing Game

Postby spaceace » February 8th, 2010, 10:26 am

thank you for the fast reply :D
User avatar
spaceace
Member
Member
 
Posts: 5
Joined: May 1st, 2008, 9:29 am

Re: [RESOLVED] MySQL General Error When Installing Game

Postby Ashley.S. » February 8th, 2010, 10:28 am

no problem :)
Ashley.S.
Member
Member
 
Posts: 9
Joined: May 24th, 2009, 11:28 am


Google
 


Return to [Arcade] Support

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest