vb.org Archive - Database (MySQL) error, how to fix??

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - Database (MySQL) error, how to fix?? (https://vborg.vbsupport.ru/showthread.php?t=167041)

Akuma2000

01-05-2008 08:09 PM

Database (MySQL) error, how to fix??

I'm recently installed the Arcade.

GREAT MOD!

But it is giving me MySQL errors when somebody in the tournament makes a new record:

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

SELECT * FROM vb_tournament WHERE tid =;



MySQL Error  : 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 '' at line 1 Error Number : 1064

Date         : Saturday, January 5th 2008 @ 05:54:13 PM

Script       : http://www.iwsclan.com/forums/index.php?act=Arcade&do=newscore

Referrer     : http://www.iwsclan.com/forums/arcade.php?&do=playtourney&gameid=4&tid=11&rung=1&faceoff=1

IP Address   : XX.XX.XX.XXX

Username     : XXX

Classname    : XXX

Can somebody tell me how to fix this?

Thnx in advance!

MrZeropage

01-06-2008 09:46 AM

it should be "tournaments" I guess there is a problem in some file-edit you did ?

Akuma2000

01-06-2008 12:16 PM

Do you have an idea wich file-edit that should be?

I can't remember doing a file edit with "vb_tournament".
And I copy-pasted everthing, so there should be no error made.

I've installed vbcredits with the ibproarcade addon

MrZeropage

01-06-2008 05:33 PM

Try to deactivate it - I am SURE that the typo is there...

Akuma2000

01-06-2008 09:54 PM

It's the addon for vbcredits.
There was a bug in there, but the coder made a patch.
See here:
http://www.vbcredits.com/forum/tracker.php?itemid=87

Might come in handy for fellow vbcredits users :)

MrZeropage

01-07-2008 04:27 PM

I was sure it was not a problem of my code ;) :D

Akuma2000

01-07-2008 06:35 PM

Hi all,

I got another error again:

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT * FROM vb_tournament WHERE tid = 5;

MySQL Error  : Table 'xxx.vb_tournament' doesn't exist Error Number : 1146

Date         : Monday, January 7th 2008 @ 07:35:40 PM

Script       : http://www.iwsclan.com/forums/index....de&do=newscore

Referrer     : http://www.iwsclan.com/forums/arcade/snake.swf

IP Address   : xx.xxx.xx.xxx

Username     : xxx

Classname    : vb_database

As you can see, the database doesn't exist.
Just as MrZeropage said before.

Because now it calles the table 'vb_tournament' instead of 'vb_tournaments'
I guess that's the problem.

But I don't know in which file this code is used.
Do you got any idea wich file it could be?

Thnx in advance!

MrZeropage

01-07-2008 07:48 PM

I guess it's vbCredit or something like this again - any addon related to ibProArcade...

Akuma2000

01-07-2008 10:56 PM

Yes!
And it's fixed again :D

See it here:
http://www.vbcredits.com/forum/showt...=5929#post5929

All times are GMT. The time now is 07:08 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01126 seconds Memory Usage 1,725KB 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 (9)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
Messages: