vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - The XEON Mp3 Player for vBulletin 3.6.X Integrated (https://vborg.vbsupport.ru/showthread.php?t=129641)

FRANKTHETANK 2 12-10-2006 10:06 PM

hey syrus. oen more thing. how do i get rid of teh add mp3 stuff and where do i add playlists and what do i add as name of them?

syrus.xl 12-10-2006 10:17 PM

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1135997)
hey syrus. oen more thing. how do i get rid of teh add mp3 stuff and where do i add playlists and what do i add as name of them?

To remove the Add Mp3 link in the popup you would need to edit your default style and edit the mp3player template. The code you would need to remove would be this:

Code:

        <div align="center" style="padding: 5px 5px 5px 5px;">
<a href="mp3playerindex.php?do=addmp3" target="_blank">Add Your MP3's</a>
        </div>

The player is designed with only 5 playlists, these can't be changed in this version. I may add this feature in an future update.

syrus.xl 12-10-2006 10:21 PM

Quote:

Originally Posted by trd167 (Post 1135996)
I installed everything when I when click on vBmp3player on the navbar or "mp3 player settings" under the admin setting, i get this error.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM mp3player_settings;

MySQL Error : Table 'whiteplusyellow.mp3player_settings' doesn't exist
Error Number : 1146
Date : Sunday, December 10th 2006 @ 04:04:30 PM
Script : http://www.whiteplusyellow.com/forum...ayer_admin.php
Referrer :
IP Address : xx.xxx.x.xxx
Username : WhiteplusYellow
Classname : vB_Database

Did you click on Save Settings after importing the product xml file? It's referring to an error that the mp3player settings table is missing. Which the product xml file creates during import.

trd167 12-10-2006 10:37 PM

Quote:

Originally Posted by syrus.xl (Post 1136003)
Did you click on Save Settings after importing the product xml file? It's referring to an error that the mp3player settings table is missing. Which the product xml file creates during import.


is there a way i could have the mp3player settings table manually? it seems like the product xml file does not create it for me during import.

TTG 12-10-2006 10:45 PM

Receiving the same database error !?

Biggles 12-10-2006 10:45 PM

Thanks a million syrus.xl. This hack of yours is a real doozy. I've kept up with the upgrades and was looking forward to this one. As I said before: my members love it and use it a lot. Very nice job you've made of it.

Biggles

FRANKTHETANK 2 12-10-2006 10:53 PM

so i just make 5 playlists like the vbplayer and name them plylist1,2 and so on?

bluesteel 12-10-2006 10:57 PM

Upgrade installed and appears to be working fine on 3.6.4 in Macclesfield. Thanks syrus.xl :)

syrus.xl 12-10-2006 11:17 PM

Quote:

Originally Posted by trd167 (Post 1136009)
is there a way i could have the mp3player settings table manually? it seems like the product xml file does not create it for me during import.

I added a note to the main post with a temporary fix. And I'll fix this later correctly.

syrus.xl 12-10-2006 11:42 PM

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1136018)
so i just make 5 playlists like the vbplayer and name them plylist1,2 and so on?

This version doesn't use that principle anymore, that was used on the XML version, released back in September 2006. Playlists are created in the Mp3 Player Management in your AdminCP.

You could rename the playlists by editing the templates for this modification, but the database will still require them to listed numerically.

FRANKTHETANK 2 12-10-2006 11:44 PM

ok well let me look at it again. can i still get the olderversion if i want. i liked it better that way was esier fo rme since i know how.

syrus.xl 12-10-2006 11:46 PM

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1136046)
ok well let me look at it again. can i still get the olderversion if i want. i liked it better that way was esier fo rme since i know how.

Yeah, its available here!:)

https://vborg.vbsupport.ru/showthread.php?t=125817

beishe8 12-11-2006 01:15 AM

Norton is deleting a file from the now updated ZIP file.
Why?

Biggles 12-11-2006 01:28 AM

Quote:

Originally Posted by beishe8 (Post 1136089)
Norton is deleting a file from the now updated ZIP file.
Why?

I had the same snag, beishe8. It's a Nortons problem (as usual). The way around it is to disable virus protection after downloading the zip (perhaps come off the net while you do that).

Once you've extracted the files, your troubles are not quite over. You will need to go back on the net to upload the files thru ftp. So, disable Antivirus briefly while you do that, otherwise Nortons will delete that same file as you try to upload. Once you are finished with the file transfer to the server, you are all clear to re-activate Nortons AV.

I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

I think the real answer is to dump Nortons and get a proper AV system. There are better available - and some don't keep recharging you for what you've already paid for - grrr!

Best of luck. Incidentally, once I did the above it's all working just fine on my site. And it's a great mod well worth the trouble of setting it up.

Regards

Biggles

beishe8 12-11-2006 04:08 AM

Quote:

Originally Posted by Biggles (Post 1136092)
I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

Thanks Biggles for the quick help. I'll do as you recommended.

Just a question to Syrus XL : Isn't it possible to rename that offending file?

Regards,

beishe8

Edit:
And a second question:Why did not pop up this problem earlier when the original player was unzipped?

dramster 12-11-2006 06:59 AM

Quote:

Originally Posted by TTG (Post 1136013)
Receiving the same database error !?

Me too...

Any ideas how we can fix this?

I installed in the same way I installed first time round and it fails with the db error.

I have installed tice now and failed both times. I have installed by uninstalling the beta version - is this correct?


Cheers,
Drammy

syrus.xl 12-11-2006 09:31 AM

Quote:

Originally Posted by dramster (Post 1136188)
Me too...

Any ideas how we can fix this?

I installed in the same way I installed first time round and it fails with the db error.

I have installed tice now and failed both times. I have installed by uninstalling the beta version - is this correct?


Cheers,
Drammy

The package is now updated. The product XML file has been updated and should fix the database problem.:)

dramster 12-11-2006 10:28 AM

Wicked, thanks Syrus.xl!

dramster 12-11-2006 11:49 AM

Scratch that - I'm still getting the error, although this time against another field:


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, December 11th 2006 @ 08:39:38 AM
Script : http://libby.asmallorange.com/~dramm...mp3playerpopup
Referrer : http://libby.asmallorange.com/~drammy/virus/
IP Address : xx.xxx.xxx.xx
Username : Drammy
Classname : vb_database

micheal332001 12-11-2006 12:37 PM

Quote:

Originally Posted by dramster (Post 1136272)
Scratch that - I'm still getting the error, although this time against another field:


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, December 11th 2006 @ 08:39:38 AM
Script : http://libby.asmallorange.com/~drammy/virus/mp3playerindex.php?do=viewmp3playerpopup
Referrer : http://libby.asmallorange.com/~drammy/virus/
IP Address : xx.xxx.xxx.xx
Username : Drammy
Classname : vb_database


Ill sort this out now and send syrus the new xml

tobybird 12-11-2006 04:18 PM

odd... double posted sry

tobybird 12-11-2006 04:20 PM

Quote:

Originally Posted by beishe8 (Post 1136089)
Norton is deleting a file from the now updated ZIP file.
Why?

Quote:

Originally Posted by Biggles (Post 1136092)
I had the same snag, beishe8. It's a Nortons problem (as usual). The way around it is to disable virus protection after downloading the zip (perhaps come off the net while you do that).

Once you've extracted the files, your troubles are not quite over. You will need to go back on the net to upload the files thru ftp. So, disable Antivirus briefly while you do that, otherwise Nortons will delete that same file as you try to upload. Once you are finished with the file transfer to the server, you are all clear to re-activate Nortons AV.

I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

I think the real answer is to dump Nortons and get a proper AV system. There are better available - and some don't keep recharging you for what you've already paid for - grrr!

Best of luck. Incidentally, once I did the above it's all working just fine on my site. And it's a great mod well worth the trouble of setting it up.

Regards

Biggles

Quote:

Originally Posted by beishe8 (Post 1136151)
Thanks Biggles for the quick help. I'll do as you recommended.

Just a question to Syrus XL : Isn't it possible to rename that offending file?

Regards,

beishe8

Edit:
And a second question:Why did not pop up this problem earlier when the original player was unzipped?

If you guys don't mind, I was wondering what the answer to his edit is as well. Thanks!

trd167 12-11-2006 08:56 PM

everything is working fine. thank you!

trd167 12-11-2006 09:08 PM

never mind...i am getting this message when i try to open the player on my navbar.

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, December 11th 2006 @ 03:07:10 PM
Script : http://www.whiteplusyellow.com/forum...mp3playerpopup
Referrer :
IP Address : xx.xxx.x.xxx.
Username : WhiteplusYellow
Classname : vB_Database

TTG 12-11-2006 11:01 PM

Quote:

Originally Posted by syrus.xl (Post 1136233)
The package is now updated. The product XML file has been updated and should fix the database problem.:)


Not yet it doesn't :confused:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM mp3player_settings;

MySQL Error : Table 'XXXXXX_XXX.mp3player_settings' doesn't exist ..
etc etc etc

PostMaster 12-12-2006 02:29 AM

Quote:

Originally Posted by trd167 (Post 1136597)
never mind...i am getting this message when i try to open the player on my navbar.

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, December 11th 2006 @ 03:07:10 PM
Script : http://www.whiteplusyellow.com/forum...mp3playerpopup
Referrer :
IP Address : xx.xxx.x.xxx.
Username : WhiteplusYellow
Classname : vB_Database

I'm getting this as well, also with me I don't even see the player on the navbar until I click on a forum to read it(any forum), then I'll see it on the navbar and it takes me to this link. My zonealarm pop up unzipping this and said it clean a file, I didn't right it down but I closed down my zonealarm and unzipped it again and upload to the forum root directory like told.

I have three styles and I can see it on the default style on 3.6.2 forum default and takes me to this error I'm quoting.

The other two sytles I don't see it until I read the forum and then see it on the navbar. I have arcade install find, this is not working for me.

also what do I put in the URL if this is the reason?
https://vborg.vbsupport.ru/external/2006/12/15.jpg

syrus.xl 12-12-2006 06:52 AM

Quote:

Originally Posted by PostMaster (Post 1136809)
I'm getting this as well, also with me I don't even see the player on the navbar until I click on a forum to read it(any forum), then I'll see it on the navbar and it takes me to this link. My zonealarm pop up unzipping this and said it clean a file, I didn't right it down but I closed down my zonealarm and unzipped it again and upload to the forum root directory like told.

I have three styles and I can see it on the default style on 3.6.2 forum default and takes me to this error I'm quoting.

The other two sytles I don't see it until I read the forum and then see it on the navbar. I have arcade install find, this is not working for me.

also what do I put in the URL if this is the reason?
https://vborg.vbsupport.ru/external/2006/12/15.jpg

I'll be updating the product XML later today, to rectify these problems. The images you have posted regarding Product version, etc are for 'live' version tracking. I didn't use these for a number of reasons, this mod is not specifically released just on vbulletin.org (which supports version tracking), but also a number of smaller sites. It is used to track if you have the latest version available from your ACP. So, both fields were left blank because it was released as a global modification.

shete 12-12-2006 09:15 AM

Everything works perfectly except for when the people try to add MP3s ...

it says " Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_pm in /includes/class_dm.php on line 763 "

What can I do to fix this ???

PostMaster 12-12-2006 11:16 PM

Quote:

Originally Posted by syrus.xl (Post 1136887)
I'll be updating the product XML later today, to rectify these problems. The images you have posted regarding Product version, etc are for 'live' version tracking. I didn't use these for a number of reasons, this mod is not specifically released just on vbulletin.org (which supports version tracking), but also a number of smaller sites. It is used to track if you have the latest version available from your ACP. So, both fields were left blank because it was released as a global modification.


Ok I see, ok updated it and unzipped it again and this is what pop up with ZoneAlarm saying it clean a virus is it ok to continue without this file to make this work? I'm assuming Zonealarm just thinks this is a virus and is protecting me from any harm. What should I do allow this file with Zonealarm closed and then upload it to the server? It will only remove it again when it does it's daily search :confused: So I will have to do this when the virus with Zonealarm is turned off.


https://vborg.vbsupport.ru/external/2006/12/8.gif

Stavs16 12-13-2006 02:49 AM

if i also wanted to embed this into my forum home what would be the code?

TTG 12-13-2006 06:50 AM

un-installed and re-installed and now new database error :

Quote:

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'

JRite 12-13-2006 08:26 PM

i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

Parture 12-13-2006 11:38 PM

That's why I am still using the xml version. Better safe than sorry. I prophesied this would happen, as it has happened so many times before like vbjournal, vbquiz and others. There is nothing worse than a database error for a plugin, where you can't unistall it and the you can't access your forum because of a database error. Before people create a product, they need to make sure it works on these very basic levels first.

JRite 12-14-2006 03:10 AM

Quote:

Originally Posted by JRite (Post 1138039)
i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

i'm still stumped...

micheal332001 12-14-2006 03:10 AM

Quote:

Originally Posted by JRite (Post 1138039)
i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

Take alook in your ftp to make sure you have uploaded all files to where they should be, as it looks like you have not uploaded them to the right folders.

JRite 12-14-2006 03:33 AM

what is my ftp?

JRite 12-14-2006 03:57 AM

oh... and...

Quote:

AdminCP -> Styles & Templates -> Navigation / Breadcrumb Templates -> navbar
^ my 3.6.4 doesn't even have those options... wtf?

tobybird 12-14-2006 01:19 PM

Quote:

Originally Posted by JRite (Post 1138247)
oh... and...


^ my 3.6.4 doesn't even have those options... wtf?

lol

Admin CP

Styles & Templates

Style Manager

Edit Templates

Navigation / Breadcrumb Templates

navbar


Ya might want to pull out the manual. ;) http://www.vbulletin.com/docs/html/

seabiscuit 12-14-2006 02:38 PM

looks really nice but i am getting this error. I think i had it working before when i was testing it, and i tried to install it for good


Database error in vBulletin 3.6.4:
Code:

Invalid SQL:
insert into mp3playlist values(

        '','http://www.xxx.com/mp3/victory.mp3','true','5','victory',''

        );

MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136

Script      : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=do_add_playlist1
Referrer    : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=addplaylist1

What's wrong? Help would be greatly appreciated.

micheal332001 12-14-2006 04:47 PM

Quote:

Originally Posted by seabiscuit (Post 1138492)
looks really nice but i am getting this error. I think i had it working before when i was testing it, and i tried to install it for good


Database error in vBulletin 3.6.4:
Code:

Invalid SQL:
insert into mp3playlist values(

    '','http://www.xxx.com/mp3/victory.mp3','true','5','victory',''

    );

MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136

Script      : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=do_add_playlist1
Referrer    : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=addplaylist1

What's wrong? Help would be greatly appreciated.

I will have alook at this for you and get back to you here.


All times are GMT. The time now is 03:46 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02264 seconds
  • Memory Usage 1,862KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete