when in phpBB install i get this error and it gets stuck at 15%

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Helter Skelter
Registered User
Posts: 175
Joined: Tue Jan 25, 2005 8:22 am
Location: integramod.com

Re: when in phpBB install i get this error and it gets stuck at 15%

Post by Helter Skelter »

It's likely your problem was not php8.3 or XAMP. It was probably mysql. The latest versions ship with STRICT_TRANS_TABLES enabled by default. Ive not tried to install phpBB3.3 with mysql strict mode enabled but recently it sure caused a lot of work running phpBB2 and phpBB3.0.14
You can check in phpmyadmin by running this

Code: Select all

SELECT @@sql_mode;
Your previous version of XAMP probably returned something like

Code: Select all

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
if this was the cause you can turn off STRICT_TRANS_TABLES by running this

Code: Select all

SET @@sql_mode = sys.list_drop(@@sql_mode, 'STRICT_TRANS_TABLES');
If that is not the cause, your better off leaving it enabled because it is more secure.
Also note that turning it off this way is not permanent, so restarting apache will enable strict mode again. To turn it off permenantly youll need to edit my.cnf and youll also want to remove NO_ZERO_IN_DATE, NO_ZERO_DATE and ERROR_FOR_DIVISION_BY_ZERO as they are all part of mysql strict mode
User avatar
imgoingtoeatMySQL
Registered User
Posts: 16
Joined: Sun Oct 13, 2024 3:17 am

Re: when in phpBB install i get this error and it gets stuck at 15%

Post by imgoingtoeatMySQL »

Helter Skelter wrote: Mon Oct 14, 2024 11:53 pm
got it well I got it to work thanks though :D
"if it dosent work i will make it work" -me
heres my phpbb forum http://70.106.216.12/
(The server is down from 11:00 PM UTC to 4:00 PM UTC)

Return to “[3.3.x] Support Forum”