PDA

View Full Version : Unknown column 'user.vbbux' in 'field list' vb 3.6 rc2


Neal-UK
07-25-2006, 04:07 AM
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
SET
`user.vbbux` = `user.vbbux` + `post.vbbux`
WHERE
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?do=dodeletethreads&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
07-26-2006, 11:41 AM
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
07-26-2006, 02:17 PM
werid .... i have it working perfectly on mine.

Neal-UK
07-26-2006, 04:20 PM
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
07-30-2006, 10:46 AM
I'm removing this as the lottery is knackered too. And I want GARS to work.

kinkarso
12-10-2006, 02:24 AM
I have the same exact problem. I have both vbplaza and GARs installed. How do I fix this?

The Geek
12-16-2006, 07:19 AM
try checking this thread-> https://vborg.vbsupport.ru/showthread.php?t=120624