AlexJ

Moving the site from 'forums' folder to root folder. Can anyone help with htaccess 301 redirect, so old index content by google doesn't get mess up? Thank you. This is the current htaccess: <IfModule mod_rewrite.c> Options -MultiViews RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteRule \.(js|css|jpeg|jpg|gif|png|ico|map|webp)(\?|$) /404error.php [L,NC] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule>

Most of the things are not applicable. I am not sure if you are trolling... or trying to help with odd suggestions. Site is online, server location can't be changed - CF picks location nearest to you, caching is enabled (Redis), PHP is 8.1 with latest IPS version and I use dedicated server.

Sometimes people don't have access to their email and password is stored in browser for many folks. U should avoid doing that. It will cause pain for a lot of members. +1 OR I see brute force attempts on week password from this IP's. I noticed that for 2 user accounts on our forums. When I asked them they had very week password, even though IPS default is moderate i believe. So we changed after 3 attempts account gets locked for 12 hrs.

That would be hard because Google Login in itself is direct auth - you are good to go. Only 3 options: 1. Word/URL filter based moderation 2. IPTable 3. If you have cloudflare - ASN bans.

This is why you ban ASN. Banning CIDR's will do no good and eventually it will take toll on CPU consumption on your server. However, if you do ban IP address, make sure to block at PREROUTING / RAW so it's quick and fast.

Then you didn't read my topic all together. Request was for 4.7.3 has terabyte suggested. But thanks for clarifying. During renewal - nothing is mentioned that previous upgrades are not supported anywhere. I didn't even received communication from IPS that 3.4.x upgrade is EOL and upgrade will not be supported. I don't even know where Jan 2022 came to the picture. I browsed the forums, saw the post that 3.4.9 is supported and renewed the license. Example: Again you are not understanding. Your latest release is not working for the upgrade. I don't think you are even bothered to check what issues I mentioned. This are part of your upgrade script. For me to use latest version, I need to be able to migrate. As of today, I can't to latest version because your latest version upgrade scripts are buggy. It's one thing to provide no support and completely another when upgrade script fails during execution on near vanilla IPS 3.4.9 version. You could have dome simple thing for me to help: Share 4.7.3 version and see how it goes and then upgrade from 4.7.3 to 4.7.6. A simple small help could have gone long way but even that you don't do anything. I can't believe how IPS support is treating their customers now then how it did few years back.

For those using Cloudflare (CF), very simple solution. Do managed challenge for this ASN's. CF firewall is extremely fast. This IP ASN: AS56380 - Normally all this spam bots use VPN/Proxy or datacenter IP's. https://ipinfo.io/AS56380 https://www.ipqualityscore.com/free-ip-lookup-proxy-vpn-test/lookup/109.107.166.230

Have requested for refund for this particular license renewal as I don't have a choice because of zero IPS support. I wish, IPS team would understand customer issues or provide help, so your customers can upgrade.

How can I retain them dude when I don't even have it! I am seriously frustrated with IPS attitude of no help for the upgrade. I renewed the license to upgrade the forums... now it's like not IPS problem, so IPS got renewal fee. I renewed in good faith i.e. based on general document that IPS upgrade from 3.4.9 to latest version is supported. Their was no mention of upgrade not supported when I renewed the license. Upgrade script is provided by IPS. IPS 3.4.9 is latest version of previous major release and moving to 4.7.6 which is recent release. I am not doing something crazy here.. i.e. going from IPS 2.x or IPS 4.x or heavily modified forum to latest version. It's to near stock forum. After having 5 licenses with mostly all addons, for appx decade, rather then helping your customer to resolve the issue, all I am getting is, middle finger from IPS team. I am sorry but that's how I am feeling, no disrespect intended. If you can see in topic, I am trying everything on my end to resolve the issue and as of IPS 4.x upgrades are through admin CP. So i don't even have the new versions. I am just tired and frustrated dealing with IPS upgrade code issues. I cannot believe, you can't fix your upgrade script to resolve this issues or provide help with 4.7.3 upgrade has terabyte suggested.

Thanks for the update. Sorry, I don't have IPS previous version and I am not sure from where I can get those files. I will try to raise the IPS ticket for 4.7.3 as a last try.

@teraßyte Need one favor .. i checked this path: forums/applications/forums/setup/upg_40000 queries.json Do you see that's it's creating the table first? It seems table itself is not getting created.. Not sure it's php 8.x issue or upgrader issue. I can keep creating missing tables manually, but I will be in same boat as before i.e. stuck on members.frm ...

Automatic moderation doesn't have option for links or certain keywords.. is their any settings for it? Thanks.

I had got bunch of missing tables error before.. but didn't share because, I added the tables i.e. created it manually based on create script from my other vanilla style forum which doesn't have any addons. So I can proceed. This is frustrating for me because I don't think they tested it. I would not have renewed the license if I would have known IPS wouldn't be supporting upgrade to their latest version. Current forum which I am trying to upgrade, has only 1 additional addon i.e. Tags and Prefixes. Rest 90% of it - it's all default. I will create a ticket, asking for refund for this license renewal because as a customer, it's really useless for me. I did tried everything, I could. For me, it's IPS product, IPS upgrade script should take care of it. If I had heavy customization, I would agree, yeah but it's all 90% default. 10% to that Tag/prefix addon from Ryan which was popular before makito started his own for IPS 4.x.

Doesn't doing force password reset helps? i.e. it sends an email to them for resetting password? OR that's no good? Trying to avoid flagging them as spammers.

@teraßyte - Tried to restart as suggested but no luck. This time, I did extra step.. i.e. converted MyISAM to INNoDB before converstion starts. UTF8 Conversion happens successfully. But during upgrade, first error same as last time: I checked and core_ratings doesn't exist in IPS 3.4.9 version. Question is why upgrade is trying to REPLACE INTO - non existent tables? Should it not create tables first? I checked DB user permissions as well and it seems, it has all permission? Am I missing something? Thanks SHOW GRANTS FOR 'user'@'localhost'; +------------------------------------------------------------------------------+ | Grants for user@localhost | +------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `database`.* TO 'user'@'localhost' | +------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)

Hi @SoftwareFactory - One of our user is facing the issue, while logging in. So i opened the ticket on IPS side. Jim mentioned below: This is the problem: https://invisioncommunity.com/forums/topic/471630-your-account-does-not-require-validation-user-login-error/#comment-2922819 Can you please help looking into this one, so that user can login?

100% agree, thank you. Nothing against the app coder but have burned myself by using new developer apps and few versions down the road, it's not supported. I have decided to stick myself with either your, Adriano, Michael, dawpi, Aiwa, Ehren, etc. apps. with whom I am familiar and they (developers) are around for a long time, as far as I know.

1. One of our user is getting "Your account does not require validation" error. I tried to change his email and manually setting password. Nothing worked. User would like to login in their account ASAP. Please open ticket, so that I can share user ID. 2. I tried to search icloud and it seems his account is not showing up in members list. I am curious to know why.

Does the APP removes before saving i.e. so that if later, if no one updates it, forum post will not be broken? OR it will remove during read? Thanks

I agree. Thanks for the fix!

Yup few Samsung users on our site are complaining for it. Bug is still their.

This seems odd: Does this means only few tables where converted in past? I see mix and match - especially more on custom application tables but i do see few IPS Core tables on utf8 as well.

While upgrading my 3.4.x site, I noticed my other forums are on UTF8. Doing some research it seems UTF8MB4 is required for Emoji's. I didn't knew that while back. How can I convert my IPS 4.7.6 site DB which is using UTF8 to UTF8MB4? I tried to search in market place and nothing comes up under IPS Community Extras. Thanks.

Thanks. Did below and so far all came back as OK except session table because it's memory engine based. Had followed bfarber advice and move session to memory while back. --auto-repair --check --all-databases I have 2 question: 1. Can i delete cache folder before upgrade starts? 2. I have below in config.. I am thinking to remove xcache line.. anything else, which you think can cause issue and I can remove it? Do note: Dedicated server - runs other 2 IPS forum on 4.7.6 - without any issue. IPS 3.4.9 server: mysql -V mysql Ver 14.14 Distrib 5.7.39, for Linux (x86_64) using EditLine wrapper IPS 4.7.6 server with other 2 IPS forum on latest version: mysql -V mysql Ver 14.14 Distrib 5.7.40, for Linux (x86_64) using EditLine wrapper php -v PHP 8.1.14 (cli) (built: Jan 7 2023 08:31:12) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.14, Copyright (c) Zend Technologies with Zend OPcache v8.1.14, Copyright (c), by Zend Technologies <?php ini_set('display_errors', '1'); $INFO['sql_driver'] = 'mysql'; $INFO['sql_host'] = 'localhost'; $INFO['sql_database'] = 'xx'; $INFO['sql_user'] = 'xx'; $INFO['sql_pass'] = 'xxx'; $INFO['sql_tbl_prefix'] = ''; $INFO['sql_debug'] = '0'; $INFO['sql_charset'] = ''; $INFO['board_start'] = '1282706691'; $INFO['installed'] = '1'; $INFO['php_ext'] = 'php'; $INFO['safe_mode'] = '0'; $INFO['board_url'] = 'https://site.com/forums'; $INFO['banned_group'] = '5'; $INFO['admin_group'] = '4'; $INFO['guest_group'] = '2'; $INFO['member_group'] = '3'; $INFO['auth_group'] = '1'; $INFO['use_friendly_urls'] = '1'; $INFO['_jsDebug'] = '0'; $INFO['mysql_tbl_type'] = 'MyISAM'; $INFO['use_xcache'] = '1'; define('IN_DEV', 0); define( 'CCS_PAGE_TITLE_RECORD', '{record_name} - {category_name} - {board_name}' ); ?> Post migration, I will convert MyISAM to InnoDB but don't want to change now to avoid any issues if that's ok.

@teraßyte - Thanks for the guidance. Appreciate everyone feedback. I re-check and so far no issues on IPS 3.4.9. Sharing if you can take a look - if you notice something odd. https://app.screencast.com/9NMdc3OCQXE97 Based on yours and @Miss_B feedback, I will re-start upgrade with fresh install again from existing copy.