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

Posts from previous Beta sessions

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

Postby 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.
Last edited by AnthonyB on Sun Jan 27, 2008 4:55 pm, edited 2 times in total.
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

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

Postby 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.
Last edited by AnthonyB on Sun Jan 27, 2008 2:04 pm, edited 1 time in total.
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

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

Postby zanix » Sun Jan 27, 2008 2:12 pm

I can't duplicate this error
The install works for me
CP updates work for me
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

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

Postby 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.
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

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

Postby 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
Last edited by zanix on Sun Jan 27, 2008 5:07 pm, edited 1 time in total.
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

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

Postby 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.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm


Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests