Jump to content

Upgrade from IP. 3.4.x to IPS4.0 (updated)


Recommended Posts

23 hours ago, Frank Jorgensen said:

Ok, apparently you can actually start the upgrade process manually without having access to the ACP. Database converted successfully.

But when it starts the last step of the upgrade it gives

Table 'uofcom_ipb.core_sys_module' doesn't exist
/home/uofcom/public_html/system/Application/Application.php::1636



 

It is correct that this table isn't in the database for some reason. Can this be created/bypassed?

If you are getting a database error for a non-existing unknown table I would submit a ticket. 

Link to comment
Share on other sites

On 5/18/2020 at 8:36 AM, bfarber said:

Hm, we do support upgrading from 3.4.9 to the current release. What's the ticket number?

This actually brings up a question that I was going to bring up, I have a board that's running 4.1.19.1, would it be best to upgrade to the current available board then upgrade to 4.5 or just wait and upgrade it right to 4.5?

Link to comment
Share on other sites

44 minutes ago, VaBeach_Guy said:

This actually brings up a question that I was going to bring up, I have a board that's running 4.1.19.1, would it be best to upgrade to the current available board then upgrade to 4.5 or just wait and upgrade it right to 4.5?

Version 4.1.19.1 is old and virtually no longer supported. Always update the latest possible version.
In my opinion, it's not worth waiting for IPS 4.5. It has not even entered beta mode, suggesting that a stable version may appear a few months later.

Link to comment
Share on other sites

  • 2 weeks later...

I've been trying to upgrade one of my boards, but get this error and can't continue... any advice on how I can fix this? I'm not really 'database' literate as far as repairing things goes. The board works, but I just can't upgrade. 

Incorrect integer value: '' for column 'starter_id' at row 493

/applications/core/sources/Setup/Upgrade.php::708

ALTER TABLE `ibf_forums_topics` CHANGE COLUMN `tid` `tid` INT (10) NOT NULL AUTO_INCREMENT , CHANGE COLUMN `starter_id` `starter_id` BIGINT (20) UNSIGNED NOT NULL DEFAULT 0 , DROP INDEX `last_poster_id`, CHANGE COLUMN `last_poster_id` `last_poster_id` BIGINT (20) UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `pinned` `pinned` TINYINT (1) NULL , CHANGE COLUMN `moved_on` `moved_on` INT (11) NOT NULL DEFAULT 0 , DROP INDEX `topic_firstpost_2`;

 

Link to comment
Share on other sites

9 minutes ago, VaBeach_Guy said:

I've been trying to upgrade one of my boards, but get this error and can't continue... any advice on how I can fix this? I'm not really 'database' literate as far as repairing things goes. The board works, but I just can't upgrade. 


Incorrect integer value: '' for column 'starter_id' at row 493

/applications/core/sources/Setup/Upgrade.php::708

ALTER TABLE `ibf_forums_topics` CHANGE COLUMN `tid` `tid` INT (10) NOT NULL AUTO_INCREMENT , CHANGE COLUMN `starter_id` `starter_id` BIGINT (20) UNSIGNED NOT NULL DEFAULT 0 , DROP INDEX `last_poster_id`, CHANGE COLUMN `last_poster_id` `last_poster_id` BIGINT (20) UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `pinned` `pinned` TINYINT (1) NULL , CHANGE COLUMN `moved_on` `moved_on` INT (11) NOT NULL DEFAULT 0 , DROP INDEX `topic_firstpost_2`;

 

I think it is best if you opened a ticket at your Client Area about this.

Link to comment
Share on other sites

2 minutes ago, VaBeach_Guy said:

 

That was going to be my next step, unless it was something simple that I could just 'tweak'. 

Well, this error is occurring because the upgrader is saving the empty string value, (''),  to the column 'starter_id', which is an integer. You can have a look at the upgrader I guess, but this is something that it best tweaked by specialists imo. 

Link to comment
Share on other sites

On 5/30/2020 at 5:17 PM, Miss_B said:

Well, this error is occurring because the upgrader is saving the empty string value, (''),  to the column 'starter_id', which is an integer. You can have a look at the upgrader I guess, but this is something that it best tweaked by specialists imo. 

Apparently, there a bunch of topics which had no content, no date, no title, no author, nothing. How that happened, I have no clue. But they fixed the issue and I was able to finish the upgrade. 

Link to comment
Share on other sites

5 minutes ago, VaBeach_Guy said:

Apparently, there a bunch of topics which had no content, no date, no title, no author, nothing. How that happened, I have no clue. But they fixed the issue and I was able to finish the upgrade. 

Glad to see that you got it fixed and the forum upgraded. 

Link to comment
Share on other sites

Well, after upgrading yesterday, everything was great. Then today, I get an email that GoDaddy has disabled my site because the database was too large. No way is it too large, I said to myself. It's only about 500MB. Well, after looking, it had ballooned up to 1.5GB. After digging a little deeper, there's two tables that seem to be the problem... ibf_core_output_cache, and ibf_core_search_index. 

I've put a support ticket in, but how did this happen and can those two tables just be dropped without harm to the overall health of the database? 

Link to comment
Share on other sites

10 hours ago, VaBeach_Guy said:

Well, after upgrading yesterday, everything was great. Then today, I get an email that GoDaddy has disabled my site because the database was too large. No way is it too large, I said to myself. It's only about 500MB. Well, after looking, it had ballooned up to 1.5GB. After digging a little deeper, there's two tables that seem to be the problem... ibf_core_output_cache, and ibf_core_search_index. 

I've put a support ticket in, but how did this happen and can those two tables just be dropped without harm to the overall health of the database? 

You should not drop them, if by drop you mean deleting them. Instead you can truncate them. 

But it would be better to wait first till you get a reply at your ticket.

Link to comment
Share on other sites

10 hours ago, Miss_B said:

You should not drop them, if by drop you mean deleting them. Instead you can truncate them. 

But it would be better to wait first till you get a reply at your ticket.

Yeah, I didn't touch any of it. Support helped me out. My search_index table is still very large and about doubles what my database was before the upgrade, so I'm delving into that. 

Link to comment
Share on other sites

I'm not sure if a specific feature was completely removed (several upgrades back) or if it just needs to be enabled but I've had multiple members ask about it. 

There used to be a time where, in a forum index, you could click on the number of replies that any given topic had and you'd be given a list of everyone who posted in the topic and how many replies those members had made. 

A couple of years ago, I noticed that this feature vanished. Was it just done away with or is it something that needs to be enabled?

Link to comment
Share on other sites

2 hours ago, VaBeach_Guy said:

I'm not sure if a specific feature was completely removed (several upgrades back) or if it just needs to be enabled but I've had multiple members ask about it. 

There used to be a time where, in a forum index, you could click on the number of replies that any given topic had and you'd be given a list of everyone who posted in the topic and how many replies those members had made. 

A couple of years ago, I noticed that this feature vanished. Was it just done away with or is it something that needs to be enabled?

A.f.a.i.k. that is not a standard Ipb feature. Most likely you had a third party plugin for that.

Link to comment
Share on other sites

18 hours ago, Miss_B said:

A.f.a.i.k. that is not a standard Ipb feature. Most likely you had a third party plugin for that.

I don't think it was. This was on a board where they didn't really install third party plugins, they just did whatever Invision had and that was it. 

Link to comment
Share on other sites

On 6/8/2020 at 3:40 PM, VaBeach_Guy said:

I'm not sure if a specific feature was completely removed (several upgrades back) or if it just needs to be enabled but I've had multiple members ask about it. 

There used to be a time where, in a forum index, you could click on the number of replies that any given topic had and you'd be given a list of everyone who posted in the topic and how many replies those members had made. 

A couple of years ago, I noticed that this feature vanished. Was it just done away with or is it something that needs to be enabled?

There is no such feature in the current release.

Link to comment
Share on other sites

18 hours ago, bfarber said:

There is no such feature in the current release.

Thanks, it's been several years since I've seen that ability, some of the members of my board have recently asked about it though, so I was hoping that maybe it was just something that could be turned on in the ACP

Link to comment
Share on other sites

  • 2 weeks later...

I'm stuck on 3.4.8 due to lack of technical knowledge and a currently terrible host that makes accessing my own data a pain. Would have to ftp download hundreds of thousands of files to be able to move. I am in the process of that.
I suspect the upgrade would be complex and forsee lots of errors I won't know how to handle.
So I was wondering if the following is feasible?

I have a number of domain names registered I am not using. Would it be feasible to take a hosting package, link one of those domain names to it that are not being used. Then I copy over all of my data to that host.
Then while my forum is still running on the old site, I employ an expert to try and setup the entire forum in his own time. Get it up and running, and upgraded to the latest version of IPB.
Once it is fully working, I point the real site to that host and make any necessary url changes?

Am I missing something critical here, and what problems can I forsee? I would like to do as little as possible myself technically, and leave it up to someone to handle (paid) and my hosts.

I even contemplate taking local hosting in my country, and handing them a copy of all the files I download on a USB stick, as i have 14 years of open attachment uploads...a LOT of files.

Any comments, suggestions and "are you nuts?" are appreciated.

been a horrible experience the past few years with my shared hosts. 

Edited by Brian Robinson_47676
Link to comment
Share on other sites

Hello Brian,

As for installing your IPS Suite on to another domain as a test site yes this is possible. The only catch is it cannot be active to the public. In other words you as the administrator and those experts you referred to may have access to this domain/test board.

Another avenue you may consider would be to submit a ticket and have support do the upgrade for you.

As for a local host environment it is quite simple. To start with...

Here is a condensed set of directions

(1) Go t o your cPanel and backup a complete copy of your database to your pc. 
(2) If you haven't already, download Wamp or  Xampp to your computer and install it.
(3) Go to phpmyadmin and create and install a copy of your database backup.
(4) Come back here (IPS) to your Client Area and download the latest version of the suite and install it on your local host. To do this create a test site directory to install to. For Wamp you will put it in the WWW directory. For Xampp you will put it in the htdocs directory.
(5) Go to your newly installed suite and start your upgrade.

Good luck and have fun!

OH By the way....

Where it comes to your license key, make sure you add -TESTINSTALL after it.

Link to comment
Share on other sites

Thanks Woodsman. But already getting confused with what would be installed on my own pc (nothing?) and what would be on the new host's space. Ideally I should try and get my working version of 3.4.8 onto a new host and have it up and running. Then try and get assistance to upgrade that to 4.x.x?
There isn't a way to install 4.x.x onto a new host and then do a conversion from my 3.4.8 installation, is there?
Don't even remember what script changes I did over the years, so hoping nothing complicates the upgrade.
That's aside from all the attachments which tend to drive upgrade scripts bonkers.
Phew...i can see why I have put this off every time I contemplate it.
And why I'd rather just pay an expert to do it. At this stage, the forum is too important worldwide to lose...lots of valuable info that cannot be found anywhere.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...