from the playlist if you click on some media...
Code:
Database error in vBulletin 4.0.5:
Invalid SQL:
SELECT * FROM media_playlist WHERE playlistID = '2';
MySQL Error : Table 'db.media_playlist' doesn't exist
Error Number : 1146
Request Date : Friday, July 30th 2010 @ 07:04:08 PM
Error Date : Friday, July 30th 2010 @ 07:04:08 PM
Script : http://domain/media.php?do=details&mid=26&pid=2
Referrer : http://domain/media.php?do=playlist&pid=2
IP Address : xxx.xxxx.xxx.xxx
Username : Nicky
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch6-log
there is the PREFIX missing in this query..
EDIT:
got it..
open media/media_details.php
change line 96 from
Code:
$playlist = $vbulletin->db->query_first("SELECT * FROM media_playlist WHERE playlistID = '".$pid."'");
to
Code:
$playlist = $vbulletin->db->query_first("SELECT * FROM ".TABLE_PREFIX."media_playlist WHERE playlistID = '".$pid."'");