Перейти до змісту
Домент ipb-board.ru продається.

Способ error: mySQL query error: UPDATE ibf_topics SET title_seo='-' WHERE tid=

Рекомендовані відповіді

Опубліковано
  • Адміністратор

Что делать в этой ситуации, когда у нас, например, такая ошибка:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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               | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Перейти:
 

/admin/applications/forums/sources/classes

Найти:

//-----------------------------------------// 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'] );}

Заменить на:

//-----------------------------------------// 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'] );}}

Для публікації повідомлень створіть обліковий запис або авторизуйтесь