vb.org Archive - v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) + 1 AS position
FROM gamesessions AS gamesessions
WHERE score > AND valid=1 AND gamesessions.gamename=''

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 'AND valid=1 AND gamesessions.gamename=''' at line 3

mysql error number: 1064

Date: Tuesday 31st of May 2005 07:10:04 PM
Script: http://www.lifesbattles.com/forums/arcade.php
Referer: http://www.lifesbattles.com/forums/a...play&gameid=16

- Show quoted text -

ANY IDEAS?

Exitilus

06-02-2005 03:37 AM

Quote:

Originally Posted by Exitilus

I've been looking through this thread for hours. Basically my scores are not submitting. Once you hit submit nothing happens. If it auto-submits it just stays on the game screen. If you exit out. You have a score of 0.

This is a fresh install on my test site.

Anyone?

dsboyce8624

06-02-2005 03:16 PM

I'm looking for the add on that puts multiple colums of games on each page.

Anybody know where it is?

Thanks.

YLP1	06-03-2005 02:52 AM

Quote:

Originally Posted by YLP1

SimonHodgkis, I have an error very similar to yours which I can't fix. I wonder if these are related.

Code:

Database error in vBulletin 3.0.7:

 

Invalid SQL: 

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline

FROM vb3_user AS user

LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid

LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid

WHERE user.userid = 

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 5

 

mysql error number: 1064

Any advise on fixing this is greatly appreciated it's been driving me nuts for over a week now.

Hi RJordon.....I got the other error fixed but this one is still hanging around and is intermittent.

I have tried all of the code mods over again and still can't get rid of this.

Any ideas?

rjordan

06-03-2005 09:41 AM

I am not sure. What I gave to you to fix this problem fixed the exact same problem on my site. I will try to look more, but I do not know what else to give you at this point.

Wachtmeister

06-03-2005 04:11 PM

Hello,

some of my users cannot challenge anymore and some scores where not set to 0, when resetting the scores last month. (as described here: http://www.v3arcadegames.com/forums/...ead.php?p=3648)

Does someone has an idea, what went wrong and what can be the problem, that some users cannot challenge anymore? Does anyone know the sql command to reset all scores to 0 and does anyone how to reset all other relevant tables in the user record?

Best wishes, Wachtmeister

jesus likes pie

06-03-2005 05:24 PM

mmmm....i have a bunch of swf games but how do i add them other than uploading them to the games folder?

dsboyce8624

06-03-2005 06:40 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=60666&highlight=v3arcade" target="_blank">https://vborg.vbsupport.ru/showt...light=v3arcade</a>

:Judge:

06-04-2005 06:22 AM

Okay I have searched through the whole thread and only people I see with an issue anything like mine was using Dreamweaver, I am not and have not used anything other then wordpad to get this error at the top of my pages.....
Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3006

Also now when I try to access a forum I get this..
Unable to add cookies, header already sent.
File: /home/******/public_html/forums/includes/init.php
Line: 27

I went and uploaded the files as they was before I started and I am still getting these errors after so. The site is down I have no clue as to what happened or how to fix it. Could someone please give me some type of diriction please.

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

Page 373 of 457

373

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07208 seconds Memory Usage 1,746KB 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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: