E11

Sorry for my delayed response Adriano. I really appreciate your feedback and the recommended workaround.

I'll give it a try. Maybe I'll have to create a custom solution or - if exist - purchase any available alternative from Store.
Will check this as well. 

Again, thank you very much for taking the time and responding to my query.

Dear all, 

is there any way how to exclude specific forums/subforums from appearing in activity stream?
I have a couple of RSS feeds which automatically creates new topics. Especially those I'd like to hide from regular community member created content.

Would be great if someone could assist with a solution.

Thanks in advance

E11

you saved my day teraßyte.

phew, what a nightmare. 
But yeah - time for another venture.

Thank you all, again, all contributors everyone who tried to assist.

Great community, great spirit.

Hello tearbyße, it gives me a good feeling that you are still with me and didnt give up already.
I really appreciate this kind of assistance.

This time the case might be more difficult.

After the login into the upgrade process the dialog #a is shown

when clicking on #2 exactly one second later screen #3 is shown.

Millon thanks to you teryßyte - the code you provided allowed me to continue the installation process.

I think I'm half through - the install unfortunately stopped again.

Error message dialog says the following

The same error message appears when I use the core admin URL

https://www.forum.com/community/admin/

I'm walking through the hell currently ;-), thank you teraßyte walking with me .

Yes, in the past we had dozens of custom built hooks. All good suff, teraßyte mods were amongst.

Would it help if I remove the entire cotent of the hooks folder or is this dangerous?

The error logs refers to 

PHP Warning:  Illegal string offset 'forum_id' in /www/htdocs/xxx/community/hooks/ajaxThanksPostData

but I'm nt really sure if this causes the issue because the forum is off.

Update - seems I'm not done with the challenge.

Upgrade process stopped here

phew, another tricky thing. Does anyone had to deal with that in the past?

Any hint or advise would be appreciated.

+Update,

the datastore is a 'drive me crazy' element.

The UTF convert process stopped at 14%, because it had an issue with converting Tapatalk tables.

As I dont need TT, I decided to remove all tables. Started the coverting processes again. Same problem after 14% was reached, Tapatalk was mentioned again as reason.

I followed Stuarts recommendation and cleaned the datastore - hey and voila, It worked as well

YEAH Stuart, damn, that was the issue solving hint.

I owe you a pint my friend. Thank you very much for re-checking that thread and the assistance.

I'm lost with that f*cking sys-check..... very frustrating, tbh.

I reuploaded all installation files and I get the same stuff shown on the screen.

Does anyone have an idea how to bypass the check which blocks the entire system. 

Hello @all - to be honest, currently I'm feeling a bit lost with that Nexus stuff.
Even if I followed all the advices and hints and where I removed orphaned Nexus tables and Hook references the system cant bypass that check. 

Is there really no other way that buying the Commerce Module to proceed?

Or could it be that the result of the initial check refers to any Cache-file which maybe have to cleaned/reset manually?

I double checked the DB tables - there are no tables left which refers to nexus.

A global search within the DB came to the same result. 

Update: I found under /hooks/ two PHPs which were connected to Nexus - removed as well, Error message remains 

Yes there is a record Mark - but there is obviosuly another issue. 

I removed the record and in Install check is still showing the Nexus Message. I logged out and tried it again - same message

Hello Mark H,

thanks for your feedback.

I checked PHPMYadmin and you are right, there are two tables referring to Nexus.

If these tables are orphaned and no longer used or needed I'd remove it from the DB.

Update: Tables deleted - issue remains.... 😞 hmmm, any additional ideas what other process the issue triggers?

Hmm, good Point Randy. Problem is that I dont see any folder /nexus/. 

The error says that it is expected under the path /application/ but there is just that content - no nexus'

1 minute ago, Randy Calvert said:

Nexus is now the Commerce app.  Do you still have that one associated with your license?

Not yet Randy. Maybe decide it later on bying it. For the moment I'd try to get the current stuff fixed as you can imagine.

Thanks Gary, yep I'm happy so far.

I uploaded the files (v4) and prepared everything. Installer is running, but system check detects an outdated Nexus

I believe Nexus had reach its End of life process. 

What can I do to bypass that message?

The info that I had Nexus installed must come from the v3. I assume. 

/www/htdocs/xxxxx/community/applications/nexus/Application.php

Update: With you great assistance guys I was finally able to setup a copy as archieve. Thanks again all of you for your support. That helped a lot.

Next Step: Upgradting from 3 to 4

Hello teraßyte,

another huge thx to you my friend.

Settings were found here:

System Settings  >  System  >  General Configuration

1. Website address

2. Images URL

HOME works,

where I'm currently not sure is how I have to deal with subdomain in settings

'Path to 'upload' directory ' and

'Upload URL'

Current form is located in a subfolder

http://www.my-forum.com/community/uploads

but now it is located in a sub-domain

http://community.my-domain.com/

Would this path be the correct one to find the uploads

http://community.my-domain.com/uploads

Dear all, thanks for your valuable feedback. This is very much appreciated.

To share some more information, maybe someone is interested in the progress we made on our side.

We will keep the current state of the community but run it behind a htaccess protection. 
Reason for that step is that we developed dozen of tailormade hooks in the past which I expect that they will stop  working after the upgrade has been processed. Thats ok, and I'm aware that it is needed to redevelop it.

The backup-board allows me to demonstrate new developers what we have developed in the past - up to a certain extend it can be used as reference. 

We copied the forum files successfully into a subfolder (the protected one). We connected it successfully with a new database, where the database is a copy from the current live system. Everything runs smoothly - except three issues we cant fix because we have no clue where to change the settings.

Maybe the one or the other can assist us here as well to find a solution or guding us in the right direction.

Issue 1: The Home Menue is linked to the live system. I assume this is somewhere hardcoded. 

Issue 2: The member’s profile pictures still lead to the main domain (path 'uploads')

Issue 3: Asset images leads also to main domain (path 'public/style_images')

All the rest seems to work incl the access to Mod-ACP and Admin-ACP.

10 minutes ago, Adlago said:

Login ftp

Open .../admin/applications/core/modules_admin/mycp

and replace dashboard  php with

this

dashboard.php 21.82 kB · 0 downloads

Hrhrhr, that works. Yeah! 
Another step further. Thanks a lo for that Adlago. 

29 minutes ago, Stuart Silvester said:

You'll likely have a hard time getting it to work on anything newer than MySQL 5.5. You don't however need to be able to load the AdminCP to perform an upgrade. You can upload the new v4 files and go directly to the upgrade process.

System says PHP Version 5.6.40 - any chance to initiate the upgrade process from ACP or is uploading the install package the only option?

Just now, Stuart Silvester said:

You'll likely have a hard time getting it to work on anything newer than MySQL 5.5. You don't however need to be able to load the AdminCP to perform an upgrade. You can upload the new v4 files and go directly to the upgrade process.

Hi Stuart, 

also thanks to you for assisting.

Just a short update after playing a bit with that what Adlago recommended.

I was able to login - My Dashboard (menu item) generates the error, but another menu item allowed me to get into the ACP. Cheers guys!

I hope from here I can start the upgrade process. If not, I think I have to follow your recommendation @Stuart Silvester - uploading files and go from there

4 minutes ago, Adlago said:

 

After  {session key} add

&app=forums

then Enter

Ah, understood. Thx for the additional hint.

Following that, I come one step further. Even if it looks odd. Seems that CSS isnt loaded. 

23 hours ago, teraßyte said:

That page means there is some kind of issue with a MySQL query or the MySQL server itself. It should save a log in the /cache folder and you can look up the actual error there.

Hello teraßyte, 

thanks for your feedback as well. Also very much appreciated.

I found in /cache the following logged 

(sql_error_log_01_03_23.cgi)

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 03 Jan 2023 21:45:47 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM ibf_sessions WHERE running_time > 1672778747' at line 1
 IP Address: XXX.67.137.8 - /community/admin/index.php?adsess=4b81af91e85926794c7ae60372897525
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM ibf_sessions WHERE running_time > 1672778747
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

and (sql_error_latest.cgi)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 03 Jan 2023 21:45:47 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM ibf_sessions WHERE running_time > 1672778747' at line 1
 IP Address: XXX.67.137.8 - /community/admin/index.php?adsess=4b81af91e85926794c7ae60372897525
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM ibf_sessions WHERE running_time > 1672778747
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

To be honest, I've no clue how I could back the control of that marauding ACP 😉