garda09
asked on
Missing #__users table
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.
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.
ASKER
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.
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.
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?
ASKER
Yes I have phpmyadmin
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.
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.
ASKER
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
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
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?
There must be a users table somewhere...
Can you send me a snapshot of all of the tables within your database?
ASKER
OK, here's what the existing database has...
truejos_acesef_bookmarks_b ackup
truejos_acesef_extensions_ backup
truejos_acesef_ilinks_back up
truejos_acesef_metadata_ba ckup
truejos_acesef_sitemap_bac kup
truejos_acesef_tags_backup
truejos_acesef_tags_map_ba ckup
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_ticketstat es
truejos_billets_u2c
truejos_billets_u2t
truejos_billets_userdata
truejos_categories
truejos_community_activiti es
truejos_community_activiti es_hide
truejos_community_apps
truejos_community_avatar
truejos_community_blocklis t
truejos_community_config
truejos_community_connecti on
truejos_community_connect_ users
truejos_community_events
truejos_community_events_c ategory
truejos_community_events_l ocation
truejos_community_events_m embers
truejos_community_featured
truejos_community_fields
truejos_community_fields_v alues
truejos_community_files
truejos_community_friendgr oup
truejos_community_friendli st
truejos_community_groups
truejos_community_groups_b ulletins
truejos_community_groups_c ategory
truejos_community_groups_d iscuss
truejos_community_groups_i nvite
truejos_community_groups_m embers
truejos_community_invitati ons
truejos_community_likes
truejos_community_location _cache
truejos_community_mailq
truejos_community_memberli st
truejos_community_memberli st_criteri a
truejos_community_msg
truejos_community_msg_rece pient
truejos_community_notifica tions
truejos_community_oauth
truejos_community_photos
truejos_community_photos_a lbums
truejos_community_photos_t ag
truejos_community_photos_t okens
truejos_community_profiles
truejos_community_profiles _fields
truejos_community_register
truejos_community_register _auth_toke n
truejos_community_reports
truejos_community_reports_ actions
truejos_community_reports_ reporter
truejos_community_storage_ s3
truejos_community_tags
truejos_community_tags_wor ds
truejos_community_userpoin ts
truejos_community_userpref
truejos_community_users
truejos_community_user_sta tus
truejos_community_videos
truejos_community_videos_c ategory
truejos_community_videos_t ag
truejos_community_wall
truejos_components
truejos_contact_details
truejos_content
truejos_content_frontpage
truejos_content_rating
truejos_core_acl_aro
truejos_core_acl_aro_group s
truejos_core_acl_aro_map
truejos_core_acl_aro_secti ons
truejos_core_acl_groups_ar o_map
truejos_core_log_items
truejos_core_log_searches
truejos_dtregister_captcha
truejos_dtregister_categor ies
truejos_dtregister_codes
truejos_dtregister_config
truejos_dtregister_events_ codes
truejos_dtregister_event_c onfig
truejos_dtregister_export_ fields
truejos_dtregister_fields
truejos_dtregister_field_e vent
truejos_dtregister_files
truejos_dtregister_group
truejos_dtregister_group_a mount
truejos_dtregister_group_e vent
truejos_dtregister_group_m ember
truejos_dtregister_history
truejos_dtregister_locatio ns
truejos_dtregister_prerequ isite
truejos_dtregister_prerequ isite_cate gory
truejos_dtregister_session
truejos_dtregister_sync
truejos_dtregister_user
truejos_dtregister_waiting
truejos_easyblog_acl
truejos_easyblog_acl_group
truejos_easyblog_adsense
truejos_easyblog_autoartic le_map
truejos_easyblog_blogger_s ubscriptio n
truejos_easyblog_captcha
truejos_easyblog_category
truejos_easyblog_category_ acl
truejos_easyblog_category_ acl_item
truejos_easyblog_category_ subscripti on
truejos_easyblog_comment
truejos_easyblog_configs
truejos_easyblog_drafts
truejos_easyblog_external_ groups
truejos_easyblog_featured
truejos_easyblog_feedburne r
truejos_easyblog_feeds
truejos_easyblog_feeds_his tory
truejos_easyblog_hashkeys
truejos_easyblog_likes
truejos_easyblog_mailq
truejos_easyblog_meta
truejos_easyblog_migrate_c ontent
truejos_easyblog_oauth
truejos_easyblog_oauth_pos ts
truejos_easyblog_post
truejos_easyblog_post_reje cted
truejos_easyblog_post_subs cription
truejos_easyblog_post_tag
truejos_easyblog_ratings
truejos_easyblog_site_subs cription
truejos_easyblog_tag
truejos_easyblog_team
truejos_easyblog_team_grou ps
truejos_easyblog_team_post
truejos_easyblog_team_requ est
truejos_easyblog_team_subs cription
truejos_easyblog_team_user s
truejos_easyblog_trackback
truejos_easyblog_trackback _sent
truejos_easyblog_twitter_m icroblog
truejos_easyblog_users
truejos_easyblog_xml_wpdat a
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_per iods
truejos_lms_backups
truejos_lms_cb_assoc
truejos_lms_certificates
truejos_lms_certificate_pr ints
truejos_lms_certificate_us ers
truejos_lms_chat_history
truejos_lms_chat_users
truejos_lms_conference_con fig
truejos_lms_conference_doc
truejos_lms_conference_per iod
truejos_lms_conference_rec ords
truejos_lms_conference_usr
truejos_lms_config
truejos_lms_courses
truejos_lms_courses_backup s
truejos_lms_courses_templa te
truejos_lms_course_cats
truejos_lms_course_cats_co nfig
truejos_lms_course_level
truejos_lms_discounts
truejos_lms_discount_coupo ns
truejos_lms_disc_c_usage_s tats
truejos_lms_documents
truejos_lms_documents_perm s
truejos_lms_documents_view
truejos_lms_documents_zip
truejos_lms_dropbox
truejos_lms_email_notifica tions
truejos_lms_email_template s
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_item s
truejos_lms_gradebook_lpat hs
truejos_lms_gradebook_scal e
truejos_lms_homework
truejos_lms_homework_resul ts
truejos_lms_languages
truejos_lms_learn_paths
truejos_lms_learn_path_con ds
truejos_lms_learn_path_gra des
truejos_lms_learn_path_pre requisites
truejos_lms_learn_path_res ults
truejos_lms_learn_path_ste ps
truejos_lms_learn_path_ste p_quiz_res ults
truejos_lms_learn_path_ste p_results
truejos_lms_learn_path_ste p_types
truejos_lms_links
truejos_lms_local_menu
truejos_lms_maintenance_lo g
truejos_lms_menu
truejos_lms_messagelist
truejos_lms_messages
truejos_lms_messages_to
truejos_lms_message_config uration
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_ma pinfo
truejos_lms_n_scorm_seq_ob jective
truejos_lms_n_scorm_seq_ro llupruleco nd
truejos_acesef_bookmarks_b
truejos_acesef_extensions_
truejos_acesef_ilinks_back
truejos_acesef_metadata_ba
truejos_acesef_sitemap_bac
truejos_acesef_tags_backup
truejos_acesef_tags_map_ba
truejos_acesef_urls_backup
truejos_acesef_urls_moved_
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_ticketstat
truejos_billets_u2c
truejos_billets_u2t
truejos_billets_userdata
truejos_categories
truejos_community_activiti
truejos_community_activiti
truejos_community_apps
truejos_community_avatar
truejos_community_blocklis
truejos_community_config
truejos_community_connecti
truejos_community_connect_
truejos_community_events
truejos_community_events_c
truejos_community_events_l
truejos_community_events_m
truejos_community_featured
truejos_community_fields
truejos_community_fields_v
truejos_community_files
truejos_community_friendgr
truejos_community_friendli
truejos_community_groups
truejos_community_groups_b
truejos_community_groups_c
truejos_community_groups_d
truejos_community_groups_i
truejos_community_groups_m
truejos_community_invitati
truejos_community_likes
truejos_community_location
truejos_community_mailq
truejos_community_memberli
truejos_community_memberli
truejos_community_msg
truejos_community_msg_rece
truejos_community_notifica
truejos_community_oauth
truejos_community_photos
truejos_community_photos_a
truejos_community_photos_t
truejos_community_photos_t
truejos_community_profiles
truejos_community_profiles
truejos_community_register
truejos_community_register
truejos_community_reports
truejos_community_reports_
truejos_community_reports_
truejos_community_storage_
truejos_community_tags
truejos_community_tags_wor
truejos_community_userpoin
truejos_community_userpref
truejos_community_users
truejos_community_user_sta
truejos_community_videos
truejos_community_videos_c
truejos_community_videos_t
truejos_community_wall
truejos_components
truejos_contact_details
truejos_content
truejos_content_frontpage
truejos_content_rating
truejos_core_acl_aro
truejos_core_acl_aro_group
truejos_core_acl_aro_map
truejos_core_acl_aro_secti
truejos_core_acl_groups_ar
truejos_core_log_items
truejos_core_log_searches
truejos_dtregister_captcha
truejos_dtregister_categor
truejos_dtregister_codes
truejos_dtregister_config
truejos_dtregister_events_
truejos_dtregister_event_c
truejos_dtregister_export_
truejos_dtregister_fields
truejos_dtregister_field_e
truejos_dtregister_files
truejos_dtregister_group
truejos_dtregister_group_a
truejos_dtregister_group_e
truejos_dtregister_group_m
truejos_dtregister_history
truejos_dtregister_locatio
truejos_dtregister_prerequ
truejos_dtregister_prerequ
truejos_dtregister_session
truejos_dtregister_sync
truejos_dtregister_user
truejos_dtregister_waiting
truejos_easyblog_acl
truejos_easyblog_acl_group
truejos_easyblog_adsense
truejos_easyblog_autoartic
truejos_easyblog_blogger_s
truejos_easyblog_captcha
truejos_easyblog_category
truejos_easyblog_category_
truejos_easyblog_category_
truejos_easyblog_category_
truejos_easyblog_comment
truejos_easyblog_configs
truejos_easyblog_drafts
truejos_easyblog_external_
truejos_easyblog_featured
truejos_easyblog_feedburne
truejos_easyblog_feeds
truejos_easyblog_feeds_his
truejos_easyblog_hashkeys
truejos_easyblog_likes
truejos_easyblog_mailq
truejos_easyblog_meta
truejos_easyblog_migrate_c
truejos_easyblog_oauth
truejos_easyblog_oauth_pos
truejos_easyblog_post
truejos_easyblog_post_reje
truejos_easyblog_post_subs
truejos_easyblog_post_tag
truejos_easyblog_ratings
truejos_easyblog_site_subs
truejos_easyblog_tag
truejos_easyblog_team
truejos_easyblog_team_grou
truejos_easyblog_team_post
truejos_easyblog_team_requ
truejos_easyblog_team_subs
truejos_easyblog_team_user
truejos_easyblog_trackback
truejos_easyblog_trackback
truejos_easyblog_twitter_m
truejos_easyblog_users
truejos_easyblog_xml_wpdat
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_per
truejos_lms_backups
truejos_lms_cb_assoc
truejos_lms_certificates
truejos_lms_certificate_pr
truejos_lms_certificate_us
truejos_lms_chat_history
truejos_lms_chat_users
truejos_lms_conference_con
truejos_lms_conference_doc
truejos_lms_conference_per
truejos_lms_conference_rec
truejos_lms_conference_usr
truejos_lms_config
truejos_lms_courses
truejos_lms_courses_backup
truejos_lms_courses_templa
truejos_lms_course_cats
truejos_lms_course_cats_co
truejos_lms_course_level
truejos_lms_discounts
truejos_lms_discount_coupo
truejos_lms_disc_c_usage_s
truejos_lms_documents
truejos_lms_documents_perm
truejos_lms_documents_view
truejos_lms_documents_zip
truejos_lms_dropbox
truejos_lms_email_notifica
truejos_lms_email_template
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_item
truejos_lms_gradebook_lpat
truejos_lms_gradebook_scal
truejos_lms_homework
truejos_lms_homework_resul
truejos_lms_languages
truejos_lms_learn_paths
truejos_lms_learn_path_con
truejos_lms_learn_path_gra
truejos_lms_learn_path_pre
truejos_lms_learn_path_res
truejos_lms_learn_path_ste
truejos_lms_learn_path_ste
truejos_lms_learn_path_ste
truejos_lms_learn_path_ste
truejos_lms_links
truejos_lms_local_menu
truejos_lms_maintenance_lo
truejos_lms_menu
truejos_lms_messagelist
truejos_lms_messages
truejos_lms_messages_to
truejos_lms_message_config
truejos_lms_notifications
truejos_lms_n_scorm
truejos_lms_n_scorm_lib
truejos_lms_n_scorm_scoes
truejos_lms_n_scorm_scoes_
truejos_lms_n_scorm_scoes_
truejos_lms_n_scorm_seq_ma
truejos_lms_n_scorm_seq_ob
truejos_lms_n_scorm_seq_ro
Is it possible that whatever community you are using took over the users table and renamed it #__community_users?
ASKER
I think that table is the JomSocial user table, it contains different information to the _users table.
Any ideas?
Any ideas?
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_aggregat e
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_extension s
jos_usergroups
jos_users
jos_user_notes
jos_user_profiles
jos_user_usergroup_map
jos_viewlevels
jos_weblinks
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
jos_facileforms_integrator
jos_facileforms_integrator
jos_facileforms_integrator
jos_facileforms_integrator
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_aggregat
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_extension
jos_usergroups
jos_users
jos_user_notes
jos_user_profiles
jos_user_usergroup_map
jos_viewlevels
jos_weblinks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
Honestly, no...I generally search through the user manager one page at a time versus searching for them within the user manager.
ASKER
my user error, very kindly pointed out.
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...