Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSplayer


gregy

Recommended Posts

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

Link to comment
Share on other sites

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

 

 

seems you forgot to add the table name in the database_tables.php

 

u must add :

 

define('TABLE_PRODUCTS_MP3', 'products_mp3');

 

;)

Link to comment
Share on other sites

omg .. i double checked when modifying .. wasn't enough ... THANK YOU

 

 

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 :'( :(

Link to comment
Share on other sites

  • 3 months later...

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 !!

Link to comment
Share on other sites

  • 4 months later...
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 by ms70
Link to comment
Share on other sites

  • 1 year later...

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 by zink
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...