...and now I can't see my list of users. I am thinking I could simply upgrade, and that column will be put back on MyPHPAdmin...won't it? Please advise.
2.5.1 I deleted the column for "city" in mdl_user on MyPHPAdmin...
Re: 2.5.1 I deleted the column for "city" in mdl_user on MyPHPAdmin...
No it won't.
Try...
ALTER TABLE ADD city varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' AFTER address;
I'm not going to ask why you deleted it - it's a required field for users in Moodle
Re: 2.5.1 I deleted the column for "city" in mdl_user on MyPHPAdmin...
Hi Wendi,
As you want the field to be optional, I would do either of the following (assuming that the table prefix is mdl and that the collation is utf8_unicode_ci):
1. Allow null values
ALTER TABLE mdl_user ADD city VARCHAR(120) NULL CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER address;
2. Do not allow null values but assign a default value (e.g. the one used in the location settings)
ALTER TABLE mdl_user ADD city VARCHAR(120) NOT NULL DEFAULT 'Default_City_Value' CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER address;
If I were doing this, I would go with the second option.
Re: 2.5.1 I deleted the column for "city" in mdl_user on MyPHPAdmin...
Thank you both! I deleted it in a hopeful attempt to get rid of the required field "City" on the signup sheet. I am an amateur...very much so. I have "tweaked" one other website I had built not quite a year ago...that is my whole experience with techy stuff. :D
Re: 2.5.1 I deleted the column for "city" in mdl_user on MyPHPAdmin...
Thanks! I think I did it right...if not, I will be groveling once again... ;)
(about 30 minutes later...)
Yep, seemed to work great! Thank you!!! :D