table moderator_logs, column 'action' is too small > Invisionize.eu

I Receive the following error when trying to perform moderation on a topic (in this case deleting a large number of topics). The action column on the moderator_logs table is only a varchar 128. In the mySQL version, its a text field. Seems like it should be increased to a varchar(max) or something larger than 128 at least.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 23 Dec 2010 04:48:47 +0000
Error: 3621 - [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.

IP Address: xx.xxx.x.xxx - /forums/index.php?app=forums&module=moderate§ion=moderate
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MSSQL query error:
INSERT INTO moderator_logs (forum_id,topic_id,post_id,member_id,member_name,ip_address,http_referer,ctime,topic_title,action,query_string) VALUES('43','0','0','6','eyelleye','24.237.7.245','http://www.mistyair.net/forums/index.php?','1293079727','','Deleted topics (IDs: 1413,1412,1411,1410,1409,1408,1407,1406,1405,1404,1403,1402,1401,1400,1399,1398,1397,1396,1395,1394,1393,1392,1391,1390,1389,1388,1387,1386,1385,1384 )','app=forums&module=moderate&section=moderate')
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| E:\web\mistyairnet\htdocs\forums\ips_kernel\classDb.php | [db_driver_mssql].query | 1187 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications\forums\sources\classes\moderate.php| [db_driver_mssql].insert | 2135 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications\forums\modules_public\moderate\moderate.php| [moderatorLibrary].addModerateLog | 3902 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications\forums\modules_public\moderate\moderate.php| [public_forums_moderate_moderate]._addModeratorLog | 3404 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications\forums\modules_public\moderate\moderate.php| [public_forums_moderate_moderate]._multiAlterTopics | 3138 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications\forums\modules_public\moderate\moderate.php| [public_forums_moderate_moderate]._multiTopicModify | 209 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\sources\base\ipsController.php | [public_forums_moderate_moderate].doExecute | 285 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

table moderator_logs, column 'action' is too small

Komentarze:

Brak komentarzy