Upgrading --- Trying to

[dstone]

Had 1.1.1 and need to upgrade to 1.2.8 and not going so well ---

First question -- are there new fields in the tables because if I just replace the files and not the tables I get errors

Second Question -- I create new tables and get no errors doing so...however when I attempt to register I get the following error

+++++++
DB Error: no such field INSERT INTO php_permission (memberid, machid) SELECT "sc146eea2f055519", machid FROM php_resources WHERE autoassign=1 [nativecode=S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sc146eea2f055519'.]
++++++

If I have to create new tables can I bring the information from the old ons in?

Thank you for your help

[Nick]

This seems to be an incompatibility with MSSQL.  You can change line 186 of lib/db/AuthDB.class.php to:

      $sql = 'INSERT INTO ' . $this->get_table('permission') . " (memberid, machid) SELECT '$id' as memberid, machid FROM " . $this->get_table('resources') . ' WHERE autoassign=1';