In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

View Revisions: Issue #1226		[ All Revisions ] [ Back to Issue ]
Summary	0001226: Storing function "crc32" results in database problem

Revision	2012-03-27 06:45:43 by alex
Additional Information	We have 54 places, where crc32 function is used (across all modules) and each place needs to be inspected. How to perform conversion in MySQL: ----------------------------------- ALTER TABLE TableName CHANGE FieldName FieldName BIGINT(11) NOT NULL DEFAULT '0'; UPDATE TableName SET FieldName = CAST((FieldName & 0xFFFFFFFF) AS UNSIGNED INTEGER) WHERE FieldName < 0;

Revision	2012-03-14 12:31:01 by alex
Additional Information	We have 54 places, where crc32 function is used (across all modules) and each place needs to be inspected.