21 September 2022, 11:05

Hi Asi,

Thank you - that screenshot is very helpful! When I run a MySQL DB server with Mahara, my settings are 'character set UTF8mb4 collate utf8mb4_bin'. Try updating your settings to match.

Additionally, I wonder if this forum post might help. It references phpMyAdmin and other community members solving a semi-related installation issue by updating their database collation.

Best,

Doris

21 September 2022, 17:45

Hi Doris,

I was able to correct the two error messages from the php error logs.

1. mysqli error: [1709: Index column size too large. The maximum column size is 767 bytes.]

Solution: In WAMPSERVER select MYSQL DBMS > MySQL settings > innodb-default-row-format = compact, compact being the default value, change or select 'dynamic' from the drop down options and this solves this maximum column size error.

2.mysqli error: [1050: Table 'event_type' already exists]

Solution: I drop all the tables in my 'mahara' database and then re-install mahara by browsing to localhost/mahara and click install and mahara installation completed successfully without any error.

I really appreciate you assistance which guided me in the right direction to solve this errors.

Thanks and Best Regards,

Asi

22 September 2022, 10:26

Hi Asi,

That's great that you got past the errors and could successfully install Mahara!

I hope you and your Academy will enjoy using it~

Kind regards,

Doris

22 September 2022, 18:04

Dear Doris,

I am now facing an issue with accessing "mahara.local" from local network. The following were added to the firewall inbound access rule;

1. wampserver

2. httpd.exe

3. Port 80

Not a success after these settings and wamp server all services restarted.

Also, see httpd-vhosts.conf notepad file attached.

Your kind assistance is always appreciated.

Best

Asi