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)

Neal-UK 02-03-2007 10:32 PM

What errors are you getting?

Ryloth 02-03-2007 11:05 PM

I'm getting the below error when attempting to goto: /forums/mp3playerindex.php?do=viewmp3playerpopup

PHP Code:

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 

If I goto just mp3playerindex.php its a blank screen.

Help.

LisaD1 02-03-2007 11:06 PM

This is the navbar error

Code:


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        : Saturday, February 3rd 2007 @ 08:05:05 PM
Script      : http://www.live-love-chat.com/forums...mp3playerpopup
Referrer    :
IP Address  : 70.78.7.84
Username    : Lisa
Classname    : vb_database

And this is the add error

Code:


Database error in vBulletin 3.6.4:
Invalid SQL:
insert into mp3playlist values(
 '','http://filecargo.com/dw.php?id=1170548929','true','0','',''
 );
MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136
Date        : Saturday, February 3rd 2007 @ 08:06:19 PM
Script      : http://www.live-love-chat.com/forums..._add_playlist1
Referrer    : http://www.live-love-chat.com/forums...o=addplaylist1
IP Address  : 70.78.7.84
Username    : Lisa
Classname    : vb_database


Ryloth 02-03-2007 11:26 PM

Oh good, I'm not the only one with that database error.

LisaD1 02-03-2007 11:29 PM

Quote:

Originally Posted by Ryloth (Post 1174001)
Oh good, I'm not the only one with that database error.


No I guess not. All we have to hope for is a fast fix!!! :p

Neal-UK 02-04-2007 12:13 AM

Here you go: https://vborg.vbsupport.ru/showpost....&postcount=422

Think you got to unistall first, and re-install with the edited plugin file ;-)

LisaD1 02-04-2007 12:17 AM

Quote:

Originally Posted by Neal-UK (Post 1174020)
Here you go: https://vborg.vbsupport.ru/showpost....&postcount=422

Think you got to unistall first, and re-install with the edited plugin file ;-)

OK I will check it out!!
Thanks!

syrus.xl 02-04-2007 01:40 AM

Quote:

Originally Posted by Ryloth (Post 1173982)
I'm getting the below error when attempting to goto: /forums/mp3playerindex.php?do=viewmp3playerpopup

PHP Code:

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 

If I goto just mp3playerindex.php its a blank screen.

Help.

The mp3playerindex.php file is not accessible directly, it relies on 'do' functions - therefore it will display a white page.

The error is relating to a database field missing - this will be fixed shortly, without having to uninstall and reinstall the product.xml file. I'll export a copy of the updated file from the development site and update the package on here.

Yvgeniy 02-04-2007 05:04 AM

Just thought I'd mention a few bugs or things that could use improvement. The PM Admin Text To User type box has a fairly small character limit, which limits the amount of stuff you can write. Pretty annoying if you ask me. The message after you add an mp3 says "The MP3 has been added to are database" or something along those lines. My point is that it's "are" instead of "our." That's all I noticed so far.

cajunboy2208 02-04-2007 06:26 AM

Can someone post a link to their site that has it running? I want to see exactly how it works, and if it is resizeable... it looks huge.

Yvgeniy 02-04-2007 04:11 PM

Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10


Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.

trd167 02-04-2007 11:42 PM

I finally unstalled this mod, it never worked. :(

Distance 02-05-2007 07:24 AM

Product checking doesn't work for this?

I think you forgot to enter the product id

Sofia 02-05-2007 07:08 PM

Quote:

Originally Posted by Yvgeniy (Post 1174515)
Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10


Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.



For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

Allan 02-05-2007 07:26 PM

But why this hack doen't upgrade with modifications to Sofia ??

hotmasala4u 02-05-2007 07:27 PM

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

cant find this template

$vbphrase[calendar]

not even this i am using blackice

Yvgeniy 02-05-2007 08:55 PM

Quote:

Originally Posted by hotmasala4u (Post 1175426)
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

cant find this template

$vbphrase[calendar]

not even this i am using blackice

That's because blackice uses image buttons instead of the regular navbar, so you have to actually look in the header to find that, I believe. Personally, I got rid of buttons and just use the standard system. That way I don't have to make a new button each time I want to add something (example: www.sakstudios.net/forums). Let me know if you want to do the same and I'll give you the code.

Quote:

Originally Posted by Sosos145 (Post 1175408)
For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

Actually, that was already there to begin with. So that's not the problem.

syrus.xl 02-05-2007 10:07 PM

Quote:

Originally Posted by Yvgeniy (Post 1174136)
Just thought I'd mention a few bugs or things that could use improvement. The PM Admin Text To User type box has a fairly small character limit, which limits the amount of stuff you can write. Pretty annoying if you ask me. The message after you add an mp3 says "The MP3 has been added to are database" or something along those lines. My point is that it's "are" instead of "our." That's all I noticed so far.

Most of the features you've mentioned have either been fixed or added. However, since this is the free version some of these features are limited or do not exist. A Pro version was designed with many new features, including new players and skins and dynamic wording, if required.

TeknoSounds 02-05-2007 11:34 PM

Hiyas, getting this error when attempting to add a file to playlist 1 thru admincp:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
insert into vb_mp3playlist values(

        '','http://teknosounds.com/download/mixes/dj3/drizzle.mp3','true','10','DJ^3 - Drizzle - Breaks',''

        );

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

Downloaded the most recent version. Tried some fixes listed but didn't seem to do anything. Anyone have suggestions on fixing this error?

Thanks in advance!

swiss 02-06-2007 03:56 AM

installed and get the following

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 : Tuesday, February 6th 2007 @ 05:54:39 AM
Script : http://<URL REMOVED>//mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 70.112.241.193
Username : <REMOVED FOR THIS POST>
Classname : vb_database

any idea's please as followed the install to a T

es-league.com 02-06-2007 07:48 AM

I also get this error when trying to add mp3's using the admin cp :

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:
insert into mp3playlist values(

'','/mp3/green_day_american_idiot.mp3','true','0','GREEN DAY - AMERICAN IDIOT',''

);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Tuesday, February 6th 2007 @ 09:42:46 AM
Script : http://www.es-league.com/forum/admin..._add_playlist1
Referrer : http://www.es-league.com/forum/admin...o=addplaylist1
IP Address : 81.129.93.143
The flash player shows up no problem , the install seems to be fine, just cant upload any tracks !! Any ideas on how to fix this please ??
I have the up to date vbadvanced installed and running 3.64

Sofia 02-07-2007 05:18 PM

Quote:

Originally Posted by swiss (Post 1175755)
installed and get the following



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 : Tuesday, February 6th 2007 @ 05:54:39 AM
Script : http://<URL REMOVED>//mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 70.112.241.193
Username : <REMOVED FOR THIS POST>
Classname : vb_database


any idea's please as followed the install to a T


For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

TeknoSounds 02-07-2007 06:39 PM

okay, got that working and now is adding the file to the database...but nothing is showing up in the playlist when viewed on the page.

http://teknosounds.com

Yvgeniy 02-08-2007 02:28 AM

Quote:

Originally Posted by syrus.xl (Post 1175551)
Most of the features you've mentioned have either been fixed or added. However, since this is the free version some of these features are limited or do not exist. A Pro version was designed with many new features, including new players and skins and dynamic wording, if required.

Give me Pro!

Quote:

Originally Posted by TeknoSounds (Post 1176972)
okay, got that working and now is adding the file to the database...but nothing is showing up in the playlist when viewed on the page.

http://teknosounds.com

Probably because you have it set to moderation approval. You have to go into the play list within Admin CP and approve the songs.

TeknoSounds 02-08-2007 05:16 AM

Did that as well...set to approved status, streamed, 5 sec buffer, but it doesn't even come up in the list on the player.

syrus.xl 02-08-2007 04:59 PM

Quote:

Originally Posted by TeknoSounds (Post 1177300)
Did that as well...set to approved status, streamed, 5 sec buffer, but it doesn't even come up in the list on the player.

Have you setup the Usergroup Permissions correctly?

TeknoSounds 02-08-2007 06:01 PM

currently set for admins to view and add, and registered users to view...

Now this is on the cmps, not using the direct link to the player.

**edit**
works fine as the additional player window, just not working in the CMPS

Moved my question over to the CMPS thread. Thanks for your help over here.

afmarko99 02-08-2007 10:56 PM

Quote:

Originally Posted by es-league.com (Post 1175843)
I also get this error when trying to add mp3's using the admin cp :



The flash player shows up no problem , the install seems to be fine, just cant upload any tracks !! Any ideas on how to fix this please ??
I have the up to date vbadvanced installed and running 3.64


This is the error I received. It seemed no one replied how to fix this problem so I had to uninstall.

TeknoSounds 02-09-2007 05:40 AM

have to add the approvedmp3 fields to the database and you no longer get that error when adding a file to the list. See a couple posts above.

jdelasko 02-09-2007 06:15 AM

"Demo: www.digitalport.co.uk"

So..... where's the demo?? There isn't one at the site above.

TomasDR 02-10-2007 09:51 PM

I am having a visual problem. The word "Array" is appearing on every screen, any thoughts?

bazzup 02-11-2007 10:16 PM

Quote:

Originally Posted by Sosos145 (Post 1175408)
For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.


in mp3playersettings i dont have the line
PHP Code:

`mp3namevarchar(155NOT NULL default ''

to add the other one underneath


player is on and loading up ok but the mp3 wont play just sits there doing nothing?

I have approved it you can click the play button once then after that its non-clickable

regards

bazz

jimrobo 02-12-2007 06:48 PM

it seems one of my forum members has broken it! When you view the playlist from the acp, the last line is greyed out and the track starts to play? no player just plays straight from the playlist view in the acp? very strange?
I do not have the options to delete it or edit it? does anyone have any thoughts? this is the 2nd time it has happened? The first time there were only 5 tracks in it so I just uninstalled it and reinstalled it and started from scratch. This time though there are 200 tracks loaded into it so i don't want to uninstall it? ANyone know how to fix????

jonny

hotmasala4u 02-12-2007 07:28 PM

i got this error

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, February 12th 2007 @ 04:25:34 PM
Script : http://xxxxxx/forums/mp3playerindex....mp3playerpopup
Referrer :
IP Address : xxx
Username : xxxxxxx
Classname : vb_database

syrus.xl 02-12-2007 07:48 PM

Quote:

Originally Posted by jimrobo (Post 1180876)
it seems one of my forum members has broken it! When you view the playlist from the acp, the last line is greyed out and the track starts to play? no player just plays straight from the playlist view in the acp? very strange?
I do not have the options to delete it or edit it? does anyone have any thoughts? this is the 2nd time it has happened? The first time there were only 5 tracks in it so I just uninstalled it and reinstalled it and started from scratch. This time though there are 200 tracks loaded into it so i don't want to uninstall it? ANyone know how to fix????

jonny

Hi Jimrobo, can you PM me the url of the installation? I will check this problem out.

Regards.

jimrobo 02-12-2007 08:41 PM

pm sent!

Many thanks for looking into!

keep my address on file for the premium version of this mod!

regards

jonny

edit: ignore the part of my pm that says the rest do not play, it seems I was being impatient and it just needed a minute...........it does play but I still have the problem with the broken track that seems to play itself when you view the playlist view in the acp?

hotmasala4u 02-13-2007 01:27 AM

Quote:

Originally Posted by hotmasala4u (Post 1180911)
i got this error

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, February 12th 2007 @ 04:25:34 PM
Script : http://xxxxxx/forums/mp3playerindex....mp3playerpopup
Referrer :
IP Address : xxx
Username : xxxxxxx
Classname : vb_database


can u help me with my stuf plzzzzzzzzzz

sinisterpain 02-13-2007 01:28 AM

Has the product xml been fixed yet cause I have had to disable this because of incorrect tables values

jimrobo 02-13-2007 04:19 PM

sorry to post another issue!

I have had this forwarded to me from one of my members who says they are getting the following error when they load the player up. Not sure if it is related my other problem as per my pm or not?

http://www.pattaya-revealed.com/atta...6&d=1171388704

bazzup 02-14-2007 11:03 AM

Quote:

Originally Posted by hotmasala4u (Post 1181163)
can u help me with my stuf plzzzzzzzzzz

read through the posts its already been answered


All times are GMT. The time now is 11:01 PM.

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.02114 seconds
  • Memory Usage 1,883KB
  • 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
  • (11)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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