PDA

View Full Version : VBSupport Plugin error :(


steven1091
02-26-2008, 01:38 PM
Hello, i get this error:

"Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,13)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Tuesday, February 26th 2008 @ 12:20:29 AM
Script : http://habbovalley.com/vbsupport.php...wthread&tid=11
Referrer : http://habbovalley.com/vbsupport.php?do=newthread
IP Address : 82.20.36.29
Username : Blured"

This is on the VB support system when sending or responding to a ticket.

Can you help??

Much appreciated!

Lynne
02-26-2008, 02:19 PM
If you have problems with a modification, the best way to get help is to post in the Modification thread.

steven1091
02-26-2008, 02:25 PM
Tried - no response - was advised to post here

Lynne
02-26-2008, 02:56 PM
Well, the error is caused by a plugin you are using. The only way to fix it is to disable the plugin or fix the plugin. We don't know what plugin it is, nor do we know the code (obviously), so it is very hard to tell you what is wrong. Well, what is wrong is that they are calling for a column called "field" in the table "vbs_ticket_post" and it isn't there. So, you need to figure out why it isn't there and then add it or get rid of the call to that field if it is no longer needed (because you deleted a plugin).

shovel
02-26-2008, 03:29 PM
In file showthread.php find the following

avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

Right after that find there should be your problem. Remove "level," and hopefully you'll be able to troubleshoot the rest. By chance, did you modify your database for this mod?

Opserty
02-26-2008, 03:34 PM
shovel: It's most likely the modification will be using Plugins to edit the queries (most common queries now have $hook_query_* vars) so you probably won't find the solution in the PHP files.

steven1091
02-26-2008, 04:37 PM
ok so to sum it up what shalll i do? Btw to see what plugin i mean you can see below "imilar threads"

Thanks

p.s no i did not modify database - automatic install.

Lynne
02-26-2008, 04:46 PM
Well, in his thread here, it looks like he has big huge letters that say
vbSupport v2.0.0 BETA 2 by CMX (http://www.cmgsccc.com (http://www.cmgsccc.com/))


Have you posted over there?

steven1091
02-26-2008, 07:01 PM
thats a complete diff website so no... anyway does anyone know the problem or not :S or any suggestions on what to do

shovel
02-26-2008, 07:08 PM
shovel: It's most likely the modification will be using Plugins to edit the queries (most common queries now have $hook_query_* vars) so you probably won't find the solution in the PHP files.

The person stated that even after the plugins were disabled the query still failed, leading me to believe that the file was modified. Did I miss something?

Anywho, if you want to be so technical then how about you look in your plugin manager absolutely make sure that ALL plugins are deactivated. Then once again return to showthread.php and try to modify, etc. etc. on any given thread.

If that doesn't work, please reply again with your result.

Paul M
02-26-2008, 08:11 PM
The person stated that even after the plugins were disabled the query still failed ...
Where have they stated that ?

Opserty
02-27-2008, 11:08 AM
Its not even the showthread.php page...

Your problem is with the modification steven1091, you won't be able to use the modification unless it is fixed by the author or yourself (that is if you have MySQL, PHP & vB knowledge).

shovel
02-27-2008, 11:52 AM
Where have they stated that ?


My apologies, I mixed up responses from two different threads, I feel like an idiot now haha. Sorry Opserty. Anywho, I'll gladly download the hack and try to pinpoint the problem, that'll probably give us a better solution.

OPsNaStYM0FO
11-04-2009, 08:53 PM
I got this working on vb 3.8.4 Patch level 1 .

Open vbsupport.php and find this below

customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

under that you will see level and then remove the whole line there is a few of them . that you will have to remove and it will work .