vBulletin Database Error!

[Utas]

Hi again,

Every hour, i got this error :

Invalid SQL:

	SELECT snapshotid, data
	FROM ffxivdbtech_vbactivity_snapshot
	WHERE snapshotid = (
		SELECT revertsnapshotid
		FROM ffxivdbtech_vbactivity_snapshotschedule
		WHERE end_hour = G
			AND end_day = w
			AND active = 1
	)
		OR snapshotid = (
		SELECT loadsnapshotid
		FROM ffxivdbtech_vbactivity_snapshotschedule
		WHERE start_hour = G
			AND start_day = w
			AND active = 1
	);

MySQL Error   : Unknown column 'G' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, May 8th 2010 @ 08:21:16 PM
Error Date    : Saturday, May 8th 2010 @ 08:21:16 PM
Script        : http://www.valkyur.com/FFXIV/cron.php?rand=1273350076
Referrer      : http://www.valkyur.com/FFXIV/forumdisplay.php?4-La-Taverne
IP Address    : 82.235.10.66
Username      : Non inscrit
Classname     : vB_Database
MySQL Version :

 

[Fillip H.]

I've uploaded a potential fix for this, please re-download the zip and re-upload the files.

 

[Utas]

I have upload the folder upload.
Do I need to re-upload xml too?

 

[Fillip H.]

No need, the files should be fine

 

[Utas]

Yep, seems to be work!
Thank you.