Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » User Registration and Validation is failing HELP- happened the day the site went live
 
Thread actions
PDF Print this page
  • Print all pages

    • User Registration and Validation is failing HELP- happened the day the site went live

    Posted by ozgenie posts: 6

    When a user trys to register they get the error message shown at the bottom of this post. Also Admin verification is failing because of this. Have turned off Verify by admin but registrations still failing. Can anyone help as the site has just gone live and no one is able to register. see http://convict.historyaustralia.org.au

    Message that users attempting to register see is:


    An error occured in a database query!

    Context:
    File tiki-register.php
    Url tiki-register.php
    Query:
    insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values(?,?,?,?,?,?,?,?,?,?,?,?,?)
    Values:
    0 ScottB
    1 pholoc71
    2 ozgenie@optusnet.com.au
    3
    4 1220797283
    5 $1$06A424ET$hNdycii7ewVSNpbtCeLIK0
    6 1220797283
    7 1220797283
    8 1220797283
    9 pholoc71
    10
    11 NULL
    12 NULL
    Message:
    Unknown column 'email_confirm' in 'field list'
    Built query was probably:
    insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values('ScottB','pholoc71','ozgenie@optusnet.com.au',,'1220797283','$1$06A424ET$hNdycii7ewVSNpbtCeLIK0','1220797283','1220797283','1220797283','pholoc71',,NULL,NULL)

    Reads: 1069
    Link
    Posted by Gary Cunningham-Lee posts: 4656 Japan

    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

    Link

    Posted by Geoff Brickell posts: 838 United Kingdom

    I think there may be a bug in the upgrade install procedure - I've upgraded several sites over the last couple of weeks and I just tripped over this same problem today.

    For a fresh/new install the email_confirm field is correctly set up in the users_users table but in all the upgrades I did it was missing - so I got the same errors when trying to add a new user for the first time today. I'm pretty sure I did the double run of the install correctly since everything else is fine.

    Manually adding the missing field with phpMyAdmin does fix it however.

    I've already posted this as a possible bug to the dev Tracker.

    geoff

    Link