-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Major
-
None
-
Affects Version/s: 2.0.0
-
Component/s: Frontend (F)
-
None
After upgrading from 1.8.5 to 2.0.0 is shown on most pages this php/sql error.
I do not know how to solve the problem. Basic functionality is not limited only to scare the user.
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: duplicate key value violates unique constraint "profiles_pkey" [include/db.inc.php:500]
Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (11, 3, 'web.latest.php.sort', 'i.name', 3, 0)] [ERROR: duplicate key value violates unique constraint "profiles_pkey"]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (0, 3, 'web.latest.php.sortorder', 'ASC', 3, 0)] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [UPDATE profiles SET value_id=8, type=1 WHERE userid=3 AND idx='web.latest.groupid' AND profileid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [UPDATE profiles SET value_id=10392, type=1 WHERE userid=3 AND idx='web.latest.hostid' AND profileid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [UPDATE profiles SET value_str='latest.php', type=3 WHERE userid=3 AND idx='web.paging.lastpage' AND profileid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [UPDATE profiles SET value_id=8, type=1 WHERE userid=3 AND idx='web.view.groupid' AND profileid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:500]
Error in query [UPDATE profiles SET value_id=10392, type=1 WHERE userid=3 AND idx='web.view.hostid' AND profileid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]