[1601] 1406: Data too long for column 'flow' at row 1

by **AnthonyB** » Sun Jan 27, 2008 12:55 pm

Just updated from 1595 to 1601 and on doing the Keys addon upgrade got the following error:

Database Error1406: Data too long for column 'flow' at row 1
SQL:
INSERT INTO `roster_addons_keys_stages` VALUES ( 'H','Onyxia',8,'Q','The Test of Skulls, Scryer',1,'SINGLE',0);
File: lib\dbal\mysql.php
Line: 228
Backtrace (most recent call last):
lib\functions.lib.php
Line: 240
Function Called: backtrace
lib\dbal\mysql.php
Line: 228
Function Called: die_quietly
Arguments:
1406: Data too long for column 'flow' at row 1
Database Error
C:\Inetpub\wwwroot\roster2\lib\dbal\mysql.php
228
INSERT INTO `roster_addons_keys_stages` VALUES ( 'H','Onyxia',8,'Q','The Test of Skulls, Scryer',1,'SINGLE',0);
lib\install.lib.php
Line: 271
Function Called: query
Arguments:
INSERT INTO `roster_addons_keys_stages` VALUES ( 'H','Onyxia',8,'Q','The Test of Skulls, Scryer',1,'SINGLE',0);
admin\addon_install.php
Line: 514
Function Called: install
admin\addon_install.php
Line: 46
Function Called: processAddon
pages\rostercp.php
Line: 118
Function Called: require_once
Arguments:
C:\Inetpub\wwwroot\roster2\admin\addon_install.php
index.php
Line: 83
Function Called: require
Arguments:
C:\Inetpub\wwwroot\roster2\pages\rostercp.php

When I go to the Keys page I now get the following error:

PHP Errorsaddons\memberslist\inc\memberslist.php
Notice line 236: Undefined index: display

The 'flow' field in my 'roster_addons_keys_stages' table is set to type char(2).

I've uninstalled the addon, verified the tables are removed, and re-installed the addon but get the same error.

by **AnthonyB** » Sun Jan 27, 2008 2:00 pm

Problem is in \addons\keys\locale\install_enUS.php
Lines 242-244

Code: Select all: 'Q|The Test of Skulls, Scryer|1|SINGLE|', 'Q|The Test of Skulls, Somnus|1|SINGLE|', 'Q|The Test of Skulls, Chronalis|1|SINGLE|',

The word SINGLE does not adhere to the rule of the flow field being either ( or ) or () ... although there appears to be other values used such as LP they stick to the 2 char Database field defined limit.

Changing those lines to

Code: Select all: 'Q|The Test of Skulls, Scryer|1||', 'Q|The Test of Skulls, Somnus|1||', 'Q|The Test of Skulls, Chronalis|1||',

allow install to complete and data to display without errors. Not sure what other implications there might be but with the limited data I had to test (i.e.1 toon) I'm not seeing any display issues.

by **zanix** » Sun Jan 27, 2008 2:12 pm

I can't duplicate this error
The install works for me
CP updates work for me

by **AnthonyB** » Sun Jan 27, 2008 4:29 pm

Weird.

Bottom line is that theoretically it should not work for the single fact that the database field that the value 'SINGLE' is being loaded into is a char(2) as defined in \addons\keys\inc\install.def.php
Line 82

Code: Select all: `flow` char(2) NOT NULL DEFAULT '',

Unless I'm missing something, that just can't work and the error I'm getting is expected.

Not sure why you can't replicate.

by **zanix** » Sun Jan 27, 2008 5:07 pm

Yeah, very weird

This is my server info
PHP Version: 5.2.3
MySQLi Version: 5.0.45
Apache 2.2.4

by **PleegWat** » Sun Jan 27, 2008 8:11 pm

I did change the syntax somewhat when I moved the defines to the DB. It didn't error for me (probably silently truncated), and I didn't notice I missed those.

Fixed SVN 1602.