Icy Phoenix

     
 

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Bugs

The time now is Tue 16 Apr, 2024 21:06 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic

While Merging Two Topics...


Post new topic  This topic is locked: you cannot edit posts or make replies.  		Page 1 of 1
 
 
Offline tormentor Male
 
avatar
Joined: October 2006
Posts: 84
Location: italia.png
 
 
Reply with quote Download Post 
Post 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
 



 
#1  Tue 19 Dec, 2006 07:16
tormentorSend private messageVisit poster's website  
Back to topPage bottom
Sponsors
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Offline TheSteffen Male
Designer
avatar
Joined: August 2006
Posts: 1625
Location: germany.png Magdeburg
 
 
Reply with quote Download Post 
Post 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.  

Here in this forum you can merge without errors.
 



 
#2  Tue 19 Dec, 2006 08:27
TheSteffenSend private message  
Back to topPage bottom
Offline TheSteffen Male
Designer
avatar
Joined: August 2006
Posts: 1625
Location: germany.png Magdeburg
 
 
Reply with quote Download Post 
Post 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
 



 
#3  Tue 19 Dec, 2006 08:50
TheSteffenSend private message  
Back to topPage bottom
Offline hpl Male
 
avatar
Joined: August 2006
Posts: 302
Location: italia.png Trieste
 
 
Reply with quote Download Post 
Post Re: While Merging Two Topics... 
 
SOLUTION        
 



 
#4  Tue 19 Dec, 2006 22:45
hplSend private messageVisit poster's website  
Back to topPage bottom
Offline Mighty Gorgon Male
Luca Libralato
Site Admin
avatar
Joined: August 2006
Posts: 7191
Location: italia.png Borgo San Michele
 
 
Reply with quote Download Post 
Post Re: While Merging Two Topics... 
 
This has been already fixed at least twice... please use the search function...

Locking...
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
#5  Sun 24 Dec, 2006 21:40
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Bugs

The time now is Tue 16 Apr, 2024 21:06 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic




 
Permissions List
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

  

 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 0.228s (PHP: 8% SQL: 92%)
SQL queries: 15 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron