Page 1 of 1

Another problem

Posted: Thu Jan 31, 2008 9:39 pm
by Poufe
everything seemed to update fine except
[Error] Error in updating tables query '
CREATE TABLE variables (
variable_name varchar(64) NOT NULL default '',
variable_value varchar(256) NOT NULL default ''
) TYPE=MyISAM': #1074: Column length too big for column 'variable_value' (max =
255); use BLOB or TEXT instead
[Error] Attempting to update database table 'variables' ... FAILED!
[Error] Error in updating tables query 'replace into variables (variable_name,va
riable_value) values('mingamefullstatus','100')': #1146: Table 'bennette_eq2.va
riables' doesn't exist
any ideas?

Posted: Fri Feb 01, 2008 5:32 am
by LethalEncounter
You must be running an older version of mysql. Anyways, the difference between 256 and 255 isnt much so I'll go ahead and change it to 255.