vBookie Database Error

[bo$$]

Maybe one of you can help.
A forum I'm on runs vBulletin 3.8.0 Alpha 2 and it's got vBookie installed on it.
Now, vBookie works fine but when you click the "vBookie" button on the forums a database error page comes up with this message:


Database error in vBulletin 3.8.0 Alpha 2:

Invalid SQL:

SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_pay_after, thread.threadid, thread.forumid, thread.postuserid
FROM vbookie_items AS item
LEFT JOIN vbookie_groups AS grp ON grp.group_id = item.group_id
LEFT JOIN thread AS thread ON thread.vbookie_item_id = item.item_id
WHERE item.item_status='OPEN'
ORDER BY item.item_open_until, item.item_pay_after, item.item_id DESC
LIMIT 0, 20;

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Request Date : Saturday, March 24th 2012 @ 11:09:54 AM
Error Date : Saturday, March 24th 2012 @ 11:09:54 AM
Script :
Referrer :
IP Address :
Username :
Classname : vb_database
MySQL Version : 5.0.91-log


do ya know how to fix this?

Thread moved by Skynus (Forum Moderator) From 'Technology Discussion' to here as it's more suited to this forum

[GoldenMerc]

Is vBookie at the correct version thats the same as the vBulletin?

[bo$$]

I would assume so. It wasn't always broken, it just suddenly happened one day.
I'll look into it though and make sure.

[GoldenMerc]

Have you installed any other plugins? you may have taken out a essential hook

[Recursion]

Heads up, vBulletin 3.x is horribly buggy and insecure.

[GoldenMerc]

Heads up, vBulletin 3.x is horribly buggy and insecure.

If your talking about HabbCrazy's vB 3 being hacked yesterday but someone over at *****, its not actually vBulletin that gave them to chance to get in. Its ipb arcade, Habbcrazy didnt update it.

[Recursion]

If your talking about HabbCrazy's vB 3 being hacked yesterday but someone over at *****, its not actually vBulletin that gave them to chance to get in. Its ipb arcade, Habbcrazy didnt update it.

Still shouldn't be using it, considering 4.1.x is out.

[GoldenMerc]

Its overpriced as hell, raising the price for vB4.x
Considering most of the stuff they said they would put in 4.x, isn't in 4.x
I highly doubt il ever buy it straight out. I've got like 3 vBs (owned) at the moment only one runs 4.x the rest 3.x
Personally 4.x is just hassle, yes security updates but if im correct vBulletin.org is still using 3.x;

Powered by vBulletin® Version 3.6.12

Can't be that insecure now!

[xxMATTGxx]

If your talking about HabbCrazy's vB 3 being hacked yesterday but someone over at *****, its not actually vBulletin that gave them to chance to get in. Its ipb arcade, Habbcrazy didnt update it.

You know what I find funny about that, the owner of HabbCrazy slated other fansites for upgrading to Vb4 and according to their maintenance page they are doing that. Oh how things change...

[GoldenMerc]

You know what I find funny about that, the owner of HabbCrazy slated other fansites for upgrading to Vb4 and according to their maintenance page they are doing that. Oh how things change...

Yeh the owners a idiot, considering when i was owner it used to be ran pretty much the same as Habbox look how its run now. get naked on cam and your admin, wala

[Jack!]

Its overpriced as hell, raising the price for vB4.x
Considering most of the stuff they said they would put in 4.x, isn't in 4.x
I highly doubt il ever buy it straight out. I've got like 3 vBs (owned) at the moment only one runs 4.x the rest 3.x
Personally 4.x is just hassle, yes security updates but if im correct vBulletin.org is still using 3.x;


Can't be that insecure now!

No, its on the latest version.


Powered by vBulletin® Version 4.1.11

Edit, I was looking at vbulletin.com forums, My bad!