AlexJ

8 hours ago, Jim M said:

Is there a second page to that in PHPMyAdmin?

Yes - that was it! Thanks for the tip. I was surprised for not finding that table.  It has only 77 records. So why it takes 10 sec and more to update this table?  

 Showing rows 0 - 77 (78 total, Query took 0.0003 seconds.)

11 hours ago, Marc Stridgen said:

You should actually contact your hosting company regarding this problem. The query there is quite a simple query, so if there are issues on it updating the data, your mysql instance would need to be optimised appropriately.

It's on dedicated server and overall MySQL is optimized. I don't see any pending locks in last 7 days. 

Locks:

Active Connections:

Row operations:

My thought was is if MySQL is not optimized - other queries will have issue as well.. but I don't see much for other queries. Those widget queries normally what I see very often. So i am targeting them first. 

Below are MySQL details from MySQLTuner. 

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 26d 12h 52m 58s (182M q [79.787 qps], 4M conn, TX: 2754G, RX: 80G)
[--] Reads / Writes: 96% / 4%
[--] Binary logging is disabled
[--] Physical Memory     : 62.6G
[--] Max MySQL memory    : 25.0G
[--] Other process memory: 0B
[--] Total buffers: 14.6G global + 71.2M per thread (150 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 22.0G (35.16% of installed RAM)
[OK] Maximum possible memory usage: 25.0G (39.93% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (290/182M)
[OK] Highest usage of available connections: 71% (107/150)
[OK] Aborted connections: 0.00%  (217/4776645)
[!!] Query cache may be disabled by default due to mutex contention.
[!!] Query cache efficiency: 0.0% (10K cached / 159M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (236K temp sorts / 31M sorts)
[!!] Joins performed without indexes: 2604207
[!!] Temporary tables created on disk: 31% (2M on disk / 9M total)
[OK] Thread cache hit rate: 99% (107 created / 4M connections)
[OK] Table cache hit rate: 99% (450M hits / 452M requests)
[OK] table_definition_cache(4000) is upper than number of tables(1754)
[OK] Open file limit used: 3% (193/5K)
[OK] Table locks acquired immediately: 99% (8M immediate / 8M locks)


-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.7% (1.1G used / 6.0G cache)
[OK] Key buffer size / total MyISAM indexes: 6.0G/121.3M
[OK] Read Key buffer hit rate: 98.8% (70M cached / 813K reads)
[!!] Write Key buffer hit rate: 18.7% (1M cached / 195K writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 8.0G/5.4G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 1.0G * 2/8.0G should be equal to 25%
[OK] InnoDB buffer pool instances: 8
[--] Number of InnoDB Buffer Pool Chunk : 64 for 8 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 100.00% (63801399921 hits/ 63801663635 total)
[!!] InnoDB Write Log efficiency: 85.36% (35910577 hits/ 42069813 total)
[OK] InnoDB log waits: 0.00% (0 waits / 6159236 writes)

11 hours ago, wegorz23 said:

check indeks on columnt in that tables. 

It shoud be:

primary: id

UNIQUE: key

INDEX: app

INDEX: plugin 

but u can add more if in select statement in where is column. 

 

in my db i have about 42 rows in that table so it cannot take that time to do something.

 

Now this is interesting: I don't even have that table. @Marc Stridgen Is it because, I am using Redis? 

Hello,

Getting below error:

/*xxxx::xxxx::IPS\_Widget::__toString:18476*/ UPDATE `ipb_core_widgets` `core_widgets`  SET `caches`='{\"widget_topicFeed_86uiii4of_60d6ddb21f110bf3c9024baf58e4fcbd\":1676231243}' WHERE `key`='topicFeed' AND app='forums';
# Time: 2023-02-12T19:47:34.620616Z
# User@Host: xxxx[xxxx] @ localhost []  Id: 4064016
# Query_time: 11.263576  Lock_time: 0.000029 Rows_sent: 0  Rows_examined: 1
SET timestamp=1676231254;

I often see above in Slow Query log. Is their any reason why widget is taking 11 sec to update? I see problem with topicFeed, upcomingEvents, etc in widget. 

Is their any performance issues with Widgets getting updated? Thanks.

Some users create empty Albums and never upload any pics. it would be nice to have an option to delete Albums without any images after xx days or months. Thanks

On 1/31/2023 at 4:25 AM, Marc Stridgen said:

Ive been doing some testing on the latest beta and Im unable to replicate this at all currently. Please test this once that is released and let us know if you see the same

Error still exist with latest version 😞  

On 2/6/2023 at 12:24 AM, Afrodude said:

@AlexJ what Redis version are using at this moment? I am using 7.0.8 latest stable version. 

1% (38.84M/23.27G)

This is usually happened whenever you clear your site system cache, and then once it finished building the new cache it goes down to 40MB. Is this what happen with you or there's something else? 

Exactly - yes. So we are saying it's normal to go less memory consumption after few days? I thought cache should grow and not go less. 

1 hour ago, The Old Man said:

Redis no longer stores the page cache which could get pretty hefty, so it would be smaller than before. Apparently IPS doesn’t clear the Redis cache when you run the support tool btw.

I noticed that. had to restart Redis application.

On 8/15/2021 at 6:50 AM, David.. said:

On mine, it is currently at 100MB.

On 8/14/2021 at 1:34 PM, Afrodude said:

Because we are waiting on the new release. You should have seen my site was taken 250MB from the ram, and normally 70MB before the update. Now after this patch back same range 68MB, and the site seems back to how it was with 4.5 version. 

I have similar question. I am noticing odd pattern in reddis. Wouldn't memory consumption increase or remain same over the period? I am not able to follow how reddis consumption goes from 250MB appx to 40MB appx. 

Sharing since you folks are also using reddis and rather then creating new topic, this topic down the road, might hold useful info for other users as well.

12 hours ago, Jim M said:

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

No change on my end. Can you please clarify: Admin CP or FTP issue? 

Update: I had display name login disabled. So i have updated email for it. Can you please re-try.

2 hours ago, Gary said:

Discord appeals mostly to the gaming sector as they build their platform to support gamers.

That's not true, trust me. I think AlexWebsite note is right on the point i.e. monetizing. I have seen much larger groups for Trading and other things. I used to think as well i.e. Discord is popular in just gaming but when I noticed other groups focused on Infra/Ops Monitoring, Trading, OpenAI etc. my perspective has changed. 

5 hours ago, AlexWebsites said:

I have multiple licenses and although not happy about the direction, I can understand business models changing. I don't fault IPS for evolving and differentiating services. At some point I will probably have to make some hard decisions myself, hopefully way down the road. Cloud pricing just does not compare to having multi-license self server/hosting.

You are not the only one. A lot of people are in the same boat. I have a feeling, eventually, folks will move to Discord or FB pages because both are complete free of cost. 

For those who can manage with current changes/cost, will continue to do so but I see slim chances, that initial forums will pay 90$/month i.e. 1K/year appx while they are just starting their forum. So discord would be massively popular down the road i.e. much more then now, unless XF or VB or phpBB alike, will fill in that spot. I haven't checked other forums in last decade. 

I would say 70-90% gaming communities have now discord available and it's picking up game by introducing threads, Q&A, etc. features. My only gripe is I don't own the data and if tomorrow Discord discontinues their service, all the valuable conversations, data, etc. is gone.

It will be interesting times down the road for sure with IPS going Pro Cloud vs Discord, FB, etc. complete free of cost. 

Need help with Twitter login. Details and error shared in this post. Probably, I am doing something wrong but not sure what...Thanks in advance.

Hi @Adriano Faria - Website shows 3 contact us and it's confusing for users.. Can you please take a look. May 1 at top and 1 at bottom might be ok? 

15 hours ago, Marc Stridgen said:

In the first instance, please test this on a default theme, with no 3rd party items enabled. If you are then still having problems, please let me know which browser you are using

Have issue in Chrome latest version on default theme. 

@Makoto Your latest 2nd update seems to have fixed an issue. Please let me know if you need ACP and I will PM u the info. Thanks much!

On 1/16/2023 at 6:33 AM, Marc Stridgen said:

Do you already have it set as using mb4 in your conf_global.php file? If so, thats likely why you are not seeing the option to convert to mb4

Sorry, I don't have that set in conf_global.php. Interesting updating is when I updated another forum from 3.4.x to latest version, i see different behavior. 

The one in problem seems to be regularly updated. 

On 1/15/2023 at 5:36 PM, teraßyte said:

And all the utf8_unicode_ci tables in your screenshots are old/unused tables the upgrade process failed to drop. Or probably tables from old modifications that weren't removed properly (like the ipb_jlogica_XXX tables).

Is their anyway for me to figure out which tables are not used, so i can drop them permanently?

Thank you both.

@Marc Stridgen Any update on this issue? Thanks

Make portal default app:

Shared login detector -> Detects how many users from same Browser. 

MAD -> Detects how many users sharing same account based on IP and Device login? 

Did I  got correct understanding? Thanks 

9 hours ago, Marc Stridgen said:

The only way to resolve that would be to limit the size of uploads unfortunately. They are not being allowed to upload a profile photo larger. They are linking to an item you have allowed a larger upload limit on.

Then gallery becomes useless... So let me explain:

Gallery permissions

Profile permissions. 

Since profile permissions are useless i.e. it can be bypassed with Gallery permissions, we should fix Profile permissions. This way, even though it's uploaded in Gallery, user can't set those images as Profile. 

OR tell me how can I disable, option i.e. Set photo as profile image so users can't abuse it. 

Please read this topic, as it has good tips and suggestion. I hope your husband recovers faster.

https://invisioncommunity.com/forums/topic/471617-spam/

50KB can by-passed by upload pic or gif in gallery and then using option, set image as photo in profile. 

So someone uploads 10MB pic in gallery and now their profile pic size is 10MB. Next thing what happens is 30 users doing that.. and now everyone needs to download those images, to load the forum. Can something be done about this? GIF's are the worse offender. Thanks.

@Makoto - I still have same issue.. after your latest update. 

I played around and I was able to fix it.. by enabling require a prefix. Above error comes if Require a prefix is disable. 

Can you please check from your end? Thanks

4 minutes ago, Jim M said:

We are not able to access it at all. I have messaged you our VPN IP address.

Thank you for quick response. Replied and whitelisted. 

9 hours ago, Marc Stridgen said:

Its still coming up "Access denied". Not getting as far as the login

Sorry not following. I am not seeing any Failed Admin login:

Are you saying, you can't open admin page all together OR website? can you please clarify the error? 

If you are restricted from opening website, can you please share your RAY ID? I am guessing, later i.e. you are not able to open website and your IP might be under one of the datacenters. I can manually whitelist your PROXY/Datacenter ASN. 

Thank you.