Jack_mcs Posted March 8, 2023 Share Posted March 8, 2023 I'm getting a timeout when trying to run oscb156. I've ran it before on this site but had to start over. The only difference I can think of between the two runs is that the site is now using CloudFlare. The live site is working fine. I've attached the log error below. Any thoughts about what it might be? 2023-03-08 18:36:20 [2603:9009:b10:7d00:300a:554a:27ed:e449][-][-][error][yii\base\ErrorException:2] yii\base\ErrorException: mysqli_connect(): (HY000/2002): Network is unreachable in /home/HIDDEN/public_html/jack/compat/database.php:18 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
osCommerce-Official Posted March 9, 2023 Share Posted March 9, 2023 @pandrei could you please check? Quote Link to comment Share on other sites More sharing options...
pandrei Posted March 9, 2023 Share Posted March 9, 2023 22 hours ago, Jack_mcs said: I'm getting a timeout when trying to run oscb156. I've ran it before on this site but had to start over. The only difference I can think of between the two runs is that the site is now using CloudFlare. The live site is working fine. I've attached the log error below. Any thoughts about what it might be? Hi Jack, It's error while connecting database. Check that the OSC Bridge finds the actual configure.php file from old osCommerce and that DB_SERVER constant points to actual database server. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 9, 2023 Author Share Posted March 9, 2023 2 hours ago, pandrei said: DB_SERVER constant points to actual database server. Yes, it does. As mentioned, the live shop, in which the install directory is located, is working fine. Assuming your install code is grabbing DB_SERVER from it, it is correct. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
pandrei Posted March 9, 2023 Share Posted March 9, 2023 mysqli_connect function that ends with error is a standard PHP function that connecting to a database. There may be only 2 reasons for that error: 1) The database host is correct but the remote machine is unreachable due network error or system failure 2) The database host is incorrect. For example, the standard configure.php file was renamed or oscb finds the old configure.php file. Your database host is a localhost or a remote IP? Does this error repeat every time or was it once? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 10, 2023 Author Share Posted March 10, 2023 16 hours ago, pandrei said: 1) The database host is correct but the remote machine is unreachable due network error or system failure As mentioned, the script is in a sub-directory of a working shop. 16 hours ago, pandrei said: 2) The database host is incorrect. For example, the standard configure.php file was renamed or oscb finds the old configure.php file. I uploaded a test script in the sbu-directory and it found and read the shops database fine. 16 hours ago, pandrei said: Your database host is a localhost or a remote IP? localhost 16 hours ago, pandrei said: Does this error repeat every time or was it once? Every time. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
pandrei Posted March 10, 2023 Share Posted March 10, 2023 @Jack_mcs, it's hard to know what exactly happens on your site. If you give me ftp or control panel access, I can investigate that. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 10, 2023 Author Share Posted March 10, 2023 @pandreiI have sent you a PM with the login. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
[email protected] Posted March 26, 2023 Share Posted March 26, 2023 (edited) On 3/9/2023 at 10:41 PM, pandrei said: mysqli_connect function that ends with error is a standard PHP function that connecting to a database. There may be only 2 reasons for that error: 1) The database host is correct but the remote machine is unreachable due network error or system failure 2) The database host is incorrect. For example, the standard configure.php file was renamed or oscb finds the old configure.php file. Your database host is a localhost or a remote IP? Does this error repeat every time or was it once? 🥴 Edited April 14, 2023 by Jan Zonjee spam link Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.