2012-09-07, 12:23 AM
I used users.timeonline for find out the users whoes timeonline < 1min and used user search to find those users and delete them.
Anyway there are not many users (around 200) and when I deleted about 50 users, further user search or user group list will cause internal sql error:
MyBB has experienced an internal SQL error and cannot continue.
I did several database dump during the deleting and noticed a funny thing: you delete more records, the dump file gets bigger!
Anyway, how do I trouble shooting this?
Thanks for your help
Cannot think of anything in mybb side, I upgraded mysql from 5.1.9 to 5.1.65.... So far so good
What's the version of MySQL most people used for mybb 1.6?
Anyway there are not many users (around 200) and when I deleted about 50 users, further user search or user group list will cause internal sql error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1406 - Data too long for column 'data' at row 1
Query:
UPDATE m_adminsessions SET `data`='a:3:{s:14:\"last_users_url\";s:33:\"index.php?module=user-users&vid=2\";s:10:\"user_views\";a:85:{s:32:\"9925cf7b0add24e7d570825a5847952c\";a:12:{s:3:\"uid\";s:1:\"1\";s:5:\"title\";s:13:\"not activated\";s:4:\"type\";s:4:\"user\";s:10:\"visibility\";s:1:\"1\";s:6:\"fields\";a:7:{i:0;s:8:\"username\";i:1;s:5:\"email\";i:2;s:7:\"regdate\";i:3;s:10:\"lastactive\";i:4;s:7:\"postnum\";i:5;s:5:\"regip\";i:6;s:8:\"controls\";}s:10:\"conditions\";a:1:{s:9:\"usergroup\";s:1:\"2\";}s:21:\"custom_profile_fields\";b:0;s:6:\"sortby\";s:10:\"reputation\";s:9:\"sortorder\";s:3:\"asc\";s:7:\"perpage\";s:2:\"20\";s:9:\"view_type\";s:5:\"table\";s:3:\"url\";s:27:\"index.php?module=user-users\";}s:32:\"05736527ee8a3bc1448c8d23bb2ce3e1\";a:12:{s:3:\"uid\";s:1:\"1\";s:5:\"title\";s:13:\"not activated\";s:4:\"type\";s:4:\"user\";s:10:\"visibility\";s:1:\"1\";s:6:\"fields\";a:7:{i:0;s:8:\"username\";i:1;s:5:\"email\";i:2;s:7:\"regdate\";i:3;s:10:\"lastactive\";i:4;s:7:\"postnum\";i:5;s:5:\"regip\";i:6;s:8:\"controls\";}s:10:\"conditions\";a:15:{s:8:\"username\";s:9:\"Unollassy\";s:5:\"email\";s:0:\"\";s:7:\"website\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:9:\"usertitle\";s:0:\"\";s:11:\"postnum_dir\";s:12:\"greater_than\";s:7:\"postnum\";s:0:\"\";s:7:\"regdate\";s:0:\"\";s:5:\"regip\";s:0:\"\";s:6:\"lastip\";s:0:\"\";s:6:\"postip\";s:0:\"\";}s:21:\"custom_profile_fields\";a:3:{s:4:\"fid3\";a:1:{s:4:\"fid3\";s:3:\"N/A\";}s:4:\"fid1\";s:0:\"\";s:4:\"fid2\";s:0:\"\";}s:6:\"sortby\";s:8:\"username\";s:9:\"sortorder\";s:3:\"asc\";s:7:\"perpage\";s:2:\"20\";s:9:\"view_type\";s:4:\"card\";s:3:\"url\";s:27:\"index.php?module=user-users\";}s:32:\"0c29d2df3519d72ec67f22a3d23099f8\";a:12:{s:3:\"uid\";s:1:\"1\";s:5:\"title\";s:13:\"not activated\";s:4:\"type\";s:4:\"user\";s:10:\"visibility\";s:1:\"1\";s:6:\"fields\";a:7:{i:0;s:8:\"username\";i:1;s:5:\"email\";i:2;s:7:\"regdate\";i:3;s:10:\"lastactive\";i:4;s:7:\"postnum\";i:5;s:5:\"regip\";i:6;s:8:\"controls\";}s:10:\"conditions\";a:1:{s:9:\"usergroup\";s:1:\"2\";}s:21:
I did several database dump during the deleting and noticed a funny thing: you delete more records, the dump file gets bigger!
Anyway, how do I trouble shooting this?
Thanks for your help
Cannot think of anything in mybb side, I upgraded mysql from 5.1.9 to 5.1.65.... So far so good
What's the version of MySQL most people used for mybb 1.6?