Posts merging

got problems since 3.1.5 update - Posts merging

got problems since 3.1.5 update

by Jane Doe » Sat Jun 27, 2015 3:11 pm

Hello,
after 3.1.5 update i got errors like

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'p.post_created' in 'field list' [1054]

SQL

SELECT f.enable_indexing, f.forum_id, p.bbcode_bitfield, p.bbcode_uid, p.post_created, p.enable_bbcode, p.enable_magic_url, p.enable_smilies, p.poster_id, p.post_attachment, p.post_edit_locked, p.post_id, p.post_subject, p.post_text, p.post_time, t.topic_attachment, t.topic_first_post_id, t.topic_id, t.topic_last_post_time FROM (phpbb_forums f CROSS JOIN phpbb_posts p CROSS JOIN phpbb_topics t) WHERE p.post_id = t.topic_last_post_id AND t.topic_id = 29799 AND p.post_visibility = 1 AND p.poster_id = 3 AND (f.forum_id = t.forum_id OR f.forum_id = 17)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/ext/rxu/PostsMerging/core/helper.php
LINE: 88
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/rxu/PostsMerging/event/listener.php
LINE: 131
CALL: rxu\PostsMerging\core\helper->get_last_post_data()

FILE: (not given by php)
LINE: (not given by php)
CALL: rxu\PostsMerging\event\listener->posts_merging()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 164
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 53
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 167
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/functions_posting.php
LINE: 1537
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/posting.php
LINE: 1400
CALL: submit_post()


after submitting a post which should be merged.

php version is 5.4.19
mod version 2.0.2
Jane Doe
Registered User
Posts: 145
Joined: Thu Aug 11, 2005 12:35 pm

Re: got problems since 3.1.5 update

by rxu » Sat Jun 27, 2015 3:45 pm

That's odd as updating the version of phpBB shouldn't affect data changes made by extensions. Are you able to check directly in the database if the post_created field does exist in the phpbb_posts table?
rxu
Extensions Development Team
Posts: 4055
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation

Re: got problems since 3.1.5 update

by Jane Doe » Sat Jun 27, 2015 9:06 pm

For some strange reasons, i installed this mod several month ago, there was no post_created field.
So fix was simple, deactivated ext, delete data, activate ext, all fine :)

Sorry for the inconvenience.
Jane Doe
Registered User
Posts: 145
Joined: Thu Aug 11, 2005 12:35 pm