Jump to content
Sign in to follow this  
man-machine

osPlayer v2

Recommended Posts

Howdy everyone,

I've done the fresh install several times...

I keep getting a

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

error whenever i go to any subcatagory

right after completing the install,

anyone else have this problem?

Any Ideas?

A-

 

Heres the entire error:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'

 

[TEP STOP]

Not sure but my guess is one of the adjustments of the files in the admin area has an error in it. Have you double checked the modifications of the files?

 

What file appears in he address bar when the error occurs?

Edited by ddp

Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Share this post


Link to post
Share on other sites
This does sound like the same problem I had. For me now on two different servers the only way it worked for me is with one with the"/" and one without the "/" like this for catalog/configure.php

 

  define('DIR_FS_CATALOG_MP3', DIR_FS_CATALOG . '/data/mp3/'); 
 define('DIR_WS_CATALOG_MP3', DIR_WS_HTTP_CATALOG . 'data/mp3/');

 

Have you tried this configuration?

 

Hi,

 

I just tried that configuration and I still cannot see the player on the product pages. I tried it backwards too, just in case, but nothing...

 

Any other suggestions? Perhaps I should look at your source pages closely and compare them to mine, see if I screwed something up somewhere... :blush:

 

Thanks!

 

jailaxmi


I repeat myself when under stress, I repeat myself when under stress, I repeat myself...

 

--King Crimson (“Discipline”)

Share this post


Link to post
Share on other sites
Hi,

 

I just tried that configuration and I still cannot see the player on the product pages. I tried it backwards too, just in case, but nothing...

 

Any other suggestions? Perhaps I should look at your source pages closely and compare them to mine, see if I screwed something up somewhere... :blush:

 

Thanks!

 

jailaxmi

 

Sure if you like post what pages you like and I will send them to you via PM


Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Share this post


Link to post
Share on other sites
Sure if you like post what pages you like and I will send them to you via PM

 

Hi,

 

How about:

catalog/index.php

catalog/products_info.php

and

catalog/includes/modules/products_listing.php?

 

That should help... Thanks a lot!!! :)

 

jailaxmi


I repeat myself when under stress, I repeat myself when under stress, I repeat myself...

 

--King Crimson (“Discipline”)

Share this post


Link to post
Share on other sites

It's the index.php

I did the easy install,

so it should be groovy,

but I'll have a look right now...

 

Any Idea what the error means,

It seems to be looking for a column that isn't there,

the sql command seemed to work fine...

 

Thanks!

A-

 

 

 

Not sure but my guess is one of the adjustments of the files in the admin area has an error in it. Have you double checked the modifications of the files?

 

What file appears in he address bar when the error occurs?

Share this post


Link to post
Share on other sites

I think I solved it, (see error below)

The index.php that comes with the contribution

was causing the problem,

I followed the advance install instructions for this file.

(by modifying the back-up)

uploaded it,

and it seems to be working.

 

Thanks for pointing me in the right direction DDP!

 

I'll be back if it gums up again...

 

(here's the origional error in case some one else has the same problem)

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'

 

[TEP STOP]

Share this post


Link to post
Share on other sites
I think I solved it, (see error below)

The index.php that comes with the contribution

was causing the problem,

I followed the advance install instructions for this file.

(by modifying the back-up)

uploaded it,

and it seems to be working.

 

Thanks for pointing me in the right direction DDP!

 

I'll be back if it gums up again...

 

(here's the origional error in case some one else has the same problem)

 

Alright I'm glad it's working!!


Backup before making changes. Backup before making changes! Backup before making changes!!

 

You did do a backup? eh?

Share this post


Link to post
Share on other sites

Ok,

Now I've got no sound coming through the player in the admin

Checked permissions, double checked the path in the admin config file,

refreshed my browser.

The file appears in firefox, but does not play, IE gives a not defined error,

I saw that others have had this trouble...

anybody solve it yet?

 

also, on the Catalog side, the player does not appear or pop-up in the category view,

only in the product view...

 

hmmmm...

A-

Share this post


Link to post
Share on other sites

Hi,

 

Trying to install this contribution and have done everything as by the manual, but I get an error message appearing at the top of my admin page:

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /mounted-storage/home15a/sub003/sc17799-IEOR/tomrowley.net/catalog/admin/includes/configure.php:51) in /mounted-storage/home15a/sub003/sc17799-IEOR/tomrowley.net/catalog/admin/includes/functions/sessions.php on line 67

 

Also, this message appears on the index page:

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /mounted-storage/home15a/sub003/sc17799-IEOR/tomrowley.net/catalog/includes/configure.php:51) in /mounted-storage/home15a/sub003/sc17799-IEOR/tomrowley.net/catalog/includes/functions/sessions.php on line 97

 

 

Any helps, ideas, poke in the right direction? Thanks in advance

 

Tom

Edited by tomrowley

Share this post


Link to post
Share on other sites

Hello,

 

I did not get the full release of OsPlayer (and the official site is down !!!), so I miss the two following files :

 

catalog/player_parser.php

catalog/popup_oscplayer.php

 

Could someone send them to me, please ?

Thank you very much !

Share this post


Link to post
Share on other sites

Just a quick solution for everybody who wants to sort their Songs by title, somehow my playlist always got mixed up and sorted the files in some strange fashion...

 

in both catalog/player_parser.php and admin/player_parser.php

 

REPLACE

 

foreach ($ExpExt as $findExt) {

	$getFile = @tep_browse_mp3($gDirectory, $findExt);
	$countFile = count($getFile);	  

	if ($countFile != 0) { 
		foreach ($getFile as $myFile) {
			$list[] = $myFile;
		}  
	}			
}

 

WITH

 

foreach ($ExpExt as $findExt) {

	$getFile = @tep_browse_mp3($gDirectory, $findExt);
	$countFile = count($getFile);	  

	if ($countFile != 0) { 
		foreach ($getFile as $myFile) {
			$list[] = $myFile;
		}  
	}			
}

$$list = array();
sort($list);

 

hope that helped.

Share this post


Link to post
Share on other sites

If you're using the above method, please remove "$$list = array(); "

 

Sorry for posting faulty code.

Share this post


Link to post
Share on other sites

v2 is looking very nice. Just one question - does it start to pull the audio from the host site when it's opened or is it when play starts? I'ld like to have it incorporated into a page as is possible by setting 'Open player in a pop up' to false - but not if it's going to start using significant bandwidth everytime a page is opened.

Share this post


Link to post
Share on other sites

hi all, yesterday i took the plunge and upgraded to php 5,

[ebuild   R   ] dev-lang/php-5.1.4

:blink:

 

after that OSC Player no longer showed the list of mp3 in both catalog and admin :'(

 

after plenty struggle, my friend helped me fix it, all credit to Gideon

 

the problem is with utf8_encode, if you change in both

1. catalog/player_parser.php

2. catalog/admin/player_parser.php

 

/////////
  function Parse($variable,$valeur) {
   echo "&" . $variable . "=" . utf8_encode(urlencode($valeur));
  }

 

to

 

/////////
  function Parse($variable,$valeur) {
   echo "&" . $variable . "=" . urlencode($valeur);
  }

 

it will be fixed, thanks also to the people who helped with php errors, fixes can be found here, PHP5 & OS Commerce

 

ciao/riaan

Psytrance B)

Edited by starachna

Share this post


Link to post
Share on other sites

I was wondering if anyone knew where this contribution is since it is no longer listed available for download?

 

and also if it works ok with IIS 6?

 

Thank you.

Share this post


Link to post
Share on other sites
Does anyone have a working FLA file for OsPlayer? I have downloaed all of them and each FLA file comes as an error once opened in Flash...

 

Anyone?

 

Thanks.

I need it too, anyone?

Share this post


Link to post
Share on other sites

Hi I am a newbie here

but I work since 3 mouth on french support

I will able to set up few contributions

 

but I have the problem with osplayer v2.1

evrey think ok on admin but nothing on the catalog

 

I Try with new distribution and it s the same

nothing apear to hear on the catalog side.

 

I read all this topics and I try every think

 

I look on my source code page and I see that nothing is call neither in index.php neithier in product_info.php

 

If someone can help , It will really use full

 

regards

Benos

Share this post


Link to post
Share on other sites

hi guys,

just solve the most recent problem in that discussion regarding not listing tracks in the player. i had that problem at the admin side. there is no error in the config files. no leading slashes needed. the correct is

define('DIR_FS_CATALOG_MP3', DIR_FS_CATALOG . 'data/mp3/');

define('DIR_WS_CATALOG_MP3', DIR_WS_CATALOG . 'data/mp3/');

 

so to fix this problem you should edit admin/mp3manager.php:

 

find:

<object type="application/x-shockwave-flash" data="osc_player.swf?mp3id=' . $product_mp3_id .'" width="193" height="265"><param name="scale" value="exactfit" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" /> <param name="movie" value="osc_player.swf"/><a href=http://www.macromedia.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash  target="blank"><img src="images/icons/noflash.gif" width="88" height="31" vspace="5" hspace="50" alt="install flash player plugin"/></a></object>

 

and replace with:

<object type="application/x-shockwave-flash" data="osc_player.swf?mp3id=' . $product_mp3_id .'" width="193" height="265"><param name="scale" value="exactfit" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" /> <param name="movie" value="osc_player.swf?mp3id=' . $product_mp3_id .'"/><a href=http://www.macromedia.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash  target="blank"><img src="images/icons/noflash.gif" width="88" height="31" vspace="5" hspace="50" alt="install flash player plugin"/></a></object>

 

so ?mp3id=' . $product_mp3_id .' is missing at the second case.

Share this post


Link to post
Share on other sites

Got a big problem... (osplayer_v2.1_for_oscommerc)

In admin under mp3manager the player is shown and when i upload a file into to data/mp3 folder by ftp the mp3 is shown in the player in mp3manager and i can play it.

But when I use the "create folder" button nothing happens, its like the page refresh but there is no error msg or anything - also no folder is created.

(i used the advanced installation - edited all files - cause i also use the new_field_everywhere_1 contrubution)

(i also changed the files that they work with Register_Globals OFF)

 

I checked the files again and again but i cant find the mistake - any hints what could be wrong?

Share this post


Link to post
Share on other sites
I'm getting a

 

current path: PATH_NOT_FOUND

NO_MP3_FOLDER

osplayer 2.1

 

In the admin part of oscommerce I have changed the paths and I do have mp3 files in those folders but still get the same error.

Also does this have a limit in file size?

 

Thanks

 

I had the same issue. I found it was were you declare the catalog folder absolute path line in both catalog\configure.php and admin\configure.php

 

changing:

 

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

 

to the old OSC style of

 

define('DIR_FS_CATALOG', '/home/YOURPATH/public_html/catalog/'); // absolute path required

 

did the trick for me :)

 

PS:- I think the limit is shown as 200mb

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×