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!
|