Re: [Postfixadmin-devel] upgrade problem

[David G. <da...@co...>]

me...@td... wrote :
> Hi,
> 
> I am attempting to upgrade from pfa 2.1.1 to svn509. The 509 install is being
> installed on a new machine that I took the old db and installed it on the new
> machine. I configured config.inc.php and ran setup.php. Below is the output
> of setup.php.
> 
> Postfix Admin Setup Checker
> 
> Running software:
> 
>      * PHP version 5.1.6
>      * Apache/2.2.3 (CentOS)
> 
> Checking for dependencies:
> 
>      * Warning: Magic Quotes: ON (internal workaround used)
>      * Depends on: presence config.inc.php - OK
>      * Checking $CONF['configured'] - OK
>      * Depends on: MySQL 3.23, 4.0 - OK
>      * Depends on: MySQL 4.1 - OK
>      * Depends on: PostgreSQL - OK (change the database_type to 'pgsql' in config.inc.php!!)
>      * Testing database connection - OK - mysqli://postfix:xxxxx@localhost/postfix
>      * Depends on: session - OK
>      * Depends on: pcre - OK
>      * Depends on: multibyte string - OK
>      * Depends on: IMAP functions - OK
> 
> Everything seems fine... attempting to create/update database structure
> 
> Updating database:
> 
> - old version: 0; target version: 509
> 
> updating to version 1 (MySQL)...   done
> 
> updating to version 2 (MySQL)...   done
> 
> updating to version 3 (MySQL)...   done
> 
> updating to version 4 (MySQL)...   done
> 
> updating to version 5 (MySQL)...   done
> 
> updating to version 79 (MySQL)...   done
> 
> updating to version 81 (MySQL)...   done
> 
> updating to version 90 (all databases)...   done
> 
> updating to version 169 (MySQL)...   done
> 
> updating to version 318 (MySQL)...
> 
> DEBUG INFORMATION:
> Invalid query: Can't create table './postfix/vacation_notification.frm' (errno: 150)
> 
> As you can see the db is not being updated properly. Can someone help me get
> this upgraded?
> 

Hi Tom,

Yes; I'm desperate to fix these MySQL errors. Would you be able to
give ma  dump of your database schema from BEFORE you did the upgrade?
If not, could you give me a dump of the database schema as it is now?


thanks
David.

-- 
David Goodwin 

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]