1
barrick
module debaser installation problem
  • 2008/7/24 3:38

  • barrick

  • Just popping in

  • Posts: 1

  • Since: 2008/7/24


I was trying to install debaser 0.92 or 0.92b on my XOOPS site. But it shown me the following error message:

Installing debaser

Invalid default value for 'added'

error: can't install debaser.

Please help. Thank you.

2
frankblack
Re: module debaser installation problem
  • 2008/7/24 7:28

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


Edit the sql-file of debaser. Remove default '' where the field's type is int.

3
jeorem
Re: module debaser installation problem
  • 2008/9/19 7:12

  • jeorem

  • Just popping in

  • Posts: 15

  • Since: 2003/5/25


Quote:

frankblack wrote:
Edit the sql-file of debaser. Remove default '' where the field's type is int.


Hi sir. I have encounter the same problem but I can not really understand what is meant by "Edit the sql-file of debaser. Remove default '' where the field's type is int."

May really sound stupid but am not really a programmer. I am hoping you could enlighten me. Was this the file save on the sql folder name "mysql"? If so, where can I find the thing stated above? I tried using search function but there are just too many values with the word default? and what is meant by "where the field's type is int."???

Thanks a lot in advance and pardon fo a newbie question.

4
maxxy
Re: xoops debaser sql fix
  • 2008/9/19 7:45

  • maxxy

  • Quite a regular

  • Posts: 286

  • Since: 2007/6/11



5
ghia
Re: module debaser installation problem
  • 2008/9/19 7:53

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Look for mysql.sql file in your /modules/debaser/sql/ directory.
Edit this file and remove all
default ''
when it is part of an integer field definition. It is OK when the fieldtype is text.
Eg.
added int(10NOT NULL default '',

=>
added int(10NOT NULL,


Edit: maxxy is first and has the easiest solution.

6
jeorem
Re: module debaser installation problem
  • 2008/9/22 6:39

  • jeorem

  • Just popping in

  • Posts: 15

  • Since: 2003/5/25


thank you so much for the kindness, it is now working...

Login

Who's Online

344 user(s) are online (274 user(s) are browsing Support Forums)


Members: 0


Guests: 344


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