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:
res_x int(11NOT NULL default '',
res_y int(11NOT NULL default '',



After:
res_x int(11NOT NULL default '0',
res_y int(11NOT 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.

Login

Who's Online

332 user(s) are online (251 user(s) are browsing Support Forums)


Members: 0


Guests: 332


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits