galenb

This is the only other thing I have found when running under the debugger...

Found the server logs and poured over those for a while... determined that I did not have a "conf_global.php" in the test.domain.com directory. So I copied the one from test.domain.com/forums and double checked the settings (at least the ones I knew like the db name and pword etc.) and I finally got the menu for the update to come up. I waited for a while and I got another page saying the update was complete and asking me to select going to the "suite" or "admincp". I selected "suite" and the next page url was test.domain.com/forums but it was blank again. I checked the DB and it seems to be up and running fine. I can attach the server and the schema looks to be there. Ran an Ips4.php file from test.domain.com and test.domain.com/forums (I put it there just make sure php would work) I get the following result So checking the access.log file. Hitting the url https://test.domain.com/forums results in the following entry (x.xx.xxx.xxx is my ip address) x.xx.xxx.xxx - - [26/Apr/2023:10:59:40 -0700] "GET /forums/ HTTP/2.0" 500 110 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0" Hitting the url https://test.domain.com/forums/index.php x.xx.xxx.xxx - - [26/Apr/2023:11:00:24 -0700] "GET /forums/index.php HTTP/2.0" 500 110 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0" I'm checking all the logs available... with no additional info. The error.log.0 is where I found the conf_global.php errors but there is nothing new in the error.log or error.log.0 I'm assuming there that php is throwing an error somewhere due to permissions or some setup I've failed to perform correctly. Nothing in the error.log though and I don't have access to php logs, I don't think... but I'll go look. The test site was up and running under the old code and php_7.4 so it might be related to something in php_8.1 and how I have things set up (What I'm saying is... I doubt the code is bad, it gotta be in the setup somewhere). I'll go mow the lawn and think about it.

I'm going to learn how to do that now. I have some "real life" stuff to do today so just off and on work today on this. I appreciate you sticking with me. Thanks.

Yes, thanks for the reminder to check the debugger Network traffic, so looks like a 500 error

(1) I confirmed that my test installation was operational. (using PHP 7.4) (2) Switched to PHP 8.x and my test installation now longer operates. (3) Downloaded and executed IPS4.php (4) Downloaded the latest upgrade package (4.7.9) unziped and uploaded to my test installation. (5) When I try to execute the upgrade. It doesn't do anything. I moved a phpinfo.php file into the /admin/upgrade/ directory and it executes ok and gives me the php info page. I can only think there is some permissions situation that is stopping me from executing beyond the "upgrade" directory or something. (6) So I've been trying to open a ticket but can't figure out how. Willing to pay for some support to this site up to date before things go to 5.x.

Ok... well that's where I'm at now. Have to go read again about where to get the files and executing it.

Just kinda keeping a log in this thread. I did the best I could getting a test system up and running on my host. It looks just like the primary when it comes up. I downloaded MySql for Windows and loaded a copy of the DB on my test system into the local DB. I took the script that the auto upgrade produced and executed every set of SQL statements for each table. There were most 3 types of changes. Updating integer fields that were set as NULL to 0's Changing PK's to Auto-Increment but my DB is so old there were no PK's defined so I had to add the PK for each of these changes. The script was trying to modify some tables and in order to do so it had a "drop index" where no index existed in my tables. An update to one table ibf_core_statistics actually killed the database... I did it three times. It looks like data that's only necessary if I was interested in knowing how many people hit what everyday but I'm not sure. Anyone know what it would do if I just truncated that table? I'll spend a little more time analyzing and then start updating my test system with each table query. 🙏

I kinda was thinking that it was something new... Can't wait to get there.

I click on Support at the top right and I get the page below. That's how I accidentally updated the caches ... by selecting the "Something isn't working correctly" and clicking continue. Then I get this page... not a "Tools & Diagnostics" menu... This is kinda where I am now but was kinda looking for that cool "T&D" menu in case i need it in the future. Previously when I was on my primary site I clicked on the "Fix This" button for the db and it aborted somewhere and trashed the primary site database. So I restored the db on the primary and started down the path of building a test site. Here on the Test site I clicked the "Fix This" button and got the same prompt... This time... I have copied and pasted all the sql to a file and will look at each piece and run them separately to see where it blows up. As I work through each of these steps I find the little hurdles of being ignorant of UNIX, MySql and how to access and build things. (I'm actually fairly decent at SQL but more used to Oracle and SQL Server, but not DBA level decent). So right now my hurdles are: (1) Terminal access to my server. Right now I just have WinSCP and the internal terminal errors out on the server. So... Gotta learn how to do that in order that I can.. (2) learn what .htaccess and .htpasswd should be and edit them in order to be IVP license compliant so there is no "outside" access to the test site. (I want to get this right so I can keep the test site up and running. There was a test site before I turned this over to other people 3 or so years ago and I think one of the people doing admin got a notice that it wasn't compliant and just removed it.) Oh... and I have to paint my garage door trim today too. 🙂

I have now... and it's all working... but I did it by accident. Can you direct me to where this located in the admincp?

Thank you Marc. I read and read and found that and got that working. I know that at some point I had some Invision Power Services instructions on .htpasswd and.htaccess implementation but I had like 15 browser tabs open and lost it and can't find it again. If you, or anyone else, knows that location, please let me know. 🙂

Found some help and now working on .htpasswd and .htaccess... I'm a Windows guy... so any help is appreciated.

I was the admin for a site 3 or 4 years back and recently re-inherited the site back to which there has been no upgrades. The site is way behind on updates and the automatic upddate failed and I had to do a db restore but yada yada poor me... I've been trying to bring up a test site so that I can test the manual update. Sooooo I have a domain of domain.com and then I created a sub domain of test.domain.com and copied over all the files from domain.com and created new database and finally got it to come up with some errors in the .css referring to the domain.com site. BUT!!! then I noticed that I have the following message. I don't want to endanger the domain.com license. I'm not trying to steal anything. I thought that I had read that the license entitled us to a primary and test site and that's what I'm trying to set up. License Key Invalid The license key in use is not valid for this site. Please contact support for further information. Here is an image of what the hosting folks say are my domain and sub domain hosts. I don't have mail support from my client area... so this is me contacting support as best I know how. Thanks for any help.

Hello again everyone. I took some time away to do "real life things" and just got back to this. I was thinking dangerous thoughts out of desperation and decided to look away for a while. Came back sat down and started reading through all the posts again and re-checking. Set everything to only test.domain.com (no www) and still no good. Finally came across the post way back in the thread to edit the conf_global.php file and found a reference to https://www.test.domain.com/forums... changed that and finally had the site come up.... have some reference to The Same Origin Policy disallows reading the remote resource at http://www.domain.com so I need to find those... Well I may be back soon but this thread has been very helpful and I appreciate the tolerance of the newbie. I did go through a lot of PHP code and refreshed a lot of old memories from 15 years or more ago too. Thanks again everyone!!!

Thank you!

I don't know what "the datastore" is. Can you give me a little more information. One of the goals is to keep the data in the database for historical purposes... so I'm hoping you don't mean I need a "fresh" database. Thanks!... I'm learning as I go. I'm an embedded software engineer, web stuff is all pretty new to me. I'll try and figure that out.

I didn't create the redirect's... they were just "there" from previous installations and copied over from the primary site. I'm a windows guy so I'll do some more reading on .htaccess and how it works. For me Unix = "black arts" 🙂 Thanks!

Looks like this subject comes up every few years or so. So I'll try to make the background short. Inherited a site that is at 4.4.5.2 trying to update to 4.7.2.1. Host is on PHP 7.4FASTCGI need to move up to 8.X. Automated update from admincp failed due to PHP Version... moved up PHP version to 8x ... site is just blank white page so put PHP back to 7x. Suggestions from folks here is to build a test system and try manual upgrade on it. (1) Created a sub domain - test.xxxx.com (where xxxx.com is my actual domain) (2) Copied all files from xxxx.com to test.xxxx.com (3) Created a new db host->mysql.test.xxxx.com ... database->xxxxtest ... sql_user -> xxxxtestadmin (4) Uploaded a copy of the original xxxx DB into xxxxtest DB (5) Changed home/xxxxtest/test.xxxx.com/forums/conf_global.php to match all the appropriate settings. (6) Changed home/xxxtest/test.xxxx.com/index.html all references to www.xxxx.com to www.test.xxxx.com AND redirection_index.php from xxxx.com to test.xxxx.com (7) Set php version to 7x (8) And when I hit the URL test.xxxx.com... I'm in an infinite loop of redirection (see attached image). (9) I can hit the URL https://test.xxxx.com/phpinfo.php and that comes back ok Any suggestions would be helpful. Thank you!

Thank you!!!

I'm building a test site... empty web server, empty database... essentially a new install. I cannot find a set of step by step instructions about how you go about this. I've downloaded from the client area and uploaded to my self hosted web server... what do you execute? Anyway... is there step by step anywhere? thanks!

Hey forgot to say thanks for the help!!!

Ok... that's gonna take me a little while... get back here in a while.

So I admin'd a forum a few years back and turned it over to someone show hasn't touched it and it's on 4.4.9.2. and now they want me to update it. (ugh). I'm an embedded software engineer so webby stuff is just a hobby at best. So when I say dumb stuff please point it out. The forum software was throwing some errors. I deleted all but the Default theme and that seems to have cleared that up. The only functions used are Forums and Calendar by this group (small group), no plugins etc. I clicked the automatic update button on the admincp and get 1C287/2 You are running PHP version 7.4.30. You need PHP 8.0.0 or above. You should contact your hosting provider or system administrator to ask for an upgrade. The hosting company (Dreamhost) allows you to switch PHP version for the site so I switched to 8.0 FASTCGI from 7.4FASTCGI Went back to the admincp and clicked the button again and just got a blank page. I hit the PHPINFO.PHP file and got 8.0.2.2 or something like that. I tried several iterations of this activity switching PHP versions and actually got to where the update from admincp prompted me with a giant SQL script. I said yes to the prompt and it blew up halfway through. I don't know what on. Spent a day looking at things and deleting themes and got a workable php 7.4 IPB 4.4.9.2 site up and running with a default theme. So now after reading and reading the forum... looks like a manual update. Downloaded "the package" read about how to copy up the files to the host (pressing yes to replace ...scary.) I vaguely remember doing that years ago for everything. I also downloaded the compatibility checker ... it reported the PHP version (I know how to fix that) and GMP PHP which it says is not necessary except for push notifications. I put my DB credentials in the PHP for $INFO and still couldn't connect but it looks like it just checks for MySQL version and the hosting service is running version 8x of Ubuntu something but I'm worried about the db schema being alright and if the compatibility checker can't get to the DB what makes me think the update code/procedure would be able to. Anyway... questions??? (1) I don't have a test site. There never was one... Is it really worth it to build all that up from scratch? (2) If I decide to just run the upgrade, should I update to php 8 before doing that? (3) Anyone have this experience with suggestions?