1
someguyiknow
[solved] myalbum. Error

Invalid default value for 'res_x'

Unable to install myalbum. Error(s):

fresh install and no go any suggestions?

2
someguyiknow
Re: myalbum. Error

Nevermind I fixed it not sure if this will cause any problems I don't see why it would , but it did install.


Edited all 4 SQL files included in the download. Works. sorry to bother :)

Before:
le="color: #000000"><?php res_x int(11) NOT NULL default '', res_y int(11) NOT NULL default '',



After:
le="color: #000000"><?php res_x int(11) NOT NULL default '0', res_y int(11) NOT NULL default '0',

3
Richybpqca
Re: [solved] myalbum. Error
  • 2007/12/14 20:25

  • Richybpqca

  • Just popping in

  • Posts: 2

  • Since: 2007/12/13


Your right someguyiknow....it does correct the problem and n it shoukld not affect anything....I had the same error...It is a MySQL 5 change that was made. I presume that this is what is happening. In an SQL statement you could create a table and assign default values of '' into a integer value..well not in version 5...the default value MUST be '0' or it will return an error. I have corrected 4 modules so far just by scanning the .SQL file and replacing the default '' by '0' in all integer values....

Hope this helps all those newbies.