XF 2.0 Can't add a Thread Prefix

[FedericoS]

Hello everyone! A few moment ago, when I try to add a thread prefix, it show me this error:

Spoiler: Log

XF\Db\DuplicateKeyException: MySQL query error [1048]: Column 'prefix_id' cannot be null in src/XF/Db/AbstractStatement.php at line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 160
5. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1403
6. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1135
7. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
8. XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 159
9. XF\Mvc\FormAction->run() in src/XF/Admin/Controller/AbstractPrefix.php at line 126
10. XF\Admin\Controller\AbstractPrefix->actionSave() in src/XF/Mvc/Dispatcher.php at line 249
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
14. XF\App->run() in src/XF.php at line 329
15. XF::runApp() in admin.php at line 13

How can I solve? Thanks

 

[Ozzy47]

What MySQL version are you running?

 

[FedericoS]

I'm using the 5.5.5 version. I have deleted the table "prefix_id" because when I did create a Thread prefix, it did shown with a different name.

Example: Request (Name typed in the box) > Closed (Name shown)

 

[Ozzy47]

Why would you delete a table in the DB?

 

[FedericoS]

I didn't know other way to solve it (I am beginner in XenForo)
I have re-created it, but it give me the same error.

 

[Ozzy47]

What exactly did you do to recreate it?

 

[FedericoS]

I simply created a table with the same name

 

[Ozzy47]

Simply creating a table is Not the way to do it. I would start by restoring your backup before you started messing around in the DB.

 

[FedericoS]

Is there a way to solve it?

 

[FedericoS]

I solved restoring my old database backup. Thanks

 

[Ozzy47]

That's good, that is what I suggested .

 

[TPerry]

And manually manipulating the database is STRONGLY advised against doing. There are many interactions between the different tables that can be broken by dropping one and then the only solution is normally restoring from a backup - which many fail to make before messing with the DB.