Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osPlayer v2


man-machine

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?

Link to comment
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”)

Link to comment
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?

Link to comment
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”)

Link to comment
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?

Link to comment
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]

Link to comment
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?

Link to comment
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-

Link to comment
Share on other sites

  • 1 month later...

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
Link to comment
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 !

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
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.

Link to comment
Share on other sites

when the page is loaded just the index of files is loaded. When a file is selected the downloading starts.

 

See it in action here:

 

http://www.deepdownproductions.com/mike-wh...tunes-p-28.html

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

 

You did do a backup? eh?

Link to comment
Share on other sites

  • 3 weeks later...

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
Link to comment
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?

Link to comment
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

Link to comment
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.

Link to comment
Share on other sites

  • 4 weeks later...

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?

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...