Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Ready to contribute?

Amazing! Sign our contributors' agreement and then join us on GitHub.

Vanilla is proud to present version 2.2.
Please upgrade to 2.1.x here. The 2.0 branch is no longer being updated.

Can't create categories.

edited February 2012 in Vanilla 2.0 Help

Just did a fresh clean install of Vanilla, but am having trouble creating categories... as a matter of fact, I can't create any! It just returns the "Bonk" error. All I've been able to do is edit the default general discussion category.

Everything else is working well. Any pointers as to what is causing this?

Best Answer


  • x00x00 MVP
    edited February 2012

    we can give pointers without the error.


    $Configuration['Garden']['Debug'] = TRUE;
    $Configuration['Garden']['Errors']['MasterView'] = 'derror.master.php';

    in config

    grep is your friend.

  • Thank you for that tip! Here is the out of adding a new category:

    Duplicate entry '2147483647' for key 'PRIMARY'

    insert GDN_Category (UrlCode, AllowDiscussions, Name, Description, InsertUserID, UpdateUserID, DateInserted, DateUpdated) values (:UrlCode, :AllowDiscussions, :Name, :Description, :InsertUserID, :UpdateUserID, :DateInserted, :DateUpdated)
    The error occurred on or near: /html/forums/library/database/class.database.php

    276: if (!is_object($PDOStatement)) {
    277: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
    278: } else if ($PDOStatement->execute($InputParameters) === FALSE) {
    279: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
    280: }
    281: } else {
    282: $PDOStatement = $this->Connection()->query($Sql);
    283: }

  • x00x00 MVP
    edited February 2012 Answer ✓

    Ah the root category is -1, some version of mysql screw up the auto increment.


    grep is your friend.

  • Thank you, I will follow that process.

Sign In or Register to comment.