google-code-export / glossword

Automatically exported from code.google.com/p/glossword
0 stars 0 forks source link

Import error #181

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
= What steps will reproduce the problem?
1. Importing terms

= What is the expected output? What do you see instead?
Error: MySQL Error 1264 (Out of range value for column crc32u ...

= What version of the product are you using?
Server type: MySQL
Server version: 5.6.13 
Web server
Apache

= Please provide any additional information below.
Solution:
Find in file /inc/query_storage_global-mysql410.php 
row 587 
`crc32u` int(10) NOT NULL default '0',
and replace it with
`crc32u` bigint(10) NOT NULL default '0',

If datatable is already created, go to MySQL account and find dictionary table 
(gw_dic_...)and select Structure command then row crc32u and select Change. 
Select Type BIGINT instead of INT.
Repeat it with table gw_history_terms.

Original issue reported on code.google.com by tanav...@gmail.com on 31 Oct 2014 at 11:50