Bug VBArcade 1.30 XML Install Parse error

[CoZmicShReddeR]

Just downloaded and tried to install and received this error when using the product-dbtech_vbarcade.xml Installer

Parse error: syntax error, unexpected T_IF in /home/content/47/9320747/html/dbtech/vbarcade/arcade_installer.php on line 192

 

[skol]

Was that striaght to your live board? I'm just setting my test board up so can't confirm..

 

[CoZmicShReddeR]

Yes live/Update from 1.2.1

 

[CoZmicShReddeR]

Fixed it was a missing ; line 190 of the arcade_installer.php

 

[CoZmicShReddeR]

Derp now I am getting all kinds of fun errors...

Fatal error: [] operator not supported for strings in /home/content/47/9320747/html/admincp/arcade_admin.php on line 1080

Invalid SQL:
SELECT s.*, d.*, u.*, g.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS avheight_thumb, c.width_thumb AS avwidth_thumb, c.filedata_thumb FROM dbtech_vbarcade_session AS s INNER JOIN dbtech_vbarcade_data AS d ON (d.local_winner = s.sessionid) LEFT JOIN user AS u ON (u.userid = s.userid) LEFT JOIN dbtech_vbarcade_game AS g ON (g.gameid = s.gameid) LEFT JOIN avatar AS a ON (a.avatarid = u.avatarid) LEFT JOIN customavatar AS c ON (c.userid = u.userid) WHERE g.enabled = 1 AND s.record = 4 AND s.userid = 309 ORDER BY s.timefinish DESC LIMIT -10, 10;

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 '-10, 10' at line 1


I think I should have waited a few days now...

 

[skol]

Yes confirm..vb4.2..new test board.

.Parse error: syntax error, unexpected T_IF in /home/arcadeco/public_html/vbarcadetesting/dbtech/vbarcade/arcade_installer.php on line 192

 

[twolegit]

I guess I'll wait to update sorry to hear you're having issues

 

[Darkwaltz4]

er, sorry about that. its what i get for extracting an update out of my tournament stuff hang on

 

[Darkwaltz4]

The missing semicolon seemed to be the only problem, and this has been applied to the dbtech downloads.
I upgraded dbtech with the latest version to be sure, and everything went smoothly.

Derp now I am getting all kinds of fun errors...

Fatal error: [] operator not supported for strings in /home/content/47/9320747/html/admincp/arcade_admin.php on line 1080

Invalid SQL:
SELECT s.*, d.*, u.*, g.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS avheight_thumb, c.width_thumb AS avwidth_thumb, c.filedata_thumb FROM dbtech_vbarcade_session AS s INNER JOIN dbtech_vbarcade_data AS d ON (d.local_winner = s.sessionid) LEFT JOIN user AS u ON (u.userid = s.userid) LEFT JOIN dbtech_vbarcade_game AS g ON (g.gameid = s.gameid) LEFT JOIN avatar AS a ON (a.avatarid = u.avatarid) LEFT JOIN customavatar AS c ON (c.userid = u.userid) WHERE g.enabled = 1 AND s.record = 4 AND s.userid = 309 ORDER BY s.timefinish DESC LIMIT -10, 10;

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 '-10, 10' at line 1


I think I should have waited a few days now...

I am not getting any of these. Try uploading a fresh copy of v1.3.0 and running the install again

 

[twolegit]

updating right now, I'll let you know how it goes

 

[Darkwaltz4]

I got the mysql error on the stats page and got that fixed.. still not getting the error on arcade admin

 

[twolegit]

i have a blank page on arcade.php and it says it's 0kb?

no error on install or admincp

 

[Darkwaltz4]

i think you downloaded right as i was uploading a new copy. download again! sorry.... thanks for bearing with me

 

[twolegit]

yeah must have been that, everything seems to be working

no error on install or in admincp and i can play games so we are good to go! looking forward to the tourny mod!