I built the site’s menu structure, content categories and articles; installed extensions, modules, plug-ins and the like from the back-end Super Admin interface. One of the extensions I have installed is the Fabrik component which allowed me to add to the site a database application consisting of related tables/lists and forms. The application will be quite extensive as one of the several tables shall contain about 3,000 records with links to other tables (when encoding is finished). I now want to open the site to users, enable them to register (into one of at least four custom user groups) and allow them to add, edit/update records in one or more tables from the front end, depending on their group assignment.
I therefore proceeded to add custom user groups from the back-end Super Admin interface. Initially, the system (Joomla) allowed me to add the custom user group Database Encoder. I was alarmed however to note that the newly added user group was automatically assigned an ID of 0, and suspected an irregularity right then, as the element ID is supposed to be a primary key automatically incremented by 1 every time a new record is added. I went on to add one more custom user group (with the intention of adding a few more actually), but as I suspected earlier, the system denied the attempt with the error message – “Save failed with the following error: Duplicate entry '0' for key 'PRIMARY'”.
I managed to talked the guy managing the web host into trying a work-around using phpMyAdmin to edit the contents of the Joomla xx_usergroups.idb table, that is replace the 0 ID of the custom user group Database Encoder with 10, add a few more custom user groups, manually assign them IDs of 11, 12 and 13 respectively. The stunt seemed to have worked initially, but I noted the lft and rgt fields (for these custom user groups) were assigned 0s respectively, in contrast with those of the built-in user groups, which have specific values for these fields (which I assume to be automatically assigned by the system). I am sending as attachment a .png image of the xx_usergroups table as sent to me by the web host for your reference.
This is giving me a pause, aware of the fact that something is not going right, and this may hold greater implications of which I am yet unaware, with my limited exposure to the workings of the Joomla system. I’m not even sure if I will be able to assign permissions and viewing access levels to these custom user groups. I don’t want to try at this point, fearing it might only wreck the whole system.
Please, help me debug and understand what’s happening to my site; and advise me on what remedial measures need to be undertaken to make things right, before I go any further with this project. I don’t even know how this bug came to be; was it in the installation of the system or one of its extensions, or the restoration of akeeba back-ups, or anything that I or the web host did or failed to do.
Your help shall be deeply and greatly appreciated as the continuation and completion of this project depends so much upon the correct creation and configuration of custom user groups upon which permissions and view access levels shall be assigned.
I’m also including herein a printout of my Forum Post Assistant for your reference. Again, I shall be deeply grateful…
Thank you and more power.
Forum Post Assistant (v1.4.3 (Frosty)) : 1st August 2018 wrote:Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.8.6-Stable (Amani) 13-March-2018
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (666) | Owner: --protected-- . (uid: /gid: ) | Group: --protected-- (gid: ) | Valid For: 3.8
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 0 | Cache: 0 | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: 0 | FTP Layer: 0 | Proxy: 0 | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: 0 | SSL: 0 | Error Reporting: none | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | dbConnection Type: mysqli | PHP Supports J! 3.8.6: Yes | Database Credentials Present: Yes |
Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: i586 | Web Server: Microsoft-IIS/10.0 | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 179.40 GiB |
PHP Configuration :: Version: 5.6.36 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: D:\home\LogFiles\php_errors.log | Last Known Error: 31st July 2018 10:33:17. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 8M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 128M
Database Configuration :: Version: 5.7.9 (Client:mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | Host: --protected-- (--protected--) | Localhost: Yes | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 37.02 MiB | #of Tables: 110Detailed Environment :: wrote:PHP Extensions :: Core (5.6.36) | bcmath () | calendar () | ctype () | date (5.6.36) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mcrypt () | SPL (0.2) | odbc (1.0) | pcre () | Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $) | session () | standard (5.6.36) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | tokenizer (0.1) | zip (1.12.5) | zlib (2.0) | libxml () | dom (20031129) | PDO (1.0.4dev) | openssl () | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | cgi-fcgi () | mysql (1.0) | mysqli (0.1) | mbstring () | gd () | gettext () | curl () | exif (1.4 $Id: e535278fc9664f5b7e5ddcdb6baec07426b8efd6 $) | xmlrpc (0.51) | xsl (0.1) | Phar (2.0.2) | soap () | pdo_mysql (1.0.2) | pdo_sqlite (1.0.1) | imap () | tidy (2.0) | wincache (1.3.7.12) | sqlsrv (3.2.0.0) | pdo_sqlsrv (3.2.0.0) | com_dotnet (0.1) | intl (1.1.0) | fileinfo (1.0.5) | pgsql () | pdo_pgsql (1.0.2) | mhash () | Zend OPcache (7.0.6-devFE) | Zend Engine (2.6.0) |
Potential Missing Extensions ::
Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: NoFolder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (---) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) | administrator/logs/ (777) |
Elevated Permissions (First 10) :: administrator/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_admin/ (777) | administrator/components/com_admin/controllers/ (777) | administrator/components/com_admin/helpers/ (777) | administrator/components/com_admin/helpers/html/ (777) | administrator/components/com_admin/models/ (777) | administrator/components/com_admin/models/forms/ (777) | administrator/components/com_admin/postinstall/ (777) |Database Information :: wrote:Database statistics :: Uptime: 304339 | Threads: 1 | Questions: 474847 | Slow queries: 0 | Opens: 1331 | Flush tables: 1 | Open tables: 1264 | Queries per second avg: 1.560 |Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_AGGREGATOR_DAILYMOTION_TITL (2.5.31) 1 | WF_AGGREGATOR_VIMEO_TITLE (2.5.31) 1 | WF_AGGREGATOR_VINE_TITLE (2.5.31) 1 | WF_AGGREGATOR_[youtube]_TITLE (2.5.31) 1 | WF_FILESYSTEM_JOOMLA_TITLE (2.5.31) 1 | WF_LINKS_JOOMLALINKS_TITLE (2.5.31) 1 | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.5.31) 1 | WF_POPUPS_JCEMEDIABOX_TITLE (2.5.31) 1 | WF_POPUPS_WINDOW_TITLE (2.5.31) 1 | WF_LINK_SEARCH_TITLE (2.5.31) 1 | WF_ANCHOR_TITLE (2.5.31) 1 | WF_ARTICLE_TITLE (2.5.31) 1 | WF_AUTOSAVE_TITLE (2.5.31) 1 | WF_BROWSER_TITLE (2.5.31) 1 | WF_CHARMAP_TITLE (2.5.31) 1 | WF_CLEANUP_TITLE (2.5.31) 1 | WF_CLIPBOARD_TITLE (2.5.31) 1 | WF_CONTEXTMENU_TITLE (2.5.31) 1 | WF_DIRECTIONALITY_TITLE (2.5.31) 1 | WF_FONTCOLOR_TITLE (2.5.31) 1 | WF_FONTSELECT_TITLE (2.5.31) 1 | WF_FONTSIZESELECT_TITLE (2.5.31) 1 | WF_FORMATSELECT_TITLE (2.5.31) 1 | WF_FULLSCREEN_TITLE (2.5.31) 1 | WF_HR_TITLE (2.5.31) 1 | WF_IMGMANAGER_TITLE (2.5.31) 1 | WF_INLINEPOPUPS_TITLE (2.5.31) 1 | WF_KITCHENSINK_TITLE (2.5.31) 1 | WF_LAYER_TITLE (2.5.31) 1 | WF_LINK_TITLE (2.5.31) 1 | WF_LISTS_TITLE (2.5.31) 1 | WF_MEDIA_TITLE (2.5.31) 1 | WF_NONBREAKING_TITLE (2.5.31) 1 | WF_PREVIEW_TITLE (2.5.31) 1 | WF_PRINT_TITLE (2.5.31) 1 | WF_SEARCHREPLACE_TITLE (2.5.31) 1 | WF_SOURCE_TITLE (2.5.31) 1 | WF_SPELLCHECKER_TITLE (2.5.31) 1 | WF_STYLE_TITLE (2.5.31) 1 | WF_STYLESELECT_TITLE (2.5.31) 1 | WF_TABLE_TITLE (2.5.31) 1 | WF_TEXTCASE_TITLE (2.5.31) 1 | WF_VISUALBLOCKS_TITLE (2.5.31) 1 | WF_VISUALCHARS_TITLE (2.5.31) 1 | WF_XHTMLXTRAS_TITLE (2.5.31) 1 |
Components :: ADMIN ::
Core :: com_admin (3.0.0) 1 | com_ajax (3.2.0) 1 | com_associations (3.7.0) 1 | com_banners (3.0.0) 1 | com_cache (3.0.0) 1 | com_categories (3.0.0) 1 | com_checkin (3.0.0) 1 | com_config (3.0.0) 1 | com_content (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_cpanel (3.0.0) 1 | com_fields (3.7.0) 1 | com_finder (3.0.0) 1 | com_installer (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_languages (3.0.0) 1 | com_login (3.0.0) 1 | com_media (3.0.0) 1 | com_menus (3.0.0) 1 | com_messages (3.0.0) 1 | com_modules (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_plugins (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_redirect (3.0.0) 1 | com_search (3.0.0) 1 | com_tags (3.1.0) 1 | com_templates (3.0.0) 1 | com_users (3.0.0) 1 |
3rd Party:: Akeeba (6.0.1) 1 | com_fabrik (3.8.1) 1 | JCE (2.5.31) 1 |
Modules :: SITE ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 0 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party:: BT Content Slider (2.3.11) 1 | BT Google Maps (2.1.0) 1 | mod_fabrik_form (3.8.1) 1 | mod_fabrik_list (3.8.1) 1 |
Modules :: ADMIN ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 0 | mod_stats_admin (3.0.0) 1 | mod_status (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party::
Plugins :: SITE ::
Core :: plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_captcha_recaptcha (3.4.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_webinstaller (1.1.1) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_p3p (3.0.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 |
3rd Party:: plg_fabrik (3.8.1) 1 | plg_content_jce (2.5.31) 1 | PLG_SIGE (3.3.1) 1 | plg_editors_codemirror (5.34.0) 1 | plg_editors_jce (2.5.31) 1 | plg_editors_tinymce (4.5.8) 1 | plg_fabrik_cron_email (3.8.1) 1 | plg_fabrik_cron_php (3.8.1) 1 | plg_fabrik_element_button (3.8.1) 1 | plg_fabrik_element_calc (3.8.1) 1 | plg_fabrik_element_cascadingdr (3.8.1) 1 | plg_fabrik_element_checkbox (3.8.1) 1 | plg_fabrik_element_databasejoi (3.8.1) 1 | plg_fabrik_element_date (3.8.1) 1 | plg_fabrik_element_display (3.8.1) 1 | plg_fabrik_element_dropdown (3.8.1) 1 | plg_fabrik_element_field (3.8.1) 1 | plg_fabrik_element_fileupload (3.8.1) 1 | plg_fabrik_element_googlemap (3.8.1) 1 | plg_fabrik_element_image (3.8.1) 1 | plg_fabrik_element_internalid (3.8.1) 1 | plg_fabrik_element_link (3.8.1) 1 | plg_fabrik_element_radiobutton (3.8.1) 1 | plg_fabrik_element_textarea (3.8.1) 1 | plg_fabrik_element_user (3.8.1) 1 | plg_fabrik_form_autofill (3.8.1) 1 | plg_fabrik_form_email (3.8.1) 1 | plg_fabrik_form_paginate (3.8.1) 1 | plg_fabrik_form_php (3.8.1) 1 | plg_fabrik_form_receipt (3.8.1) 1 | plg_fabrik_form_redirect (3.8.1) 1 | plg_fabrik_list_copy (3.8.1) 1 | plg_fabrik_list_php (3.8.1) 1 | plg_fabrik_validationrule_areu (3.8.1) 1 | plg_fabrik_validationrule_isal (3.8.1) 1 | plg_fabrik_validationrule_isem (3.8.1) 1 | plg_fabrik_validationrule_isgr (3.8.1) 1 | plg_fabrik_validationrule_isno (3.8.1) 1 | plg_fabrik_validationrule_isun (3.8.1) 1 | plg_fabrik_validationrule_note (3.8.1) 1 | plg_fabrik_validationrule_php (3.8.1) 1 | plg_fabrik_validationrule_rege (3.8.1) 1 | plg_fabrik_visualization_calen (3.8.1) 1 | plg_fabrik_visualization_chart (3.8.1) 1 | PLG_FABRIK_VISUALIZATION_FULLC (3.8.1) 1 | plg_fabrik_visualization_googl (3.8.1) 1 | plg_fabrik_visualization_media (3.8.1) 1 | plg_fabrik_visualization_slide (3.8.1) 1 | plg_installer_jce (2.5.31) 1 | plg_quickicon_akeebabackup (1.0) 0 | plg_quickicon_jcefilebrowser (2.5.31) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK_T (1.1) 1 | PLG_SYSTEM_BACKUPONUPDATE_TITL (3.7) 1 | plg_fabrik_system (3.8.1) 1 | System - Fabrik Scheduled Task (3.8.1) 1 | plg_system_jce (2.5.31) 1 |Templates Discovered :: wrote:Templates :: SITE :: beez3 (3.1.0) 1 | protostar (1.0) 1 | protostarcopy (1.0) 1 |
Templates :: ADMIN :: hathor (3.0.0) 1 | isis (1.0) 1 |