Sql Error After Upgrading

Discussion in 'Installation' started by bestbuyloaders, Jun 2, 2003.

  1. Okay not sure i have upgraded properly but this is what i did.

    1.) changing servers
    2.) uploaded pro verision
    3.) went though setup process (all fine)
    4.) logged into admin fine
    5.) did a sql dump of my amember freeware on old server
    6.) uploaded freeware sql file into new server, all seems to work but i get this error on the front page of the admin:


    Code:
    MYSQL ERROR:
    Unknown column 'tm_added' in 'field list'
    in query:
    SELECT FROM_DAYS(TO_DAYS(tm_added)) as date, count(payment_id) as added_count, sum(amount) as added_amount FROM amember_payments p WHERE tm_added BETWEEN '2003-05-26 00:00:00' AND '2003-06-02 23:59:59' GROUP BY TO_DAYS(tm_added)
  2. alex-adm

    alex-adm Guest

    steps 5,6) should be just before step 3)

    aMember setup will not drop records in your database, don't worry. It will update database structure as needed for Pro version.

Share This Page