Newly created pages are not visible in the Page list.

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client was experiencing issues with new page creation; once created, the page was not visible in the all pages list.
Solution:
We resolved the issue by performing the following steps:
- Access the site's Database.
- Open the

simcollina_icl_translations

table and execute the SQL query:

SELECT * FROM `simcollina_icl_translations` WHERE `translation_id` <= 1;

- If an entry with translation_id = '1' is found, decide to either update this entry to a new ID or remove it.
- To update, run the SQL query:

UPDATE `simcollina_icl_translations` SET `translation_id` = [NEW_ID] WHERE `translation_id` = 1;

Replace [NEW_ID] with a non-conflicting value.
- Finally, re-apply the AUTO_INCREMENT Attribute with the SQL query:

ALTER TABLE `simcollina_icl_translations` CHANGE `translation_id` `translation_id` BIGINT(20) NOT NULL AUTO_INCREMENT;

If the solution provided here is not relevant to your case, because it might be outdated or not applicable, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please open a new support ticket.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Exception

This topic contains 5 replies, has 2 voices.

Last updated by Prosenjit Barman 1 year, 1 month ago.

Assisted by: Prosenjit Barman.

Author	Posts
March 21, 2024 at 10:11 am
antonio	I've problems with new page creation Once created, it is not visible in the all page list
March 21, 2024 at 11:22 am
March 21, 2024 at 11:30 am #15435956
Prosenjit Barman WPML Supporter since 03/2023 Languages: English (English ) Timezone: Asia/Dhaka (GMT+06:00)	Hi, Following our conversation, I've converted the chat into a ticket for further assistance. I suggest setting up a staging or testing version from your main site to pinpoint the problem. Once the testing site is ready, try to create the page both with the WPML plugin activated and deactivated. If the problem only occurs with WPML active, please share access to the testing site so I can conduct a comprehensive investigation into the issue. I enabled the private fields for you so that you can securely share the access. The private box looks like this: hidden link Looking forward to your response and appreciate your cooperation in this matter. Best regards, Prosenjit
March 21, 2024 at 4:46 pm #15437648
antonio	Hi Prosenjit, here the dev installation, I've already deactivate wpml: hidden link WP credentials are the same of production website.
March 21, 2024 at 5:20 pm #15437743
antonio	Maybe I found the problem: the AUTO INCREMENT of ICL tables, I'm updating it manually, I'll let you know asap.
March 21, 2024 at 5:44 pm #15437966
antonio	After updating all the tables, only few tables return error "#1062 - ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'" These are the tables: ALTER TABLE `simcollina_icl_mo_files_domains` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `simcollina_icl_strings` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `simcollina_icl_string_packages` CHANGE `ID` `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `simcollina_icl_translations` CHANGE `translation_id` `translation_id` BIGINT(20) NOT NULL AUTO_INCREMENT; Any help?
March 22, 2024 at 5:41 am #15438771
Prosenjit Barman WPML Supporter since 03/2023 Languages: English (English ) Timezone: Asia/Dhaka (GMT+06:00)	Hello There, Thank you for the update. Good to see that you've identified the root cause of the issue. The error you encountered usually happens if the table already contains an entry with a primary key value of '1'. When you try to add the AUTO_INCREMENT attribute to the primary key column, MySQL tries to resequence the existing entries, but it conflicts with the existing '1'. However, I'm happy to inform you that I was able to solve the issue with page creation on the Testing site. Here's what you can do to solve the issue. - Please open the Database of your site. - Open the "simcollina_icl_translations" table and execute the following SQL query: SELECT * FROM `simcollina_icl_translations` WHERE `translation_id` <= 1; - If you find an entry with translation_id = '1', you'll need to decide whether to update this entry to a new ID or remove it. - If you want to update it Run the following SQL query (ensure the new ID does not conflict with existing IDs): UPDATE `simcollina_icl_translations` SET `translation_id` = [NEW_ID] WHERE `translation_id` = 1; Replace [NEW_ID] with a value that doesn't conflict with existing IDs. - Once done, re-apply the AUTO_INCREMENT Attribute by running the following SQL query: ALTER TABLE `simcollina_icl_translations` CHANGE `translation_id` `translation_id` BIGINT(20) NOT NULL AUTO_INCREMENT; These steps should help you resolve the issue with the AUTO_INCREMENT resequencing error. Please feel free to let me know if you need further assistance in this matter. I will be happy to help. Best regards, Prosenjit
March 22, 2024 at 8:39 am #15439310
antonio	Thank you, we solved it, all is working now.