Error synchronization - phpBB3 SEO Sitemap
Error synchronization
when I click on "Click here to synchronise" I get this error:
SQL ERROR [ mysqli ]
Unknown column 'post_modified' in 'where clause' [1054]
SQL
UPDATE phpbb_posts SET post_modified = CASE WHEN post_time > post_edit_time THEN post_time ELSE post_edit_time END WHERE post_id IN (4, 38, 42, 72, 106, 129, 131, 151, 155, 164, 165, 169, 170, 171, 179, 181, 190.......) AND post_modified = 0
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 994
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/shredder/sitemap/acp/sitemap_module.php
LINE: 134
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: shredder\sitemap\acp\sitemap_module->main()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
In addition, only 519 posts are indexed out of a total of over 180,000.
Can you help me?
Thanks.
-
- Registered User
- Posts: 21
- Joined: Wed Oct 24, 2018 12:34 pm
- Contact:
Re: Error synchronization
Forms Extension | Browser & Mobile Notifications Extension | Mixed Content Fixer Extension
-
- Extension Customisations
- Posts: 2295
- Joined: Thu Apr 30, 2009 8:49 pm
- Name: Jakub
- Contact: