What to do if phpcms 2008 installation error occurs

What should I do if I get an error when installing phpcms 2008?

#The reason why this error is reported may be that your mysql version may be too high.

Because the error location is: 'TYPE=MyISAM DEFAULT CHARSET=gbk', type and engine both represent database engines, but type is only backward compatible. It is recommended to use engine to solve the problem.

The correct sql statement is as follows:

CREATE TABLE `phpcms_admin` ( `userid` MEDIUMINT(8) UNSIGNED NOT NULL,

`username` CHAR (20) NOT NULL,

`allowmultilogin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

`alloweditpassword` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

`editpasswordnextlogin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

`disabled` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`userid`))

ENGINE=MYISAM DEFAULT CHARSET=gbk

Or the simplest way is to install a php integrated installation package with a mysql version lower than 5.2, which can successfully install phpcms.

PHP Chinese website, a large number of free PHPCMS tutorials, welcome to learn online!

The above is the detailed content of What to do if phpcms 2008 installation error occurs. For more information, please follow other related articles on the PHP Chinese website!