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

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, gdzie zamiast strony wyświetla nam się Driver Error(There appears to be an error with the database..). 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:

• Wchodzimy do lokalizacji: /admin/applications/forums/sources/classes i otwieramy plik: topics.php
  
• 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'] );
  }
  }

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