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

177 user(s) are online (84 user(s) are browsing Support Forums)


Members: 0


Guests: 177


more...

Donat-O-Meter

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

Latest GitHub Commits