Migrated Joomla now can't access AMember

Discussion in 'Troubleshooting' started by daveb, Jan 19, 2009.

  1. daveb

    daveb New Member

    Joined:
    Oct 4, 2006
    Messages:
    3
    I migrated from Joomla 1.0.x to 1.5.8. Removed all the old Jos_ files and uploaded the new Joomla. Now when I try to access the AMember admin screen I get this.

    MYSQL ERROR:
    Unknown column 'group_id' in 'field list'
    in query:
    SELECT group_id, parent_id, name FROM thepecom_db.jos_core_acl_aro_groups WHERE name != 'ROOT' AND name != 'USERS'

    -Dave
  2. daveb

    daveb New Member

    Joined:
    Oct 4, 2006
    Messages:
    3
    Solved it myself!

    Problem Solved! If you migrate your site from Joomla 1.0.x to 1.5.x and find you can no longer access your Amember CPanel, here's how I got in.

    http://yourwebsiteaddress.com/amember/admin/setup.php

    login using your admin account (the screen will look horrible and you will see errors, just ignore)
    Go to the Joomla hyperlink and make the following corrections
    1. Replace your Secret Word if it changed(it can be found in your Joomla
    Administrator Control Panel > Global Configuration > Server Tab
    This is a generated string like W7NQu1AkGgfjaPT7 , use copy & paste)

    2. Click SAVE - then you may have to hit the BACK button on your browser
    3. Change Joomla version from 1.0.x to 1.5
    4. Click SAVE - again you may have to hit the BACK button on your browser
    5. Change Joomla DEFAULT Group to the appropriate setting
    6. Click SAVE -

    Now everything should be back to normal.

    I hope this helps someone else.

    DaveB!

Share This Page