Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Database connection error  (Read 3331 times)

Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Database connection error
« on: July 18, 2020, 04:08:02 AM »
Hello

I am getting the below error messages from time to time and as i see that it is related to a database connection issue, i contacted my host provider A2 Hosting and they say that there is no errors in their log files.

What may cause this issue??


2020-07-15 6:21:50 - warning: AbanteCart core v.1.2.16 mysqli::__construct(): (HY000/2002): No such file or directory in <b>/home/XXXXXX/public_html/core/database/amysqli.php</b> on line <b>50</b>
2020-07-15 6:21:50 - App Error: AbanteCart core v.1.2.16 Cannot establish database connection to XXXXXX_YYYYYY using XXXXXX_admin@localhost
Trace:
#0 /home/bethleh1/public_html/core/database/amysqli.php on line 52
#1 /home/XXXXXX/public_html/core/lib/db.php on line 52
#2 /home/XXXXXX/public_html/core/init.php on line 322
#3 /home/XXXXXX/public_html/index.php on line 55
2020-07-15 6:21:50 - database error: AbanteCart core v.1.2.16 Cannot establish database connection. Check your database connection settings. in <b>/home/XXXXXX/public_html/core/database/amysqli.php</b> on line <b>54</b>

Thanks in advance

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: Database connection error
« Reply #1 on: July 18, 2020, 08:41:26 PM »
Check your database credentials in the configuration file.

There is a file system/config.php


Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Re: Database connection error
« Reply #2 on: July 20, 2020, 06:18:38 AM »
Hi

Thanks for your reply
I checked the system/config.php file and i don't see that there is anything wrong

This error occurs from time to time which means that the database connection is good and my site works perfect BUT in some moments something happens and the database connection is down, i checked with my server provider A2 Hosting and they say that there is errors in the server logs file

What other reasons may cause this database failure??

Thanks

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: Database connection error
« Reply #3 on: November 10, 2020, 02:13:59 AM »
Hello Team!

I have the same error log since 3 days.

configuration is 100% correct.

What's the problem here??

Thanks
Thank you In Advanced
Regards
HADY

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Database connection error
« Reply #4 on: November 10, 2020, 08:31:20 AM »
Hello.
Try to repair and optimize your database tables in case a problem occurs again please contact your hosting provider.

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: Database connection error
« Reply #5 on: November 21, 2020, 03:58:51 AM »
Hello.
Try to repair and optimize your database tables in case a problem occurs again please contact your hosting provider.

Thank you Basara, 

I would like to fix and optimize some issues on DB but I have a problem on orders statuses because they did caused these errors. Can you tell me how to edit old statuses on order to be deleted please?
Thank you In Advanced
Regards
HADY

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Database connection error
« Reply #6 on: November 21, 2020, 06:27:33 PM »
HADY, you can not fix anything until you resolve database connection issue. Fix your database connectivity and create new thread with other unrelated to this topic questions. 
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

 

Powered by SMFPacks Social Login Mod