Shulou(Shulou.com)06/02 Report--

This article mainly introduces how to solve the problem of phpcms2008 installation failure prompt 1064. The article is very detailed and has a certain reference value. Interested friends must finish reading it!

Phpcms2008 installation failure prompt 1064 what to do?

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 '0mm, `alloitwedpassword` tinyint (1) unsigned NOT NULL default' 0mm, `editpasswordnextlogin` tinyint (1) unsigned NOT NULL default '0mm, `userled` tinyint (1) unsigned NOT NULL default' 0mm, PRIMARY KEY (`userid`)) TYPE=MyISAM DEFAULT CHARSET=gbk MySQL Error: 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 installation succeeded, phpcms2008 installation failed

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

Don't say anything about binary uploads, absolutely no problem. In addition, the database is new and there are no tables.

Answer:

After the database is installed, the compatibility between the database and PHP is not good. If you really can't, install the database a few more times. This problem occurs when many people install, or switch to other databases. This is your server environment problem. There are many reasons. The common ones are the following:

1. MySQL database environment and coding problems

2. Windows environment configuration and connection timeout

The above is all the content to solve the problem of phpcms2008 installation failure tip 1064, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.