1
cotros
Membership module probs
  • 2007/1/26 12:58

  • cotros

  • Just popping in

  • Posts: 11

  • Since: 2007/1/23


Im installing the module on XOOPS 2.0.15 and im getting the error below
-------------
Installing Membership

Invalid default value for 'time_changed'

Unable to install membership. Error(s):
-------------

any ideas why?

2
bumpe
Re: Membership module probs
  • 2007/2/3 13:05

  • bumpe

  • Just popping in

  • Posts: 40

  • Since: 2005/5/31


I have the same problem
Quote:

cotros wrote:
Im installing the module on XOOPS 2.0.15 and im getting the error below
-------------
Installing Membership

Invalid default value for 'time_changed'

Unable to install membership. Error(s):
-------------

any ideas why?


Can someone help please.

3
Sven71
Re: Membership module probs
  • 2007/4/7 3:29

  • Sven71

  • Just popping in

  • Posts: 3

  • Since: 2006/6/25


This issue is caused by changes in SQL syntax. The module file affected is membership/sql/mysql.sql

If you open this one in a text editor you will find a line close to the lower end of the page which says:


time_changed timestamp NOT NULL default 'NOW()',


Due to the syntax of my server's MySQL I had to change that into

time_changed timestamp NOT NULL default CURRENT_TIMESTAMP,


The changes are:

1.) NOW() changed to CURRENT_TIMESTAMP
2.) the apostrophes in 'NOW()' are gone. Just CURRENT_TIMESTAMP

It worked for me. If it won't work for you and you have a quality service provider you should find a MySQL manual inside the webadmin area. Look up the correct syntax for timestamp settings.

4
bumpe
Re: Membership module probs
  • 2007/4/9 3:07

  • bumpe

  • Just popping in

  • Posts: 40

  • Since: 2005/5/31


Sven "Module Membership installed successfully" Thanks for the line, it has worked greatly.

5
macmend
Re: Membership module probs
  • 2008/5/20 9:13

  • macmend

  • Quite a regular

  • Posts: 285

  • Since: 2004/2/27


I think this module does not work with recent versions of mysql, it needs some rewriting
Free Mac Support

Ordinary Wisdom

apache server with php sshexec turned on
xoops version 2.0.18.1 & 2.3.1
php version 5.2.5
mysql version 5.0.45

Login

Who's Online

72 user(s) are online (45 user(s) are browsing Support Forums)


Members: 0


Guests: 72


more...

Donat-O-Meter

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

Latest GitHub Commits