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

This article will explain in detail what to do about 1064 errors in phpcms. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

MySQL Errno: 1064 error occurred in the last step of PHPCMS V9 installation, online, etc.

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, phpcms V9 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

This is the end of the article on "what to do if there are 1064 errors in phpcms". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.