?
Solved

Missing #__users table

Posted on 2012-09-17
15
Medium Priority
?
902 Views
Last Modified: 2012-09-18
I have a Joomla client that is experiencing odd user behaviour.  For example, filter not working in the user manager, some users unable to use some features of the site and some users unable to log on.  I have just dicovered that the database is missing the '_users' table, my guess is that this is causing some or all of these problems.

The
_core_acl_aro
_core_acl_aro_groups
_core_acl_aro_map
_core_acl_aro_sections
_core_acl_groups_aro_map

are all present.

I have a copy of the _users table from 5 months ago but since then there will be new users that have registered.

My questions are these:

1. What is the best way to re introduce this missing table into the Joomla database?

2. Will I loose any user data?

3. What are the implications of running this site without the #__users table?

Thank you

D.
0
Comment
Question by:garda09
  • 8
  • 7
15 Comments
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38407165
If you have the table, the best way is to import it into the database...using php if possible.

Since there is NO _users table at all, there should be no data loss...IF you only import that table.  If you import more than that table, then there could be lots of data loss.

The biggest thing you need to do is BACKUP the entire database and site BEFORE you do anything to it.  

Then, restore the users table and test it.

Without the users table, the whole site is unsecured...and I'm suprised it still allows you to login to the admin side of it...
0
 

Author Comment

by:garda09
ID: 38407471
Hi nukit.
 I backed up the whole site and created a duplicate to work on a solution before tackling the live site.

I now need a step by step solution to restore this table using php.  I'm confident that I can follow instruction and quite keen to have a go.
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38407520
You can't actually restore it using php unless you completely code every single line of the database table.  Do you have access to PHPMYADMIN? Is this hosted externally or internally?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:garda09
ID: 38408321
Yes I have phpmyadmin
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38409432
Then, what I would do...

You said you had a backup of the _users table correct?  

Import the backup of the table into the database using PHPMYADMIN.  This will restore the table.  Also, do you happen to know SQL?  If so, you might need to code each line, might not...it depends on how it was backed up in the first place.
0
 

Author Comment

by:garda09
ID: 38409602
I don't know SQL unfortunately, I guess I'll try and import the table using phpmyadmin into the duplicate site and see what happens.

Assuming it imports successfully, what is the best way to add the new users (about 500) that registered since the last recorded entry in the _users table that I have?

thanks for sticking with me!

dg
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38409609
I'm not even sure that's possible...how in the word do you happen to have 500 new people registered in the system without a users table?

There must be a users table somewhere...

Can you send me a snapshot of all of the tables within your database?
0
 

Author Comment

by:garda09
ID: 38409633
OK, here's what the existing database has...


 truejos_acesef_bookmarks_backup
 truejos_acesef_extensions_backup
 truejos_acesef_ilinks_backup
 truejos_acesef_metadata_backup
 truejos_acesef_sitemap_backup
 truejos_acesef_tags_backup
 truejos_acesef_tags_map_backup
 truejos_acesef_urls_backup
 truejos_acesef_urls_moved_backup
 truejos_ak_acl
 truejos_ak_profiles
 truejos_ak_stats
 truejos_ak_storage
 truejos_banner
 truejos_bannerclient
 truejos_bannertrack
 truejos_billets_categories
 truejos_billets_comments
 truejos_billets_config
 truejos_billets_f2c
 truejos_billets_fields
 truejos_billets_fileblobs
 truejos_billets_files
 truejos_billets_frequents
 truejos_billets_labels
 truejos_billets_messages
 truejos_billets_t2a
 truejos_billets_ticketdata
 truejos_billets_tickets
 truejos_billets_ticketstates
 truejos_billets_u2c
 truejos_billets_u2t
 truejos_billets_userdata
 truejos_categories
 truejos_community_activities
 truejos_community_activities_hide
 truejos_community_apps
 truejos_community_avatar
 truejos_community_blocklist
 truejos_community_config
 truejos_community_connection
 truejos_community_connect_users
 truejos_community_events
 truejos_community_events_category
 truejos_community_events_location
 truejos_community_events_members
 truejos_community_featured
 truejos_community_fields
 truejos_community_fields_values
 truejos_community_files
 truejos_community_friendgroup
 truejos_community_friendlist
 truejos_community_groups
 truejos_community_groups_bulletins
 truejos_community_groups_category
 truejos_community_groups_discuss
 truejos_community_groups_invite
 truejos_community_groups_members
 truejos_community_invitations
 truejos_community_likes
 truejos_community_location_cache
 truejos_community_mailq
 truejos_community_memberlist
 truejos_community_memberlist_criteria
 truejos_community_msg
 truejos_community_msg_recepient
 truejos_community_notifications
 truejos_community_oauth
 truejos_community_photos
 truejos_community_photos_albums
 truejos_community_photos_tag
 truejos_community_photos_tokens
 truejos_community_profiles
 truejos_community_profiles_fields
 truejos_community_register
 truejos_community_register_auth_token
 truejos_community_reports
 truejos_community_reports_actions
 truejos_community_reports_reporter
 truejos_community_storage_s3
 truejos_community_tags
 truejos_community_tags_words
 truejos_community_userpoints
 truejos_community_userpref
 truejos_community_users
 truejos_community_user_status
 truejos_community_videos
 truejos_community_videos_category
 truejos_community_videos_tag
 truejos_community_wall
 truejos_components
 truejos_contact_details
 truejos_content
 truejos_content_frontpage
 truejos_content_rating
 truejos_core_acl_aro
 truejos_core_acl_aro_groups
 truejos_core_acl_aro_map
 truejos_core_acl_aro_sections
 truejos_core_acl_groups_aro_map
 truejos_core_log_items
 truejos_core_log_searches
 truejos_dtregister_captcha
 truejos_dtregister_categories
 truejos_dtregister_codes
 truejos_dtregister_config
 truejos_dtregister_events_codes
 truejos_dtregister_event_config
 truejos_dtregister_export_fields
 truejos_dtregister_fields
 truejos_dtregister_field_event
 truejos_dtregister_files
 truejos_dtregister_group
 truejos_dtregister_group_amount
 truejos_dtregister_group_event
 truejos_dtregister_group_member
 truejos_dtregister_history
 truejos_dtregister_locations
 truejos_dtregister_prerequisite
 truejos_dtregister_prerequisite_category
 truejos_dtregister_session
 truejos_dtregister_sync
 truejos_dtregister_user
 truejos_dtregister_waiting
 truejos_easyblog_acl
 truejos_easyblog_acl_group
 truejos_easyblog_adsense
 truejos_easyblog_autoarticle_map
 truejos_easyblog_blogger_subscription
 truejos_easyblog_captcha
 truejos_easyblog_category
 truejos_easyblog_category_acl
 truejos_easyblog_category_acl_item
 truejos_easyblog_category_subscription
 truejos_easyblog_comment
 truejos_easyblog_configs
 truejos_easyblog_drafts
 truejos_easyblog_external_groups
 truejos_easyblog_featured
 truejos_easyblog_feedburner
 truejos_easyblog_feeds
 truejos_easyblog_feeds_history
 truejos_easyblog_hashkeys
 truejos_easyblog_likes
 truejos_easyblog_mailq
 truejos_easyblog_meta
 truejos_easyblog_migrate_content
 truejos_easyblog_oauth
 truejos_easyblog_oauth_posts
 truejos_easyblog_post
 truejos_easyblog_post_rejected
 truejos_easyblog_post_subscription
 truejos_easyblog_post_tag
 truejos_easyblog_ratings
 truejos_easyblog_site_subscription
 truejos_easyblog_tag
 truejos_easyblog_team
 truejos_easyblog_team_groups
 truejos_easyblog_team_post
 truejos_easyblog_team_request
 truejos_easyblog_team_subscription
 truejos_easyblog_team_users
 truejos_easyblog_trackback
 truejos_easyblog_trackback_sent
 truejos_easyblog_twitter_microblog
 truejos_easyblog_users
 truejos_easyblog_xml_wpdata
 truejos_groups
 truejos_jevents_categories
 truejos_jevents_exception
 truejos_jevents_icsfile
 truejos_jevents_repbyday
 truejos_jevents_repetition
 truejos_jevents_rrule
 truejos_jevents_vevdetail
 truejos_jevents_vevent
 truejos_jev_defaults
 truejos_jev_users
 truejos_lms_agenda
 truejos_lms_attendance
 truejos_lms_attendance_periods
 truejos_lms_backups
 truejos_lms_cb_assoc
 truejos_lms_certificates
 truejos_lms_certificate_prints
 truejos_lms_certificate_users
 truejos_lms_chat_history
 truejos_lms_chat_users
 truejos_lms_conference_config
 truejos_lms_conference_doc
 truejos_lms_conference_period
 truejos_lms_conference_records
 truejos_lms_conference_usr
 truejos_lms_config
 truejos_lms_courses
 truejos_lms_courses_backups
 truejos_lms_courses_template
 truejos_lms_course_cats
 truejos_lms_course_cats_config
 truejos_lms_course_level
 truejos_lms_discounts
 truejos_lms_discount_coupons
 truejos_lms_disc_c_usage_stats
 truejos_lms_documents
 truejos_lms_documents_perms
 truejos_lms_documents_view
 truejos_lms_documents_zip
 truejos_lms_dropbox
 truejos_lms_email_notifications
 truejos_lms_email_templates
 truejos_lms_files
 truejos_lms_file_types
 truejos_lms_forums
 truejos_lms_forum_details
 truejos_lms_gqp_cats
 truejos_lms_gqp_levels
 truejos_lms_gradebook
 truejos_lms_gradebook_cats
 truejos_lms_gradebook_items
 truejos_lms_gradebook_lpaths
 truejos_lms_gradebook_scale
 truejos_lms_homework
 truejos_lms_homework_results
 truejos_lms_languages
 truejos_lms_learn_paths
 truejos_lms_learn_path_conds
 truejos_lms_learn_path_grades
 truejos_lms_learn_path_prerequisites
 truejos_lms_learn_path_results
 truejos_lms_learn_path_steps
 truejos_lms_learn_path_step_quiz_results
 truejos_lms_learn_path_step_results
 truejos_lms_learn_path_step_types
 truejos_lms_links
 truejos_lms_local_menu
 truejos_lms_maintenance_log
 truejos_lms_menu
 truejos_lms_messagelist
 truejos_lms_messages
 truejos_lms_messages_to
 truejos_lms_message_configuration
 truejos_lms_notifications
 truejos_lms_n_scorm
 truejos_lms_n_scorm_lib
 truejos_lms_n_scorm_scoes
 truejos_lms_n_scorm_scoes_data
 truejos_lms_n_scorm_scoes_track
 truejos_lms_n_scorm_seq_mapinfo
 truejos_lms_n_scorm_seq_objective
 truejos_lms_n_scorm_seq_rolluprulecond
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38409662
Is it possible that whatever community you are using took over the users table and renamed it #__community_users?
0
 

Author Comment

by:garda09
ID: 38409681
I think that table is the JomSocial user table, it contains different information to the _users table.

Any ideas?
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38409730
Hmm...very interesting.  

By chance are you running more than 1 joomla installation into that database?

There are a LOT of tables that seem to be missing from your database...like you menu table...

jos_assets
jos_associations
jos_banners
jos_banner_clients
jos_banner_tracks
jos_birthdays_contacts
jos_categories
jos_contact_details
jos_content
jos_content_frontpage
jos_content_rating
jos_core_log_searches
jos_extensions
jos_facileforms_compmenus
jos_facileforms_config
jos_facileforms_elements
jos_facileforms_forms
jos_facileforms_integrator_criteria_fixed
jos_facileforms_integrator_criteria_form
jos_facileforms_integrator_criteria_joomla
jos_facileforms_integrator_items
jos_facileforms_integrator_rules
jos_facileforms_packages
jos_facileforms_pieces
jos_facileforms_records
jos_facileforms_scripts
jos_facileforms_subrecords
jos_finder_filters
jos_finder_links
jos_finder_links_terms0
jos_finder_links_terms1
jos_finder_links_terms2
jos_finder_links_terms3
jos_finder_links_terms4
jos_finder_links_terms5
jos_finder_links_terms6
jos_finder_links_terms7
jos_finder_links_terms8
jos_finder_links_terms9
jos_finder_links_termsa
jos_finder_links_termsb
jos_finder_links_termsc
jos_finder_links_termsd
jos_finder_links_termse
jos_finder_links_termsf
jos_finder_taxonomy
jos_finder_taxonomy_map
jos_finder_terms
jos_finder_terms_common
jos_finder_tokens
jos_finder_tokens_aggregate
jos_finder_types
jos_jumi
jos_languages
jos_menu
jos_menu_types
jos_messages
jos_messages_cfg
jos_modules
jos_modules_menu
jos_newsfeeds
jos_overrider
jos_redirect_links
jos_schemas
jos_session
jos_template_styles
jos_updates
jos_update_categories
jos_update_sites
jos_update_sites_extensions
jos_usergroups
jos_users
jos_user_notes
jos_user_profiles
jos_user_usergroup_map
jos_viewlevels
jos_weblinks
0
 
LVL 13

Accepted Solution

by:
Andrew Derse earned 2000 total points
ID: 38409733
Is it possible that it is there, but not visible due to some weird phpmyadmin rule that is only displaying the first let's say 50 tables?  Click the next button to display the next 50 tables?
0
 

Author Comment

by:garda09
ID: 38409838
you are a legend.  Absolutely right, it wasn't displaying all the tables!  I'm really not familiar with this interface at all.  Nice one.

So, now I can see the table _users (don't i feel stupid!).  Glad I came here before trying anything else.

Do you have any idea what could cause some users to be found when searching in the user manager and some not?
0
 
LVL 13

Expert Comment

by:Andrew Derse
ID: 38409948
Honestly, no...I generally search through the user manager one page at a time versus searching for them within the user manager.
0
 

Author Closing Comment

by:garda09
ID: 38410051
my user error, very kindly pointed out.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question