Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    62
    Plugin Contributions
    0

    Default Upgrading MariaDB 5 to 10

    ZC v1.5.8a
    php 7.4
    phpMyAdmin v4.9.7
    MariaDB v5.5.68 / v10.3.29


    After upgrading ZC from 1.3.9h to v1.5.8a, everything works fine, and the next thing to do is switch from MariaDB v5 to v10.

    I use phpMyAdmin to export the database from MariaDB v5, and import to v10. No error message here, and DB name, username, password are all the same.
    Stop v5 and run v10. The website says "There seems to be a problem connecting to our database." Error log shows:

    Request URI: /index.php?main_page=product_reviews_info&products_id=2&reviews_id=10&zenid=1k4o0 1rd1saah9js23cvlhnj30, IP address: 124.243.150.207, Language id
    #1 mysqli_connect() called at [/web/includes/classes/db/mysql/query_factory.php:76]
    #2 queryFactory->connect() called at [/web/includes/init_includes/init_database.php:22]
    #3 require(/web/includes/init_includes/init_database.php) called at [/volume1/web/kendo158/includes/application_top.php:199]
    #4 require(/web/includes/application_top.php) called at [/volume1/web/kendo158/index.php:25]
    --> PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /web/includes/classes/db/mysql/query_factory.php on line 76.
    Stop v10 and run v5, and everything is back to normal. It looks like phpMyAdmin can see MariaDB v10 on my server, but ZC can't. Do I miss any step?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Upgrading MariaDB 5 to 10

    Quote Originally Posted by siliconbug View Post
    mysqli_connect(): (HY000/2002): No such file or directory
    That message typically means that the database is not responding to PHP's connection attempt when using the credentials specified in your /includes/configure.php file, namely:
    DB_SERVER
    DB_SERVER_USERNAME
    DB_SERVER_PASSWORD
    DB_DATABASE
    DB_PREFIX
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Apr 2009
    Posts
    62
    Plugin Contributions
    0

    Default Re: Upgrading MariaDB 5 to 10

    All configuration looks correct, and to stop/restart Apache/php/MariaDB 10 doesn't make any difference (in a Linux server).
    Finally, I reboot the whole server..., and it works.

    Come on, you're a Linux, not Windows!

 

 

Similar Threads

  1. MariaDB 10.2
    By mprough in forum General Questions
    Replies: 2
    Last Post: 14 Apr 2022, 09:06 AM
  2. v155 Error after upgrading to MSQL to MariaDB 10.3, how do I see error messages
    By patrioticflags in forum General Questions
    Replies: 10
    Last Post: 13 Jun 2019, 07:20 PM
  3. v155 Error whenever someone places an order after upgrading to MariaDB 10.3
    By patrioticflags in forum General Questions
    Replies: 1
    Last Post: 13 Jun 2019, 06:14 PM
  4. v156 Host upgrading from MySQL 5.6 to MariaDB 10.3
    By bowbiz in forum General Questions
    Replies: 5
    Last Post: 9 Apr 2019, 08:12 PM
  5. centos7/mariadb
    By pixelpadre in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 26 Jul 2017, 06:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR