blog documentation FAQ followers forum marketplace services youtube

Subscription Issue

The Jamroom Network » Forum » Jamroom Developers » Page » Subscription Issue
ukdenny
@ukdenny
4 years ago
293 posts
On one of my sites I just upgraded the Subscription from 1.4.8 and there appear to be issues. The subscriptions previously created no longer display and the accounts that choose a subscription no longer display in their account.
updated by @ukdenny: 08/25/20 10:03:15PM
paul
@paul
4 years ago
4,325 posts
Can you let us know which site, and send the admin login for it to support[at]jamroom[dot]net ?
Thanks


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
Hi Paul, I was trying to get my password for you Paul (because onlog in it shows as ********* so logs in but I forgot the password. Now I have broke it and cannot login at all. I can't find the phpfile that used to sort this, only the repair.php which I used to no avail.
My hosting company installed a backup but this has made no difference. 'Forgot password' does not send an email so I am at a loss Could you advise please
updated by @ukdenny: 05/26/20 10:52:33AM
paul
@paul
4 years ago
4,325 posts
Is your site still basically working but not sending emails?
If so, I'd first check your error logs. You might be able to do this if your host provides cPanel or something similar, or you might need to FTP to your site.


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
The site is working for signed up people to login etc. It does not recognise Admin, it says 'An account with that email address or user name was not found - please try again' So Admin has no way of logging in, this is why it cannot send email to retrive the password.
paul
@paul
4 years ago
4,325 posts
You'll need to look at the jr_jruser_item_key table on the database (accessed via your cPanel or similar). As admin, your account will be detailed there as '_item_id' 1. Check what email is stored against the 'user_email' key. If its no longer a valid email, change it to one that is.
hth


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
I checked the jr_jruser_item_key and found the user name and email address but when I put the address in the 'forgot password' it's as before 'An Account with that email addresws does not exist?
paul
@paul
4 years ago
4,325 posts
Check that you entered the email address correctly, or try the user name instead. Also check that user_active on the database is set to 1.


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
I was looking at the wrong db. The correct one...item 1 is missing, but I am unsure how to add it
paul
@paul
4 years ago
4,325 posts
It might not be item 1, it is usually as master admin is the first account created, but you might subsequently have created another master admin account and deleted the original.
Do a table search for what you think your email or username might be.


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
I think the database might be corrupt. When I look at the DB for my other sites and browse the jr_jruser_item key table it's different and when I log in as a user some things are corrupt.
Would it make a difference if I exported the sql and do a clean install except skins and data folders (using the ones I have) then install, then replace the sql? Would it work?
paul
@paul
4 years ago
4,325 posts
Quote: Would it make a difference if I exported the sql and do a clean install except skins and data folders (using the ones I have) then install, then replace the sql? Would it work?

I doubt it. There's a lot going on in the DB and you would spend a lot of time tweaking things to make it right.
So in what way is the user table different? Why do you think its corrupt?


--
Paul Asher - JR Developer and System Import Specialist
ukdenny
@ukdenny
4 years ago
293 posts
Hi Paul
I'm back up and running. I backed up a database from 2 days ago and now it's looking okay but I am a bit worried of updating the modules in case it crashes again and I haven't updated my other site still working on Subscriptions 1.4.8 things went wrong updating to 1.4.9

Tags