vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   sql errors when adding games and submitting scores (https://vborg.vbsupport.ru/showthread.php?t=107147)

Madmp3zz 02-04-2006 05:09 PM
sql errors when adding games and submitting scores
 
I just wiped out my board and started from scratch.
I've done so many updates and hacks I figured it was about time to redo the whole box.

It's been a while since I installed vbulletin so I'm a little confused with this error.

The board is up and running along with the arcade.
When I try and add new games using tar files I am getting this error with every game I try, just the name is different..
I'm assuming it's a permission error.

Code:
mySQL query error: INSERT INTO games_list (gname,gwords,gtitle,bgcolor,gwidth,gheight,active,object,gkeys,gcat,added) VALUES ('100mRunning',' Run 100M as fast as you can, your best time will be submitted. ','100m Running','FFFFFF','600','450','1','4',' Run 100M as fast as you can. ','1','1139080076')

mySQL error: Field 'g_raters' doesn't have a default value
mySQL error code:
Date: Saturday 04th 2006f February 2006 02:07:56 PM
These are all good tar files, I had them saved from the original board.

When submitting scores I get thise error..
Code:
mySQL query error: INSERT INTO games_scores
                                                          (mid,gid,name,score,ip,timespent,datescored) VALUES
                                                  ('1','4','PAWSOX','3242','68.56.143.32','229','1139080830')

mySQL error: Field 'comment' doesn't have a default value
mySQL error code: 0
Date: Saturday 04th 2006f February 2006 02:20:30 PM
Did I miss something on the original setup?

TIA

cyberhypnotic 02-04-2006 05:23 PM
That's the game 100m, not the arcade. I'll let you know that some games don't work quite as well as some others.

Some games don't post scores, some games aren't even playable. It's all a matter of where you get the games from also. Some game files aren't written correctly and such.

Where did you get the 100m game from?

Madmp3zz 02-04-2006 07:21 PM
It's all 1100+ games that I get the error on...
I just posted that one as an example.

The error for the posting scores is from the standard Tetris that installs with the arcade.

I've used all these games 1100+ games on my board prior to reformatting and starting from scratch.

Madmp3zz 02-12-2006 06:30 PM
Is this a common issue or do I need to do a complete reinstall?

cyberhypnotic 02-12-2006 09:55 PM
I would try that out. Make sure you uninstall completely before reinstalling it.

Madmp3zz 02-14-2006 07:24 PM
WTF....
Just did a complete reinstall.. same errors..

I think it has to do with the mysql install...
Not sure what I did wrong, going to try and uninstall and reinstall mysql.

Anyone have a tutorial to setup mysql?
I remember I found one on the web somewhere and it worked perfect for my original install months ago..

jiffy 11-01-2006 09:05 PM
I'm having this same problem after moving to a new server. Did you figure it out?


All times are GMT. The time now is 03:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01120 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete