Duplicate column name 'voucher_filename_lang_id' in SQL Alter table when upgrading from 2.4.1 to 2.4.7.1


  • Default avatar
    cpaschen    
     8 months ago
    0

    I'm trying to upgrade a site that presently has AWO Coupon 2.4.1 to the latest version 2.4.7.1.

    When trying to install this version I am getting the Warning:

    Duplicate column name 'voucher_filename_lang_id' SQL=ALTER TABLE wukrp_awocoupon_profile ADD COLUMN voucher_filename_lang_id INT AFTER voucher_text_exp_lang_id

    and the component doesn't install.

    I've tried to find older versions (to try updating to interim versions to see if that resolves the issue) but can't find any here on the site.

    I've also looked through the docs and searched the forum and didn't find anything that related to this issue.


    Any ideas how to resolve this (without loosing the data already in the AWO set-up)?
  • Your avatar
    seyi    
     8 months ago
    0

    Hello,

    I think you will have to do a manual install to get this up and running. Would be happy to do it if you could sent temp admin and ftp access. But if you would like to do it yourself, here is what to do:

    Copy file:
    - copy zip admin/* to www/administrator/components/com_awocoupon/*
    - copy zip media/* to www/media/com_awocoupon/*
    - copy zip site/* to www/components/com_awocoupon/*
    - copy zip language/admin/en-GB.com_awocoupon.ini to /administrator/language/en-GB/en-GB.com_awocoupon.ini
    - copy zip language/site/en-GB.com_awocoupon.ini to /language/en-GB/en-GB.com_awocoupon.ini
    - if Joomla 3.x and up copy zip awocoupon_j3.xml to /administrator/components/com_awocoupon/awocoupon_j3.xml
    - if less than Joomla 3, copy zip aowocupon.xml to /administrator/components/com_awocoupon/awocoupon.xml

    Database:
    - in zip find the folder admin/helpers/install/upgrade/sql/
    - the error you got started in file 2.4.3.sql. So start there, open up phpmyadmin and manually run the sql statements from 2.4.3 up
    - not you will need to change the database prefix from #__ to your actual prefix

    That should be it.
  • Default avatar
    cpaschen    
     8 months ago
    0

    Thanks for those steps.

    I have followed them and it looks like everything is working - except the version listing.

    On the dashboard it says:

    Old Version currently installed

    Latest Version: 2.4.7.1 (2016-03-15)
    Installed Version: 2.4.1

    If I click on the "UPDATE FOUND! CLICK TO UPDATE" link

    It says that A new version is available

    Installed Version 2.2.0
    Latest Version 2.4.7.1
    Latest release date 2016-03-15

    If I click "Refresh update information" nothing changes
    If I click on "Update to the latest version", after a bit of "spinning wheel" I get:
    You already have this version of AwoCoupon Pro: 2.4.7.1 pro

    I then copied the awocoupon.xml file to the admin folder (even though I'm running J!3.4.8) and I now get:
    Old version currently installed
    and
    Installed Version: 2.4.1

    However, it does have the green check and says "You have the latest version"

    Is there anything else I need to do to get this to all display properly?


  • Your avatar
    seyi    
     8 months ago
    0

    Hello,

    You do not want awocoupon.xml, remove that and make sure you only have awocoupon_j3.xml.

    Then go to control panel->cache and clear awocoupon cache on the admin side. That should update the panel to display correctly.
  • Default avatar
    cpaschen    
     8 months ago
    0

    Thanks. It's working now.