15 minutes ago, medbena said:

I'm sorry to bother you and thank you for your help!

Personally I am not bothered at all. Glad to help out whenever I can.

Your server meets all the requirements for Ipb 4.7.x. Regarding the error that you are getting when attempting to upgrade your forum, to quote myself:

57 minutes ago, Miss_B said:

The error you are getting with the upgrade is due to a missing database table. Try to add it in the database and give the upgrade another go.

Edited January 23Jan 23 by Miss_B

22 hours ago, Miss_B said:

The error you are getting with the upgrade is due to a missing database table. Try to add it in the database and give the upgrade another go.

Hi

I don't know which table is missing, but if it is ''core_social_promote". there are two in the database, namely: "core_social_promote_content" and "core_social_promote_share"

The first one has no rows [ MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)] the second one has 25 rows and seems correct ..Maybe the problem is there

15 minutes ago, medbena said:

Maybe the problem is there

May not, since neither in blog nor in cms there is no content (never used)

1 hour ago, medbena said:

I don't know which table is missing, but if it is ''core_social_promote". there are two in the database, namely: "core_social_promote_content" and "core_social_promote_share"

That’s the table reported by the upgrader as missing from the dataabse. Both those tables that you mentioned have nothing to do with the error. You will have to readd the table that’s missing. That will make that error go away.

Edited January 24Jan 24 by Miss_B

Hi

On 1/24/2025 at 4:25 PM, Miss_B said:

You will have to readd the table that’s missing. That will make that error go away.

I added today the core_social_promote witjh five columns.

I'm not sure if this is correct, because I got this error when trying to continue the upgrade:

Incorrect table name ''
/home/oasisalg/public_html/forums/system/Db/Select.php::465
SELECT count(*) FROM ``

line 465= $this->runQuery();

I'm at the end of my patience, I think I'll stop, what a waste of time.

Thank you Miss_B

1. Did you restore a backup, add the missing table, and start the upgrade from scratch?

2. Or did you add the table and try to restart from where you were blocked?

If you tried #2, trying #1 might solve the issue. If you already did that, I can’t really think of anything else right now. 🙄

8 hours ago, medbena said:

Hi

I added today the core_social_promote witjh five columns.

I'm not sure if this is correct, because I got this error when trying to continue the upgrade:

Incorrect table name ''
/home/oasisalg/public_html/forums/system/Db/Select.php::465
SELECT count(*) FROM ``

line 465= $this->runQuery();

I'm at the end of my patience, I think I'll stop, what a waste of time.

Thank you Miss_B

I have a question, do you have a database prefix? I am asking because according to your first screenshot, the error reports that the oasisalg_core_social_promote table is missing. The oasisalg_ looks like a database prefix to me. If you do have a database prefix, you have added the table without it, and that’s what’s causing this new error imo as the table isn’t being recognised without the prefix. If you append the prefix to the table name I think the issue will be solved. i.e. the table name should be oasisalg_core_social_promote instead of core_social_promote. Hope it helps.

Edited January 28Jan 28 by Miss_B

Restore first of all, and check if you actually have the table before you begin the upgrade. Then, as terabyte mentioned, you want to start the upgrade after adding the table at that point

12 hours ago, teraßyte said:

1. Did you restore a backup, add the missing table, and start the upgrade from scratch?

2. Or did you add the table and try to restart from where you were blocked?

Hello,

Yes

7 hours ago, Miss_B said:

the table name should be oasisalg_core_social_promote instead of core_social_promote.

both are tried

7 hours ago, Marc said:

Restore first of all, and check if you actually have the table before you begin the upgrade. Then, as terabyte mentioned, you want to start the upgrade after adding the table at that point

I did it same problem

Too bad, I think I have no choice to do a new install when it is released

20 minutes ago, medbena said:

Hello,

Yes

both are tried

I did it same problem

Too bad, I think I have no choice to do a new install when it is released

On 1/13/2025 at 4:06 AM, medbena said:

Table 'monsite_forus.core_social_promote' doesn't exist #0  
/home/monsite/public_html/forums/system/Db/Db.php(1838): IPS\Db->query() #1
/home/monsite/public_html/forums/system/Application/Application.php(1766): IPS\Db->renameTable() #2
/home/monsite/public_html/forums/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3

Looking at this screenshot, the database name says oasisalg_forus, but in your op the error messages that you posted are of a different database called: monsite_forus.

I've to ask, are you sure that you are readding the missing table in the correct database?

2 hours ago, Miss_B said:

Looking at this screenshot, the database name says oasisalg_forus, but in your op the error messages that you posted are of a different database called: monsite_forus.

Sorry, it's true it's confusing.

monsite_forus is only to hide oasisalg on this topic, not a capture from database

Looking at the error log, I have had the following error for a few days:

[28-Jan-2025 18:18:44 UTC] PHP Parse error: syntax error, unexpected ':', expecting ')' in /home/oasisalg/public_html/forums/applications/blog/Application.php on line 89

ligne 89: \IPS\Output::i()->sendOutput( $document->asXML(), 200, 'text/xml', array(), TRUE, parseFileObjects: FALSE );

26 minutes ago, medbena said:

Looking at the error log, I have had the following error for a few days:

[28-Jan-2025 18:18:44 UTC] PHP Parse error: syntax error, unexpected ':', expecting ')' in /home/oasisalg/public_html/forums/applications/blog/Application.php on line 89

ligne 89: \IPS\Output::i()->sendOutput( $document->asXML(), 200, 'text/xml', array(), TRUE, parseFileObjects: FALSE );

That means you're using PHP 7 when you need to be using PHP 8.0 or 8.1 for v4. 8.1 or newer for v5.

16 hours ago, Stuart Silvester said:

That means you're using PHP 7 when you need to be using PHP 8.0 or 8.1 for v4. 8.1 or newer for v5.

In that case, then it's correct, on TeraByte's suggestion, I've rolled back to 4.7.4 for the time being to try again with IPS 4.4.0 which is the only backup I have . currently i am on PHP 8.1

Thanks to everyone who tried to help me

Hi

Now I was able to view the forum, but still unable to continue the upgrade, unable to connect to the admin cp

I also have a theme problem :

[[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

I contacted the host because there are also a PHP configuration problems.

PHP 8.0

PHP 8.1

Also I suspect FileZilla is causing me problems...is this possible?

Thank you

That looks like some files didn't upload properly. 🤔

To avoid issues like this I usually upload a ZIP/TAR file with all files at once and then decompress it from cPanel's file manager directly on the server.

Uploading files 1-by-1 sometimes has problems with certain files not being uploaded correctly. Using the single compressed file + decompress helps avoid that.

Hello TeraByte

I was using paid and/or free ftp client since 2007, never had any problem but lately FileZila seems not to work well.

Yes I will do as you recommend.

Thanks and have a nice day

15 hours ago, teraßyte said:

Using the single compressed file + decompress helps avoid that.

unfortunately for me, it didn't work.

I tried three times with the Cpanel file manager

All elements under forums are updated as of today except SYSTEM, OAUTH AND THEME which date between 2018 and 2022

Also there are no third party applications or plugins that all database tables are innodb

When I try to connect to /forums/admin it gives a blank page with the error:

[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

3 minutes ago, medbena said:

When I try to connect to /forums/admin it gives a blank page with the error:

[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Can you check the server error log and see if there are any recent messages pertaining to this?

34 minutes ago, Miss_B said:

Can you check the server error log and see if there are any recent messages pertaining to this?

No recent web server errors exist for your domain

No recent web server errors exist and no suEXEC events exist

Also my problem was reported by another member

Please ensure all access details on file are up to date, and I can take a look to see if I can see whats happening there

12 hours ago, medbena said:

No recent web server errors exist and no suEXEC events exist

Also my problem was reported by another member

Note, the issue on that one, was the path for PHP sessions on PHP was incorrect. What PHP version are you using, and have you just changed?

9 hours ago, Marc said:

Please ensure all access details on file are up to date, and I can take a look to see if I can see whats happening there

Hi Marc,

Are believed to be up to date

8 hours ago, Marc said:

Note, the issue on that one, was the path for PHP sessions on PHP was incorrect. What PHP version are you using, and have you just changed?

I use php 8.1

Just note; when recovery mode is set in constants ; it return :

Hi Marc!

An error occurred (500 Error)

We're sorry, but a temporary technical error has occurred which means we cannot display this site right now.

Unknown column 'css_added_to' in 'where clause'

You can try again by clicking the button below, or try again later.

Try again

and when recovery mode is removed and trying to login forums/admin a mapbox login appear to enter my infos after that this error in blank page appears

[[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

And login to forums:

Sorry, there is a problem

Something went wrong. Please try again.

Sorry for the delay, I just came from work

Taking a look, you dont look to have reverted to the backup done prior to your original upgrade. You need to restore to that backup first of all. If thats then not working, we need to look from there