1
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.



2
Richybpqca
Re: Newbie install Question - PHP Notice & Install DMS error (xoops V2.13)
  • 2007/12/14 20:24

  • Richybpqca

  • Just popping in

  • Posts: 2

  • Since: 2007/12/13


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.




TopTop



Login

Who's Online

171 user(s) are online (95 user(s) are browsing Support Forums)


Members: 0


Guests: 171


more...

Donat-O-Meter

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

Latest GitHub Commits