群不能保存

zhj265

自建的群和管理端设置的群都不能保存，重新登录后，丢失。还很难找到。查找界面里看不到任何群！急需解决！

admin

是不是你的数据库有问题，这个最好带上服务器端的日志信息，才能精确判断

zhj265

好像是数据库的问题，帮忙看看吧！
2013-01-17 00:13:52 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'ClusterID' 无效。) !
2013-01-17 00:13:55 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:13:59 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:01 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:02 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:08 [ E ]:  {3668}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:16 [ E ]:  {1560}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:16 [ E ]:  {1560}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:16 [ E ]:  {1560}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:16 [ E ]:  {1560}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'NickName' 无效。) !
2013-01-17 00:14:23 [ E ]:  {4172}io-server ( PortalServer ) wait sock ( 7888177342885926592 ) for event has error3 ( 64 ) !
2013-01-17 00:14:39 [ I ]:  {4268}user ( id : 131, token : 1836661002, state : confirm ) logon has succesful!
2013-01-17 00:14:39 [ I ]:  {3024}user ( id : 131 , ip : 192.168.0.22, port : 32749) has logon message-media-server successful!
2013-01-17 00:14:39 [ E ]:  {2956}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 00:14:39 [ I ]:  {2016}user ( 131 ) has enter cluster ( id : 16540662, name : dvdv )!
2013-01-17 00:17:28 [ I ]:  {3356}user ( 131 ) has been exit cluster ( id : 16540662, name : dvdv )!
2013-01-17 00:17:28 [ I ]:  {608}user ( 131 ) has been logoff and message-service report to center!
2013-01-17 00:17:28 [ I ]:  {5680}user ( 131 ) has logoff!
2013-01-17 00:32:12 [ I ]:  {4972}user ( 131 ) has been recycled!
2013-01-17 07:34:29 [ I ]:  {1836}user ( id : 508, token : 1863049987, state : confirm ) logon has succesful!
2013-01-17 07:34:29 [ I ]:  {3024}user ( id : 508 , ip : 192.168.1.87, port : 1033) has logon message-media-server successful!
2013-01-17 07:34:30 [ E ]:  {1836}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:40:40 [ I ]:  {4824}user ( id : 130, token : 1863421143, state : confirm ) logon has succesful!
2013-01-17 07:40:40 [ I ]:  {3024}user ( id : 130 , ip : 192.168.1.49, port : 1047) has logon message-media-server successful!
2013-01-17 07:40:40 [ E ]:  {4824}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:49:33 [ I ]:  {380}user ( id : 274, token : 1863953752, state : confirm ) logon has succesful!
2013-01-17 07:49:33 [ I ]:  {3024}user ( id : 274 , ip : 10.216.212.227, port : 1154) has logon message-media-server successful!
2013-01-17 07:49:33 [ E ]:  {4052}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:50:28 [ I ]:  {1964}user ( id : 215, token : 1864009283, state : confirm ) logon has succesful!
2013-01-17 07:50:28 [ I ]:  {3024}user ( id : 215 , ip : 192.168.1.78, port : 1041) has logon message-media-server successful!
2013-01-17 07:50:28 [ E ]:  {2672}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:51:57 [ I ]:  {4684}user ( id : 264, token : 1864098143, state : confirm ) logon has succesful!
2013-01-17 07:51:57 [ I ]:  {3024}user ( id : 264 , ip : 192.168.1.84, port : 1036) has logon message-media-server successful!
2013-01-17 07:51:57 [ E ]:  {4080}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:54:40 [ I ]:  {520}user ( id : 221, token : 1864260752, state : confirm ) logon has succesful!
2013-01-17 07:54:40 [ I ]:  {3024}user ( id : 221 , ip : 192.168.1.88, port : 1040) has logon message-media-server successful!
2013-01-17 07:54:40 [ E ]:  {1576}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:54:40 [ E ]:  {608}io-server ( MessageTServer ) wait sock ( 8005620406096497784 ) for event has error3 ( 64 ) !
2013-01-17 07:54:40 [ I ]:  {3248}user ( 274 ) has been logoff and message-service report to center!
2013-01-17 07:54:40 [ I ]:  {520}center service has recv notify about user ( 274 ) logoof, but not find user!
2013-01-17 07:54:40 [ I ]:  {608}user ( 274 ) has been logoff and message-service report to center!
2013-01-17 07:54:40 [ I ]:  {1576}user ( 274 ) has logoff!
2013-01-17 07:55:01 [ I ]:  {520}user ( id : 259, token : 1864281643, state : confirm ) logon has succesful!
2013-01-17 07:55:01 [ I ]:  {3024}user ( id : 259 , ip : 10.216.212.200, port : 1068) has logon message-media-server successful!
2013-01-17 07:55:01 [ E ]:  {520}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:55:53 [ I ]:  {1576}user ( id : 124, token : 1864333924, state : confirm ) logon has succesful!
2013-01-17 07:55:53 [ I ]:  {3024}user ( id : 124 , ip : 192.168.1.93, port : 2620) has logon message-media-server successful!
2013-01-17 07:55:53 [ E ]:  {520}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:56:56 [ I ]:  {4840}user ( id : 249, token : 1864397205, state : confirm ) logon has succesful!
2013-01-17 07:56:56 [ I ]:  {3024}user ( id : 249 , ip : 10.216.212.201, port : 1074) has logon message-media-server successful!
2013-01-17 07:56:56 [ E ]:  {224}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:57:24 [ I ]:  {224}user ( id : 409, token : 1864424877, state : confirm ) logon has succesful!
2013-01-17 07:57:24 [ I ]:  {3024}user ( id : 409 , ip : 192.168.1.53, port : 2479) has logon message-media-server successful!
2013-01-17 07:57:24 [ E ]:  {484}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:58:07 [ I ]:  {484}user ( id : 207, token : 1864467533, state : confirm ) logon has succesful!
2013-01-17 07:58:07 [ I ]:  {3024}user ( id : 207 , ip : 10.216.212.220, port : 1062) has logon message-media-server successful!
2013-01-17 07:58:07 [ E ]:  {5008}ado-session execute sql has been failed([Microsoft][ODBC SQL Server Driver][SQL Server]列名 'UserID' 无效。) !
2013-01-17 07:58:35 [ I ]:  {2816}user ( id : 206, token : 1864495674, state : confirm ) logon has succesful!
2013-01-17 07:58:35 [ I ]:  {3024}user ( id : 206 , ip : 192.168.1.212, port : 1071) has logon message-media-server successful!

angelinair

我的也是这个问题

zhj265

备份数据库,重新建数据库运行SQL,导入备份数据.好了.