Issues with upgrade - template issue and some strange query function

[Shadow Wolf]

I am having an issue upgrading to the latest version. First, it was an issue with PHP 8.1 which I got resolved. It has an issue downloading and extracting and has me download it manually, then upload it. I copied all the contents of the site, and put them in a 'old_backup' directory. I then uploaded everything from a fresh download of the Community Suite. When I went to Continue to upgrade I got the following error:

Quote

[[Template core/global/global/includeCSS is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

I removed everything from the directory. Put everything from the old_backup into the directory. I tried to run the support tool in the AdminCP to restore the default theme but got the following:

Quote

;(function($,_,undefined){"use strict";ips.controller.register('core.admin.support.contact',{initialize:function(){this.on('change','#elCheckbox_support_request_extra_admin',this.acpAccountCheckboxChange);},acpAccountCheckboxChange:function(e){if(!$('#elCheckbox_support_request_extra_admin').is(':checked')){ips.ui.alert.show({type:'confirm',message:ips.getString('supportAcpAccountHead'),subText:ips.getString('supportAcpAccountDisableBlurb'),icon:'warn',buttons:{ok:ips.getString('supportAcpAccountDisableYes'),cancel:ips.getString('supportAcpAccountDisableNo')},callbacks:{ok:function(){$('#elCheckbox_support_request_extra_admin').prop('checked',true);}}});}}});}(jQuery,_))

If I try to go to anything like AdminCP -> Pages -> Databases

Quote

;(function($,_,undefined){"use strict";ips.controller.register('cms.admin.databases.download',{initialize:function(){this.on('click',this.launchAlert);},launchAlert:function(e){var self=this;e.preventDefault();ips.ui.alert.show({type:'confirm',message:ips.getString('cms_download_db_explain'),icon:'fa fa-download',buttons:{ok:ips.getString('cms_download_db'),cancel:ips.getString('cancel')},callbacks:{ok:function(){window.location=self.scope.attr('data-downloadURL');},}});}});}(jQuery,_))

AdminCP -> Customization -> Themes -> Edit HTML and CSS

Quote

 

ips.templates.set('templates.editor.newTab',"

• {{title}}
• ");ips.templates.set('templates.editor.tabPanel'," ");ips.templates.set('templates.editor.tabContent'," ");ips.templates.set('templates.editor.unsaved'," ");ips.templates.set('templates.editor.saved'," ");ips.templates.set('templates.editor.diffHeaders',"
  {{#lang}}theme_diff_original_header{{/lang}} {{#lang}}theme_diff_original_desc{{/lang}}

  {{#lang}}theme_diff_custom_header{{/lang}} {{#lang}}theme_diff_custom_desc{{/lang}}
  ")

 

 

My next plan since I can mostly view the pages was to install a fresh load into a 'temp directory'. We use mostly pages, no forum, and a couple of gallery images so not a heavy site. Then I can manually move all the pages over. Then once it's set up properly, remove everything from the main directory, install a fresh load, and point it to the new database that was created with the temp install. 

For the most part, that is working. I installed a testinstall and started to move the pages over. There were a couple of css issues to deal with, but since I can view the main page mostly, I can at least use 'Developer Tools' to see the css that I need to add. The main issue though is I can't see the original configuration settings for Database, how it was set up and I thought I added some fields for the pages to use like "Chapter". However, I can't view any of those settings because of the errors above. 

Any idea on how I can view the setups (I do have access to phpmyadmin) or how to fix whatever template issue it is having so I can view them?

 

 

 

 

 

[Marc Stridgen]

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

[Shadow Wolf]

I have updated FTP access.

I can't change the password for IPB account, it gives me an error. I did submit a ticket through the Support link in the admin on 12/24/2022, it created a temp user as part of it that should still be there. The support directed me here. Are you able to look up that ticket and see the user/pass that got created with that?

Normally I would have tried to upload new board files to overwrite, in case something did not copy over right when I moved them to the old directory and back to the original folder. But I lost my main drive a while back, only have my backup before I started version control for IPB so I just have a bunch of Invision Community folders, and not sure which is the one that matches. 

I tried resetting the one in access information t through 'forgot password' but I am not sure if it updated correctly. I have to wait 14 minutes because its locked out currently. 

 

 

[Jim M]

1 hour ago, Shadow Wolf said:

I can't change the password for IPB account, it gives me an error. I did submit a ticket through the Support link in the admin on 12/24/2022, it created a temp user as part of it that should still be there. The support directed me here. Are you able to look up that ticket and see the user/pass that got created with that?

These would be automatically deleted from our support ticket engine as this is no longer supported. This has been this way for over a year now, I'm afraid.

If you do not know this password, you can provide us an unrestricted administrator account.

[Shadow Wolf]

I have updated the login information with an admin/password.

[Jim M]

Is this on your test site? I see that is running the latest release but we would require email address rather than display name as it seems your login is setup to use that.

[Shadow Wolf]

No, not the test site, that was installed and is working fine. 

It is the main site, which is on the old version. Since I could not upgrade it through the menu because it looks like its getting a template issue/error even though I did restore via the Support tool. After I moved the files/folders into an old directory. Then moved them back, it seemed to not work anymore at all.

I was just hoping to get be able to access the settings for page, so I can manually look at the base setups to set them on the test site. Then I was just going to manually recreate/move the pages to the test site. Then remove the old one, upload fresh one, and point it to the database that was created with the test. At least that was my theory of getting it updated the hard way. 

I cleared cookies and cache too.. but it seems confused between the test and the main site for some reason. The main site is in the main directory / while the test is in /new. Main site and test site are in their own sql directories. I even removed everything in the mian directory, then recopied the files from /old over but something must not of copied correctly or gotten messed up.

[Jim M]

Unfortunately, we would not provide support to old versions. Is there a reason that you are not directly upgrading your live install or attempting that with the test install? That we can assist with any issues.

[Shadow Wolf]

Yes, I tried to upgrade it via AdminCP, it would not download. It said to manually download. I manually downloaded it, then uploaded it to the directory, and pressed Continue as directed but then got the following error:

Quote

[[Template core/global/global/includeCSS is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

If I try to run the Support option from the menu or just go into templates to try to revert everything back to default theme, I get:

Quote

;(function($,_,undefined){"use strict";ips.controller.register('core.admin.support.contact',{initialize:function(){this.on('change','#elCheckbox_support_request_extra_admin',this.acpAccountCheckboxChange);},acpAccountCheckboxChange:function(e){if(!$('#elCheckbox_support_request_extra_admin').is(':checked')){ips.ui.alert.show({type:'confirm',message:ips.getString('supportAcpAccountHead'),subText:ips.getString('supportAcpAccountDisableBlurb'),icon:'warn',buttons:{ok:ips.getString('supportAcpAccountDisableYes'),cancel:ips.getString('supportAcpAccountDisableNo')},callbacks:{ok:function(){$('#elCheckbox_support_request_extra_admin').prop('checked',true);}}});}}});}(jQuery,_))

So that is why I installed a fresh test. And was going to go through the process of manually copying all the pages into the test. Then replace the existing old with a new, pointed to the sql database. 

Edited February 2, 2023 by Shadow Wolf

[Jim M]

Once the files are applied to your server, you would just simply go to {your base url}/admin/upgrade . If anything is happening once you attempt that, please let us know. Right now, you have a mix of files on your server it sounds like which is why you're running into issues.

[Shadow Wolf]

No there should be no mix of files. The old files are in the / while the new ones are in /new.
I copied everything from / (minus /new) to /old. When I tried the upgrade and did upload them, there was a mix then. 
To revert though I deleted everything from / (except for /new and /old), then copied files from /old back into / so it should only be the old files, no mix of files. 

That was me trying to upgrade through the menu options in the AdminCP.

I now re-uploaded the new files into the / directory, now there is a mix of files. But instead of going through the AdminCP as directed, I went to {your base url}/admin/upgrade, which seems to be working. It is running the database upgrade now so that is moving forward at least.

I am not sure why going through the AdminCP and clicking the upgrade option did something different... but it does appear that is upgrading.

Once it is updated and it is working, I will remove all the files in / and then upload a clean fresh batch of the new software, keeping my conf_global and that should leave me with an upgraded functioning board and no old files at all.

[Jim M]

When you upload files manually, you always want to avoid the ACP and go straight to the upgrader at /admin/upgrade. There are theme templates stored in the database that need updating and if the upgrader isn't ran yet, the ACP can be wonky. Especially when you are doing a giant upgrade gap like you did here.

[Shadow Wolf]

I spoke too soon. I can log into the main page, view some pages. It seems the Categories are broke. When I go to log into Admin CP, I get: 

[Randy Calvert]

That looks like some of your Pages templates are not compatible with PHP8.  You might need to review and rework them to ensure they're PHP8 compatible.  

[Shadow Wolf]

I could not even get into the Admin to make changes to templates. I was able to force through the errors to get the support page to at least load, then was able to "Clear System Cache". I am now at least able to get into AdminCP.

[Shadow Wolf]

Still having issues. I went to the Support Tool, Restored the default theme, still having some issues navigating, getting errors. 

The Gallery works fine. I think it is not related to the theme in InvisionBoard but instead related to edits/theme in Pages. It has a different part and calls for theming. I'll have to copy out the changes and see if I can rever those parts.

[Marc Stridgen]

Pages you would need to use default templates to check yourself, as the support tool would not revert those

[Shadow Wolf]

It looks like I am going to have to go back to my original plan. Manually cut and paste all the articles from the main site into /test. Then remove the main database and replace it by pointing to the new one created with test. 

I've reverted back to the default theme for IPB. I have reverted all the templates that I can see if Pages, I made sure Articles was using IPS Default. I am still getting an error but have no idea what would be causing it. I've spent hours comparing settings, at least the ones in AdminCP that I can get too. Otherwise I get errors like this:

Main page appears to be fine, but when I try to click on any of the articles I get:

If I try to log in, it logs me in but then gives me the error:

 

[Jim M]

You are still showing themes in your screenshots there. This is not related to themes. You will want to go to ACP > Pages -> Page Management -> Templates.

You can create new templates based on the defaults in the software too in there. Then go to your Database settings and change the templates which that database is using.

[Shadow Wolf]

I have done that, I went through ACP -> Pages -> Page Management -> Templates, I even compared the versions with the test board. I tried copying over the defaults from the test board, just in case something was missed. 

The crux though is that

That is the issue though, I can't access the Database settings to change the templates. So I tried making sure they all matched defaults. If I click on ACP -> Pages -> Databases this is what happens:

[Jim M]

Something was not right with your hooks.php file so after rebuilding that by disabling/enabling an application, the Database settings appear. You are utilizing completely custom templates for the Articles database:

 

You will want to change those three to unmodified/custom versions of those.

[Shadow Wolf]

Gol Form looks like the only one that I didn't copy over the default templates from. I already cut and paste (since there is no revert) Sog Chapters and Gol Display to defaults.

It seems the main issue was with hooks.php file, whatever that issue was. It looks like that is created as part of the install process or update process as the base software doesn't have a hooks.php. That was what was alluding me. I was replacing the files in the / directory with clean files from fresh download, I even removed the old files... when I should have downloaded the files from the /new test install, then uploaded those into root. Since that has a hooks.php, that would have caught that issue. 

Everything is now working.

I have reverted the Database to the default Listing, Display and Form templates. I will copy, re-edit the templates from them, just in case there is something else that got missed in the customization. Most of it is just ccs renames and removing a few sections that she doesn't want to display.

Thank you!

[Jim M]

The hooks.php file basically is what holds the data for applications/plugins hooking into items. If something broke while uninstalling a third party application/plugin that could relate to what you were seeing. 

At any rate, I am glad to hear everything is working for you again 🙂 .