when I trying to install postfix admin (2.2.1.1) I get:
PHP version 5.2.9
Apache/2.2.11 (FreeBSD) mod_ssl/2.2.11 OpenSSL/0.9.8k DAV/2 PHP/5.2.9 with Suhosin-Patch
Everything seems fine… attempting to create/update database structure
Updating database:
old version: 4; target version: 397
updating to version 5 (MySQL)…
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ C' at line 9
Could you help me, pls!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
What version of MySQL are you using? The error message sounds like MySQL 6.x which requires to use ENGINE= instead of TYPE=. I fixed this issue in SVN r723 - at least I hope so because I don't have MySQL 6.x installed for testing).
Please test with the latest SVN version or with the upcoming 2.3 release (not yet available). If it still doesn't work, please open a bugreport.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK. Thanks! I really have MySQL 6 version, but this upgrade occured in during installation of postfixadmin. Initially I had version 5.
I changed TYPE to ENGINE and overcame this step but stumbled on following:
Everything seems fine… attempting to create/update database structure
Updating database:
old version: 343; target version: 397
updating to version 344 (MySQL)…
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), primary key(id) )' at line 16
I had closely studied this segment in upgrade.php but didn't understant
what my error. Could you help me?
Thanks in advance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please try to modify the query until it can create the table, and then report back so that I know what needs to be fixed. From the error message, I'd try to change "date timestamp(14)" to just "date timestamp" or "date datetime", but I can't say for sure if this is really the problem. Just play around with the query a bit ;-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you haven't figured this out already, here's a workaround.
In the upgrade.php file, find "function upgrade_344_mysql()".
Change the line
"date timestamp(14),"
to
"date datetime NOT NULL default '0000-00-00 00:00:00',"
That is what I did and it seems to run from there.
(System configuration: FreeBSD 8.1, Apache 2.2.15, PHP 5.3.2, MySQL 5.5.4, postfix admin 2.3_1)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
when I trying to install postfix admin (2.2.1.1) I get:
PHP version 5.2.9
Apache/2.2.11 (FreeBSD) mod_ssl/2.2.11 OpenSSL/0.9.8k DAV/2 PHP/5.2.9 with Suhosin-Patch
Everything seems fine… attempting to create/update database structure
Updating database:
old version: 4; target version: 397
updating to version 5 (MySQL)…
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ C' at line 9
Could you help me, pls!
What version of MySQL are you using? The error message sounds like MySQL 6.x which requires to use ENGINE= instead of TYPE=. I fixed this issue in SVN r723 - at least I hope so because I don't have MySQL 6.x installed for testing).
Please test with the latest SVN version or with the upcoming 2.3 release (not yet available). If it still doesn't work, please open a bugreport.
OK. Thanks! I really have MySQL 6 version, but this upgrade occured in during installation of postfixadmin. Initially I had version 5.
I changed TYPE to ENGINE and overcame this step but stumbled on following:
Everything seems fine… attempting to create/update database structure
Updating database:
old version: 343; target version: 397
updating to version 344 (MySQL)…
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), primary key(id) )' at line 16
I had closely studied this segment in upgrade.php but didn't understant
what my error. Could you help me?
Thanks in advance!
Looks like another incompatibily in MySQL 6.0 :-/
Please try to modify the query until it can create the table, and then report back so that I know what needs to be fixed. From the error message, I'd try to change "date timestamp(14)" to just "date timestamp" or "date datetime", but I can't say for sure if this is really the problem. Just play around with the query a bit ;-)
Thank you very much!
Now is OK! "date timestamp" is OK!
Thank you very much!
Thanks for testing and reporting back!
Fixed in SVN r745.
If you haven't figured this out already, here's a workaround.
In the upgrade.php file, find "function upgrade_344_mysql()".
Change the line
"date timestamp(14),"
to
"date datetime NOT NULL default '0000-00-00 00:00:00',"
That is what I did and it seems to run from there.
(System configuration: FreeBSD 8.1, Apache 2.2.15, PHP 5.3.2, MySQL 5.5.4, postfix admin 2.3_1)
There's a much easier solution: use PostfixAdmin 2.3.2 - it already includes the fix ;-)