-B- Upgrade 2.0 to 2.2: (1) Howto - (2) user registration bug
this is the 2nd of my 2 postings:
B.1. FACTS: User registration: does not work:
After upgrading from 1.9.9. ... 1,9.10 ... 2.0
now in 2.0 the user registration does not any more work.
The user gets a confirmation mail with a link like:
http://infos7.com/tiki-login_validate.php?user=sarbel&pass=3e8179c91029ef193e6af509a3cc4d92
which does not do the job.
B.2. FACTS: When admin tries to create the link:
Query is:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values('sarbel',,'nospam@terra-unika.com',,'1231410389','$1$aIEBt3dX$cC7OGbSEHRQTBEGwtgvBP0','1231410389','1231410389','1231410389',NULL,NULL,NULL,'u')
Error is:
Unknown column 'email_confirm' in 'field list'
B.3. Supposed ???bug??? :
The official DB structure was probably meantime extended with the fields
`pass_confirm`, `email_confirm`,
the software of 2.0 requires these fields,
so upgrading to 2.0. had to include some minimal DB structure modification?
B.4. Possible solutions?
If this would be the only change, then it would be the easiest way to
extend the DB interactively / manually on the server with these two fields.
I could look up the field types in the SQL installer of current Tikiwiki 2.2.
B.5. My SOS question :
Hopeful that some wise possessor of knowledge will find the time to
communicate his opinion, and then I will proceed correspondingly...
If there would be far more DB modifs between 1.9.9. and 2.0 or 2.2,
then administrators should better do a re-install of 2.2. ,
with download / upload of the data of the running system...
;){kind=link}
;){kind=link}