Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Installation stuck at creating database #976

Closed
frankhubrepo opened this issue Jan 7, 2021 · 32 comments
Closed

Installation stuck at creating database #976

frankhubrepo opened this issue Jan 7, 2021 · 32 comments
Assignees
@Fasse
Labels
change module:installation
Milestone
v4.1.11

Comments

@frankhubrepo
Copy link

I tried both the beta and the official version in my localhost, and both times I haven't gotten past the "creating database" screen:
image

Has anyone ran into this issue?
@Fasse
Copy link
Member

Fasse commented Jan 7, 2021

Do you have any entries in the PHP errorlog?

@Fasse
Copy link
Member

Fasse commented Jan 29, 2021

We need more informations about this issue. Do you have access to PHP logfiles?

@zhuguangxx
Copy link

The problem I encountered was the same, the card was in the install database page. Installation environment: php56, mysql5.7.33
PHP slow log: [21-feb-2021 01:22:52] Note: child 470828 stopped for tracing
[21-Feb-2021 01:22:52] NOTICE: about to trace 470828
[21-Feb-2021 01:22:52] NOTICE: finished trace of 470828

@zhuguangxx
Copy link

[21-Feb-2021 01:06:27] NOTICE: fpm is running, pid 496760
[21-Feb-2021 01:06:27] NOTICE: ready to handle connections
[21-Feb-2021 01:06:28] NOTICE: fpm is running, pid 496778
[21-Feb-2021 01:06:28] NOTICE: ready to handle connections
[21-Feb-2021 02:00:01] NOTICE: Reloading in progress ...
[21-Feb-2021 02:00:01] NOTICE: reloading: execvp("/www/server/php/56/sbin/php-fpm", {"/www/server/php/56/sbin/php-fpm", "--daemonize", "--fpm-config", "/www/server/php/56/etc/php-fpm.conf", "--pid", "/www/server/php/56/var/run/php-fpm.pid"})
[21-Feb-2021 02:00:01] NOTICE: using inherited socket fd=10, "/tmp/php-cgi-56.sock"
[21-Feb-2021 02:00:01] NOTICE: using inherited socket fd=10, "/tmp/php-cgi-56.sock"
[21-Feb-2021 02:00:01] NOTICE: fpm is running, pid 502089
[21-Feb-2021 02:00:01] NOTICE: ready to handle connections

@Fasse
Copy link
Member

Fasse commented Feb 21, 2021

do you have any new tables of Admidio in the database after that? Or is the database still empty?

@zhuguangxx
Copy link

do you have any new tables of Admidio in the database after that? Or is the database still empty?

no ,there is no tables.

@mrlawrencelam
Copy link

I have the same issue. Installation stuck at "Creating Database.....". No table created under phpMyAdmin.

This is taken from the error log:

PHP Fatal error: Uncaught Error: Call to a member function fetchAll() on bool in /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Database.php:463
Stack trace:
#0 /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Database.php(389): Database->loadTableColumnsProperties('adm_sessions')
#1 /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/TableAccess.php(141): Database->getTableColumnsProperties('adm_sessions')
#2 /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/TableAccess.php(100): TableAccess->clear()
#3 /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Session.php(59): TableAccess->__construct(Object(Database), 'adm_sessions', 'ses')
#4 /home/rljjnww/public_html/upoint_membership/adm_program/system/common.php(97): Session->__construct(Object(Database), 'afc68aeff73c821...', 'ADMIDIO_KLTGA_u...')
#5 /home/rljjnww/public_html/upoint_membership/index.php(27): require_once('/home/rl8klsljj in /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Database.php on line 463

@Fasse
Copy link
Member

Fasse commented Apr 18, 2021

#5 /home/rljjnww/public_html/upoint_membership/index.php(27): require_once('/home/rl8klsljj in /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Database.php on line 463

Hmm, the errorlog looks strange because it started with index.php at the main folder. There should be an errorlog that will start at /home/rljjnww/public_html/upoint_membership/adm_program/installation ...

Is there something within the logs?

@mrlawrencelam
Copy link

I found the problem.

When I first installing, I used MS-Edge browser. After submitting the online setup form, I got a message saying the password which I chose was not strong enough. I guess there is something wrong with the cache here. I tried re-installing a few times (clean new installation) and it always stuck at CREATING DATABASE. Cleaning the cookies and reopening Edge did not solve the problem.

I then changed to FireFox and installed again. There was no problem and the installation was complete.

@mrlawrencelam
Copy link

mrlawrencelam commented Apr 19, 2021 •
edited
Loading

#5 /home/rljjnww/public_html/upoint_membership/index.php(27): require_once('/home/rl8klsljj in /home/rljjnww/public_html/upoint_membership/adm_program/system/classes/Database.php on line 463

Hmm, the errorlog looks strange because it started with index.php at the main folder. There should be an errorlog that will start at /home/rljjnww/public_html/upoint_membership/adm_program/installation ...

Is there something within the logs?

Yes, there is only one line in the log file. It says my password was not strong enough although I have carried out re-installation and used a strong password.

Re-installing the script using Firefox solved the problem. I was using Edge earlier the first time it said "password is not strong enough".

@Fasse
Copy link
Member

Fasse commented May 2, 2021

@frankhubrepo Do you still have the problem at installation?

@Fasse Fasse changed the title Amidio installation stuck at creating database Installation stuck at creating database May 24, 2021
@esotericxa
Copy link

A great project, many extremely well done parts.
However, using Firefox to get around this problem;
is NOT a solution. It is a work around. NOT the same thing at all.
Seems to get stuck on IE11 and Brave as well.
Happy to help with documentation and to reduce gaps in install instructions for example,
but not directly skilled in PHP, XML and MYSQL for example.
Quite experienced at role based security design, so I will be interested in your model,
if I can ever get to see it.

@esotericxa
Copy link

Adding some logs
access.log
error.log

@esotericxa
Copy link

As in, it did not work with firefox either.
I was thinking of using this for our car club, but things are not looking good.

@esotericxa
Copy link

PHP_Error_Admidio_Install.txt
line 443 in on of the two? files named database.php gets an error...??

@esotericxa
Copy link

Actually, it did appear to install once, after a LONG wait using Edge, so I got to logo and have a look around.
Is this project still going??

@Fasse
Copy link
Member

Fasse commented Mar 11, 2022

@esotericxa Thanks for the logs. I will have a look at it within the next days.

@Fasse
Copy link
Member

Fasse commented Mar 11, 2022

There is something wrong with your database connection. But you should never get so far is you are not connected to the database. Do you got an error after you insert the database login infos?

@esotericxa
Copy link

esotericxa commented Mar 12, 2022 via email

@Fasse
Copy link
Member

Fasse commented Mar 13, 2022 •
edited
Loading

Could you have a view into your database? Has Admidio created at least one or more tables in the database?

Has the database user the right to create tables within the databse?

@esotericxa
Copy link

esotericxa commented Mar 13, 2022 via email

@esotericxa
Copy link

esotericxa commented Mar 14, 2022 via email

@esotericxa
Copy link

esotericxa commented Mar 14, 2022 via email

@esotericxa
Copy link

Hi. This is still an issue.
I posted this on the admidio forum a few days ago, about 60 people have looked at it and no response yet.
"
"5. In the next step you have to enter the access data to your database. These should have been provided by your hoster."

Since I am my own would be hoster, and there are no instructions about how to set up the data base;

this may be why my many install attempts have so far failed.

I can install the AMPPS but after that, it is all guessing and trial and error.

A working set of instruction would be a great helps here.

The instructions as they exist at this point, without this information, will fail,
unless there is and expert hoster to guide. I expect that this is very often the case.

sorry to lump more work on to the team but not sure what else to do.

Also, once you hit the install button, about how long should it take to get to the completion?
Running an intel Q8200S 8 gig ram, ssd for testing etc.

Also, the reference to security of 777 does not apply on Windows, this is described differently on windows
, and there may be an issue of
TPC/IP and NAMED PIPES ? adjustments in windows, that pops up occasionally?

Thanks
"
Perhaps some one could at least explain WHY these steps should be legitimately left out?
Perhaps a prerequisite for trying this out should be at least DBA beginner skills?
Thanks again

Fasse added a commit that referenced this issue Mar 30, 2022
@Fasse
Installation stuck at creating database #976
53aa126
Fasse added a commit that referenced this issue Mar 30, 2022
@Fasse
Installation stuck at creating database #976
722f613
@Fasse Fasse added this to the v4.1.11 milestone Mar 30, 2022
@Fasse Fasse self-assigned this Mar 30, 2022
@Fasse
Copy link
Member

Fasse commented Mar 30, 2022

I have no solution for your problem. Set up a working database is a requirement for Admidio.

But for the next version I have implement a check at installation if the current database user has the right to create a table. Otherwise a database error will be thrown, so it's easier for all to find the problem and there will be no white page at the last installation step.

@Fasse Fasse closed this as completed Mar 30, 2022
@Fasse Fasse added change and removed bug labels Mar 30, 2022
@esotericxa
Copy link

Good move. Thanks

@cybercol
Copy link

Hi,
I had the same problem as described above. Used edge and chrome but kept hanging at creating database. But solved it for me.
Two things:
Check you have no cookie blockers or adblock on the browser - I had both of these and after disabling them for my site, it created the database.
Just in case that was a fluke, just do a page refresh and see if that works - When I disabled my blockers they both did a page refresh automatically and then the database installed.
Hope that helps.

@esotericxa
Copy link

esotericxa commented Apr 21, 2022 via email

@chelahmy
Copy link

chelahmy commented Aug 5, 2022

I had the same problem with version 4.1.13. No database table was created. I'm using Chrome on localhost. Reload the page (ctrl-F5) solved the problem. Anyway, it is still a bug.

@Fasse
Copy link
Member

Fasse commented Sep 14, 2022

Maybe your problems are solved with #1307 if you use chrome at installation.

@Fasse Fasse pinned this issue Sep 14, 2022
@Fasse Fasse unpinned this issue Sep 14, 2022
@esotericxa
Copy link

I have voted with my feet. The response to this issue was unspeakably poor and the problem has basically never been addressed properly. Don't waste your time.

@Fasse
Copy link
Member

Fasse commented Sep 16, 2022

@esotericxa but this is/was not only your issue and maybe someone other is still interested in a solution.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Fasse Fasse

Labels
change module:installation
Projects
None yet
Milestone
v4.1.11
Development

No branches or pull requests
7 participants
@chelahmy @Fasse @frankhubrepo @cybercol @esotericxa @zhuguangxx @mrlawrencelam