Topic: database error in 1.1.7

[Panzz]

I am not sure if this is the right place to post this so please move it accordingly if required so.

I am getting an error for some of the games, error like this

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 '
endTime = 1227714436, gameDuration = 1227714436, memberIp = '116.15.170.189'' at line 3
File: /home/letstalk/public_html/Sources/Subs-Arcade.php
Line: 710

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

Executed the upgrade.php and still no difference, the same error still occur whenever you try to submit the score for the game.

Now the weirder thing is, the scores despite receiving an error like the above are saved!

So I would really appreciate if someone can help me out, if you need me to provide any more things, just let me know.

Thanks!

[jeza]

The last time I say an error like that was because games were being used that were not supported.

However you say the scores were saved?

The clue is in the gameDuration, its saying you were playing for 38 years.
 

Is this happening with the games from here?

[Panzz]

The last time I say an error like that was because games were being used that were not supported.

However you say the scores were saved?

The clue is in the gameDuration, its saying you were playing for 38 years.
 

Is this happening with the games from here?

I realized that yes, all the games that were affected were games not from here.

I think I probably will just either let it be as it is or delete all the affected games.

Now then again, 38 years?! I really remember it was only 5 mins 

[jeza]

Panzz I just got this error myself while trying out an old ipb game.
It seems the $startTime is not being sent to the savescore function so screwing up the timing variables. It also tries to insert a null startTime into the database which throws the error.

I'm looking into this now.
 

[Panzz]

now that is weird! You know I will really like to help, but I am not very familiar with the score codes.

Let me know if you need any files from me alright?

Thanks.

[jeza]

The problem with some older IBP games is they seem to drop through the entire ArcadeSubmitIBP function, the first run through saves the score and clears the session, the second, with data missing, throws the error.
Thats why you get the error but the score is saved anyway.

Try this , it worked for me.

Open ArcadePlay.php and in the ArcadeSubmitIBP function find

if (isset($_SESSION['arcade']['ibp']) && isset($_REQUEST['ibpa']) && $_REQUEST['ibpa'] == 3)

change that to

if (isset($_SESSION['arcade']['ibp']) && isset($_REQUEST['ibpa']) && $_REQUEST['ibpa'] === 3)

then find:

elseif (isset($_REQUEST['ibpa']) && $_REQUEST['ibpa'] == 2)

change that to

elseif (isset($_REQUEST['ibpa']) && $_REQUEST['ibpa'] === 2)

Let me know how you get on please.

[Panzz]

Thank you so much jeza! 

It fixed all the reported errors from my first post.

I hope this would be useful for some others who might have faced the similar issue because it worked great for me too!

[jeza]

Just keep an eye on things Panzz, make sure all regular games are now working ok.
 

[Panzz]

Just keep an eye on things Panzz, make sure all regular games are now working ok.
 

Will do !
Thank you so much once again!