phpBB3 SEO Sitemap

Error synchronization - phpBB3 SEO Sitemap

Error synchronization

by Vastasia2018 » Sun Oct 28, 2018 7:43 am

Hi,
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.
Vastasia2018
Registered User
Posts: 21
Joined: Wed Oct 24, 2018 12:34 pm
Contact:

Re: Error synchronization

by Senky » Mon Dec 03, 2018 12:13 pm

I experience the same problem.
Senky
Extension Customisations
Extension Customisations
Posts: 2146
Joined: Thu Apr 30, 2009 8:49 pm
Name: Jakub
Contact: