I have also installed and am getting an error when I click the link to view the player and also an error when I tryto add a new playlist.

--------------------------------
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;
MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
-------------------------------
Database error in vBulletin 3.6.5:
Invalid SQL:
insert into mp3playlist values(
'','http://jessicabolin.com/media/mp3/Slipknot-Vermilion2.mp3','true','0','Slipknot Vermillion Pt 2',''
);
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136

----------------------------------------
Update:

I read through the posts and saw someone suggest making some changes to the product xml. I did that and now the errors are gone. However, the mp3 files do not play or show up in the player. I checked my usergroup permissions and they are enabled, the player is enabled, and I verified the url to the mp3. Everything looks in order. Any idea why this would not play or show the mp3s? Thanks.

----------------------------------------
Update 2:

Okay, I am retarded! I just realized that I didn't have the little "approve" checked to "yes" for my mp3s. Duh! Haha!

-----------------------------------------
Conclusion:

This is a good hack so far. I just suggest adding those changes to the product xml as mentioned in previous posts so people don't have to go searching all over for a solution to the errors like I did. Plus, I see that a lot of people haven't gone so far as to look through the posts as I did. Would save a lot of trouble for others.

Thanks for the hack though!

Hi there Syrus

Installed but then get the following error can you please shed some light

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(*) AS id
FROM vb3_mp3playlist AS mp3playlist WHERE approvemp3=1;

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Friday, March 9th 2007 @ 11:22:17 AM
Script : http://www.conlons.co.uk/forum/mp3pl...mp3playerpopup
Referrer :
IP Address : 81.178.0.78
Username : *******
Classname : *******

Read back through the old posts. I had the same problem, but there is a solution given on one of the past pages. I can't remember the page number though. It's just some simple edits to your product xml file. Took care of the errors for me. :D

Installed (Clicked Installed) and with same above error regardless of the XML fix. I am sure once all the kinks are out it will be a very nice mod for my site!

These were the instructions I followed to get rid of my errors (listed in an earlier post of mine) and this worked. Make sure you are adding that new code to all of the tables listed there in red, plus mp3playlist5. It also says "disable" the plugin. I completely uninstalled and then reinstalled the product xml/plugin.

Looks like I'll have to update this error myself, since I haven't seen my co-author address the problem. I was hoping to have this mod fully working, since I've got another nearly ready.

The product xml file error is partially my fault for using a 3rd party exporter, which vb's product system doesn't seem to like. I'll try and get this issue addressed this weekend.

Sorry for the inconvenience.

hi ...

is this one updated?

Have uploaded all files installed product

try to edit templates and this what I get when trying to save....

Have checked to see if template.php is there and it is

Not sure what to do next...

"Not Acceptable

An appropriate representation of the requested resource /Forum/admincp/template.php could not be found on this server."

Cheers if anyone can help

Col

I've been trying to get this updated for some time now - everytime I go to do the update, something else comes along. I'll try and get it fully updated this week, and send out notifcations when its done.

Sorry for the delay...

Are you receiving this error from the standard vBulletin style, or a custom style? With some styles the template edit maybe slightly different.