database problems

Need help installing Joomla! 3.x? For all Joomla! 3.x installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

database problems

Post by Koos O » Fri Mar 08, 2019 5:15 pm

Our site has al kind of database related problems causing pages not indexed, invisible captcha not working, 404 page not showing and 404 incidents not logged etc etc.

I cannot find a solution for it so I was thinking.

If i start a new joomla site with an new clean database and I incorporate an Akeeba backup from the old site in the new site.

Would I then import the old problems in the new site or is there a good chance on success?

Thanks a million,
Koos

User avatar
JAVesey
Joomla! Hero
Joomla! Hero
Posts: 2635
Joined: Tue May 14, 2013 1:21 pm
Location: Cardiff, Wales, UK
Contact:

Re: database problems

Post by JAVesey » Fri Mar 08, 2019 6:10 pm

Koos O wrote:
Fri Mar 08, 2019 5:15 pm
If i start a new joomla site with an new clean database and I incorporate an Akeeba backup from the old site in the new site.

Would I then import the old problems in the new site or is there a good chance on success?
Almost certainly.

Are you able to log in to /administrator? If so then have you looked at:

1. Extensions > Manage > Database.
Is anything showing? If so, have you clicked the "Fix" button?

2. Extensions > Manage > warnings
Anything reported?

I'm making lots of assumptions about your site/server environment. Please can you carry out the actions in this post:
viewtopic.php?f=806&t=969442

It will help others to help you.
John V
Cardiff, Wales, UK
Joomla 5.1.0 "live" site on PHP 8.2.15 and MariaDB 10.11.7
Joomla 5.1.0 on XAMMP for OSX with PHP 8.2.4 and MariaDB 10.4.28

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Fri Mar 08, 2019 6:40 pm

Thank you John,

The database has no warnings

The warning only mention php temporary folder not set

I need the help of the hosting provider to fix that. Can it be a real problem?

The FPA, is worth trying. Ill get back to you.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Fri Mar 08, 2019 7:33 pm

How did you install Joomla originally ?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sat Mar 09, 2019 9:41 am

Forum Post Assistant (v1.4.8 (koine)) : 9th March 2019 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.3-Stable (Amani) 12-February-2019
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: true | FTP Layer: false | Proxy: false | LiveSite: https://www.slagkracht-outsourcing.nl | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.3: Yes | Database Supports J! 3.9.3: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 4.9.0-8-amd64 | Technology: x86_64 | Web Server: Apache/2.4.29 (Debian) | Encoding: gzip, deflate, br | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 116.11 GiB |

PHP Configuration :: Version: 7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626 | PHP API: fpm-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: /usr/share/php:/home/koosoverbeeke.nl/:/usr/sbin:/usr/bin:/bin:/tmp:/etc/phpmyadmin | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 256M

Database Configuration :: Version: 5.5.5-10.1.37-MariaDB-0+deb9u1 (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | Host: --protected-- (--protected--) | default Collation: utf8_general_ci (default Character Set: utf8) | Database Size: 268.90 MiB | #of Tables: 119
Detailed Environment :: wrote:PHP Extensions :: Core (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | date (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | libxml (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | openssl (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pcre (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | zlib (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | filter (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | hash (1.0) | Reflection (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | SPL (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | session (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | standard (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | cgi-fcgi () | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | PDO (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | xml (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | bcmath (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | bz2 (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | calendar (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | ctype (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | curl (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | dom (20031129) | mbstring (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | fileinfo (1.0.5) | ftp (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | gd (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | gettext (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | iconv (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | imagick (3.4.3) | imap (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | intl (1.1.0) | json (1.5.0) | ldap (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | exif (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | mcrypt (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | mysqli (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | odbc (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pdo_mysql (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | PDO_ODBC (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pdo_pgsql (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pdo_sqlite (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pgsql (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | Phar (2.0.2) | posix (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | pspell (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | readline (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | recode (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | shmop (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | SimpleXML (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | soap (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | sockets (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | sqlite3 (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | sysvmsg (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | sysvsem (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | sysvshm (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | tokenizer (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | wddx (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | xmlreader (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | xmlrpc (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | xmlwriter (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | xsl (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | zip (1.13.5) | ionCube Loader () | Zend OPcache (7.1.26-2+0~20190216175340.13+stretch~1.gbpc20626) | Zend Engine (3.1.0) |
Potential Missing Extensions ::
Disabled Functions :: pcntl_alarm | pcntl_fork | pcntl_waitpid | pcntl_wait | pcntl_wifexited | pcntl_wifstopped | pcntl_wifsignaled | pcntl_wifcontinued | pcntl_wexitstatus | pcntl_wtermsig | pcntl_wstopsig | pcntl_signal | pcntl_signal_get_handler | pcntl_signal_dispatch | pcntl_get_last_error | pcntl_strerror | pcntl_sigprocmask | pcntl_sigwaitinfo | pcntl_sigtimedwait | pcntl_exec | pcntl_getpriority | pcntl_setpriority | pcntl_async_signals | |

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 4525352 | Threads: 4 | Questions: 818238348 | Slow queries: 0 | Opens: 34399085 | Flush tables: 1 | Open tables: 64 | Queries per second avg: 180.812 |
Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: WF_ARTICLE_TITLE (2.6.37) ? | WF_IMGMANAGER_EXT_TITLE (2.6.37) ? | WF_XHTMLXTRAS_TITLE (2.6.37) ? | WF_INLINEPOPUPS_TITLE (2.6.37) ? | WF_FONTCOLOR_TITLE (2.6.37) ? | WF_FULLSCREEN_TITLE (2.6.37) ? | WF_TEMPLATEMANAGER_TITLE (2.6.37) ? | WF_HR_TITLE (2.6.37) ? | WF_STYLESELECT_TITLE (2.6.37) ? | WF_MEDIAMANAGER_TITLE (2.6.37) ? | WF_DIRECTIONALITY_TITLE (2.6.37) ? | WF_CAPTION_TITLE (2.6.37) ? | WF_SPELLCHECKER_TITLE (2.6.37) ? | WF_EMOTIONS_TITLE (2.6.37) ? | WF_KITCHENSINK_TITLE (2.6.37) ? | WF_VISUALCHARS_TITLE (2.6.37) ? | WF_BROWSER_TITLE (2.6.37) ? | WF_IMGMANAGER_TITLE (2.6.37) ? | WF_PREVIEW_TITLE (2.6.37) ? | WF_LINK_TITLE (2.6.37) ? | WF_FORMATSELECT_TITLE (2.6.37) ? | WF_AUTOSAVE_TITLE (2.6.37) ? | WF_TABLE_TITLE (2.6.37) ? | WF_LISTS_TITLE (2.6.37) ? | WF_STYLE_TITLE (2.6.37) ? | WF_NONBREAKING_TITLE (2.6.37) ? | WF_CHARMAP_TITLE (2.6.37) ? | WF_MICRODATA_TITLE (2.6.37) ? | WF_VISUALBLOCKS_TITLE (2.6.37) ? | WF_CLEANUP_TITLE (2.6.37) ? | WF_FILEMANAGER_TITLE (2.6.37) ? | WF_IFRAME_TITLE (2.6.37) ? | WF_MEDIA_TITLE (2.6.37) ? | WF_CONTEXTMENU_TITLE (2.6.37) ? | WF_SOURCE_TITLE (2.6.37) ? | WF_FONTSELECT_TITLE (2.6.37) ? | WF_TEXTPATTERN_TITLE (2.6.37) ? | WF_PRINT_TITLE (2.6.37) ? | WF_LAYER_TITLE (2.6.37) ? | WF_TEXTCASE_TITLE (2.6.37) ? | WF_FONTSIZESELECT_TITLE (2.6.37) ? | WF_SEARCHREPLACE_TITLE (2.6.37) ? | WF_CLIPBOARD_TITLE (2.6.37) ? | WF_ANCHOR_TITLE (2.6.37) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.6.37) ? | WF_POPUPS_WINDOW_TITLE (2.6.37) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.6.37) ? | WF_LINK_SEARCH_TITLE (2.6.37) ? | WF_LINKS_JOOMLALINKS_TITLE (2.6.37) ? | WF_AGGREGATOR_VIMEO_TITLE (2.6.37) ? | WF_AGGREGATOR_VINE_TITLE (2.6.37) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.6.37) ? | WF_AGGREGATOR_[youtube]_TITLE (2.6.37) ? |

Components :: ADMIN ::
Core :: com_fields (3.7.0) 1 | com_menus (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_redirect (3.0.0) 1 | com_associations (3.7.0) 1 | com_search (3.0.0) 1 | com_privacy (3.9.0) 1 | com_plugins (3.0.0) 1 | com_login (3.0.0) 1 | com_modules (3.0.0) 1 | com_admin (3.0.0) 1 | com_finder (3.0.0) 1 | com_templates (3.0.0) 1 | com_messages (3.0.0) 1 | com_checkin (3.0.0) 1 | com_tags (3.1.0) 1 | com_contenthistory (3.2.0) 1 | com_cache (3.0.0) 1 | com_banners (3.0.0) 1 | com_categories (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_config (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_ajax (3.2.0) 1 | com_installer (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_joomlaupdate (3.6.2) 1 | com_content (3.0.0) 1 | com_users (3.0.0) 1 | com_languages (3.0.0) 1 | com_media (3.0.0) 1 |
3rd Party:: JCH Optimize (5.4.1) 1 | COM_JCE (2.6.37) 1 | FlexiContactPlus (15.03) 1 | COM_FIX404ERRORLINKS (1.3.2) 1 | JMap (4.6.1) 1 | com_rsform (2.1.2) 1 | com_j2xml (3.3.153.237) 1 | JotCache (6.2.1) 1 | Akeeba (6.4.0) 1 |

Modules :: SITE ::
Core :: mod_whosonline (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_articles_popular (3.0.0) 1 | mod_search (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_feed (3.0.0) 1 |
3rd Party:: RSForm! Pro Module (1.51.1) 1 | JSitemap module (4.6.1) 1 | Responsive Nivo Slider (1.4) 1 |

Modules :: ADMIN ::
Core :: mod_logged (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_login (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_status (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_version (3.0.0) 1 | mod_title (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_submenu (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_feed (3.0.0) 1 |
3rd Party:: JSitemap Quickicons (4.6.1) 1 |

Libraries :: SITE ::
Core ::
3rd Party:: Regular Labs Library (19.2.10100) 1 | file_fof30 (3.4.1) ? |

Plugins :: SITE ::
Core :: plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_captcha_recaptcha_invisible (3.8) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_system_log (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_redirect (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_sessiongc (3.8.6) 1 | plg_system_logout (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_logrotation (3.9.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_p3p (3.0.0) 0 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_extension_joomla (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 0 | plg_finder_contacts (3.0.0) 0 | plg_finder_newsfeeds (3.0.0) 0 | plg_finder_categories (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 |
3rd Party:: Content - JSitemap Pingomatic (4.6.1) 1 | Content - Fast Social Share (3.0) 1 | Content - FlexiContactPlus (9.01) 1 | Content - RSForm! Pro (1.51.1) 1 | plg_content_jce (2.6.37) 1 | JotLoadmodule (6.2.1) 0 | Content - Pop Any Module (2.2) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK (1.1) 1 | PLG_SYSTEM_WEB357FRAMEWORK (1.7.5) 1 | JotCache (6.2.1) 1 | plg_system_regularlabs (19.2.10100) 1 | PLG_SYSTEM_FIX404ERRORLINKS (1.3.2) 1 | System - JCE MediaBox (1.2.9) 1 | System - RSForm! Pro reCAPTCHA v2 (1.52.2) 1 | PLG_SYSTEM_AKEEBAACTIONLOG (1.0) 0 | PLG_SYS_ADMINEXILE (3.16.3) 1 | System - RSForm! Pro Delete Submiss (1.0.0) ? | System - RSForm! Pro Joomla! Captch (1.0.2) ? | System - Google Analytics (4.6.1) 1 | JotMarker (6.2.1) 0 | PLG_SYSTEM_JCH_OPTIMIZE (5.4.1) 0 | System - RSForm! Pro Registration F (1.52.1) ? | plg_system_sourcerer (7.4.2) 1 | System - JSitemap utilities (4.6.1) 1 | plg_system_jce (2.6.37) 1 | PLG_SYSTEM_J2XML (3.4.34.64) 1 | PLG_SYSTEM_BACKUPONUPDATE (3.7) 0 | plg_extension_jce (2.6.37) 1 | plg_editors_codemirror (5.40.0) 1 | plg_editors_jce (2.6.37) 1 | plg_editors_tinymce (4.5.9) 1 | plg_quickicon_jce (2.6.37) 1 | plg_quickicon_akeebabackup (1.0) 1 | plg_fields_mediajce (2.6.37) 1 | Crawler (6.2.1) 1 | Recache (6.2.1) 0 | Crawler Extended (6.2.1) 1 | plg_editors-xtd_sourcerer (7.4.2) 1 | PLG_INSTALLER_FIX404ERRORLINKS (1.3.2) 1 | plg_installer_rsform (1.0.0) 1 | plg_installer_jce (2.6.37) 1 |
Templates Discovered :: wrote:Templates :: SITE :: protostar (1.0) 1 | beez3 (3.1.0) 1 |
Templates :: ADMIN :: isis (1.0) 1 | hathor (3.0.0) 1 |

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sat Mar 09, 2019 9:47 am

I posted the FPA

User avatar
Rondeb
Joomla! Guru
Joomla! Guru
Posts: 623
Joined: Mon Dec 02, 2013 12:14 pm
Location: Meschede - Germany
Contact:

Re: database problems

Post by Rondeb » Sat Mar 09, 2019 10:42 am

Hello Koos,

they old database gives you problem so when you make a backup with akeeba you import also the problem in your new site.

Your site is slagkracht-......? When i go to the backend I come on a white page!

Greatings Ron

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Sat Mar 09, 2019 11:32 am

LiveSite: ... should have no value

Code: Select all

public $live_site = '';
Session Path Writable: No ... Should be yes ... speak to your Host
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sat Mar 09, 2019 3:52 pm

Rondeb wrote:
Sat Mar 09, 2019 10:42 am
Hello Koos,

they old database gives you problem so when you make a backup with akeeba you import also the problem in your new site.

Your site is slagkracht-......? When i go to the backend I come on a white page!

Greatings Ron
Thank you Ron,

That makes the new implementation option an no go.

The back end white is correct. There is a plugin active that makes the back end only accessible if you know were to find it. That was done on purpose.
Did you have a special reason for mentioning this?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Sat Mar 09, 2019 3:56 pm

Koos O wrote:
Sat Mar 09, 2019 3:52 pm
...

That makes the new implementation option an no go. ...
No it doesn't. Use Akeeba to copy your site to localhost (wamp on your PC) ... don't forget to edit out the livesite value. Once you have done that ... post back and you will get instructions how to fix your site. Don't forget to fix he server problems as well.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sat Mar 09, 2019 4:53 pm

Webdongle wrote:
Sat Mar 09, 2019 11:32 am
LiveSite: ... should have no value

Code: Select all

public $live_site = '';
Session Path Writable: No ... Should be yes ... speak to your Host
Thank you 'webdongle'

I will contact our host on Monday :-(

Why the session path is non writeble? I don't know. Do you have an Idea what trouble it could cause?

I know the public live site should be " ".
Our host has put the website address in it because after the installation of this new site (then 3.8.10) we had this issue: klicking on a menu item we got the corresponding page but in the browser stood this address:
www.slagkracht-outsourcing.nl/slagkracht-outsourcing.nl/index.php

The host solved this problem with the public $live_site

I guess he solved the problem and introduced new ones? Do you have an idea what could have been re real problem that should have been solved?

Thank you :-)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Sat Mar 09, 2019 5:03 pm

Koos O wrote:
Sat Mar 09, 2019 4:53 pm
...
I know the public live site should be " ".
...
No. two single apostrophes with a semi colon not two quotation marks and a full stop (period)
Move the site to wamp localhost and fix it there. wamp will provide a good platform and rule out server error/misconfiguration.

There is much wrong with your Host server configuration.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sun Mar 10, 2019 9:50 am

I copied the site to my PC using Xampp. Wamp is not available this weekend :-(

I saw many php errors caused by fast social share so I disabled that plugin.

No ,what should I do next? :-)

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sun Mar 10, 2019 10:45 am

On pc localhost I cannot test the recaptcha function. Google does not give keys for localhost.

User avatar
Rondeb
Joomla! Guru
Joomla! Guru
Posts: 623
Joined: Mon Dec 02, 2013 12:14 pm
Location: Meschede - Germany
Contact:

Re: database problems

Post by Rondeb » Sun Mar 10, 2019 10:54 am

Hello,

you can make a subdomain at your hosting so you can test recaptcha.

Of gives a subdomain also problems with your hosting?

Greatings Ron

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sun Mar 10, 2019 11:45 am

Rondeb wrote:
Sun Mar 10, 2019 10:54 am
Hello,

you can make a subdomain at your hosting so you can test recaptcha.

Of gives a subdomain also problems with your hosting?

Greatings Ron

That's a good idea :-) Thank you Ron,

In the mean time the indexer from 'smart search' is still running (an hour now) om my pc copy of the site. I am curious if it comes to an end or if it hangs like it did on life site at yourhosting

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sun Mar 10, 2019 12:31 pm

The indexer from Smart Search does on my PC the same as it did on the official site. It exexes all catagories and 79 articles and then nothing happens anymore but it should find more then 300 articles.

The screen remains als the picture shows (do not close this)

Image

What can i do to find the problem?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Sun Mar 10, 2019 12:33 pm

Components >>> Joomla update ... check for updates ... Reinstall core files.

Extensions >>> manage >>> discover

Fix the problems on the host server. Session path ... php version ... Potential Missing Extensions
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Koos O
Joomla! Apprentice
Joomla! Apprentice
Posts: 49
Joined: Fri Aug 11, 2017 8:40 am

Re: database problems

Post by Koos O » Sun Mar 10, 2019 9:13 pm

Webdongle wrote:
Sun Mar 10, 2019 12:33 pm
Components >>> Joomla update ... check for updates ... Reinstall core files.

Extensions >>> manage >>> discover

Fix the problems on the host server. Session path ... php version ... Potential Missing Extensions
Thank you Webdongle, You give me suggestions I did not Know until now.

Unfortunately, so far no succes.

Reinstall core files: Done that. No updates. Reinstalled core file Worked fine but, Problems remain.
Discover:

Discover extensions that have not gone through the normal installation process.
No Matching Results

I am open for further suggestions. Tomorrow I first call the hosting provider

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44074
Joined: Sat Apr 05, 2008 9:58 pm

Re: database problems

Post by Webdongle » Sun Mar 10, 2019 10:29 pm

On localhost
Install a fresh Joomla (no sample data)
Use https://extensions.joomla.org/extension/j2xml/ to transfer data
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Locked

Return to “Installation Joomla! 3.x”