PostfixAdmin / Discussion / Postfix Admin Discussion: versions conflict?

irado furioso com tudo - 2009-08-24

I am trying to install postfixadmin via ports on FreeBSD 7.2 but 'am stuck with some strange errors:
note: I am using this http://www.purplehat.org/?page_id=11 tutorial for mySQL, Postfix and PostfixAdmin.

MySQL version: 6.1
Postfix version 2.6.3
Postfixadmin - latest in ports
PHP 5.2.10 with Suhosin-Patch 0.9.7 (cli) (built: Aug 20 2009 17:35:58) (DEBUG)

upgrade.php :
a) TYPE=MyISAM: error, doesnot exist
b) Innodb= ditto
c) unrecon words "primary key" and "key"

any suggestion, tip, hint, whitepaper?
TIA

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Tabmow - 2009-08-25
  
  It doesn't support MySQL 6+
  Revert back to MySQL 5 and you shouldn't have any issues.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - irado furioso com tudo - 2009-08-26
    
    ok, I removed 6.x and installed the 5.0 version; everything runs smoothly now :)
    
    thank you.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Christian Boltz - 2009-09-08
  
  I can't believe that postfixadmin is incompatible to MySQL 6.x. (I'm using 5.x, but according to the online documentation MyISAM and InnoDB are still available - maybe they are not enabled in your setup?)
  
  Please run upgrade.php?debug=1 and paste the output (last executed query + error messages) here.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Christian Boltz - 2009-10-06

Finally found it: TYPE=… is no longer supported, it needs to be replaced with ENGINE=… Fortunately ENGINE= is supported by all relevant MySQL versions (checked 4.1 doc because I didn't find an older one) so that this doesn't need a MySQL version check/switch.

I just submitted a fixed upgrade.php to SVN (r723) - please test if creating a new database works with MySQL 6.x.
If any other problems are left, please run upgrade.php?debug=1 and paste the last executed query + error message here.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

versions conflict?

Forums

Help

versions conflict?

versions conflict?

Forums

Help

versions conflict? document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

versions conflict?