AlexJ

5 hours ago, Gary said:

I was talking about the retention of your current files on 3.4.9, which you mentioned you are upgrading from.

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: 

5 hours ago, Gary said:

With regard to older versions of 4.x, we don't provide old insecure releases. If you wish to upgrade, it will need to be done on the latest release.

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. 

6 hours ago, Gary said:

Hi @AlexJ,

I am just letting you know the only way to have these files are if you retained them before upgrading. We do not provide previous versions of our software, unfortunately.

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 ... 

1 minute ago, AlexWebsites said:

You can optionally hold all newly posted links for moderation, which is what I do. 

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

Just now, teraßyte said:

Hmm, that's a new/different error compared to your previous attempt. Or did you also get it before but didn't post it?

 

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. 

1 minute ago, teraßyte said:

I doubt IPS tested an upgrade from 3.x to 4.7 using PHP 8 at least. 🙄

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.

29 minutes ago, Malwarebytes Forums said:

At this point we have to assume that all 20 accounts are now compromised and flag them as spammers. In checking, aside from the spam posts these accounts have not posted in years anyways.

 

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:

Quote

Looks like this account was created by a third party login handler for Discord. Please contact the author for further assistance on resolving this issue.
 

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? 

3 hours ago, teraßyte said:

In this case a plugin that removes the extra empty lines at the end before saving would probably be better. It needs to be coded from scratch though.

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.

15 minutes ago, teraßyte said:

That page might not show if a table is crashed. The best way would be to check from phpMyAdmin (or a similar script) and eventually run also a REPAIR on all tables just in case. If everything is okay nothing will change, if something's broken with the files it will tell you exactly what.

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. 

39 minutes ago, Miss_B said:

A word of advice, if I may, make first a duplication of your live forum to a test forum and then upgrade the test forum first to see how things will go. Like that you can take all the time to troubleshoot the errors that might pop up without disrupting the main forum. 

 

I don't have much active users - may be 100.. or so as it's gaming mod support forum. I agree. Doing this on new VPS for testing using A records, so i can switch quickly... or else, I will run into another hassle of URL's. So try to avoid that. Thank you.

40 minutes ago, Miss_B said:

As mentioned previously, it looks like the upgrader can't find the members table. If I were you, I would try to start the upgrade again.

 

Why it's looking for members table? Initially during upgrade, I believe it converted members table to core_members. 

IPS 3.4.9 - i have members table

During upgrade -> members to core_members

My other forum on latest IPS version doesn't have members table either. 

It seems like IPS upgrade is converting members to core_members and then complaining for members table doesn't exist? How to fix this error? 

9 hours ago, AlexJ said:

Can't find file: './xxx/members.frm' (errno: 2 - No such file or directory)
/home/xxxx/public_html/forums/applications/core/setup/upg_40000/upgrade.php::42

@Miss_B  This is the error, which I am stuck on. Any thoughts on how to fix it? 

3 hours ago, Miss_B said:

The upgrader should add them automatically. Did you upgrade directly to the latest version,  4.7.6? Can you try to first upgrade your forum to the latest version of the 3.4. series and then to  4.7.6?

I am on version 3.4.9. I am not sure if that is latest or not. How to get latest 3.4.x version? Thank you.

1 hour ago, Jim M said:

It sounds like there is an issue creating these columns/tables in your database, you may wish to investigate that.

However, I am very sorry, but version 3.x is no longer supported, including upgrades. I have moved this topic to our community support forum so you can receive assistance from other administrators. 

I am not asking for 3.x support. I am asking for 4.7.6 which you should officially support or else people can not upgrade. 

It's IPS code and should handle the upgrades. If you are not going to support 4.7.6 upgrade, who will? This doesn't make any sense.

You are quick to tell not a IPS problem. 

FYI: It seems, I have members table in IPS 3.4.x but new version looks for core_members. It didn't existed, so i added it.. will it transfer old members to new one? 

For now, i have pointed website to older version, so users can use it. Also tables like core_notifications don't exist. Shouldn't upgrade script create it by itself? I found at least 5-8 tables, it didn't create. 

I removed the word_pack column... but then now i get below error:

Can't find file: './xxx/members.frm' (errno: 2 - No such file or directory)
/home/xxxx/public_html/forums/applications/core/setup/upg_40000/upgrade.php::42

Is upgrader tested i.e. going from IPS 3.4.x to 4.7.6 latest version? I got a lot of missing table errors which i am adding manually.. from my another site.

But getting tired of missing columns, tables, etc. 

At this point, I am stuck since, I have no idea how to fix this error!