Article ID: 114857, created on Sep 28, 2012, last review on May 11, 2014

  • Applies to:
  • Plesk 11.x for Linux
  • Plesk 10.x for Linux
  • Plesk 9.x for Linux/Unix
  • Plesk 11.x for Windows
  • Plesk 10.x for Windows
  • Plesk 9.x for Windows


Net2ftp, Coppermine, 4image and PhpList fail to be installed producing the following error:

Error: Installation of net2ftp at http://plesktestdomain.tld//net2ftp failed. Non-zero exit status returned by script. Output stream: 'Unable to execute SQL statement ( CREATE TABLE `net2ftp_log_access` (`id` int(10) unsigned NOT NULL auto_increment,`date` date NOT NULL default '0000-00-00',`time` time NOT NULL default '00:00:00',`remote_addr` text NOT NULL,`remote_port` text NOT NULL,`http_user_agent` text NOT NULL,`page` text NOT NULL,`datatransfer` int(10) unsigned default '0',`executiontime` mediumint(8) unsigned default '0',`ftpserver` text NOT NULL,`username` text NOT NULL,`state` text NOT NULL,`state2` text NOT NULL,`screen` text NOT NULL,`directory` text NOT NULL,`entry` text NOT NULL,`http_referer` text NOT NULL,KEY `index1` (`id`)) TYPE=MyISAM): 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' at line 1 '. 


DB schema SQL scripts of the above applications are using queries like these to create tables in database:
CREATE TABLE `table_name` ( ... ) TYPE=MyISAM;
However, 'TYPE' keyword is deprecated since MySQL 5.1.


The affected applications have been fixed, re-packaged and published to

net2ftp - 0.98-4, Published: 2012-08-25
Coppermine - 1.5.20-3, Published: 2012-07-14
PhpList - 2.10.17-6, Published: 2012-02-08
4images - 1.7.11-2, Published: 2012-08-25

I.e. they are now available for installation from the Application Vault in Parallels Plesk Panel web interface.

bd7fc88cf1b01f097749ae6f87272128 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 dd0611b6086474193d9bf78e2b293040 29d1e90fd304f01e6420fbe60f66f838 6ef0db7f1685482449634a455d77d3f4 aac4a8fcd879de03758354e15495d69a c796c01d6951fa24ed54c7f1111667c6 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF