Jump to content
Дизайн и модификация IPS Community IPBSkinsBETA
Search In
  • More options...
Find results that contain...
Find results in...
Sign in to follow this  
Атаман

You have an error in your SQL syntax

Recommended Posts

Пришла личка, но прочесть не могу. Выскакивает ошибка с БД

 

 Date: Wed, 04 Mar 2015 18:18:46 +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 'ORDER BY start_date DESC LIMIT 0,5' at line 1
IP Address: 11.11.11.11 - /index.php?app=members&module=messaging&section=view&do=showConversation&topicID=1108
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT tid,title,starter_id,start_date,forum_id,approved,title_seo FROM toptalkru_jtapia_topics WHERE approved = 1 AND starter_id = ORDER BY start_date DESC LIMIT 0,5
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| cache/skin_cache/cacheid_1/skin_messaging.php                              | [ZozMyTopicsUserInfoPanel].userInfoPane                                       | 636               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| cache/skin_cache/cacheid_1/skin_messaging.php                              | [skin_messaging_1].__f__cf1b71b256edd7872efb59935e6f3740                      | 564               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/messaging/view.php               | [skin_messaging_1].showConversation                                           | 733               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/messaging/view.php               | [public_members_messaging_view].showConversation                              | 150               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php                                       | [public_members_messaging_view].doExecute                                     | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Share this post


Link to post
Share on other sites

Разобрался.

 

Ошибка была из-за хука.

Edited by Атаман

Share this post


Link to post
Share on other sites

В запросе есть синтаксическая ошибка. Хук ZozMyTopicsUserInfoPanel.

Лечится заменой

if ( in_array( $this->request['f']

На

if ( $author['author_id'] AND in_array( $this->request['f']

  • Upvote 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...