Error updating to 3.6.0.2


  • Default avatar
    begoña    
     24 days ago
    0

    I'm testing to upgrade from Aworewards from 3.6.0.0 to 3.6.0.2, but it's not working.

    When updating I get this error: "Duplicate key name 'user_id'", I attach an image.

    What could be the problem?

    Thank you.

  • Your avatar
    seyi    
     24 days ago  last edited 24 days ago
    0

    Hello,

    Seems db and install are not in sync?

    Go into phpmyadmin and run this query:

    SELECT value FROM #__aworewards_config WHERE name="AWOREWARDS_VERSION_DB";

    What do you go get, is it less than 3.6.0.0?  If so update it to
    UPDATE #__aworewards_config SET value="3.6.0.0" WHERE name="AWOREWARDS_VERSION_DB";

    Then run the update again.


    In the above queries, update #__ to your actual database prefix.
  • Default avatar
    begoña    
     23 days ago
    0

    Hello,

    Now the value of "AWOREWARDS_VERSION_DB" is 3.5.2.1

    What are the changes in the database from 3.5.2.1 to 3.6.0.0 besides the version number?

    If I just change "AWOREWARDS_VERSION_DB" to 3.6.0.0 I think some changes might be missing in the database.

    Regards
  • Your avatar
    seyi    
     22 days ago  last edited 22 days ago
    0

    You can find the changes in the folder:

    /administrator/components/com_aworewards/aworewards/library/install/upgrade/sql/

  • Default avatar
    begoña    
     16 days ago
    0

    The only problem was the value of "AWOREWARDS_VERSION_DB", once updated, everything seems to work fine.

    Thanks.