Bug DB Errors after uploading the latest patch

[Mick]

Here is the error

-------------------------------------------------
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
listingid
FROM theforumprefix__dbtech_classifieds_listing
WHERE enddate > 1392921849AND startdate < 1392921849 AND ended = 0 AND featured = 1 AND active = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'startdate < 1392921849 AND ended = 0 AND featured = 1 AND active = 1' at line 4
Error Number : 1064
Request Date : Thursday, February 20th 2014 @ 06:44:09 PM
Error Date : Thursday, February 20th 2014 @ 06:44:09 PM
Script : http://www.digitalworldz.co.uk/forumdisplay.php?f=466
Referrer : DigitalWorldz Technology Forum - Satellite, television, consoles, community
IP Address : 92.23.107.224
Username : hutchy36
Classname : vB_Database_MySQLi
MySQL Version :
-------------------------------------------------


I had to put the older files on for the time being.

I did try and reload all caches...

Did I need to re-upload the product?

Mick

 

[Mick]

Also this one just popped up

=====================================================

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
COUNT(*) AS count,
l.userid
FROM theforumprefix__dbtech_classifieds_listing AS l
WHERE l.userid IN ()
AND l.enddate > 1392923005
AND l.startdate < 1392923005
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 MariaDB server version for the right syntax to use near ')
AND l.enddate > 1392923005
AND l.startdate < 1392923005
AND l.ended =' at line 5
Error Number : 1064
Request Date : Thursday, February 20th 2014 @ 07:03:25 PM
Error Date : Thursday, February 20th 2014 @ 07:03:25 PM
Script : http://www.digitalworldz.co.uk/showthread.php?t=379089
Referrer :
IP Address : 87.238.41.136
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================

 

[Mokonzi]

Thanks matey. Will patch this first thing in the morning... I thought I'd covered the second error popping up... grrrrhhh

 

[Mick]

To be honest you might have....

That 2nd error was when I put the old files back

Cheers

 

[Mokonzi]

It's just the first error that's the issue. I've fixed and patched the Beta 1 files

 

[Mick]

Seems to be working fine now...

Thank you.

Mick

 

[Mick]

Hi Mokonzi,

One of my members has just messaged me this...


------------------------------------------
Error code below as well picture attachment.

Code:
Database Error Database error
The DigitalWorldz Technology Forum - Satellite, television, consoles, community database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the DigitalWorldz Technology Forum - Satellite, television, consoles, community home page, then try to open another page.
Click the Back button to try another link.

The DigitalWorldz Technology Forum - Satellite, television, consoles, community forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
------------------------------------------

They are getting the standard white DB error page

These are my logs...

------------------------------------------
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
listingid
FROM theforumprefix__dbtech_classifieds_listing
WHERE enddate > 1393017768 AND startdate < 1393017768 AND ended = 0 AND active = 1 AND l.moderated = 0;

MySQL Error : Unknown column 'l.moderated' in 'where clause'
Error Number : 1054
Request Date : Friday, February 21st 2014 @ 09:22:48 PM
Error Date : Friday, February 21st 2014 @ 09:22:48 PM
Script : http://www.digitalworldz.co.uk/dbtclassifieds.php?do=listing&categoryid=24
Referrer : Viewing Listing: XBOX 360 JTAG in - Buy Sell Wanted on Digitalworldz Classifieds Adverts
IP Address : 82.5.126.176
Username : Abu Baniaz
Classname : vB_Database_MySQLi
MySQL Version :
------------------------------------------

This is the actual username of the member that private messaged me.

I am not getting these errors myself, it all works fine for me...

 

[Mokonzi]

That was fun to find... but I think I've got it. If you want to try redownloading Beta 1 and see if the same user gets the same error again. I believe I've got it, but if you can confirm and then I'll upload the Lite to vb.org.

 

[Mick]

I have done the patch.

But waiting for the member to get back to me...

Regards
Mick

 

[Mick]

Mokonzi They are still getting errors mate.

=====================================================

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
listingid
FROM theforumprefix__dbtech_classifieds_listing
WHERE enddate > 1393022479 AND startdate < 1393022479 AND ended = 0 AND featured = 1 AND active = 1 AND l.moderated = 0;

MySQL Error : Unknown column 'l.moderated' in 'where clause'
Error Number : 1054
Request Date : Friday, February 21st 2014 @ 10:41:19 PM
Error Date : Friday, February 21st 2014 @ 10:41:19 PM
Script : http://www.digitalworldz.co.uk/dbtclassifieds.php?do=listing&categoryid=22
Referrer : Viewing Listing: VU+ DUO + 500 GB harddrive in - Buy Sell Wanted on Digitalworldz Classifieds Adverts
IP Address : 151.229.77.107
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================

 

[Mick]

I had a little play around and found in the listing.php there was two instances of

l.moderated

I do not know allot about MySQL or the calls, but I changed this to moderated and the classifieds is now working...

But again I am not sure what the l.moderated means.

Regards
Mick

 

[Mokonzi]

I've uploaded a new fix for you. I'd missed one of the instances that mattered.

l.moderated is a short cut for saying moderated on the listing table. The problem here was a function I was using wasn't using the 'l' abbreviation. I thought I'd got the only instances of it covered, but it wasn't which is why the second MySQL error cropped up. Changing both instances might create an error for you in another area later, so try replacing the /upload/dbtech/classifieds/action/listing.php file and see if that fixes this second error.

Thanks for the feedback and input.

 

[Mick]

That is looking positive

I am not getting any DB errors when viewing as a guest (and I was before).

See what the other members say, they will let me know sooner or later should there be an issue.

Thanks Mokonzi.

Great Support mate!!!

Mick