Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Problem registering new users

    Posted by ifrad88

    Hi,

    I recently upgraded to 3.2. I'm facing a problem in terms of letting new users register themselves on my wiki. Whenever someone registers (using a username, password and email) they receive the following error message:


    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 newmember1
    2 ii...@cl...
    3
    4 1256760009
    5 $1$ozQhJmyZ$qCHvnQPjbXMom9D2kyXgT0
    6 1256760009
    7 1256760009
    8 1256760009
    9 lelele
    10
    11 NULL
    12 NULL
    Message:
    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('newmember1',,'ii...@cl...',,'1256760009','$1$ozQhJmyZ$qCHvnQPjbXMom9D2kyXgT0','1256760009','1256760009','1256760009','lelele','',NULL,NULL)


    It was initially said that this is a bug that is solved in all TikiWiki versions from 2.0 onwards... however I'm still facing this problem with 3.2. Any ideas?

    Reads: 6617
    Posted by Xavier de Pedro

    Try installing in local a brand new tiki 3.2, and compare the mysql table users_users (columns, etc.) with the one in your server. There is something different for sure in your upgraded db (maybe you were missing some step in a previous upgrade process or some problem occurred). But normal upgrades from 2.latest work fine (I've done several in different servers without that issue at all)

    That could be easy and fast to fix with some patience using phpmyadmin or similar to compare both tables and fix the wrong one.
    Or you can request help to one of the Consultants to do it for you if you don't wat to do it yourself.
    HTH


    Posted by gmw

    I just upgraded from 2.2 to 3.2 with the same problem

    This works

    Hi,

    I have gotten the answer from an earlier post.

    The problem was that the column email_confirm was missing in the table users_users in the new installation.

    Solution: Add the column to the table users_users using the following syntax in phpMyAdmin:

    ALTER TABLE users_users ADD email_confirm int( 14 ) default NULL