Upgrading from 1.0.1 to 1.2.12

[yeahmag]

I'm testing updating an old 1.0.1 instance to 1.2.12. After editing the update.sql file to reflect the correct DB name I was able to successfully run the updates. From there I get the error:

There was an error executing your query:
DB Error: no such field SELECT count(*) as num FROM login WHERE (email='mckinnon@caltech.edu' OR logon_name='mckinnon@caltech.edu') AND password='XXX' [nativecode=1054 ** Unknown column 'logon_name' in 'where clause']

I'm guessing I need to find and old update.sql script to go to 1.1 first... Any other ideas?

Thanks.

-Aaron

[yeahmag]

Some additional info:

PHP 5.3.3
php-pear-db-1.7.13-2.el5.rf
php-pear-1.4.9-6.el5
Server version: Apache/2.2.3
mysql  Ver 14.12 Distrib 5.0.27 (running with "sql_mode = MYSQL40")

[Nick]

Oooh boy. Your guess is probably correct. I'm not sure if there's going to be a simple way to run this upgrade, though. If you're comfortable, it may be simpler to create a 2nd database for 1.2.12 and import the data yourself.

[BernardII]

I was having the same problem......thanks "yeahmag" for sharing the info

[yeahmag]

Is there a way to export the data?

[Nick]

The simplest way would be to use the tools built into MySQL or a tool like phpMyAdmin