1 otterine Feb 02, 2023 18:15
3 otterine Feb 02, 2023 19:01
I don't know how to "drop a table."
It's not that I am trying to downgrade. I tried to upgrade from 6.11.3-stable to 7.2.5-stable on Jan 29 2023 and then made a mess of trying to fix it, so I had the webhost restore my files to a Jan 23 2023 backup date. But, something must not have been changed with that restoration, because I'm getting the database error. I don't know how to fix this.
As for PHP/Maria -- those were those questions I was asked in the form for a support ticket, but I didn't know what to answer.
Do you know what I need to do from here to get my blogs back working? Either to 6.11.3-stable or to the latest without issue for pixelgreen?
Thank you!
4 amoun Feb 02, 2023 23:08
Yes the restore of files took you back to 6.11.3 which wants the old database, hence a downgrade.
So are you not familiar with database manipulation via phpMyAdmin? If you are you maybe able to change the database version number in the database, back to 13220
Unless you can change the database version, you will have to go back to installing at least 7.2.1 that's the earliest that uses the 16170 database.
If you get it working and can change the skin from pixelgreen do that to at least get the site usable.
That pixelgreen isn't really compatible with the updated b2evo and was never an official skin, there are no updates for it.
5 otterine Feb 02, 2023 23:22
No, I don't know database manipulation via phpMyAdmin unfortunately.
I will try your suggestions. Thank you!
6 amoun Feb 03, 2023 19:00
No, I don't know database manipulation via phpMyAdmin unfortunately.
You have access to CPanel on your host from where you can access phpMyAdmin probably
7 otterine Feb 03, 2023 23:16
I definitely have access to phpMyAdmin, but I don't know what to do from there.
I am waiting for another backup restore by the webhost because it doesn't seem the one they just did was complete, which is its own issue. Once that is done, I will see what the status of the blog is.
8 amoun Feb 04, 2023 15:55
Using phpMyAdmin you can search for the database version and change it.
Make sure you have a backup of the database in case it doesn't work or another error arises.
You may also want to try searching the forum more, here are similar topics and posts:
https://forums.b2evolution.net/how-to-tell-database-version
https://forums.b2evolution.net/b2evo-version-and-database-version
especially the second one second post
9 otterine Feb 12, 2023 18:10
I was able to get the webhost to fully restore back to 6.11.3.
10 amoun Feb 12, 2023 18:21
Ok sounds good.
In reverse order
Drop the table before you try the next time
You seem to be trying to downgrade from 16170 to 13220 which is not possible
PHP/Maria
b2evo > /config/advanced.php
Mismatching the b2evo version and the database version seems more of an issue than the php and maria,