Loading...
 
Skip to main content

Architecture / Installation


Installed 2.0 New Registrations not working. Help Please

posts: 82 Norway

I think everything is working now, except registration. I get the error message below. I tried to set registration check security to low, with no luck.

this is the site: http://www.gilb.com/tiki-register.php

(original error message is in a nice table)

ERROR

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 TestName
1 passord1
2 flokai@yahoo.com
3
4 1218943437
5 $1$EFY.ZOev$wf8VVIMKm7T8M3.rXfbVz1
6 1218943437
7 1218943437
8 1218943437
9 passord1
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('TestName','passord1','flokai@yahoo.com',,'1218943437','$1$EFY.ZOev$wf8VVIMKm7T8M3.rXfbVz1','1218943437','1218943437','1218943437','passord1',,NULL,NULL)

posts: 82 Norway

I headed over to http://www.opensourcecms.com/cms/tiki/ tried to register, and found that they had the same technical problem!!!

I have reinstalled Tiki wiki version 2, but the problem is still there.
Desperately needing help, thanks😢


posts: 82 Norway

WOW, I managed to fix it, found some guys that had fixed it and followed their vague instruction. see http://dev.tikiwiki.org/tiki-view_tracker_item.php

posted on: 20 Aug. 08 03:09 GMT+12
I also installed tikiwiki v2 from 1.9xx using the install scripts on a browser
I went to my phpMyAdmin/index.php db
opened users_users
cliced the Structure tab
at the bottom of the page, select Add1 fied - after pass_confirm
put in the info as it was in pass_confirm
Field: email_confirm Type: INT Length: 14 Collation and Attributes: blank Null: null Default: blank Extra: blank Select the tre --- Not huck of the T

add it, and now it works.

Thanks nyloth, and oraab and all of you


posts: 27

I have the same issue. It existed with both RC4 and V2.0. When I try to register I get a message:

The registration mail can't be sent. Contact the administrator

In looking at the syslog I see this:

163 mail error 08/23/2008 20:07 CDT Anonymous jon_web@greisz.com/
164 register 08/23/2008 20:07 CDT Anonymous created account test10

The account is created, but the email is not sent. If I authorize the account, then the email is correctly sent. This means that the email is configured correctly. I'm hosting on GoDaddy. All I see in the GoDaddy logs is this:

File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
(2)No such file or directory: File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/modules.php
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
(2)No such file or directory: File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/modules.php
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html

The site is at http://www.tatankanation.org. Any suggestions on what to try?

posts: 27

Any ideas on this?

I have the same issue. It existed with both RC4 and V2.0. When I try to register I get a message:

The registration mail can't be sent. Contact the administrator

In looking at the syslog I see this:

163 mail error 08/23/2008 20:07 CDT Anonymous jon_web at greisz.com/
164 register 08/23/2008 20:07 CDT Anonymous created account test10

The account is created, but the email is not sent. If I authorize the account, then the email is correctly sent. This means that the email is configured correctly. I'm hosting on GoDaddy?. All I see in the GoDaddy? logs is this:

File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
(2)No such file or directory: File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/modules.php
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
(2)No such file or directory: File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/modules.php
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/favicon.ico
File does not exist: /var/chroot/home/content/g/r/e/greisz/html/tatanka2/missing.html

The site is at http://www.tatankanation.org. Any suggestions on what to try?


posts: 24 Canada
WOW, I managed to fix it...


I had this exact problem as well. I followed your instructions exactly and now user registration works fine. Thanks for posting it! 😀

I do have this little worry that it may interfere with a future upgrade though. Does anyone know if there might be any problems with that?

posts: 4664 Japan

I think the missing info that caused the database error is fixed in the Tiki 2.1 release. Future upgrades should be smooth.

-- Gary


posts: 257 United States

Upgraded to 2.1 -no dice. Tried above fix -worked like a charm!

It looks imposing but if you do what the fix says it will make sense when you see it. Remember -the null value means don't put anything in the field blank -zip nada!(and if there's something in there get it out).

Now, if you do not have access to the database you'll have to give this fix to someone who does.