Update Error


  • Default avatar
    bob515    
     8 years ago
    0

    Hi
    When I try to update my AwoCoupon to the latest version I get an error:
    Table 'JB_awocoupon_voucher_customer' already exists SQL=RENAME TABLE JB_awocoupon_giftcert_order TO JB_awocoupon_voucher_customer

    What should I do please?
    Thanks in adavnce
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    What version are you updating?
  • Default avatar
    bob515    
     8 years ago
    0

    Hi Seyi.
    2.3.1 is what I currently have.
  • Default avatar
    bob515    
     8 years ago
    0

    I am also not able to save configuration settings for Awo Rewards - which too is odd. Are these related perhaps?
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    In your db, do you have the table #__awocoupon_voucher_customer? If so, looks like your tables are at least version 2.3.3. Not really sure how they could have got out of sync.

    You could try to manually update, in which case you would just manually copy the files over and update the database directly.
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    What version of Joomla is this?
  • Default avatar
    bob515    
     8 years ago
    0

    Hi Seyi
    Tried a manual install via file upload in ext manager but got the same issue:
    Table 'JB_awocoupon_voucher_customer' already exists SQL=RENAME TABLE JB_awocoupon_giftcert_order TO JB_awocoupon_voucher_customer

    What should I try next? If I uninstall the component will I loose all existing coupons - there are a few which are active and being promoted!

    Could this also be connected with AwoRewards configuration not being saved? I've managed to save settings in General Tab, but no changes are saved when changing Invitation tab (not tried any others yet...)
    Thanks
    Bob

    ADD:
    Renamed the table back to JB_awocoupon_giftcert_order and tried to upload install again. This time the error is:
    Can't DROP 'email_sent'; check that column/key exists SQL=ALTER TABLE JB_awocoupon_voucher_customer DROP COLUMN email_sent

    What to do...
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    For a manual update, here is what you have to do:

    1) coppy the files from zip:
    admin -> www/administrator/components/com_awocoupon
    site -> www/components/com_awocoupon
    media -> www/media/com_awocoupon
    language/admin -> www/administrator/language/en-GB
    language/site -> www/language/en-GB
    awocoupon_j3.xml -> www/administrator/components/com_awocoupon
    install.awocoupon.php -> www/administrator/components/com_awocoupon

    2) database update: open the file
    www/administrator/components/com_awocoupon/helpers/install/upgrade/sql
    Look in all files from 2.3.1.sql and up and nanually update the database with those that are relevant. You will have to change #_ to JB, your database prefix


    That should be it.



  • Default avatar
    bob515    
     8 years ago
    0

    Thanks Seyi
    All accomplished except the database updates. There are many tables missing. My install is reporting version 2.3.1 But when I try to open 2.3.1.sql the file is blank - no commands in that file.
    Going back to 2.0.1sql:ALTER TABLE JB__awocoupon_vm ADD COLUMN `params` TEXT; results in error
    Table 'juicebik_db.JB__awocoupon_vm' doesn't exist

    So this is going to be a real pain to do manually. Is there any way to keep the current settings and coupons, and reinstall the whole database?
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    If you want to see the tables that exist look in the file
    www/administrator/components/com_awoocupon/helpers/install/mysql.install.sql

    awocoupon_vm did exist but does not anymore. Do not bother going back to 2.0.1.sql. Start at 2.3.1. Yes there might be some blank files, just means there waere no database updates for that version update. Once you have updated to the latest, your tables should match exactly what is in mysql.install.sql.

    If you prefer, happy to look at it directly if you can send a pm with temp admin and ftp access.
  • Default avatar
    bob515    
     8 years ago
    0

    Thanks Seyi
    That wasn't easy! But now done and shows current version. I would appreciate a second look - thanks for your offer. Can you register at the site and I can make you admin... when you have time.
    juicybike.co.uk
  • Default avatar
    bob515    
     8 years ago
    0

    There is one thing I don't understand... when I create a module for AwoPromotions there are no options available for selecting a rule, but I have rules created. The drop-down list is empty. And I'm still not sure the upgrade was completed successfully.

    Ok Fixed that - I hadn't created any rule appropriate for a module display, only menu display rules had been created.
    BUT: Now, when I create a module - following the example given for Facebook Like Rewards - the module kills the site. If I un-publish that module, the site returns.

    I'd appreciate support for this Seyi - it's been a struggle to install and configure this component so far.
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    Yes, there is a problem with the module in Joola 3. Sending you a link now for the updated version, just install.
  • Default avatar
    bob515    
     8 years ago
    0

    Great Stuff! That's fixed it - Thanks Seyi
  • Default avatar
    bob515    
     8 years ago
    0

    Hello again Seyi
    I'm grateful for your help so far.
    Three things I hope you can help me with:

    1. How can I remove the Trophy that's shown on the Facebook Like module? I can't seem to find the module to edit and remove that image.
    2. I'd really like to remove the option to upload email addresses (I think it may look too complicated for my users). Is this an option?
    3. (wishful thinking) I'd really like the option to to invite Facebook friends - but I guess that's really difficult.

    Think the plug-in is great, by the way - a little difficult to understand at first, but beginning to get my head around it.
    Regards
    Bob
  • Your avatar
    seyi    
     8 years ago
    0

    Hello,

    1. It is in the plugin. You can override it by copying whichever file you are dealing with, for example:
    www/plugins/aworewards/facebook/tmpl/module_facebook_like_default.php

    to

    www/templates/[YOUR_TEMPLATE]/html/plg_aworewards_facebook/module_facebook_like_default.php

    And then making the edits to the file in your template

    2. It is not an option, but again, you could copy the file
    www/components/com_aworewards/views/invitation/tmpl/default.php

    to
    www/templates/[YOUR_TEMPLATE]/html/com_aworewards/invitation/default.php

    And make the modifications in the template

    3. An interesting idea. Might be added in the future, probably would require your facebook app being reviewed and approved by facebook since it is requiring sensitive information.

  • Default avatar
    bob515    
     8 years ago
    0

    Thanks Seyi
    Managed no. 1 easily, and hope you get the time required for no. 3.

    Finding how to eliminate the section on inviting email addresses by file is proving a bit beyond me.
    I've tried simply commenting out the lines at around 329:

    <div class="getter_link">
                          <a href="javascript:void(0);" onclick="jQuery('#email_upload_block').toggle();return false;">

                    <img src="<?php echo JURI::root(true); ?>/media/com_aworewards/images/icon_50_upload.png" alt="upload" />

                    <span><?php echo JText::_('COM_AWOREWARDS_EMAIL_UPLOAD_MSG'); ?></span>

                </a>

                <div id="email_upload_block">

                    <form action="<?php echo JRoute::_'index.php' ); ?>" method="post" enctype="multipart/form-data">

                        <input type="file" name="file" /> <input type="submit" value="<?php echo JText::_('COM_AWOREWARDS_SUBMIT'); ?>" />

                        <input type="hidden" name="option" value="com_aworewards" />

                        <input type="hidden" name="view" value="invitation" />

                        <input type="hidden" name="task" value="invite_uploadmail" />

                        <?php echo JHTML::_'form.token' ); ?>

                    </form>

                </div>

            </div>


    But that seems to break adding email addresses. Could you give me any pointers to where I am going wrong?
    Gratefully
    Bob
  • Default avatar
    bob515    
     8 years ago
    0

    Well this was sorted by a lot of guess-work, using the class hide. You must be busy Seyi...
  • Your avatar
    seyi    
     8 years ago
    0

    Ah, I did not think of that, easier option, yes, just hide it through css. Glad you got it working.