No announcement yet.

Creating Blogs and Articles

  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating Blogs and Articles

    Hey there,

    I've got some problems with creating blogs and articles. There are no mods or anything else running on my vB 5.4 forum currently. I've created a custom style (editing style var and a couple of css templates).
    Now, I wanted to use the Articles and Blogs function for the first time and both of them don't work - I think for different reasons. I turned on Debug mode and here's what I got:

    When I write an article and click Post, this appears:

    ## /www/htdocs/w017e434/ Exception Thrown
    #0 /www/htdocs/w017e434/ vB_Library_Node->getNodeBare(0)
    #1 /www/htdocs/w017e434/ vB_Library_Node->getNode(0)
    #2 /www/htdocs/ vB_Api_Content_Text->add(Array, Array)
    #3 /www/htdocs/w017e434/ vB_Api_Wrapper->__call('add', Array)
    #4 /www/htdocs/w017e434/ Api_Interface_Collapsed->callApi('content_text', 'add', Array)
    #5 /www/htdocs/w017e434/ vB5_Frontend_Controller_CreateContent->createNewNode('content_text', Array, Array, Array)
    #6 /www/htdocs/w017e434/ vB5_Frontend_Controller_CreateContent->actionTextNodeInternal('content_text')
    #7 /www/htdocs/w017e434/ vB5_Frontend_Controller_CreateContent->index()
    #8 {main}


    __________________________________________________________________________________________ _______________

    When I want to add a blog, I can't because the Blog modules says:

    An internal error has occurred and the module cannot be displayed. Template: widget_bloghome => conversation_toolbarController: user Method: canCreateBlogEntry Arguments: Array ( [0] => 4 ) Errors:

    Array ( [0] => Error Database error in vBulletin 5.4.0: Invalid SQL: SELECT n.nodeid, n.title FROM closure AS cl INNER JOIN node AS n ON n.nodeid = cl.child INNER JOIN groupintopic AS git ON git.nodeid = n.nodeid WHERE cl.parent = 4 AND git.groupid IN () and git.userid = 1 ORDER BY title /**getGitCanStartThreads**/; MySQL Error : 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 ') and git.userid = 1 ORDER BY title /**getGitCanStartThreads**/' at line 4 Error Number : 1064 Request Date : Monday, April 2nd 2018 @ 10:31:18 AM Error Date : Monday, April 2nd 2018 @ 10:31:18 AM Script : Referrer : IP Address : - Username : Prescott Classname : vB_Database_MySQLi MySQL Version : 5.7.21-nmm1-log [1] => Array ( [0] => exception_trace [1] => ## /www/htdocs/w017e434/ Exception Thrown #0 /www/htdocs/w017e434/ vB_Database->halt() #1 /www/htdocs/w017e434/ vB_Database_MySQLi->execute_query(true, Object(mysqli)) #2 /www/htdocs/w017e434/ vB_Database->query_read('Invalid SQL:\r\nS...') #3 /www/htdocs/w017e434/ vB_dB_Result->rewind() #4 /www/htdocs/w017e434/ vB_dB_Result->__construct(Object(vB_Database_MySQLi), 'SELECT n.nodeid...', false) #5 /www/htdocs/w017e434/ vB_dB_Query_Stored->execSQL() #6 /www/htdocs/w017e434/ vB_dB_Assertor->assertQuery('vBForum:getGitC...', Array, false) #7 /www/htdocs/w017e434/ vB_dB_Assertor->getRows('vBForum:getGitC...', Array) #8 /www/htdocs/w017e434/ vB_Api_User->getGitCanStart('4') #9 /www/htdocs/w017e434/ vB_Api_User->canCreateBlogEntry('4') #10 /www/htdocs/w017e434/ vB_Api_Wrapper->__call('canCreateBlogEn...', Array) #11 /www/htdocs/w017e434/ Api_Interface_Collapsed->callApi('user', 'canCreateBlogEn...', Array, false, true) #12 /www/htdocs/w017e434/ : eval()'d code(261): vB5_Template_Runtime::ParseData('user', 'canCreateBlogEn...', '4') #13 /www/htdocs/w017e434/ eval() #14 /www/htdocs/w017e434/ vB5_Template->render(false) #15 /www/htdocs/w017e434/ vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n...') #16 /www/htdocs/w017e434/ vB5_Template->render(false) #17 /www/htdocs/w017e434/ vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- *** STA...') #18 /www/htdocs/w017e434/ vB5_Template->render(false) #19 /www/htdocs/w017e434/ vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\r\n\r\n...') #20 /www/htdocs/w017e434/ vB5_Template->render(false) #21 /www/htdocs/w017e434/ vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\t\r\n\r...') #22 /www/htdocs/w017e434/ vB5_Template->render(false) #23 /www/htdocs/w017e434/ vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\t\r\n\t\t<me...') #24 /www/htdocs/w017e434/ vB5_Template->render() #25 /www/htdocs/w017e434/ vB5_Frontend_Controller_Page->index(17, '$pagenum', '4', '17') #26 {main} ) )

    I would be grateful if someone could help me!
    Thank you!


  • #2
    What is the vBulletin version?
    What is the php version?

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo


    • #3
      I'm using vBulletin 5.4.0 and PHP 7.0.


      • #4
        If you use any tools like mod_security, make sure it isn't removing any values from the POST variables when submitting forms. You would need to coordinate with your hosting provider or server administrator for this.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.


        • #5
          I contacted my hosting provider and showed them the problem. They told me that there could be something wrong with the database, more specifically the structure / table "closure".
          I didn't do anything to the database.

          What could be my next steps?


          • #6
            Stuck with the same problem for Blogs. Getting the error: "An internal error has occurred and the module cannot be displayed"

            Any help you offer OPrescott, will help me too. Please offer some help here, would appreciate a lot. Thanks.

            OPrescott, I hope I'm not stepping on your toes .. just bumping the discussion since I'm experiencing the same problem with my VB 5.4


            • #7
              And I resolved the problem. It was all in permissions.

              OPrescott, here is what I did:

              Admin Panel > Channel Management > Channel Permissions > Look for BLOGS channel on the right side.

              Since I use my Super Moderator account primarily for doing everything on the forum, I clicked EDIT before Super Moderators. Edited the permissions and allowed ALL for Super Moderators.

              Saved and checked .. problem solved!

              Please let me know if this helped you. Cheers!


              Related Topics