BUG stickies in beginners area

Discussion in 'New Forum Upgrade Bug Tracker' started by shubbie, Mar 3, 2016.

Thread Status:
Not open for further replies.
  1. I get this error only in the stickies of the beginners area
    Server Error
    Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY attachment.content_id, attachment.attach_date' at line 7

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
    5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Attachment.php at line 37
    6. XenForo_Model_Attachment->getAttachmentsByContentIds() in GrassCity/GrowJournals/Extend/XenForo/ControllerPublic/Thread.php at line 13
    7. GrassCity_GrowJournals_Extend_XenForo_ControllerPublic_Thread->actionIndex() in ModEss/ControllerPublic/Thread.php at line 40
    8. ModEss_ControllerPublic_Thread->actionIndex() in ThreadRating/ControllerPublic/Thread.php at line 7
    9. ThreadRating_ControllerPublic_Thread->actionIndex() in Bookmarks/ControllerPublic/Thread.php at line 15
    10. Bookmarks_ControllerPublic_Thread->actionIndex() in Andy/SimilarThreads/ControllerPublic/Thread.php at line 12
    11. Andy_SimilarThreads_ControllerPublic_Thread->actionIndex() in XenForo/FrontController.php at line 351
    12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    13. XenForo_FrontController->run() in /var/www/html/index.php at line 13
     
  2. Hi @shubbie

    Do you get the error when you try to view, or try to post in stickied threads?
    Are you on your phone, or on PC?
    What browser are you using (ex. Safari 9.0.2)?

    @Lizard King
     
  3. I am on a pc, win 10. Using Firefox 45. That is the only place, so far, I get that error. And I was just trying to open the thread, i.e. view.

    I just tried again and get this

    A server error occurred. Please try again later.
     
    • Like Like x 1
  4. Thanks for the info.
    @Lizard King
     
  5. Can you please give me the exact url that generates this error
     
  6. Thanks for letting us know,i checked this on development server and we have the same issue. Seems we missed this on QA steps. I'll investigate this tomorrow.
     
  7. No problem, thanks, I was refreshing my memory on light levels, thinking of doing led's vs cfl's...........
     
  8. I checked these and found a very interesting thing , all these 3 threads have 0 post on old ipb database
    Code:
    MariaDB [ipb]> select count(*) from posts where topic_id=73015;
    +----------+
    | count(*) |
    +----------+
    |        0 |
    +----------+
    1 row in set (0.00 sec)
    
    MariaDB [ipb]> select count(*) from posts where topic_id=24559;
    +----------+
    | count(*) |
    +----------+
    |        0 |
    +----------+
    1 row in set (0.00 sec)
    
    MariaDB [ipb]> select count(*) from posts where topic_id=15076;
    +----------+
    | count(*) |
    +----------+
    |        0 |
    +----------+
    1 row in set (0.00 sec)
    Once i complete setting IPB instance on test server , i'll check those 3 threads to find out why they don't have any post assigned to them.

    I currently hide the threads to make sure no other user enters them
     
    • Like Like x 1
  9. I just realised IPB bugs still haunt us , what a f..ked up system it was :cop:
     
  10. I set the IPB instance and found the cause of the issue. IPB seems to archive some posts and move them away from posts table. We are creating a special import function to bring those posts back in the system. Should be done my next week.
     
Thread Status:
Not open for further replies.

Share This Page