Sorry, the article title "xxx" has been taken! Solution

Jieqi program background editing novel, encountered "Sorry, the article title "xxx" has been occupied!", first check whether the title is repeated, found that there is no duplicate title, then check whether the database is damaged, no problem, finally thought Find the problem in the program, but the program used is the Jieqi official website program, and the program should not have this problem.

Finally, I found that there was a space at the end of the article title, as shown below:

There is also this space in the database, as shown below:

Try to delete the spaces from the field and then edit it in the Jieqi background. The editing was successful.

But if there are multiple novels in the database, it is impossible to manually remove spaces from each novel. Here is a simple method. We use MYSQL's trim function to remove spaces before and after the fields, and upgrade the Jieqi backend database. Or execute the following SQL code in phpmyadmin:

Remove the spaces before and after all novel names:
update jieqi_article_article set `articlename` = trim(`articlename`);

If you only want to operate one or more novels, you can use the following code:

Remove the spaces before and after the novel title with ID 100:
update jieqi_article_article set `articlename` = trim(`articlename`) where articleid = 100;

Remove the spaces before and after the novel names with IDs 1-100:
update jieqi_article_article set `articlename` = trim(`articlename`) where articleid >1 and articleid < 100;

Directly operating the database is risky, so operate with caution.

The title after the novel title is stored in the database at the time of collection.

This is just one of the reasons for this problem. If you check that there are no spaces before and after your novel title, it is not caused by this reason.

Recommended site search: free virtual space, permanent registration-free cloud server recommendation in mainland China, high-defense server rental qy, virtual host space, ip proxy, Hong Kong ip, 100m free space, foreign vps server rental, US host recommendation, South Korea Server rental,