Data not saving


  • Your avatar
    seyi    
     5 years ago
    0

    Hi, i've got the latest version of AW coupon for virtuemart and i'm having a problem saving the profile and gift certificates.

    When i create either i'm told data is saved but nothing appears in the list.

    please help.

    Ben.
  • Your avatar
    seyi    
     5 years ago
    0

    strange, can you turn on debug mode in global configuration and try it again? If there is a database error, it should tell you.
  • Default avatar
    ben745    
     5 years ago
    0

    Here is the debug information, i'm not sure what this all means. Thanks. Ben.

    Profile Information
    Application afterLoad: 0.002 seconds, 0.32 MB
    Application afterInitialise: 0.053 seconds, 2.58 MB
    Application afterRoute: 0.056 seconds, 2.63 MB
    Application afterDispatch: 0.101 seconds, 4.16 MB
    Application afterRender: 0.162 seconds, 5.81 MB
    Memory Usage
    6139952
    14 queries logged.

    DELETE
    FROM jos_session
    WHERE ( TIME < '1316697396' )
    SELECT *
    FROM jos_session
    WHERE session_id = 'icoap2nb0shkrmglufdjb1b4p1'
    UPDATE `jos_session`
    SET `time`='1316700096',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1'
    WHERE session_id='icoap2nb0shkrmglufdjb1b4p1'
    SELECT *
    FROM jos_components
    WHERE parent = 0
    SELECT folder AS TYPE, element AS name, params
    FROM jos_plugins
    WHERE published >= 1
    AND access <= 2
    ORDER BY ordering
    SELECT template
    FROM jos_templates_menu
    WHERE client_id = 1
    AND menuid = 0
    SELECT id,VALUE
    FROM jos_awocoupon_license
    SELECT g.*,p.product_name,p.product_sku,pr.title AS profile, COUNT(pc.id) AS codecount

    FROM jos_awocoupon_giftcert_product g

    LEFT JOIN jos_vm_product p
    ON p.product_id=g.product_id

    LEFT JOIN jos_awocoupon_giftcert_profile pr
    ON pr.id=g.profile_id

    LEFT JOIN jos_awocoupon_giftcert_code pc
    ON pc.product_id=p.product_id


    GROUP BY g.id

    ORDER BY p.product_name
    LIMIT 100, 20
    SELECT g.*,p.product_name,p.product_sku,pr.title AS profile, COUNT(pc.id) AS codecount

    FROM jos_awocoupon_giftcert_product g

    LEFT JOIN jos_vm_product p
    ON p.product_id=g.product_id

    LEFT JOIN jos_awocoupon_giftcert_profile pr
    ON pr.id=g.profile_id

    LEFT JOIN jos_awocoupon_giftcert_code pc
    ON pc.product_id=p.product_id


    GROUP BY g.id

    ORDER BY p.product_name
    SELECT id, title, module, POSITION, content, showtitle, control, params
    FROM jos_modules AS m
    LEFT JOIN jos_modules_menu AS mm
    ON mm.moduleid = m.id
    WHERE m.published = 1
    AND m.access <= 2
    AND m.client_id = 1
    ORDER BY POSITION, ordering
    SELECT a.*, SUM(b.home) AS home
    FROM jos_menu_types AS a
    LEFT JOIN jos_menu AS b
    ON b.menutype = a.menutype
    GROUP BY a.id
    SELECT *
    FROM jos_components
    WHERE `option` <> "com_frontpage"
    AND `option` <> "com_media"
    AND enabled = 1
    ORDER BY ordering, name
    SELECT COUNT(*)
    FROM jos_messages
    WHERE state = 0
    AND user_id_to = 62
    SELECT COUNT( session_id )
    FROM jos_session
    WHERE guest <> 1

    Language Files Loaded

    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_awocoupon.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.mod_submenu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.mod_title.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.mod_menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_acymailing.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_awocoupon.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_chronocontact.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_chronoforms.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_akeeba.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_contact.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_customquickicons.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_datsogallery.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_eventlist.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_fpss.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_jce.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_jfuploader.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_poll.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_search.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_virtuemart.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_xmap.menu.ini
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_banners.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_newsfeeds.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.com_weblinks.menu.ini 1
    /home/sites/splashlight.net/public_html/administrator/language/en-GB/en-GB.mod_status.ini 1

    Untranslated Strings Diagnostic

    None

    Untranslated Strings Designer

    None
  • Default avatar
    ben745    
     5 years ago
    0

    Hi, i've just uninstalled and reinstalled the component.

    this time the profiles appeared, so i set up a new certificate, added all the html info and then imported all the codes which all worked fine.

    I then tried to add another certificate linked to another product. (Both products are child products.) and again this installed no problem, i added a second set of voucher codes via import, checked they were in there, which they were and went back to the certificates and they had gone!
  • Default avatar
    ben745    
     5 years ago
    0

    ok, if i check the codes ive imported are there by click on the navigation at the bottom, or on 'end' and then click on certificates the certificates have dissapered, if i go back into codes and click on page 1, then click on certificates they are back.

    Looks like the certificate page and the code page is linked together somehow when being displayed.

    I now have my certificates back :-)