Quote:
Originally Posted by JD45
Atakan, I'm still getting this error when trying to view links. Any suggestions?
Code:
Invalid SQL:
SELECT *
FROM vb_advnavbar_links
ORDER BY advnavbar_links.linkorder DESC
LIMIT 0, 10;
MySQL Error : Unknown table 'advnavbar_links' in order clause
|
Find advanced_navbar.php
PHP Code:
switch($vbulletin->GPC['order'])
{
case 'name':
$order = 'advnavbar_links.linkname';
break;
case 'id':
$order = 'advnavbar_links.linkid';
break;
case 'status':
$order = 'advnavbar_links.linkstatus';
break;
default:
$order = 'advnavbar_links.linkorder';
}
REPLACE
PHP Code:
switch($vbulletin->GPC['order'])
{
case 'name':
$order = TABLE_PREFIX .'advnavbar_links.linkname';
break;
case 'id':
$order = TABLE_PREFIX .'advnavbar_links.linkid';
break;
case 'status':
$order = TABLE_PREFIX .'advnavbar_links.linkstatus';
break;
default:
$order = TABLE_PREFIX .'advnavbar_links.linkorder';
}