Aworewards and Awoaffiliate migration from joomla 3 to joomla 5


  • Default avatar
    rene54    
     7 days ago
     0

    Hi Seyi,

    Migrated AWOCOUPON to Joomla 5 (by copying the old tables from Joomla 3.).

    This worked well and I could not spot any error. However, the original tables from AwoCoupon (V.4.0.1.5) have different column names.

    Now I need to migrate the data (tables) for AwoRewards and AwoAffiliate from J3 to J5.

    How is the migration scenario for Aworewards and Awoaffiliate ? Also just copy the old tables from Joomla 3 ?


    Thanks for clarifiying and best regards

    Rene

  • Your avatar
    seyi    
     7 days ago
     0

    Hello,

    Yes, it is the same process.

    - install awo extension on joomla 5 site
    - delete the tables created
    - add the tables from the j3 site
    - load the awo extension in the backend (this will upgrade the tables)



    Regards
  • Default avatar
    rene54    
     4 days ago
     0

    Hi Seyi,


    I followed your advice from the above post. .

    Seems not to work. I tried with awoaffiliate.

    The config table doesnt exist in J3 (xx_awoaffiliate_config) and there was a joomla exception. So I took the config table from J5, but when I click the awoaffiliate dashboard, the loading wheel keeps spinning forever. 


    Also several tables have different names in J5 and J3 !!!


    Can you please elaborate more for this migration. What need to be done to fix this.


    PS: Also after copying the J3 tables from AwoCoupon and clicking on the dashboard, the tables are not "upgraded". It looks like all is working in AwoCoupon, but the copied J3 tables are not like the "original" J5 tables from the J5 installation.

    Any comment on this ? Is it really migrated correctly ????

    Many thanks and br


  • Default avatar
    rene54    
     4 days ago  last edited 4 days ago
     0

    e.g. for AWO AFFILIATE, the table names (as well as several column names) are different:


    In awo affiliate 2.3.6:

    j3_awoaffiliate_commission_paid

    j3_awoaffiliate_commission_paid_details


    In awo affilaite 4.0.0.4

    above tables don't exist. But there exists:

    j5_awoaffiliate_commission_paid_details

    j5_awoaffiliate_commission_paid_details


    It looks like, the script

    administrator\components\com_awoaffiliate\awoaffiliate\library\install\upgrade\sql

    did not execute.

    I did not delete the original tables but I renamed the original tables from version 4.0.0.4 with a different prefix.

    Could that be the issue ?

    Please advise

  • Default avatar
    rene54    
     3 days ago
     0

    ok, already found it out. Needed to re-install the extension again AFTER copying the original j3 tables. Then the update script was executed.

    Except for awoaffiliate, where the table j5_awoaffiliate_config has to be set to version 2.3.6 first. In 2.3.6 there was no config table yet...

    Now, all is working :-)