Geeklog Forums

One of the easier migration that I've done, however the only remaining issue I have having is trying to create new users as noted below. I can edit existing users but can create new ones. I tried turning PEAR = True then PEAR = False and restarted server but have same issue.

1364: Field 'passwd' doesn't have a default value. SQL in question: INSERT INTO gl_users (username,email,regdate,cookietimeout)
VALUES ('leec','leec@somedomain.com','2009-01-24 08:03:22','28800'

Thanks

Lee

That doesn't really have anything to do with PEAR ...

The passwd field should have '' (i.e. an empty string) as the default. From the table definition:
See if you can fix that in phpMyAdmin.

bye, Dirk

Which table is that?

gl_users

Dirk,
Thanks for your patience, I found the table and entry. i compared it to another one of my sites that doesn't have a problem and looks like you're spot on with your solution. However I'm user MySQL Administrator, there are 7 columns: Column Name, Datatype, Not Null, Auto Inc, Flags, Default Value and Comment.
The 6th column Default Value is Null, however on the table editor you can make a manual entry or to the right is a NULL button that you click. Thinking that perhaps if you click an already set NULL value that it might reset it but it didn't work.

Thanks

To MySQL, NULL and an empty string are not the same thing. Try entering something into that field, then remove what you typed again (so it's empty) and save your change. That should do the trick.

bye, Dirk

It automatically puts the NULL back in when I remove the number. Tried it again, put 0 in then tried to empty the field and it is putting 0 back into the field?

Actually, since the field is supposed to be "NOT NULL" you also need to change that. And then you should be able to set a default value.

bye, Dirk

Sorry, I'm not following can you give me more details? :shock:

I meant changing the "NULL / NOT NULL" option to NOT NULL first, then try to enter an empty default value.

bye, Dirk