Hi all,
I trying install MM 3.20.2 or 3.20.3 on one of my machine.
step 1, 2 and first compile_locale works fine.
When I ran step_03 I have this error:
[codebox]------------------------------------
Installing Package_Manager_Core:
------------------------------------
0 => bodycopy
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "type_code" violates not-null constraint' in /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc:603
Stack trace:
#0 /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc(603): PDOStatement->execute()
#1 /usr/local/strony/mysource_matrix/core/include/asset_management.inc(269): DAL::execPdoQuery(Object(PDOStatement))
#2 /usr/local/strony/mysource_matrix/core/include/asset_management.inc(159): Asset_Management->_install()
#3 /usr/local/strony/mysource_matrix/core/include/package_manager.inc(304): Asset_Management->update()
#4 /usr/local/strony/mysource_matrix/core/assets/package_manager_core.inc(83): Package_Manager->updatePackageDetails(Array)
#5 /usr/local/strony/mysource_matrix/install/install.inc(323): Package_Manager_Core->updatePackageDetails(Array)
#6 /usr/local/strony/mysource_matrix/install/step_03.php(128): install_core(Array)
#7 {main}
thrown in /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc on line 603
[root@asgard mysource_matrix]#[/codebox]
In log I have:
[codebox]Apr 22 13:56:24 asgard postgres[1562]: [2-1] ERROR: null value in column "type_code" violates not-null constraint
Apr 22 13:56:24 asgard postgres[1562]: [2-2] STATEMENT: INSERT INTO sq_ast_typ
Apr 22 13:56:24 asgard postgres[1562]: [2-3] (type_code, version, name, description, instantiable, allowed_access, parent_type, lvl, dir, customisation)
Apr 22 13:56:24 asgard postgres[1562]: [2-4] VALUES
Apr 22 13:56:24 asgard postgres[1562]: [2-5] ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
Apr 22 13:56:24 asgard postgres[1562]: [3-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
Apr 22 13:56:24 asgard postgres[1562]: [3-2] STATEMENT: DEALLOCATE pdo_pgsql_stmt_4621cd00
[root@asgard mysource_matrix]#[/codebox]
System is:
FreeBSD/sparc64
DB
postgresql-client-8.3.6
postgresql-server-8.3.6
PDO:
php5-pdo-5.2.9
php5-pdo_pgsql-5.2.9
php -i | grep pdo -i
PDO
PDO support => enabled
PDO drivers => pgsql
pdo_pgsql
PDO Driver for PostgreSQL => enabled
Revision => $Id: pdo_pgsql.c,v 1.7.2.11.2.3 2008/12/31 11:17:42 sebastian Exp $
[root@asgard mysource_matrix]#
Any idea what is wrong?
Regards
Arek
[quote]I trying install MM 3.20.2 or 3.20.3 on one of my machine.
step 1, 2 and first compile_locale works fine.
When I ran step_03 I have this error:
[codebox]------------------------------------
Installing Package_Manager_Core:
------------------------------------
0 => bodycopy
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "type_code" violates not-null constraint' in /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc:603
Stack trace:
#0 /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc(603): PDOStatement->execute()
#1 /usr/local/strony/mysource_matrix/core/include/asset_management.inc(269): DAL::execPdoQuery(Object(PDOStatement))
#2 /usr/local/strony/mysource_matrix/core/include/asset_management.inc(159): Asset_Management->_install()
#3 /usr/local/strony/mysource_matrix/core/include/package_manager.inc(304): Asset_Management->update()
#4 /usr/local/strony/mysource_matrix/core/assets/package_manager_core.inc(83): Package_Manager->updatePackageDetails(Array)
#5 /usr/local/strony/mysource_matrix/install/install.inc(323): Package_Manager_Core->updatePackageDetails(Array)
#6 /usr/local/strony/mysource_matrix/install/step_03.php(128): install_core(Array)
#7 {main}
thrown in /usr/local/strony/mysource_matrix/core/lib/DAL/DAL.inc on line 603
[root@asgard mysource_matrix]#[/codebox][/quote]
The "type_code" column should be populated with "bodycopy" and for some reason is either not being bound to the $1 value or is being supplied as null.
This has not been replicated locally as this would have been brought to our attention sooner. I would suggest verifying that the database details are correct and the appropriate file permissions are applied as part of the installation instructions.
If you are a Squiz client, please lodge a ticket with Squiz Support so we can investigate why this is occurring on your system.
[quote]The "type_code" column should be populated with "bodycopy" and for some reason is either not being bound to the $1 value or is being supplied as null.
This has not been replicated locally as this would have been brought to our attention sooner. I would suggest verifying that the database details are correct and the appropriate file permissions are applied as part of the installation instructions.
If you are a Squiz client, please lodge a ticket with Squiz Support so we can investigate why this is occurring on your system.[/quote]
Hi,
No, I'm not Squiz client.
I check perms to db.
user is owner mm db.
[codebox] Name | Owner | Encoding
-----------±------±---------
db_mm | u_mm | LATIN2[/codebox]
in db.inc user, dbname and type are correct
I tried with and without host=
I do install mm as root user.
in pgsql all conections from localhost are trusted also via socket.
I have error on pgsql 8.3 and 8.2
At this moment I just stuck 
How can I get more info (debug/verbose mode) during installation?
Regards
Arek
Hi,
Today I made 3 test.
2 installations:
- FreeBSD/i386
- FreeBSD/amd64
all packages were in the same versions like on sparc machine, ports
compilations options were also same, MM 3.20.3.
On i386 and amd64 all went OK.
I also tried dump db and tar MM from amd64
and restore on spark. MM doesn't work.
Tomorrow I'll try recompile php without shuoshi patch but with debug.
Regards
Arek
Hi Arek,
My encoding for matrix is SQL_ASCII don't know if that helps
List of databases
Name | Owner | Encoding
--------±--------±----------
matrix | matrix | SQL_ASCII
Mitch
[quote]Hi Arek,
My encoding for matrix is SQL_ASCII don't know if that helps
List of databases
Name | Owner | Encoding
--------±--------±----------
matrix | matrix | SQL_ASCII
Mitch[/quote]
Hi Mitch,
On all my MM instalations I always use LATIN2 encoding and this work fine.
I tested with:
LATIN2, UTF8 and SQL_ASCII
Without success.
Regards
Arek
I give up.
3,5 days of reading configure and make output, db, kernel tunning, turning on/off patches, debugging are enough.
I'll use this machine for another services.
Regards
Arek
[quote]I give up.
3,5 days of reading configure and make output, db, kernel tunning, turning on/off patches, debugging are enough.
I’ll use this machine for another services.
Regards
Arek[/quote]
While it is possible to select any Unix distribution, it is recommended to use one of the distributions which are actively tested while we develop the product. These are listed on the Matrix Requirements page:
- Debian Linux 4 (etch) - 32/64 bit
[*]Red Hat Enterprise Linux (RHEL) 5 - 32/64 bit
Note, MySource Matrix is also known to work on:
[list]
[*]Solaris 10
[*]CentOS 5
[/list]
I am not aware of anyone else running Matrix under FreeBSD/sparc64, however if anyone in the Matrix community has been successful, perhaps they could provide some assistance.
[quote]While it is possible to select any Unix distribution, it is recommended to use one of the distributions which are actively tested while we develop the product. These are listed on the Matrix Requirements page:
- Debian Linux 4 (etch) - 32/64 bit
[*]Red Hat Enterprise Linux (RHEL) 5 - 32/64 bit
Note, MySource Matrix is also known to work on:
[list]
[*]Solaris 10
[*]CentOS 5
[/list]
I am not aware of anyone else running Matrix under FreeBSD/sparc64, however if anyone in the Matrix community has been successful, perhaps they could provide some assistance.[/quote]
Hi Mark,
I'v installed Debian/sparc64 on this machine and now it's work fine.
But I still don't like Linux ;)
Regards
Arek
Hi Arek,
Glad to hear that you have got the system working as expected.