Bug No prefix in tagging sql query

Status
Not open for further replies.

janslu

Customer
I have tried to regenerate content tags after upgrading to a current build of dbseo. I have reset existing tags and ran the add tags procedure in dbseocp. It shows process numbers as if it ran correctly, but there's an error message below:


Code:
Warning: mysqli_query(): (42S22/1054): Unknown column 'thread.dateline' in 'where clause' in ..../includes/class_core.php on line 1435

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT threadid FROM vb_thread WHERE threadid >= 101 AND thread.dateline >= 1152309600 LIMIT 1;

MySQL Error   : Unknown column 'thread.dateline' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, July 8th 2014 @ 11:28:49 AM
Error Date    : Tuesday, July 8th 2014 @ 11:28:52 AM
Script        : http://www.babyboom.pl/forum/dbseocp/index.php?do=tagging
Referrer      : http://www.babyboom.pl/forum/dbseocp/index.php?do=tagging
IP Address    : 77.253.215.54
Username      : janslu
Classname     : vB_Database_Slave_MySQLi
MySQL Version : 5.5.37-0ubuntu0.12.04.1-log

I guess the query should be:
Code:
SELECT threadid FROM vb_thread WHERE threadid >= 101 AND vb_thread.dateline >= 1152309600 LIMIT 1;
as I'm using vb_ table prefix...
 
This has now been fixed, the fixed file is /dbtech/dbseo/actions/admin/tagging.php :)

Thanks :)
 
Status
Not open for further replies.

Legacy DragonByte SEO

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
7,193
Customer rating
5.00 star(s) 1 ratings
Back
Top