FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » Converting phpBB2 w/mail2forum posts
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Converting phpBB2 w/mail2forum posts [message #168497 is a reply to message #168468] Sun, 12 May 2013 07:01 Go to previous messageGo to previous message
cpreston is currently offline  cpreston   United States
Messages: 160
Registered: July 2012
Location: Oceanside
Karma:
Senior Member
The -1 fix worked like a charm.

The fud30_thread_notify issue was that there was no validation (or validation did not work) in phpbb2 that should have restricted a user from subscribing to a same topic. This created duplicate records in the _topics_watch table.

The following changes to the phpBB2 map fixed the issue.
//commented line no 249 and replaced it with the line below
$c = bbq('SELECT * FROM '. dbpref .'topics_watch GROUP BY user_id,topic_id HAVING notify_status=0');

[Updated on: Sun, 12 May 2013 07:01]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: JForum Conversion to FUDForum
Next Topic: phpBB2 to FUDforum converter
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 01:00:14 GMT 2024

Total time taken to generate the page: 0.03992 seconds