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

This article mainly introduces the solution to the cache failure of phpcms v9 update column, which has certain reference value and can be used for reference by friends who need it. Let's take a look at it with me.

Problems and reasons:

Recently, in the maintenance of a previous project, I did a little secondary development of phpcms, in which a script was written to generate columns independently, resulting in a large number of columns added after running for a period of time. A few more columns were added yesterday, and I suddenly found that there was no way to update the cache.

When updated, only two lines of prompts are displayed. Then update the column cache, too bad, all the data are out, pull to the bottom of the displayed sql statement-"MySQL server has gone away", it turns out that the cache is full.

Solution:

You need to configure the max_allowed_ packet value in mysql's my.ini file.

1. Check whether there is a max_allowed_packet attribute in my.ini. If not, add it.

2. Modify the default value of the attribute 1m to 16m

3. Add a "max_allowed_packet=16M" at the end of the file

4. Restart the server.

These are the details of the solution to the cache failure in the update column of phpcms v9. Do you have anything to gain after reading it? If you want to know more about it, welcome to the industry information!

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.