Thanks for letting us know. I'll have a look at what's continuing to cause the issues. :)

Matt

The error you are getting suggests that your server hasn't run the upgrade script that came with the first Beta for v1.1.0. Can you check if in your database you have the columns:

dbtech_classifieds_feedbackleftcount
dbtech_classifieds_feedbackleftcount
dbtech_classifieds_itemwoncount
dbtech_classifieds_itemsoldcount
dbtech_classifieds_itemunsoldcount

In the table user

If not, then try setting your version number in your product to 1.0.3 and then reimport the latest Beta 2 import script and see what happens.

Regarding the other MySQL error caused when viewing threads via TapaTalk, I've a new version of Beta 2 and I'm hoping this fixes the issue. :)

We need to re-download the version 1.1.0b2 Matt?

I did the updated download.
It's still happening.

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393423414
AND l.startdate < 1393423414
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND l.enddate > 1393423414
AND l.startdate < 1393423414
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 09:03:34 AM
Error Date : Wednesday, February 26th 2014 @ 09:03:35 AM
Script : http://www.hobby-machinist.com/mobiquo/mobiquo.php
Referrer :
IP Address : 66.175.144.84
Username : usrjcro11
Classname : vB_Database
MySQL Version :

nelson@hobby-machinist.com nelson@hobby-machinist.com
9:05 AM (23 minutes ago)

to nelson
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393423521
AND l.startdate < 1393423521
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND l.enddate > 1393423521
AND l.startdate < 1393423521
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 09:05:21 AM
Error Date : Wednesday, February 26th 2014 @ 09:05:21 AM

Uploaded a fix for that MySQL error Nelson as well as another MySQL error that was happening because of a missing column in the user table.

For the second fix to work, download the package and reupload the files. Before importing the XML, change the version number of the DragonByte Classifieds product in the Admin Control Panel > Plugins & Products > Manage Products > DragonByte Tech: Classifieds (Pro) or (Lite) > Edit to 1.0.3 and save the product.

Then reimport the XML which should add the missing column in the user table.

We will include this fix in the Beta 3 upgrade files, but this fix is there for users who want to apply these fixes before Beta 3 is ready.

Matt

Matt:

The error came back even though table entries were modified.


nelson@hobby-machinist.com nelson@hobby-machinist.com
4:00 PM (0 minutes ago)

to nelson
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393448403
AND l.startdate < 1393448403
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND l.enddate > 1393448403
AND l.startdate < 1393448403
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 04:00:03 PM
Error Date : Wednesday, February 26th 2014 @ 04:00:04 PM
Script : http://www.hobby-machinist.com/mobiquo/mobiquo.php
Referrer :
IP Address : 50.175.76.112
Username : nmasi
Classname : vB_Database
MySQL Version :

I got rid of it finally. I had to delete the old files. Then download fresh, & install. Then reinstall after changing the version number. That did it.

Thanks for updating us Nelson. :)

Matt

Hi, I have the pro version, and since the last update when I click http://www.zzz.com/dbtclassifieds.php?do=user&action=feedbacklist reviews gives me a database error:

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE xxxuser
SET
dbtech_classifieds_feedbackleftcount = 0,
dbtech_classifieds_feedbackreccount = 0
WHERE userid = 1;

MySQL Error : Unknown column 'dbtech_classifieds_feedbackreccount' in 'field list'
Error Number : 1054
Request Date : Thursday, February 27th 2014 @ 01:09:04 PM
Error Date : Thursday, February 27th 2014 @ 01:09:04 PM
Script : http://www.zzz.com/dbtclassifieds.php?do=user&action=feedbacklist
Referrer : http://www.zzz.com/dbtclassifieds.php?do=listing&action=viewlisting&l istingid=4
IP Address : 37.15.182.202
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.35-cll

Questions regarding the Pro mod, needs to be asked on their site in the pro support forum for the mod.