gregy Posted February 28, 2005 Share Posted February 28, 2005 hmm .. here's the problem .. when i click on Mp3 manager in product in admin i receive 1146 - Table 'xxxx.TABLE_PRODUCTS_MP3' doesn't exist select products_folder from TABLE_PRODUCTS_MP3 where products_id = '42' [TEP STOP] i have inserted following code DROP TABLE IF EXISTS `products_mp3`; CREATE TABLE `products_mp3` ( `products_id` int(11) NOT NULL default '0', `products_folder` varchar(25) NOT NULL default '', PRIMARY KEY (`products_id`), UNIQUE KEY `products_folder` (`products_folder`) ) TYPE=MyISAM; INSERT INTO configuration_group VALUES ('4356', 'osplayer', 'osPlayer v2 Options', '20', '1'); INSERT INTO configuration VALUES ('', 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES ('', 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES ('', 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?', 8, 5, now(), now(), NULL, NULL); i have changed20 to 4356 since i already have 20 in database .. any idea why do i receive this? fyi products_mp3 is in database Quote Link to comment Share on other sites More sharing options...
man-machine Posted February 28, 2005 Share Posted February 28, 2005 hmm .. here's the problem .. when i click on Mp3 manager in product in admin i receive 1146 - Table 'xxxx.TABLE_PRODUCTS_MP3' doesn't exist select products_folder from TABLE_PRODUCTS_MP3 where products_id = '42' [TEP STOP] i have inserted following code DROP TABLE IF EXISTS `products_mp3`; CREATE TABLE `products_mp3` ( `products_id` int(11) NOT NULL default '0', `products_folder` varchar(25) NOT NULL default '', PRIMARY KEY (`products_id`), UNIQUE KEY `products_folder` (`products_folder`) ) TYPE=MyISAM; INSERT INTO configuration_group VALUES ('4356', 'osplayer', 'osPlayer v2 Options', '20', '1'); INSERT INTO configuration VALUES ('', 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES ('', 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES ('', 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?', 8, 5, now(), now(), NULL, NULL); i have changed20 to 4356 since i already have 20 in database .. any idea why do i receive this? fyi products_mp3 is in database <{POST_SNAPBACK}> seems you forgot to add the table name in the database_tables.php u must add : define('TABLE_PRODUCTS_MP3', 'products_mp3'); ;) Quote Link to comment Share on other sites More sharing options...
gregy Posted February 28, 2005 Author Share Posted February 28, 2005 seems you forgot to add the table name in the database_tables.php u must add : define('TABLE_PRODUCTS_MP3', 'products_mp3'); ;) <{POST_SNAPBACK}> omg .. i double checked when modifying .. wasn't enough ... THANK YOU Quote Link to comment Share on other sites More sharing options...
gregy Posted February 28, 2005 Author Share Posted February 28, 2005 omg .. i double checked when modifying .. wasn't enough ... THANK YOU <{POST_SNAPBACK}> more strange things happened :) take a look at here and view source .. you will find all necessary code .. but blank where should code be ... :'( or is this correct .. also i don't see any button for play or anything that smells like mp3 player :'( :( Quote Link to comment Share on other sites More sharing options...
gregy Posted February 28, 2005 Author Share Posted February 28, 2005 one more .. why is it in admin playing too fast ... not normal sound .. if i play it via winamp it plays ok .. Quote Link to comment Share on other sites More sharing options...
gregy Posted March 2, 2005 Author Share Posted March 2, 2005 one more .. why is it in admin playing too fast ... not normal sound .. if i play it via winamp it plays ok .. <{POST_SNAPBACK}> would appreciate your help thanx Quote Link to comment Share on other sites More sharing options...
man-machine Posted March 3, 2005 Share Posted March 3, 2005 would appreciate your help thanx <{POST_SNAPBACK}> i guess it's because of the sample rate of your mp3 .. flash pluginh required that the sample rate is 44 khz , 22khz or 11khz ( must be a multiple of 44 ) .. Quote Link to comment Share on other sites More sharing options...
gregy Posted March 3, 2005 Author Share Posted March 3, 2005 thanx i'll try to make another mp3 .. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2005 Share Posted March 5, 2005 Will this be fixed? I'm having the same problem. :rolleyes: Quote Link to comment Share on other sites More sharing options...
gregy Posted March 5, 2005 Author Share Posted March 5, 2005 Will this be fixed? I'm having the same problem. :rolleyes: <{POST_SNAPBACK}> it works .. i changed the rate as stated above .. it plays well now! Quote Link to comment Share on other sites More sharing options...
ms70 Posted June 9, 2005 Share Posted June 9, 2005 osPlayer Lite problem: I upload an mp3 file with the product... upload is successful (green message). mp3 is in data/mp3 (CMOD 777) ... osplayerlite.swf is in catalog/ ... But in the product listing with the same product there is only the "-" shown for NO mp3 .... What am I missing..??? please help .. THNX !! Quote Link to comment Share on other sites More sharing options...
ms70 Posted June 9, 2005 Share Posted June 9, 2005 ok.. found the 'products_mp3' in table 'products' is still NULL ...guess there should be the mp3 title...(??) any ideas? Quote Link to comment Share on other sites More sharing options...
ms70 Posted June 9, 2005 Share Posted June 9, 2005 found it: mp3 file name was too long or had too many dots.. But still problems.. Player isn't playing the file ... (??) Quote Link to comment Share on other sites More sharing options...
ms70 Posted June 10, 2005 Share Posted June 10, 2005 ...and while still not playing mp3's, the flash movie (osplayerlite.swf) is breaking up my tables.. everything that comes after the flash movie is skipped... why is that..?? Quote Link to comment Share on other sites More sharing options...
ms70 Posted June 10, 2005 Share Posted June 10, 2005 found it.. <object> wasn't closed... BUT: osplayerlite still doesn't play MP3 from /data/mp3/ does anybody know a reason? Quote Link to comment Share on other sites More sharing options...
ms70 Posted October 13, 2005 Share Posted October 13, 2005 (edited) BUT: osplayerlite still doesn't play MP3 from /data/mp3/does anybody know a reason? it was a wrong path call. Instead of '&path='.DIR_WS_MP3, it was wrong like this: '&path='.DIR_FS_MP3, Edited October 13, 2005 by ms70 Quote Link to comment Share on other sites More sharing options...
zink Posted November 26, 2006 Share Posted November 26, 2006 (edited) Hi there Just trying to install this mod on the latest version of OSC and getting same error: 1146 - Table 'xxxx.TABLE_PRODUCTS_MP3' doesn't exist select products_folder from TABLE_PRODUCTS_MP3 where products_id = '42' I copied all the files across from the osplayer and have checked all the suggestions in this post including the database_tables.php update. As my client's shop will be mp3 downloads only, obviously it is essential that i get this to work, so any previous versions that this works with etc please let me know. Do I need to install this the manual (advanced) way ? p.s. the table does exist ;-) Please help! Edited November 26, 2006 by zink Quote Link to comment Share on other sites More sharing options...
zink Posted November 27, 2006 Share Posted November 27, 2006 Can anyone help me? :'( Quote Link to comment Share on other sites More sharing options...
New 
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.
Note: Your post will require moderator approval before it will be visible.