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

Editor to share with you how to solve the problem of 1064 errors in phpcms, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Solutions to phpcms 1064 errors

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

The above is all about how to solve the problem of 1064 error in phpcms. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.