[Forgott3n]

Originally Posted by silveryhat

*edit : Forgott3n I came up with a solution if you could perform these steps to help me checking it out.

Open install_dnp_musicbox.php with notepad
Find

PHP Code:

$check_song = mysql_query 


Replace with

PHP Code:

    global $vbulletin;
        $check_song = $vbulletin->db->query_first 


Save and Close, then run the installer again to see if the notice still appears.

Unfortunately it causes the page to hang at "Sending request ..." when loading either the install page or uninstall page.

function quick_db_sneak(){
		global $vbulletin;
        $check_song = $vbulletin->db->query_first("SELECT * FROM 
							  " . TABLE_PREFIX . "music_song,
							  " . TABLE_PREFIX . "music_album,
							  " . TABLE_PREFIX . "music_artist,
							  " . TABLE_PREFIX . "music_cat,
							  " . TABLE_PREFIX . "music_news,
							  " . TABLE_PREFIX . "music_logo,
							  " . TABLE_PREFIX . "music_setting 
							  limit 0,1");

Thats the affected code?

EDIT

Going directly to the forums/install_dnp_musicbox.php?do=setup_database page with the $_GET set, I receive this error:

Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM 
							  music_song,
							  music_album,
							  music_artist,
							  music_cat,
							  music_news,
							  music_logo,
							  music_setting 
							  limit 0,1;

MySQL Error   : Table 'bandaids_basilik.music_setting' doesn't exist
Error Number  : 1146
Request Date  : Saturday, July 11th 2009 @ 04:20:28 AM
Error Date    : Saturday, July 11th 2009 @ 04:20:28 AM
Script        : http://www.avrilbandaids.com/forums/install_dnp_musicbox.php?do=setup_database
Referrer      : 
IP Address    : 24.87.76.41
Username      : Forgott3n
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.81-community