[SOLVED] problem with registration

wgary
OFFLINE
Posts: 33
Thanks: 1
Karma: 0

12 years 1 month ago - 12 years 1 month ago #216235 by wgary

[SOLVED] problem with registration was created by wgary

I am updating an old Joomla 1.5 site to 2.5. (old site: www.p-m-a.at )
I moved the page to a new server, and its domain is currently beta.p-m-a.at

My Problem:
When I register a new member through community-builder register page for a special cbsubs-plan (for example pma community = standard plan),
I get the activation link. Perfect.
But when I open the link, i have to choose my membership again (because the old one is expired). Strange.

I found the error (mysql.log of a registration):

Code:

137 Query	UPDATE `pma_comprofiler` 
	SET `user_id`=18792,`firstname`='askljdf',`lastname`='lkj',`approved`=0,`confirmed`=0,`registeripaddr`='82.150.201.1',
	`cbactivation`='reg29117017fd9c820c7173b86489904dd00e1b0353',`acceptedterms`=1,`cb_title`='',`cb_title2`='',`cb_sex`='_MALE',
	`cb_privattel`='alskdfj',`cb_geburtsdatum`='2012-02-02',`cb_privatstrasse`='aölksdjf',`cb_privatplz`='aölskdfj',`cb_privatort`='90as9df',
	`cb_countrylist`='Österreich',`cb_rechnart`='Privat',`company`='',`cb_branche`='',`cb_kommentar1`='' WHERE id='18792'
		  
137 Query	UPDATE `pma_cbsubs_subscriptions` 
	SET `replaces_plan`=NULL,`replaces_subscription`=NULL,`subscription_date`='2012-12-03 12:58:03',
	`last_renewed_date`='2012-12-03 12:58:03',`expiry_date`=NULL,`autorenew_type`=0,`autorecurring_type`=0,`regular_recurrings_total`='0',
	`regular_recurrings_used`=1,`previous_expiry_date`=NULL,`previous_status`='R',`previous_recurrings_used`=0,
	`ip_addresses`='82.150.201.1',`status`='A',`user_id`='0',`plan_id`='12',`parent_plan`=0,`parent_subscription`=0,`integrations`='' WHERE id='18947'

You see, the user_id in the pma_cbsubs_subscriptions is 0. But I dont know why.

greetings

Last edit: 12 years 1 month ago by krileon.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48709
Thanks: 8319
Karma: 1447

12 years 1 month ago #216250 by krileon

Replied by krileon on topic Re: problem with registration

How did you migrate? The only supported migration method is jUpgrade. Have you tried installing CB 1.9 and CBSubs 2.0.2 over your existing install to ensure everything is up to date and functioning properly? Migrations never are error free, you will have issues.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

wgary
OFFLINE
Posts: 33
Thanks: 1
Karma: 0

12 years 1 month ago #216282 by wgary

Replied by wgary on topic Re: problem with registration

I have not used jupgrade or other migration stuff.

On the old system runs CB 1.5.1, i exported the tables,
installed CB 1.9 on the new system and imported the tables.

So I have exactly the same stuff in my tables - it works fine, but the registration fails.
Because on the insert for the pma_cbsubs_subscriptions-table is the user-id 0. (you see it in the code below)
I dont think that's a migration problem.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48709
Thanks: 8319
Karma: 1447

12 years 1 month ago #216302 by krileon

Replied by krileon on topic Re: problem with registration

You can't direct export/import to J2.5, the tables are completely different. It's a migration and you need to use a migration tool or you're going to have massive table adjustments to manually fix the problems. All usergroups and accessviewlevels are different compared to J2.5, the entire ACL tables are charged as well. If you exported with CB Juice and imported with CB Juice you'll be ok though as it probably imports the users using APIs.

Please Log in or Create an account to join the conversation.

wgary
OFFLINE
Posts: 33
Thanks: 1
Karma: 0

12 years 1 month ago #216309 by wgary

Replied by wgary on topic Re: problem with registration

I didn't copy the tables.
Ive made some insert into ... select from ... to right columns.
the acl table is ok. all existing users are in the right plans and groups.
this is not the problem.

you can register as a new user for a special ps-plan.
after clicking on the confirm-mail the user is in the right joomla-group,
but the ps-plan is expired, and you have to renew your subscritpion.

and i see that the pma_cbsubs_subscriptions-table has a new entry for the new registred user, but the user_id is 0.
why?

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48709
Thanks: 8319
Karma: 1447

12 years 1 month ago #216312 by krileon

Replied by krileon on topic Re: problem with registration

why?

I don't know, for whatever reason the plan is creating without a user id. Try on a clean install on the same host and see if issue persists. Something went wrong with your migration. If not done already try installing CB and CBSubs over top of themselves to auto upgrade to latest releases and see if there is a problem is sources, but am doubtful there is. Try also running CB tools (all except sample data) and see if there are any problems.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon