Re: User Registration and Validation is failing HELP- happened the day the site went live
Looking at db/tiki.sql in the Tiki 2.0 download, I see that it does in fact have a column "email_confirm", which the error message says is missing from your database. So it looks like you need to add this. You can use phpMyAdmin to insert the new row
email_confirm int(14) default NULL
in the users_users table. Maybe it would also work to run the tiki-install.php script again, this time using the tiki_1.9to2.0.sql update. This update file can be run repeatedly and won't bother your data or settings, but only make updates to the database structure.
-- Gary