What should I do if there is an error reading additional information in some dedecms articles?

dedecms What should I do if there is an error reading additional information in some articles?

Today I modified the table prefix of the dede website database due to some needs, and also changed the table prefix in the database configuration information file. Then when editing the published document, "Read additional information" appeared. Error!" message, the same error occurred when adding the document, and the message "An error occurred while saving the data to the database additional table `dede_addonarticle`, please submit the relevant information to DedeCms official." When regenerating the html file, the original The documentation is also missing.

Recommended study: 梦Weavercms

So I used the code editor to search for the file where "Error reading additional information!" was located, and found this piece of information It is in admin/article_edit.php, and the condition for its appearance is that the array $addRow does not exist, that is, the above sql statement "SELECT * FROM `$addtable` WHERE aid='$aid'" returns a result of 0, the same as this sql It can be seen from the statement that problems will occur when the table name $addtable is wrong, or the document aid does not exist, and $addtable = $cInfos['addtable'], $cInfos is passed through "SELECT * FROM `dede_channeltype` WHERE id= '".$arcRow['channel']."'", we can see that the table name $addtable is stored in the addtable field in the table dede_channeltype (where dede_ is the table prefix), instead of using something like The table prefix of dede_channeltype was obtained by adding the table name. As a result, I went to the dede_channeltype table in the database and found that it contained the content model information, but the prefix of the table name stored in it was still the original, so I changed the table name inside Correct it, go to the backend and check again, the error will be gone.

Summary: This error occurs because the database table name does not match the table name stored in dede_channeltype. People who can operate the database can modify it in the database. People who cannot operate the database can modify it in the core - channel model. --Content model management--Just change the model's 'attached table' correctly.

Attachment: When I checked the dede_channeltype table, I found that the table name is also stored in the field maintable. People who can change the database should also change the table prefix inside. Although it is said that it can be solved by changing the addtable field. mistake.

The following is the method of the dedecms forum:

I checked the old articles on the website today and found that many of them were "Error reading additional information!". When browsing the content, there was only a description paragraph. , all the text content is missing.

Go to phpmyadmin and open the dede_addonarticle table to search for the ID of the article in question. The result is not found, so I try to insert content and enter the ID of the article in question in the aid field.

Sure enough, the background can be edited, but the text content cannot be found. The only way is to re-write the content, or take a look at Baidu snapshots~~~

This problem has existed for me for a long time I haven't found it yet. Baidu has updated it countless times and I can't find the content in the snapshot. It's sad~~ I have to look for it one by one.

I still don’t know how this problem occurs and how to prevent it~~ Can any experts tell me?

My solution:

If there is an error in the sub-table storage of dedecms, then we can manually store it in the database. In dedecms5.1, you only need to add the content of the specified ID to dede_archives and dede_addonarticle respectively, and then modify it to the content you want, which is a perfect solution.

The above is the detailed content of What should I do if there is an error reading additional information in some dedecms articles?. For more information, please follow other related articles on the PHP Chinese website!