Status
Not open for further replies.

CharlieDelta

Customer
Getting the following database error when trying to show log entries.

Code:
Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'id' in 'order clause' in [path]/includes/class_core.php on line 1391
Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

		SELECT dbtech_search_log.*, user.username
		FROM dbtech_search_log AS dbtech_search_log
		LEFT JOIN user AS user ON (user.userid = dbtech_search_log.userid)
		
		ORDER BY id 
		LIMIT 0, 25;

MySQL Error   : Unknown column 'id' in 'order clause'
Error Number  : 1054
Request Date  : Friday, May 10th 2013 @ 09:39:51 PM
Error Date    : Friday, May 10th 2013 @ 09:39:51 PM
Script        : http://www.archerandangler.com/..../dbtech_search_log.php?do=view
Referrer      : http://www.archerandangler.com/...../dbtech_search_log.php?do=select
IP Address    : 98.124.1.10
Username      : Outdoorsman
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.68-cll
 

Ozzy47

Former Developer
Customer
Grief, re download the files and upload admincp / dbtech_search_log.php and let me know if that fixes it.
 

Ozzy47

Former Developer
Customer
CharlieDelta Ok cool, do it once again I noticed the Ascending Descending was not working as it should have been.
 

Ozzy47

Former Developer
Customer
Thanks for finding the issue, I forgot to rename one of the rows in the parameters that I had changed in the db.
 
Status
Not open for further replies.

vBSearch Log

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
3
Customer rating
0.00 star(s) 0 ratings
Top