pgsql insert error in frontend

XMLWordPrintable

    • 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]

            Assignee:
            Unassigned
            Reporter:
            Martin Janda
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: