blog documentation FAQ followers forum marketplace services youtube

Error message on website, can't even log in.

The Jamroom Network » Forum » Using Jamroom » Page » Error message on website, can't even log in.
nellyslideguitar
@nellyslideguitar
9 years ago
9 posts
I have an error message on my website.
On my home page the website header loads,but thats all.
CRI: Query Error: Table 'andyniel_nels.jr_jraudio_item_key' doesn't exist

I can't log in either,when i enter password it says
Query Error: Table 'andyniel_nels.jr_jruser_item_key' doesn't exist

I haven't changed any settings in months,the errors started 24.12.14
updated by @nellyslideguitar: 02/13/15 11:47:42PM
paul
@paul
9 years ago
4,326 posts
Does the database and these tables still exist? Check via your cPanel and phpMyAdmin.
If so, check the /data/config/config.php file has the correct database username and password in it.
hth
Pa


--
Paul Asher - JR Developer and System Import Specialist
brian
@brian
9 years ago
10,148 posts
Sounds like your hosting provider might have lost your database - they should be able to assist you in restoring it from a backup.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
nellyslideguitar
@nellyslideguitar
9 years ago
9 posts
Thanx for your response,I was hoping it might be an easy fix,as I'm a novice. I had a look in the cPanel, when i select the error items,'jraudio_item_key_' and 'jruser_item_key' from the tables list it says it doesn't exist !! As i said i've changed nothing.
brian
@brian
9 years ago
10,148 posts
nellyslideguitar:
Thanx for your response,I was hoping it might be an easy fix,as I'm a novice. I had a look in the cPanel, when i select the error items,'jraudio_item_key_' and 'jruser_item_key' from the tables list it says it doesn't exist !! As i said i've changed nothing.

Yep - that means your hosting provider needs to help you out, as your database has been deleted (and Jamroom cannot do that).

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
nellyslideguitar
@nellyslideguitar
9 years ago
9 posts
Turns out these items in the Server database had been deleted: 'jruser_item_key' and 'jraudio_item_key' . Server said I've got to reload the site,which will blank all data.
Is there anyway of recovering members details,which file are they stored in ? and how do i reload them ?
bear in mind I can't log in
michael
@michael
9 years ago
7,715 posts
nellyslideguitar:Is there anyway of recovering members details,which file are they stored in ? and how do i reload them ?

All the members details are stored in the database. Usually Hosting provides take backups of your site for you. Unless you've downloaded the database anytime recently one of their backups is the best chance of not having to start again from the beginning.

Contact them and ask them to restore the latest backup version they have.

Tags