Bug Conflict with Tapatalk?

[Nelson]

Since installing 1.1.ob1, I get the following error with Tapatalk 4.9.1. I DISABLED the classifieds mod and the errors STOPPED!


nelson@hobby-machinist.com nelson@hobby-machinist.com
9:24 AM (14 minutes ago)

to nelson
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
COUNT(*) AS count,
l.userid
FROM dbtech_classifieds_listing AS l
WHERE l.userid IN ()
AND l.enddate > 1392819884
AND l.startdate < 1392819884
AND l.ended = 0
AND l.active = 1
AND l.moderated = 0
GROUP BY l.userid;

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 > 1392819884
AND l.startdate < 1392819884
AND l.ended =' at line 5
Error Number : 1064
Request Date : Wednesday, February 19th 2014 @ 09:24:44 AM
Error Date : Wednesday, February 19th 2014 @ 09:24:44 AM
Script : DI for the tool post
Referrer :
IP Address : 66.249.64.7
Username : Unregistered
Classname : vB_Database
MySQL Version :

 

[Mokonzi]

Thanks matey. I've found the issue. I'll put out a patch on the beta shortly for you all

 

[Nelson]

Can you upload the fix patch here please? I re-downloaded the mod and still am getting the errors with Tapatalk. Thanks!

Nelson

 

[Nelson]

I downloaded your latest version and the issue persists.

 

[Mokonzi]

Thanks for the update Nelson. I'll see if I can get to the route of the issue.

 

[Mokonzi]

I've uploaded a fix into the latest v1.1.0 Beta 2. Can you test the Lite download from here at DBTech and see if that resolves your issue?

 

[Nelson]

It's still happening, and I want to use it.

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

 

[Mokonzi]

I'll post up some changes shortly matey. Not sure why Tapatalk isn't obeying the checks that are in place.

 

[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 another potential MySQL error you might receive.

 

[Nelson]

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 another potential MySQL error you might receive.

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 :

 

[Nelson]

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.

 

[Mokonzi]

Can you try redownloading the product again and seeing if that fixes the issue. From what I can see the fix is in place, so I'm puzzled as to why it's not showing up here. Do you cache files in any way?

 

[Mokonzi]

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.

Never noticed the reply since it was on a new page. Glad you got it sorted matey. It was puzzling me.