Loading...
 
Architecture / Installation

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, thankscry


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! biggrin

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: 4656 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.


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting