1146: Table 'bonaroma_bonaroma.CMSI_audio_details' doesn't exist
select b.audio_id, b.access_type from CMSI_audio b LEFT JOIN CMSI_audio_details a on a.audio_id = b.audio_id WHERE b.status='1' AND IF(b.access_type = 'H' , b.membership_id LIKE '%{-1}%' AND /* CASE D */ CASE b.visibilty_type WHEN 'D' THEN IF( (RTRIM( LTRIM( b.visibilty_date ) ) <> '' AND b.visibilty_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= b.visibilty_date , 1 ) AND IF( (RTRIM( LTRIM( b.expiry_date ) ) <> '' AND b.expiry_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) <= b.expiry_date, 1 ) AND IF( b.no_of_downloads >0, a.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 ) /* CASE R */ WHEN 'R' THEN IF(b.visibilty_days > 0 OR b.visible_upto_days > 0, '' <> '' AND IF(b.visibilty_days > 0, DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= DATE_ADD( /* Consider upgrade or regisration date. */ IF(b.flag_regi_upgrade_date = 'R','0000-00-00','0000-00-00') , INTERVAL b.visibilty_days DAY), 1) AND IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD( /* Consider upgrade or regisration date. */ IF(b.flag_regi_upgrade_date = 'R','0000-00-00','0000-00-00') , INTERVAL (b.visibilty_days + b.visible_upto_days) DAY),1) AND IF(b.no_of_downloads > 0, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) , IF(b.no_of_downloads > 0, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) ) /* CASE '' */ WHEN '' THEN b.membership_id LIKE '%{-1}%' END , 1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bonaroma/public_html/classes/class.procedure.php on line 92
1054: Unknown column 'parent_cat_id' in 'where clause'
SELECT IF((membership_id LIKE '%{-1}%'), '1', '-1') as access_type, category_id, category FROM CMSI_audio_category WHERE parent_cat_id='0' AND status = '1'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bonaroma/public_html/classes/class.procedure.php on line 92
Audio Meta Title
Username: Password:
Forgot your password?

Audio


Note:
  • * marked fields are mandatory.
  • Either Audio URL or Audio File is mandatory.
  • There are 3 ways to add a audio file:
    1. Direct upload
    2. Full file url- file can be located from anywhere else.
    3. Upload to amazon s3 (if enabled)
    • Note 1: Direct upload file from your pc will be uploaded to this site server.
    Note 2: A full URL example: http://somewhere-domain.com/file-name

    Select Category *
    Audio Name *    
    Audio Slug     
    Example: yourdomain.com/Audio Categoryslugnamehere.html
    [If Not Given, System Will Assign a Unique One based on Product heading]
    [Cannot Contain Spaces, or any other special characters except ( - ) or ( _)]
    Author *    
    Description
    AudioThumbnail *     

    (For IE 7 Users Only) If you are unable to preview images, click here to see how to change your browser settings.
    Thumbnail Alt Text     
    Audio Running Time     
    Page Meta Keywords Tag     
    450 character limit. Separate each word by a comma.
    Recommended to not repeat a keyword more than 3 times.
    Page Title     
    Meta Description
    150 character limit Recommended
    Meta Category     
    Type 1 or 2 suited main categories for your product.
    Example: Business, Education, Etc..
    Search keyword
    450 character limit.
    Separate each word by a comma. Recommended for use on search to your site.
    Audio Files Collapse[+]
      

       

    Copyright ©1990-2011 BonaRoma.com. All Rights Reserved.

       |