15Degrees

Hmm yeah might be. We are using

WPRocket
Redis
Object cache
Perfmatters
CloudFlare

Ill run some tests and assume it makes the change but we just don't see it because of caching.

On 3/15/2024 at 2:41 PM, Marc Stridgen said:

Im not seeing any issues on this end. Could I just check you have the latest updates and also check there are no patches showing in the support area of your admin CP?

Hi Marc

All up to date although a patch appeared today that I have to implement. I mainly use Chrome which is all up to date.

It appears this is not just in that area. I just unchecked permissions for seeing a forum and went back in and none were saved. But then if you leave it a bit and then go back in they are all saved. It's an odd one. It's like a delay to me seeing the change happen.

Hi Guys

If I change this "post must be approved" to be unchecked and save it and then come back in the setting has not been saved? I've tried this multiple times in various groups. Is there a delay in making the change the Db accepting it or something or is it a bug?

Strewth never knew that's what they look like.

Hi Guys

Just noticed this IP address being obfuscated post upgrade. 

is this caused by my AVG on my laptop or is it an invision thing? Not seen it on any other members

Cheers
Mark

Ah got yah. Ill try that also.

Asked him today. We have URLs enabled

Bugger.

I tried deactivating our Wp-Admin redirect login plugin but yeah made no difference. This URL

https://Our-Site/community/login/ still goes to a 404 page.

Does Invision create a normal login page and also the admin login page upon installation? Could we have disabled the normal login page in settings?

Could the SSO plugin be forcing people to have to have a Wp account and only login via that route?

And the standard URL would be

URL/community/login/

We do have the WPAdmin login URL changed via a plugin. Is that what you mean?

Hmm we have 404 for that path

URL/community/login/

Do we have to create that page manually?

Our normal users access the community via logging into WordPress and then within their course (LifterLMS) they have a link on the top menu to the community that takes them there directly.

Thats fine and works for us but yeah these test users we don't want to create Wordpress and Lifter accounts for so were wondering what the direct login page URL is for users we create directly in Invision. 

Should add we are using SSO plugin

The question is what is the standard URL path for the login page for Invision? 

Hi Guys

Want to create some test accounts. What would the login page URL be if we create these as bulk by using .CSV? Admin CP does not work as I've tired that already. All our other users come via Wordpress with SSO but these ones we don't want to be or have Wordpress accounts and be in our CRM.

23 minutes ago, Nathan Explosion said:

Just going to add this to the fun...

If it was me doing this, I'd be checking if I have any other non-Invision applications installed which may have a table in the database.

For example...."links"...

With NO knowledge of what you have installed in your Invisiion environment, and NO knowledge of whether you have 1 table called "links" or more than one tables called  "links_<SOMETHING>", I'd be wondering if that was used by an application called "Links Directory"

I only have base Invision installed with Calendar. The only plugin I am using is SSO.

Either way I have deleted both links and commentmeta and it's all still working 🙂

Ill give that a try. At the moment Invision is working fine on the new Db with the new Db details. Ill now delete all the invision tables out of my WP database 🙂 and also delete commentmeta and links out of the Invision DB.

Its actually not taken me too long to do this to be honest.

Update:
 

Ok this is what I have done:

1. Copied my WordPress Db to a new Db I called Invision

2. Gone through this new DB and deleted (painstakingly) all tables that do not look like Invision

3. I now have the following tables left over

calendar
commentmeta
core
forums
links

Out of these I "think" 

commentmeta
links

Could be deleted but I am not sure.

4. I then changed the conf_global.php and edited the 

  'sql_database' => 
  'sql_user' => '
  'sql_pass' => '

With the new DB values.

5. Then I logged into the forum and it let me log in and all seems to be present and correct.

Do you think I could also delete the two tables I am unsure about?

To be clear.

I am trying to install Invision Test version on my web server.

1. I have created a database
2. I have created the user and given it permissions

So my question is because I am getting an error and as this is my web server

1. What do I put in as Hotname?
2. Database name I am putting the DB I created
2. Do I put the Username and password of the Database I have created and its user?

I know the username and password for the database as I created the database and its user.

I am running the installer because I am trying to install another version of Invision on my web server so I can see all the stock tables.

Hmm.

I started to install the test Invision to a database I have created called Invision_Test and using the TEST license key but what do I put in these two fields? 

I have tried the new databases "Invision_Test" Username and its password but I get an error saying it has no permission. I gave it full permissions when I created it though>?

For Host as this is on my web server do I put the domain name or server hostname?

Any ideas?

Oh Ive got plenty of those and they all have Wordpress in them LOL.

Ill crack on

17 hours ago, Jim M said:

You may wish to do a fresh installation to get those database table names into a new database that you delete later.

Before you go through all this work, did you just recently install your Invision Community software? Is there anything you want to keep? If you just recently started and don't have much, you could just create a new Invision Community installation into a new database and then delete the Invision Community database tables from your WordPress database.

Looking through all of the tables the only ones that look like they belong to Invision are these two

core
forums

There are a LOT of these. Nearly 5 whole pages in phpmyadmin out of 9 pages total. I assume Invision does not use WordPress options table so that one can go. Loads of tables are easily identifiable 

All the others I have looked at look like they belong to WordPress.

Ill do a test install and see what that looks like.

26 minutes ago, Miss_B said:

The best way to go about it imo is to install a new wordpress at a test folder/subdomain using a new database and then compare its tables with the ones from the database that you have used to install your Ipb and wp and omit those tables when you backup the current database so you can restore it at the new database with only the Ipb tables.

Or as mentioned above you can move the database as whole to a new database and after connecting it to the Ipb forum, delete all the wp tables from it. Either method will work. 

I suggested the wp tables as a comperasion because wp has less database tables than Ipb and it will reduce your workload. 

Yeah I could do this on a staging env. Ill try. Is there a list of Invision tables floating around anywhere? So to be sure.

1. Create a new DB with a new prefix and new user and a new DB name

2. Copy my existing WP DB to this new DB

3. Change Invision config file so it uses this new DB (Prefix, password etc)

4. Go through this new DB and delete out all the WordPress tables

Sound about right?

1 hour ago, teraßyte said:

Looks like you've used the same prefix for both Invision Community and WordPress. 🤔

Yep, an utterly stellar move on my part.

How can I extract Invision out of Wordpress DB in this case? Is there a list of Invision tables that I can select them and move them all?

4 hours ago, Miss_B said:

The reason I mentioned it is if you wanted to bridge both scripts so when someone registers at your forum it is registered automatically at the WP as well and vice versa, or if you want your forum recent posts/topics to show up automatically at the wp. i.e. stuff like that. 

Ah no I don't need to do that and our Wordpress is connected to invision using an SSO plugin which works great. I just want Invision to have its own DB now I have figured out it does not.

17 hours ago, DawPi said:

Do you have set table prefixes in the conf_global.php file? If yes then it would be easy - export only these tables as a SQL dump, import them into a new database, and update access details to that db in conf_global.php file.

Hiya

I have this in the conf file. 

I've looked at all the tables and they all start with "oni"

@Miss_BWhen you say "If you are planning to make an integration of Wordpress with your Ipb forum in the future it's better to have both databases in the same place."

Why would you do that and what would be the benefit of the doing of it?

Thanks so much.

Ok yeah, I have installed it using the same DB as my WordPress install. I made a note in my diary. It simply says

Bugger.

Question?

Is this an issue and how can I extricate it and get it into its own DB?

Cheers

Mark