"error:Could not co...
 
Notifications
Clear all

"error:Could not connect to database " with combu3

28 Posts
2 Users
0 Reactions
913 Views
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I met this error  when I want to update frome combu2 to combu3( I just setup Combu3 in a new machine,no combu2 now), I  read the  topic about this ,but these does not work ,so I have to make a new topic

1:19:22 [main] XAMPP Version: 8.2.0
1:19:22 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]

windows 11

http://localhost/combu/admin get error,

1 in

Combu setup

Config.php , I just use the default setting ,no change,

 

2  I add "a new line with lower_case_table_names=2 just below the line that contains [mysqld] " in.ini   so  I am sure all table now first letter is "Account" not "account"

I  re-setup for several times, it doest not work

 

3  All Info in Game_DB_XXX seems  correct,

GAME_DB

???????????

 

Plz help, now I am in a hurry

 
Posted : 29/03/2023 8:06 pm
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

 I installed  XAMPP  , Need I intall MySql???

This post was modified 2 years ago by simon
 
Posted : 30/03/2023 5:24 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

In XAMP control I See ,

 

11:33:12 [Apache] Attempting to start Apache app...
11:33:12 [Apache] Status change detected: running
11:33:14 [mysql] Attempting to start MySQL app...
11:33:14 [mysql] Status change detected: running
11:33:15 [mysql] Status change detected: stopped
11:33:15 [mysql] Error: MySQL shutdown unexpectedly.
11:33:15 [mysql] This may be due to a blocked port, missing dependencies,
11:33:15 [mysql] improper privileges, a crash, or a shutdown by another method.
11:33:15 [mysql] Press the Logs button to view error logs and check
11:33:15 [mysql] the Windows Event Viewer for more clues
11:33:15 [mysql] If you need more help, copy and post this
11:33:15 [mysql] entire log window on the forums

 

 
Posted : 30/03/2023 5:34 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I re-install XAMP  ,xampp-windows-x64-8.2.0-0-VS16-installer , still  does not work,

Now  there is no error on COntrol pad, but  http://localhost/combu/admin/ or http://127.0.0.1/combu/admin/ still "Could not connect to database:"

This post was modified 2 years ago by simon
 
Posted : 30/03/2023 6:09 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I  never met this problem in Combu2

😓

 
Posted : 30/03/2023 10:55 am
(@skaredcreations)
Posts: 805
Prominent Member Admin
 

I see in the log above that MySQL is stopping to work (11:33:15 [mysql] Error: MySQL shutdown unexpectedly) so of course you cannot access Combu, you should try to understand why MySQL service is stopping (it has nothing to do with Combu or its version).

You won't be able to connect to Combu database until MySQL service is up and running.

FRANCESCO CROCETTI @ SKARED CREATIONS

 
Posted : 01/04/2023 1:11 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

thanks for reply .

now the MySqls is OK  ,but the problem is still there.........

the xampPad  logis

13:42:27 [main] Initializing Control Panel
13:42:27 [main] Windows Version: Home 64-bit
13:42:27 [main] XAMPP Version: 8.2.0
13:42:27 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
13:42:27 [main] You are not running with administrator rights! This will work for
13:42:27 [main] most application stuff but whenever you do something with services
13:42:27 [main] there will be a security dialogue or things will break! So think
13:42:27 [main] about running this application with administrator rights!
13:42:27 [main] XAMPP Installation Directory: "d:\xampp\"
13:42:27 [main] Checking for prerequisites
13:42:29 [main] All prerequisites found
13:42:29 [main] Initializing Modules
13:42:29 [main] Starting Check-Timer
13:42:29 [main] Control Panel Ready
13:42:30 [Apache] Attempting to start Apache app...
13:42:31 [Apache] Status change detected: running
13:42:31 [mysql] Attempting to start MySQL app...
13:42:31 [mysql] Status change detected: running

 bug  http://localhost/combu/admin/   show 

Could not connect to database:

This post was modified 2 years ago by simon
 
Posted : 01/04/2023 8:10 am
(@skaredcreations)
Posts: 805
Prominent Member Admin
 

Try to use "localhost" instead of "127.0.0.1" for GAME_DB_SERVER, some systems accept one or the other for local connections (check also the user hostmask set for "root" on MySQL Users settings, XAMPP provides http://localhost/phpmyadmin to manage the databases you should try to login with those credentials there). Another test you can do is to set FALSE for GAME_DB_USE_PDO, it may be that your PHP build hasn't the PDO library module installed.

By the way, how did you create the tables? By using the /_setup pages and clicking the button "Execute" or did you copy&paste the SQL queries on phpMyAdmin? Also, have the tables (and fields) capital letters ("Account" not "account")?

FRANCESCO CROCETTI @ SKARED CREATIONS

 
Posted : 01/04/2023 2:31 pm
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

HI ,finally I found my account for your forum,

I set FALSE for GAME_DB_USE_PDO, but it does not work

about the Table Name ,

 
Posted : 28/07/2023 6:44 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I set FALSE for GAME_DB_USE_PDO,  there will be error when  I click "

Create the database script

"

 

and Here is the config.php ,  I can not find the problem , just default setting......I did not  change anything except I add the pwd  123456

 
Posted : 28/07/2023 6:51 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

Here is the config.php 

 
Posted : 28/07/2023 6:52 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

"how did you create the tables? By using the /_setup pages and clicking the button "Execute" or did you copy&paste the SQL queries on phpMyAdmin? Also, have the tables (and fields) capital letters ("Account" not "account")"

I  think I did it 

 
Posted : 28/07/2023 6:54 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I  really need   a  remote control to my computer .... if you like

 
Posted : 28/07/2023 6:55 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

when I use Combu 2 , there is no so many problem.....

 
Posted : 28/07/2023 6:55 am
(@simonyu)
Posts: 33
Eminent Member
Topic starter
 

I try set GAME_DB_SERVER is "localhost" or "127.0.0.1"  , both of them    still problem

 
Posted : 28/07/2023 9:16 am
Page 1 / 2
Share: