Woodsman Posted May 17, 2020 Author Posted May 17, 2020 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.
Frank Jorgensen Posted May 18, 2020 Posted May 18, 2020 16 hours ago, Woodsman said: If you are getting a database error for a non-existing unknown table I would submit a ticket. I have already in the past and was told that neither 3.x or the upgrade process is officially supported anymore.
Woodsman Posted May 18, 2020 Author Posted May 18, 2020 Are you able to get your complete 3.x board working properly in a local enviornment like Wamp or Xampp?
bfarber Posted May 18, 2020 Posted May 18, 2020 7 hours ago, Frank Jorgensen said: I have already in the past and was told that neither 3.x or the upgrade process is officially supported anymore. Hm, we do support upgrading from 3.4.9 to the current release. What's the ticket number?
Woodsman Posted May 18, 2020 Author Posted May 18, 2020 (edited) 8 hours ago, Frank Jorgensen said: I have already in the past and was told that neither 3.x or the upgrade process is officially supported anymore. Really... Edited May 18, 2020 by Woodsman
VaBeach_Guy Posted May 20, 2020 Posted May 20, 2020 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?
aXenDev Posted May 20, 2020 Posted May 20, 2020 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.
VaBeach_Guy Posted May 30, 2020 Posted May 30, 2020 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`;
aXenDev Posted May 30, 2020 Posted May 30, 2020 @VaBeach_Guy Create a support ticket. They will definitely help you in the update.
Miss_B Posted May 30, 2020 Posted May 30, 2020 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.
VaBeach_Guy Posted May 30, 2020 Posted May 30, 2020 2 minutes ago, aXen | 1s2k said: @VaBeach_Guy Create a support ticket. They will definitely help you in the update. Just now, Miss_B said: I think it is best if you opened a ticket at your Client Area about this. That was going to be my next step, unless it was something simple that I could just 'tweak'.
Miss_B Posted May 30, 2020 Posted May 30, 2020 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.
VaBeach_Guy Posted June 2, 2020 Posted June 2, 2020 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. Miss_B and Joel R 2
Miss_B Posted June 2, 2020 Posted June 2, 2020 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.
VaBeach_Guy Posted June 3, 2020 Posted June 3, 2020 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?
Miss_B Posted June 4, 2020 Posted June 4, 2020 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.
VaBeach_Guy Posted June 4, 2020 Posted June 4, 2020 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.
VaBeach_Guy Posted June 8, 2020 Posted June 8, 2020 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?
Miss_B Posted June 8, 2020 Posted June 8, 2020 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.
VaBeach_Guy Posted June 9, 2020 Posted June 9, 2020 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.
bfarber Posted June 9, 2020 Posted June 9, 2020 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.
VaBeach_Guy Posted June 10, 2020 Posted June 10, 2020 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.
Nihonto Posted June 23, 2020 Posted June 23, 2020 (edited) 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 June 23, 2020 by Brian Robinson_47676
Woodsman Posted June 23, 2020 Author Posted June 23, 2020 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. Nihonto 1
Nihonto Posted June 23, 2020 Posted June 23, 2020 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. supernal 1
Recommended Posts