ddp Posted April 22, 2006 Share Posted April 22, 2006 (edited) 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 April 22, 2006 by ddp Quote 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 More sharing options...
♥jailaxmi Posted April 22, 2006 Share Posted April 22, 2006 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 Quote 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 More sharing options...
ddp Posted April 22, 2006 Share Posted April 22, 2006 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 Quote 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 More sharing options...
♥jailaxmi Posted April 22, 2006 Share Posted April 22, 2006 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 Quote 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 More sharing options...
A-- Posted April 22, 2006 Share Posted April 22, 2006 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? Quote Link to comment Share on other sites More sharing options...
A-- Posted April 22, 2006 Share Posted April 22, 2006 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] Quote Link to comment Share on other sites More sharing options...
ddp Posted April 22, 2006 Share Posted April 22, 2006 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!! Quote 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 More sharing options...
A-- Posted April 22, 2006 Share Posted April 22, 2006 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- Quote Link to comment Share on other sites More sharing options...
Guest Posted June 7, 2006 Share Posted June 7, 2006 (edited) 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 June 7, 2006 by tomrowley Quote Link to comment Share on other sites More sharing options...
eftibug Posted June 9, 2006 Share Posted June 9, 2006 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 ! Quote Link to comment Share on other sites More sharing options...
hiklot Posted June 19, 2006 Share Posted June 19, 2006 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. Quote Link to comment Share on other sites More sharing options...
hiklot Posted June 19, 2006 Share Posted June 19, 2006 If you're using the above method, please remove "$$list = array(); " Sorry for posting faulty code. Quote Link to comment Share on other sites More sharing options...
itinerant baker Posted June 20, 2006 Share Posted June 20, 2006 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. Quote Link to comment Share on other sites More sharing options...
ddp Posted June 20, 2006 Share Posted June 20, 2006 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 Quote 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 More sharing options...
itinerant baker Posted June 20, 2006 Share Posted June 20, 2006 Cheers. On the page it goes then. B) Quote Link to comment Share on other sites More sharing options...
starachna Posted July 11, 2006 Share Posted July 11, 2006 (edited) 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 July 11, 2006 by starachna Quote Link to comment Share on other sites More sharing options...
wwalbaum Posted July 15, 2006 Share Posted July 15, 2006 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. Quote Link to comment Share on other sites More sharing options...
ddp Posted July 15, 2006 Share Posted July 15, 2006 You should be able to download the whole package here: http://www.oscommerce.com/community/contri...ry/search,82004 Quote 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 More sharing options...
poj Posted July 19, 2006 Share Posted July 19, 2006 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? Quote Link to comment Share on other sites More sharing options...
benos Posted July 26, 2006 Share Posted July 26, 2006 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 Quote Link to comment Share on other sites More sharing options...
osCommerce4you.com Posted July 31, 2006 Share Posted July 31, 2006 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. Quote Link to comment Share on other sites More sharing options...
benos Posted August 24, 2006 Share Posted August 24, 2006 Ok It seem to be great thanks a lot benos Quote Link to comment Share on other sites More sharing options...
floppy Posted August 28, 2006 Share Posted August 28, 2006 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? Quote Link to comment Share on other sites More sharing options...
mwildin1 Posted August 30, 2006 Share Posted August 30, 2006 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 Quote Link to comment Share on other sites More sharing options...
jhdesign Posted August 31, 2006 Share Posted August 31, 2006 Anyone solve teh NO SOUND issue? I've got the same problem on my site. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.