Bug Feedback Database error.

[Mick]

Hi Mokonzi,

Running latest beta.

One of my members is getting a database error when trying to leave feedback

Here is what I can find in the database log...

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE theforumprefix__user
SET
dbtech_classifieds_feedbackleftcount = 0,
dbtech_classifieds_feedbackreccount = 0
WHERE userid = 258576;

MySQL Error : Unknown column 'dbtech_classifieds_feedbackreccount' in 'field list'
Error Number : 1054
Request Date : Monday, February 24th 2014 @ 08:24:48 PM
Error Date : Monday, February 24th 2014 @ 08:24:48 PM
Script : DigitalWorldz Technology Forum - Satellite, television, consoles, community
Referrer : DigitalWorldz Technology Forum - Satellite, television, consoles, community
IP Address : 86.11.179.153
Username : monty55
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================


Cheers

Mick

 

[Mokonzi]

Thanks matey. I've had another report if this. Can you tell me if those columns exist in your user table?

 

[Mick]

I have the feedbackleftcount, but cannot find the feedbackrecount in phpmyadmin.

Cheers
Mick

 

[JaiKai]

Got the same issue reported to me this morning on our system.

 

[Mokonzi]

Fixed that file for you. Download Beta 2, and follow the instructions in this post:

DragonByte Classifieds v1.1.0 Beta 2 Released!

Those should fix this MySQL error.

 

[Mick]

Seems good so far will check the logs in 30 mins see what happens

Cheers
Mick