vBulletin Mods

The Official vBulletin Modifications Site

Unknown column 'user.vbbux' in 'field list' vb 3.6 rc2
by Neal-UK
25 Jul 2006 06:07

Forum Version: 3.6rc2

I keep getting errors like this, sometimes referring to cron and also every time I try to delete a thread. Even if I try to prune them via Admin CP.

It works on another site, but the site i'm having problems with also has p3tz enabled so is that conflicting somewhere?


Database error in vBulletin 3.6.0 Release Candidate 2:
Invalid SQL:
UPDATE user AS user, post AS post
`user.vbbux` = `user.vbbux` + `post.vbbux`
post.threadid = '2983'
AND user.userid = post.userid;
MySQL Error : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date : Tuesday, July 25th 2006 @ 12:55:00 AM
Script : http://www.***.eu/talk/inlinemod.php...threadids=2983
Referrer : http://www.***.eu/talk/inlinemod.php?forumid=127
IP Address : *************
Username : Neal
Classname : vb_database
EDIT: Turns out GARS and vBux will not work together. Works fine when either turned off.

The Geek 26 Jul 2006 13:41

There isnt a conflict with GARS, there are bugs in the vbux deletion scripts where the sql statements are qualiifed incorrectly:

i.e. `user.vbux` makes SQL think its a column name called `user.vbux` insetead of a column aliased to table `user`. I already posted about this a month ago (along with the typos with TABLE_PREFIX).

Kenshin11 26 Jul 2006 16:17

werid .... i have it working perfectly on mine.

Neal-UK 26 Jul 2006 18:20

Ah well, it's a shame. I need vBux for the P3tz system, but I would like GARS as it's great. Too many files for me to go through to check.

Neal-UK 30 Jul 2006 12:46

I'm removing this as the lottery is knackered too. And I want GARS to work.

kinkarso 10 Dec 2006 04:24

I have the same exact problem. I have both vbplaza and GARs installed. How do I fix this?

The Geek 16 Dec 2006 09:19

try checking this thread-> http://www.vbulletin.org/forum/showthread.php?t=120624

All times are GMT. The time now is 21:07.

Powered by vBulletin® Version 3.8.13
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.