The dedecms prompts to save the data to the database master table #@__ archives

Solution 1

Run SQL command lines in the background

Scenario 1: alter table '#@__ archives 'add COLUMN 'voteid' int (10) not null default 0 AFTER 'mtype ';

Condition 2: check the structure of the @ __archives table and find that the table structure is different. My statement is like this.
Alter table '# @__ archives 'add COLUMN 'weight' int (10) not null default 0 AFTER 'voteid ';
This is done after SQL execution, so it depends on whether the table structure is different.

Solution 2

The solution is as follows:

Solution 1 .:

1. Download DedeCmsV5.3GBK-5.6GBK upgrade package http://updatenew.dedecms.com/downloads/v53gbk-upv56gbk.tar.gz
2. Decompress the package and find update. php in the uploads folder. Copy the file.
3. Copy the file to the DEDE root directory.
4. Run localhost/update. php
-Solution! This method is estimated to solve the problem after the upgrade, which is caused by incomplete upgrades or upgrade errors.
 

Solution 2:

Solution: System> SQL command line tool> run SQL command line

The following content:

Alter table 'dede _ Archives' ADD 'utyadmin' MEDIUMINT (8) unsigned default '0' not null;

Alter table 'dede _ archives 'add' tackid' INT (10) DEFAULT '0' not null;

Another solution was to fix the table. Later, I found a solution from the dedecms website.

Now it's basically a perfect upgrade to 5.7. The default value is mysqli. Changed to mysql ~~ Image: 1.jpg    Image: 2.jpg [Attachment = 75784] [This post was edited by my5231 at]