Sposób na error: mySQL query error: UPDATE ibf_topics SET title_seo='-' WHERE tid=

[makensis]

W nowej wersji IPB znalazły się "zabezpieczenia", które powodują, że niektóre przeniesione tematy się nie wczytują. Widać to w Google Webmasters Tools i oczywiście wchodząc na dany temat. Co zrobić w tej sytuacji, gdy mamy np. taki błąd:

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 14 Jan 2013 14:41:04 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
 IP Address: 82.160.150.181 - /topic/110723322399-test/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: UPDATE ibf_topics SET title_seo='-' WHERE tid=
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/sources/classes/topics.php                       | [db_main_mysql].update                                                        | 1745              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/topics.php                 | [app_forums_classes_topics].parseTopicForLineEntry                            | 1303              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/topics.php                 | [public_forums_forums_topics]._getSameTaggedData                              | 304               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_topics].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Możemy napisać do supportu, jak ten biedak , albo samemu naprawić błąd.

 

W tym celu:

1. Wchodzimy do lokalizacji: /admin/applications/forums/sources/classes i otwieramy plik: topics.php
2. W miejscu gdzie mamy:
   

   //-----------------------------------------
   // Rebuild SEO title on the fly, if needed
   //-----------------------------------------
   if( ! $topic['title_seo'] )
   {
   $topic['title_seo'] = IPSText::makeSeoTitle( $topic['title'] );
   $this->DB->update( 'topics', array( 'title_seo' => ( $topic['title_seo'] ) ? $topic['title_seo'] : '-' ), 'tid=' . $topic['tid'] );
   }
   
   

   Zamieniamy na:
   
    

   //-----------------------------------------
   // Rebuild SEO title on the fly, if needed
   //-----------------------------------------
   if ($topic['tid'])
   {
   if( ! $topic['title_seo'] )
   {
   $topic['title_seo'] = IPSText::makeSeoTitle( $topic['title'] );
   $this->DB->update( 'topics', array( 'title_seo' => ( $topic['title_seo'] ) ? $topic['title_seo'] : '-' ), 'tid=' . $topic['tid'] );
   }
   }

    

    

3. Nadpisujemy plik i cieszymy się znów działającymi tematami na forum!