Ok, I apologize for all the questions today, but I am stumped as to why step_03 would not be finishing. I got as far as step_03, it does run, but when it gets to 0 => metadata_field it just takes me back to the cmd prompt. It somehow just quits the script.
Has anyone seen this before?
Sorry for the lack of info, I will see if I can find anything in the logs. Does anything even get written to the logs at this point?
Upgrading from what to what?
I see this quite frequently. If there is some kind of script/PHP error, it prints it to the error log instead of STDERR. Check your data/private/logs/error.log - there should be more information in there 
3.16.8 -> 3.18.7
I will check the log when I get to work and report back here what I find.
Ok, I found the error that is getting thrown when step_03 quits:
[09-Dec-2008 10:20:20] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key violates
unique constraint "ast_typ_pk"' in /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc:601
Stack trace:
#0 /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc(601): PDOStatement->execute()
#1 /home/websites/puc_matrix_3-16-2/core/include/asset_management.inc(269): DAL::execPdoQuery(Object(PDOStatement))
#2 /home/websites/puc_matrix_3-16-2/core/include/asset_management.inc(159): Asset_Management->_install()
#3 /home/websites/puc_matrix_3-16-2/core/include/package_manager.inc(304): Asset_Management->update()
#4 /home/websites/puc_matrix_3-16-2/core/assets/package_manager_core.inc(83): Package_Manager->updatePackageDetails(Array)
#5 /home/websites/puc_matrix_3-16-2/install/install.inc(323): Package_Manager_Core->updatePackageDetails(Array)
#6 /home/websites/puc_matrix_3-16-2/install/step_03.php(128): install_core(Array)
#7 {main}
thrown in /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc on line 601Duplicate key? Does this have to do with our warranty key just expiring? We do still have an SLA with Squiz, I just need to contact them to get a new key.
That doesn't have anything to do with a warranty key. It's saying that an asset type is trying to be installed twice.
There is definitely something strange going on with this test upgrade of yours. We haven't had problems like this with other 3.16->3.18 upgrades, so I suggest talking to Squiz Support about getting some help. They've got a lot of experience upgrading systems on many different platforms.
[quote]That doesn't have anything to do with a warranty key. It's saying that an asset type is trying to be installed twice.
There is definitely something strange going on with this test upgrade of yours. We haven't had problems like this with other 3.16->3.18 upgrades, so I suggest talking to Squiz Support about getting some help. They've got a lot of experience upgrading systems on many different platforms.[/quote]
I think that I am going to restore the servers and start over again first.
Just wanted to run one more thing by you. I followed the 3.16 -> 3.18 upgrade instructions, while at the same time doing the steps for 3.18.2 -> 3.18.3, 3.18.4 -> 3.18.5 and 3.18.6 -> 3.18.7 at the same time. Should I have done those smaller upgrade steps AFTER doing the 3.16 -> 3.18 steps? I assumed I should do them at the same time since I was going straight to 3.18.7.
Also, when running SQL queries, so I need to enter those in line by line, then commit them? Or can I copy and paste a block of them and commit? I just want to be doing it correctly.
Does matrix still supply Debian packages? The URLs that are set in my sources.list file for Squiz are all erroring out when trying to update the package list. Does Squiz still provide this service to clients?
Thanks Greg.
You can do them at the same time, although they are not written to work that way and are not tested that way. If it doesn't work, you could try jumping to 3.18.0 first and seeing if that works.
[quote]Also, when running SQL queries, so I need to enter those in line by line, then commit them? Or can I copy and paste a block of them and commit? I just want to be doing it correctly.[/quote]
You can run them in blocks. Just make sure PostgreSQL is reporting that each query was run. Sometimes there may be too much text in the buffer for it to process.
[quote]Does matrix still supply Debian packages? The URLs that are set in my sources.list file for Squiz are all erroring out when trying to update the package list. Does Squiz still provide this service to clients?[/quote]
I have no idea. You'll need to contact your account manager or Squiz Support for that information.
Ok, just an FYI.
I started from scratch again, and am going from 3.16.8 -> 3.18.0 first, and it seems to be going better. I ran into one error when running step_03:
+------------------------------------------------------------------------------------------------------------------------------------+
| PHP Warning |
|------------------------------------------------------------------------------------------------------------------------------------|
| File : [SYSTEM_ROOT]/install/install.inc |
| Line : 447 |
|------------------------------------------------------------------------------------------------------------------------------------|
| require_once([SYSTEM_ROOT]/packages/google_maps/package_manager_google_maps.inc): failed to open stream: No such file or directory |
+------------------------------------------------------------------------------------------------------------------------------------+I think this has to do with no files even being in the google_maps dir. :) I contacted Squiz Support about this.
I think the problem with the last upgrade try was when I ran the DB queries. I tried to do them all at the same time, stupid me. This time I did them in small chunks, and everything seems to have gone smoothly. Once I get past the google maps issue, we should be all clear!