upgrading from 3.16.1 to 3.16.2 went as expect for for the test environment, when it came to the dev environement got the following error during step_03
Installing package_manager_core:
------------------------------------
0 => bodycopy
1 => bodycopy_container
±--------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------+
| MySource Warning |
|---------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------|
| File : [SYSTEM_ROOT]/core/include/assertions.inc |
| Line : 508 |
|---------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------|
| [ASSERT EXCEPTION] DB Error: constraint violationINSERT INTO sq_ast_attr |
| (attrid, type_code, owning_type_code, name, type, uniq, parameters_type_code, default_type_code, de fault_val, parameters_val, is_admin, description) |
| VALUES |
| ('1279', |
| 'bodycopy_container', |
| 'bodycopy_container', |
| 'description', |
| 'text', |
| 0, |
| 'bodycopy_container', |
| 'bodycopy_container', |
| '', |
| 'a:0:{}', |
| 0, |
| 'Description for this bodycopy container') [nativecode=ERROR: duplicate key violates unique constr aint "ast_attr_pk"] (LINE 580 IN [SYSTEM_ROOT]/core/include/asset_management.inc) [SYS0270] |
±--------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------+
±-----------------------------------------------------------------+
| MySource Warning |
|------------------------------------------------------------------|
| File : [SYSTEM_ROOT]/core/include/transaction_manager.inc |
| Line : 125 |
|------------------------------------------------------------------|
| Unable to Commit, Transaction has already been aborted [SYS0220] |
±-----------------------------------------------------------------+
±----------------------------------------------------------+
| MySource Warning |
|-----------------------------------------------------------|
| File : [SYSTEM_ROOT]/core/include/transaction_manager.inc |
| Line : 156 |
|-----------------------------------------------------------|
| Unable to Rollback, No Transaction is Open [SYS0231] |
±----------------------------------------------------------+
Any suggestions?
Currently it is the GPL version, just doing some development work before system admin does install of SSV on new box. So if database stuffed let me know I can retrieve what is necessary for new install.
Now have a couple of errors on dev environment home page will see if I can resolved them, before posting them here.
when looking at any asset listing used I now get following error messagee in dev enviroment:
MySource Warning
File: [SYSTEM_ROOT]/core/include/asset.inc Line: 3062
Message: Attribute "link_value_filter" not found for Asset "page_asset_listing" [SYS0094]
Backtrace: Show
MySource Warning
File: [SYSTEM_ROOT]/core/include/asset.inc Line: 3062
Message: Attribute "link_value_filter_enabled" not found for Asset "page_asset_listing" [SYS0094]
Backtrace: Show
I assume "link_value_filter" and "link_value_filter_enabled" fields not created during the problem upgrade.
have no idea what this means:
PHP Warning
File: [SYSTEM_ROOT]/core/include/mysource.inc Line: 560
Message: Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:172)
Backtrace: Show
Yes, those attributes are meant to be added by step_03.php during the upgrade process. Because your step_03.php didn't complete successfully, they have not been installed properly.
And I tried to complete step_03 again, with exactly the same results. So there is a problem somewhere, just where?
For some reason, it is trying to add an attribute with a primary key that already exists in the database. I'm not sure why it would be trying this -- as this is a dev environment, do you guys have any custom code that may have broken the database? You'd need to check if that primary key does exist, and if perhaps the sequence for that table is stuffed up or something.
Avi no custom code involved, especially nothing that touches the database.
Had a few problems going from 3.14.3 to 3.16.0, I might of got one of the eight steps from 3.12.0 to 3.14.3 out of order (or swapped content between dev and test) I was upgrading both installs. Had to redo the upgrade (3.14.3 to 3.16.0) again and it worked (had been going good since then). But now this error. It looks like trying PGSQL command line stuff to fix it (delete duplicate record).
reverted to 3.16.1, did not touch database, just recovered mysource_matrix 3.16.1 files and back running again will be extra careful about upgrade, porably do a fresh install of 3.18 (when available) and not transfer data.
damn I am dangerous when I click the wrong button
[quote]when looking at any asset listing used I now get following error messagee in dev enviroment:
MySource Warning
File: [SYSTEM_ROOT]/core/include/asset.inc Line: 3062
Message: Attribute "link_value_filter" not found for Asset "page_asset_listing" [SYS0094]
Backtrace: Show
MySource Warning
File: [SYSTEM_ROOT]/core/include/asset.inc Line: 3062
Message: Attribute "link_value_filter_enabled" not found for Asset "page_asset_listing" [SYS0094]
Backtrace: Show
I assume "link_value_filter" and "link_value_filter_enabled" fields not created during the problem upgrade.
have no idea what this means:
PHP Warning
File: [SYSTEM_ROOT]/core/include/mysource.inc Line: 560
Message: Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:172)
Backtrace: Show[/quote]
I had the same problem. I've run step_03 for cms package only and this sorted it out.