Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Nov 2014, 14:06
tarball tarball is offline
 
Join Date: Jul 2007
Error when resetting best score ever

Since I move server (new PHP / Mysql version?) I get this error while trying to remove best score ever on all games...

mySQL error: Incorrect integer value: '' for column 'bestmid' at row 1

I have been able to succesfully run the query manually by running it in phpmyadmin

UPDATE games_list SET bestscore='0',bestmid='0',besttime='0' WHERE gid IN

The 0 was missing. Which file should I update so I don't have to run the query manually in the future ?

--------------- Added 08 Nov 2014 at 14:36 ---------------

Apache v2.4.10 (cgi-fcgi)
PHP 5.5.18
Version MySQL 5.6.21
Reply With Quote
Comments
  #2  
Old 08 Nov 2014, 15:36
stangger5's Avatar
stangger5 stangger5 is offline
 
Join Date: Jan 2005
admincp/arcade.php

Look for:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

change :

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
vb ibProArcade: Download Game, Game Challenge, Report Game, Daily Game Systems.
40,000+ Flash and HTML5 Games,, and more can be found at: next-level-arcade.com
Reply With Quote
  #3  
Old 08 Nov 2014, 17:43
tarball tarball is offline
 
Join Date: Jul 2007
Thanks! Is there any other known patch to do when updating PHP/mysql?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 18:17.

Layout Options | Width: Wide Color: