Toni Font

Thank you very much Marc. We have detected and blocked a malicious IP belonging to a Bot that was posing as a Chrome user and was saturating our database. We can close the thread. Thank you very much for your time and help.

I updated the details, sorry

1) OK, Well. 2) Rafillapm https://www.nikonistas.com/digital/foro/topic/506739-código-de-error-2s1191 3) No, nothing. On Monday we did a mass mailing. We usually do 1 or 2 a month.

Hi Marc, thank you very much for your quick response. It's not that I don't think I can get support. It's just that I can't request it privately by email, as I used to be able to. The error is shown to the user when logging in. The problem is not the origin of the queries. The problem, as you can see in the graph, is that they have increased by 600% without any action on our part. Before writing we have restarted the services, we have enough CPU and memory that have managed the load perfectly until yesterday. I don't think the solution is to increase CPU or memory. The forum tool is causing this increase in queries for some reason.

Hi, We are paying for a support plan and we don't understand how we can't send a ticket by email. We have a problem with the forum since yesterday. It is running very slow. A user tells us that when accessing shows the following error: 2S119/1 The server managers pass us the following data. Seguimos viendo que las siguientes queries están generando toda esta carga de cpu: | 10751 | nikonistasforo | 10.210.148.2:8822 | foro_ipboard | Execute | 0 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? | 544 | 0 | 0 | | 10752 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0 | 0 | 0 | | 10753 | nikonistasforo | 10.210.148.2:8826 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1435 | 0 | 0 | | 10754 | nikonistasforo | 10.210.148.2:8832 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1198 | 0 | 0 | | 10755 | nikonistasforo | 10.210.148.2:8834 | foro_ipboard | Execute | 1 | Sending data | /*foro_ipboard::nikonistasforo::IPS\Data\Store\_Database::loadIntoMemory:108*/ SELECT * FROM `ibf_core_store` AS `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') ) | 1198 | 0 | 0 | | 10756 | nikonistasforo | 10.210.148.2:8838 | foro_ipboard | Execute | 1 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? | 563 | 0 | 0 | | 10757 | nikonistasforo | 10.210.148.2:8840 | foro_ipboard | Execute | 1 | statistics | /*foro_ipboard::nikonistasforo::IPS\Session\Store\_Database::loadSession:95*/ SELECT * FROM `ibf_core_sessions` AS `core_sessions` WHERE id=? Can you help us? Toni

Thank you very much Marc. Sorry, BBDD means database, abbreviation in my language, the habit... Ok, so there is no solution, I imagined that Maxmind would have a bug reporting service even if it is the free database. Thanks for your help.

Do you know exactly which BBDD uses? Bugs can be reported on this page. https://www.maxmind.com/en/geoip-demo Although, on this page the IP information, which we are talking about, is correct.

Show the address IP correct, but the information provided is incorrect.

Hi, We have activated the management of connected devices and in some cases the location of the IP that shows the user is wrong. This information causes discomfort because it is not a close location of the user. For example: IP- 88.5.20.198 The IPBoard IP Tool show "Barcelona, Catalunya" and the right location is Zaragoza (another autonomous community) The user don't connect via VPN. I check this IP in other IP tool https://www.cual-es-mi-ip.net/geolocalizar-ip-mapa and show the right location Is there any solution? Can the IP lookup tool be changed? Thanks, Toni

I have version v4.7.6, I have my own design on the home page and somewhere internally, do you know if I update it to the latest version 4.7.8 will something change in the design?

Thanks Marc. We have done the unarchiving in all the threads of a forum from the AdminCP. Now we wanted to reapply the archiving rule.

We have a problem with the archiving of old forums. From always we have the archive of forums that have not had movement in the last 5 years. For a cleaning reason I had to unarchive a lot of forums to hide or delete blocked posts because if the forum is archived it does not allow it to be hidden or unblocked posts. To unarchive them I have done it through the AdminCP, removing them from the list of forums to archive. Now, I have the problem that once the cleaning is done, I put them back in the list of forums to be archived in the AdminCP, but it doesn't archive them. I have seen that in the moderation actions of a forum the option "Allow this topic to be archived" appears, but this action is one by one. Is there a way to bulk re-archive unarchived forums? Thank you.

Thanks a lot @Marc Stridgen This is very easy... 😬

Hi, Where is the content of variables beginning with core_pfield translated? I can't find them in "Languages" and I need to translate: core_pfield_11 core_pfieldgroups_1 Toni Invision Community v4.7.6

Hi @Daniel F and @Faqole, Is there now a stable version of this hook that works in Invision 4.3? Thanks