i cant find it

The player looks like it is playing but the progress button doesnt move and no sound comes out. Whats up?

Datenbankfehler in vBulletin 3.6.4:

Invalid SQL:

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

MySQL-Fehler : Unknown column 'approvemp3' in 'where clause'
Fehler-Nr. : 1054
Datum : Thursday, February 15th 2007 @ 09:39:24 PM

This fixes your problem.
https://vborg.vbsupport.ru/showpost....&postcount=422
thanks to Allan for posting the fix for 3.6.4

i got the same problem with you, even though i already used the alan fix code,


can someone confirm if you got this one work correctly on vb 3.6.4 ?

i did try installed on my forum, but after i added the mp3, and all i got play button flashing, look like it playing, but there no sound, no time track, i added like 5 mp3, but on the playlist shown only 1, i did approved from cpanel ....

i think this one dont work for vb 3.6.4

i have to uninstall this thing ....:o

[QUOTE=lonelime;1185796]i got the same problem with you, even though i already used the alan fix code,


can someone confirm if you got this one work correctly on vb 3.6.4 ?

i did try installed on my forum, but after i added the mp3, and all i got play button flashing, look like it playing, but there no sound, no time track, i added like 5 mp3, but on the playlist shown only 1, i did approved from cpanel ....

i think this one dont work for vb 3.6.4

Try this, if installed already allow overwrite when importing
EDIT:(You can get the files from the author's site which fixed the problem) I could post them but will not without the author's approval. Apparently he changed more than the XML. Not sure why its not updated here.

[QUOTE=sinisterpain;1185877]I did and received this error:


XML Error: syntax error at Line 2

[QUOTE=revmitchell;1185901]See above for your answer

I'll just uninstall it. Thanks

[QUOTE=revmitchell;1185901]This error will soon be fixed. It was caused by an Advanced Product Export System which isn't compatible with an un-modified vBulletin forum. I don't suggest installing the modification so this error doesn't show, since it is for debugging new scripts, etc.

hi syrus,

any chance on an update for my previous post re the broken track?

many thanks

jonny

hi all,

any chance to get this updated, so it could work correctly for vb 3.6.4

this would be nice ...

I'll try and get this done, before releasing another modification which is nearly finished. I'll send out emails to people that have installed this version, and pressed 'Installed'.

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Thursday, February 22nd 2007 @ 04:42:37 PM
Script : http://www.xxxx.com/forums/mp3player...mp3playerpopup
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database

I'm using 3.6.4 and I have the same error.
Is there any way to handle that?

No One will Help??

look like this one is death ... no update

the fixed code still lot of bugs, and couldnt get the mp3 playing ....

your new mod was release....but there is no update on this one yet ??

I'm waiting on the co-author to apply a fix for this mod. Sorry.

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.

Hi

I'm using various styles on the site and have tried it on a few including the default...but I do have a nav bar mod which doubles up the nav bar registered members see a secondary nav bar above the main navbar.



site is here if you wish to take a look

Thanks

http://www.performancepolishing.net/...php?styleid=16

Is there any way to have the player sort the lists alphabetically by the song title? I don't like how all the songs and artists are all mixed up. Thanks.

Well, I have had a lot of bother trying to get mods to work, so on instruction from VB, I have made a new forum without a skin mod! I added your MP3 player and this is the error I get...

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Monday, March 26th 2007 @ 04:16:36 AM
Script : http://www.l2wildc5.com/testforum/mp...mp3playerpopup
Referrer :
IP Address : 196.25.255.250
Username : Nutty
Classname : vb_database


How do I fix this?
thanks
Nutty

I got it all installed, seemed to work, but it does not play the MP3. The play button flashes and thats it. I checked the url to the mp3, it works. the mp3 name is simple lowercase letters and no spaces.. what else can I do?

I get the exact same error please help!

I install it and i get this sql error and i dont now how to fix it
Can you help me please?
Thank you


Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Friday, March 30th 2007 @ 01:39:15 AM
Script : http://www.greekwave.net/forums/mp3p...mp3playerpopup
Referrer :
Classname : vb_database

This is the same fix which we are all waiting for.

<a href="https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=422</a> you guys read through alot...

That does not fix our problem. Thanks for playing though.

I'm very excited about this great hack. However, I too am experiencing difficulties. I've applied the aforementioned XML edits but still receive the following error.


I'm willing to make a $$ donation if we can expedite the resolution.