vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=122045

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?

Quote:

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...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.