What should I do if the installation of phpcms2008 fails and prompts 1064?

What should I do if phpcms2008 fails to install and prompts 1064?

MySQL Errno: 1064 error occurred in the last step of PHPCMS2008 installation!

MySQL Query : 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`)) TYPE=MyISAM DEFAULT CHARSET=gbk 
MySQL Error : 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 CHARSET=gbk' at line 1 
MySQL Errno : 1064 
Message : MySQL Query Error

Virtual host platform, discuz7 was successfully installed, but phpcms2008 failed to be installed

Microsoft-IIS/6.0
MySQL client version: 5.0.45
PHP extension: mysql

Don’t talk about binary upload, it’s absolutely no problem. In addition, the database is new and has no tables.

Answer:

After installing the database, the compatibility between the database and PHP is not good. If it really doesn’t work, install the database a few more times. This problem will appear when many people install it, or use other Database This is a problem with your server environment. There are many reasons. The common ones are the following:

1. MySQL database environment problems and encoding problems;

2. Windows environment configuration problems and connection timeout Question;

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

The above is the detailed content of What should I do if the installation of phpcms2008 fails and prompts 1064?. For more information, please follow other related articles on the PHP Chinese website!