XF 1.3 Mysqli statement execute error - preventing me from doing many operations

[jflory7]

Hello XenForo forums,

Today, I encountered a strange issue with my XenForo installation.

I was trying to rebuild my user cache and ran into this error. Thinking it was related to an add-on I was using, I tried disabling the add-on and received this error. I then tried disabling other add-ons and received similar results.

To say the least, I am a little confused. To begin, I've done a little diagnostic information on my end. Thinking there may be a corrupt MySQL table, I tried checking, repairing, and optimizing my MySQL database for XenForo by following this guide. This is the exact command I ran:

# mysqlcheck -u root -p --auto-repair -c -o xenforo

However, this did not seem to solve the problem.

The next thing I tried was restarting the MySQL server, but that also did not help any.

I am quite confused… any help would be very appreciated!

- jflory7

 

[Mike]

It looks like you may have some invalid/corrupt data in the DB. It's likely related to the secondary_group_ids column in xf_user. You'd really need to find the invalid value and remove it. You might be able to get away with identifying the user and then editing them via the control panel.

Have you imported? If so, from what and using what importer?

 

[jflory7]

It looks like you may have some invalid/corrupt data in the DB. It's likely related to the secondary_group_ids column in xf_user. You'd really need to find the invalid value and remove it. You might be able to get away with identifying the user and then editing them via the control panel.

Have you imported? If so, from what and using what importer?

I haven't ever imported any data – this is a fresh installation.

As for the invalid data, I use this add-on by @KoolKrafter which adds a new column called 'uuid' to the xf_user table. This is probably the issue, isn't it?

 

[jflory7]

I tried running this command in my XenForo MySQL database.

mysql> ALTER TABLE 'xf_user' DROP 'uuid';

After that, I tried doing some of the tasks from before to the same result.

Server Error
Mysqli statement execute error : Out of range value for column 'user_group_id' at row 2

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in XenForo/DataWriter/User.php at line 1076
4. XenForo_DataWriter_User->rebuildUserGroupRelations() in XenForo/Deferred/User.php at line 38
5. XenForo_Deferred_User->execute() in XenForo/Model/Deferred.php at line 256
6. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
7. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 335
8. XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
9. XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 347
10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
11. XenForo_FrontController->run() in /var/www/html/admin.php at line 13

Any ideas?

 

[Mike]

Please submit a ticket with phpMyAdmin and ACP access details and I'll look into it.

 

[jflory7]

Please submit a ticket with phpMyAdmin and ACP access details and I'll look into it.

Ticket submitted. Thanks.

 

[KoolKrafter]

I tried running this command in my XenForo MySQL database.

mysql> ALTER TABLE 'xf_user' DROP 'uuid';

After that, I tried doing some of the tasks from before to the same result.

Any ideas?

Sorry for the delayed response, but I don't see why my extra column would cause that problem.. did you get it fixed?

 

[Paul B]

The problem was due to corrupt data in the secondary_group_ids in the database.

An add-on was most likely the culprit although it wasn't confirmed which one.

 

[KoolKrafter]

The problem was due to corrupt data in the secondary_group_ids in the database.

An add-on was most likely the culprit although it wasn't confirmed which one.

Okay. I'm glad it could be resolved

 

[jflory7]

The problem was due to corrupt data in the secondary_group_ids in the database.

An add-on was most likely the culprit although it wasn't confirmed which one.

The problem was a Minecraft plugin that interacted with the XenForo MySQL database, and it turns out that it forgot to properly add a comma for the secondary user IDs. The problem was in no way related to @KoolKrafter's add-on or any add-on that I've used from the XF Resources section. As of the writing of this post, the developer has posted a fix for the plugin as well, so hopefully this will not happen to any other users.

If the issue ever occurs for any others, the plugin's name is "CommunityBridge".