New Install Ver 2.2.4 Problem

[banderson407]

Trying to do a fresh install of version 2.2.4 but can't get past the point where it keeps telling me the database is not in UTF8 (see attachement)
But the database is in the correct format (see attachement).

Any ideas how to get past this point?

Brad

[gregrgay]

Perhaps its the connection that's not utf-8. Try running the provided query, if you have not already. and see https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html

[banderson407]

I had wondered about that.
This what I noticed when I was in PhpMyadmin

If that is the case, how would I change it?

[gregrgay]

There's a few ways to do it, described at the link provided.

[banderson407]

I can change it on PhpMyadmin but the change is only for that session.

We use a Grid server that is a shared server so sometimes we can't make some changes, I'll have to check with them.
Is this something new for the newer versions of Atutor, I don't remember it being an issue with the older ones or perhaps changes by my hosting company?

Is this current connection type ,if it can't be changed, going to cause problems going forward with my current installs?

Sorry to bother
Brad

[gregrgay]

Somethings probably changed on the server side.
Uncomment the utf-8 line(s) //$db->query("SET NAMES 'utf8'"); in:

ATutor/include/lib/mysql_connect.inc.php

Line 23 in 155526c

//$db->query("SET NAMES 'utf8'");

[banderson407]

Thanks Greg, I don't know how you keep it all straight in your head.
I'll try that this evening.

I tried one of the queries and it looks like because it's shared I might not be able to change it.
Hopefully this will get me around it and complete the install.

Probably have to look at changing my hosting plan to containers or dedicated pretty soon.

Thanks again
Brad

[banderson407]

Uncommented the two lines in the routine.
Lines 19 and 23 but still can't get past the error.
Double checked to make sure the database was still in the right format and it is.

[gregrgay]

It's going to take some analysis to figure this out, which I'll have to leave to you. Start by using the debug() function to output variable values etc, after enabling debugging in the include/vitals.inc.php file with "define('AT_DEVEL', 1);" near the top of the file. (also be sure the php/mysql versions are compatible with the system requirements)

start here

ATutor/include/install/install.inc.php

Line 459 in 57f990d

/* Check if the database that existed is in UTF-8, if not, ask for retry */

[banderson407]

Greg,
Thanks for a starting point.
Pretty sure the current versions are okay but let me know if you see an issue:
Php Ver. 7.3.11
MySql Ver. 5.6.32-78.0

Thanks
Brad

[banderson407]

Greg,

Not sure if you are still active on this or not but worth a try.
We were attempting to move a copy of the production ATutor instance to another server.
I compressed and moved the code base and dumped the database and imported it but when I tried to access it just a blank screen...just hangs.
Figured I would try a fresh install of 2.2.4 and after putting in the database connection info and selecting 'next', same thing...blank screen and hangs.
Does this sound familiar to you?
Do you know a good place to start looking ?
We are running :
Ubuntu 22.04
Apache 2.4
PhP 7.3
MySql 5.6.51

Thanks in advance,
Brad

[atutor]

Hey Brad, Sorry for the delayed reply, I'm not really paying much attention to ATutor these days. I'm not sure I can advise much beyond enabling debug in the include/vitals.inc.php file and doing some debugging. It been a few years since I've looked at ATutor, and I've not been keeping up on changes to PHP/Mysql etc. that might have an effect if there are new settings etc.