Database problem

Thunde · Post by **Thunde** » Wed Jan 26, 2022 8:01 am

Hi, I had the forum closed for 3 days due to an error (I don't know what it was, related to the database) now I made an older backup I go into it, but when I enter a topic I have this error

forum address: https://www.metin4you.ro/
phpbb : 3.3.5
theme: milk v2 (and so does the prosilver)

warmweer · Post by **warmweer** » Wed Jan 26, 2022 8:39 am

Thunde wrote: ↑Wed Jan 26, 2022 8:01 am Hi, I had the forum closed for 3 days due to an error (I don't know what it was, related to the database) now I made an older backup I go into it, but when I enter a topic I have this error
...

Posting the error as text using code tags is usually clearer than a picture
For one: that older backup, is that a database backup only or also a files backup?
Reason = styles/Milk_v2/theme/ro/stylesheet.css seems to be missing

Also you have a lot of extensions: are they all phpBB 3.3.5 compatible? ( check Who visited this topic).
Also are they all compatible with PHP 7.4.27 ?
You could try disabling all extension at once, and then enable them one at a time.

Thunde · Post by **Thunde** » Wed Jan 26, 2022 8:47 am

Also you have a lot of extensions: are they all phpBB 3.3.5 compatible? ( check Who visited this topic).Yes
Also are they all compatible with PHP 7.4.27 ? Yes
did I remove the extensions, do I have to delete the data as well?

Post by **thecoalman** » Wed Jan 26, 2022 8:54 am

Looking this error up I'm presuming your host upgraded MySQL. The ONLY_FULL_GROUP_BY is stricter default mode in higher versions of MySQL. Looking in phBB's bug tracker there is some older tickets related to this but nothing recent. As warmweer suggested it's likely related to an extension that has incorrect query syntax using that mode.

Post by **thecoalman** » Wed Jan 26, 2022 8:56 am

Thunde wrote: ↑Wed Jan 26, 2022 8:47 am do I have to delete the data as well?

If it's only one extension and you can get into ACP try disabling it. Purge phpBB'S cache afterward.

warmweer · Post by **warmweer** » Wed Jan 26, 2022 8:57 am

Thunde wrote: ↑Wed Jan 26, 2022 8:47 am did I remove the extensions, do I have to delete the data as well?

I take it you removed the extensions, meaning deleting the extension files.

Adding to thecoalman's information: if you have removed extensions, then

The correct way of doing that =
1: disable the extension (ACP)
2: delete data (ACP)
3: delete extension files (server)

So you should put back the files of any extension you disabled and removed without having deleted data, and then remove them the proper way.

Thunde · Post by **Thunde** » Wed Jan 26, 2022 9:01 am

You're right it's from an extension
Thanks for the advice, now I'm trying to see what it is

Post by **thecoalman** » Wed Jan 26, 2022 9:03 am

Thunde wrote: ↑Wed Jan 26, 2022 8:47 am ( check Who visited this topic).Yes

It is that extension, there is fix here:

https://www.phpbb.com/customise/db/exte ... pic/227356

Thunde · Post by **Thunde** » Wed Jan 26, 2022 9:15 am

thecoalman wrote: ↑Wed Jan 26, 2022 9:03 am
Thunde wrote: ↑Wed Jan 26, 2022 8:47 am ( check Who visited this topic).Yes
It is that extension, there is fix here:

https://www.phpbb.com/customise/db/exte ... pic/227356

Thanks, you're a wonderful man

janus_zonstraal · Post by **janus_zonstraal** » Wed Jan 26, 2022 9:28 am

How old is that database backup?
I think that it is better to solved your problem than putting back a (very) old backup.

Thunde · Post by **Thunde** » Wed Jan 26, 2022 9:37 am

janus_zonstraal wrote: ↑Wed Jan 26, 2022 9:28 am How old is that database backup?
I think that it is better to solved your problem than putting back a (very) old backup.

I solved the problem for the most part, I only have 2 forums left that don't work
https://i.postimg.cc/02dSxnQ0/image.png

Post by **thecoalman** » Wed Jan 26, 2022 9:42 am

Try purging phpBB's cache.

Thunde · Post by **Thunde** » Wed Jan 26, 2022 9:50 am

https://www.phpbb.com/customise/db/exte ... tar_status
that was the problem