Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Bugs

While Merging Two Topics...

This topic is locked: you cannot edit posts or make replies.

 

tormentor
Quote
Posts: 84
Tue 19 Dec, 2006 07:16
Subject: While Merging Two Topics...
P.S. Ok, I found another topic about it, sorry


While merging two topics I hjad this error and the old topic was not deleted

Could not delete topic reads

DEBUG MODE

SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back

DELETE FROM phpbb_upi2db_unread_posts WHERE topic_id IN ()

Line : 846
File : modcp.php

Profile PM   Website
TheSteffen
Quote
Posts: 1625 Location: Magdeburg
Tue 19 Dec, 2006 08:27
Subject: Re: While Merging Two Topics...
Which version of phpBBXS do you use?

Did you update to UPI2DB v3.0.7 ?
http://www.icyphoenix.com/viewtopic.php?t=693&highlight=

I have updated and get the same error. :roll:

Here in this forum you can merge without errors.

Profile PM  
TheSteffen
Quote
Posts: 1625 Location: Magdeburg
Tue 19 Dec, 2006 08:50
Subject: Re: While Merging Two Topics...
OK,

find in

OPEN modcp.php
FIND
Code: [Download] [Hide] [Select]
//<!-- BEGIN Unread Post Information to Database Mod -->
if($userdata['upi2db_access'])
{
$sql = "DELETE FROM " . UPI2DB_UNREAD_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";

if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete topic reads', '', __LINE__, __FILE__, $sql);
}

$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";

if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete topic reads', '', __LINE__, __FILE__, $sql);
}
}
//<!-- END Unread Post Information to Database Mod -->

REPLACE WITH
Code: [Download] [Hide] [Select]
//<!-- BEGIN Unread Post Information to Database Mod -->
if($userdata['upi2db_access'])
{
/*
$sql = "DELETE FROM " . UPI2DB_UNREAD_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";
*/
$sql = "DELETE FROM " . UPI2DB_UNREAD_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_list[$i])";

if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete topic reads', '', __LINE__, __FILE__, $sql);
}

/*
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";
*/
$sql = "DELETE FROM " . UPI2DB_LAST_POSTS_TABLE . "
WHERE topic_id IN ($topic_id_list[$i])";

if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete topic reads', '', __LINE__, __FILE__, $sql);
}
}
//<!-- END Unread Post Information to Database Mod -->


For me it's working.

I have updated this http://www.phpBBXS.eu/viewtopic.php?t=693

Profile PM  
hpl
Quote
Posts: 302 Location: Trieste
Tue 19 Dec, 2006 22:45
Subject: Re: While Merging Two Topics...
SOLUTION :roll: :roll: :roll: :roll:

Profile PM   Website
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Sun 24 Dec, 2006 21:40
Subject: Re: While Merging Two Topics...
This has been already fixed at least twice... please use the search function... :wink:

Locking...

Profile PM   Website
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.118s (PHP: 26% SQL: 74%)
SQL queries: 10 - Debug Off - GZIP Enabled