MODS.DB9.DK

[Clark]

Hi

I didn't run gender_db_update.php before uploading the new files... Now it is returning error messages everywhere. I restored the old files to make it work for users. But how can I fix the database? I don't want to restore my weekly db either... Please help me...
The forum is
http://www.studentbbs.co.uk
Version of phpbb: 2.17
version of the mod: gender_1.2.6em
Thanks in advance
Clark

[Beeveer]

Execute the following in phpMyAdmin:

Code: Select all

ALTER TABLE phpbb_users ADD user_gender TINYINT not null DEFAULT "0";

Eventually, replace phpbb_ with your own prefix.

[Clark]

Execute the following in phpMyAdmin:

Code: Select all

ALTER TABLE phpbb_users ADD user_gender TINYINT not null DEFAULT "0";

Eventually, replace phpbb_ with your own prefix.

Hi thanks for your help!
But didn't update file already run this line? If I execute this line and then upload all mods file,s will my forum get to work?

[Beeveer]

You can try it again, It doesn't matter, the only error you can get is good, not bad.

Ah, I see you forum is working again!

[Clark]

Is there anyway to undo

ALTER TABLE phpbb_users ADD user_gender TINYINT not null DEFAULT "0";

because I decided to not keep this mod any more, and wished to restore my db to normality.
Also at http://www.studentbbs.co.uk/profile.php ... rofile&u=2
there is an extra : on the right hand side. How can I delete it? Thanks guys.