Hi,
Today appeared to me this error:


Type: 256

Message: postgres7 error: [-1: ERROR: invalid input syntax for integer: "P:9"] in EXECUTE("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?")

File: /var/www/crm/libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "postgres7 error: [-1: ERROR: invalid input syntax for integer: \"P:9\"] in EXECUTE(\"SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?\") ", "/var/www/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("postgres7", "EXECUTE", -1, "ERROR: invalid input syntax for integer: \"P:9\"", "SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array (#2), Object (ADODB_postgres7), "SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array (#2), "postgres7 error: [-1: ERROR: invalid input syntax for integer: \"P:9\"] in EXECUTE(\"SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?\") "))

File: /var/www/crm/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("postgres7 error: [-1: ERROR: invalid input syntax for integer: \"P:9\"] in EXECUTE(\"SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?\") ", 256)

File: /var/www/crm/libs/adodb/adodb.inc.php

    line 1043

    function called: ADODB_Error_Handler("postgres7", "EXECUTE", -1, "ERROR: invalid input syntax for integer: \"P:9\"", "SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array ("2", "P:9"), "Object (ADODB_postgres7)")

File: /var/www/crm/libs/adodb/adodb.inc.php

    line 1014

    function called: _Execute("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array ("2", "P:9"))

File: /var/www/crm/libs/adodb/adodb.inc.php

    line 1392

    function called: Execute("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array (2, "P:9"))

[PHP core called function]

    function called: GetAssoc("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array (2, "P:9"))

File: /var/www/crm/include/database.php

    line 459

    function called: call_user_func_array(Array (Object (ADODB_postgres7), "GetAssoc"), Array ("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=? AND internal_id=?", Array (#2)))

File: /var/www/crm/modules/Utils/Watchdog/WatchdogCommon_0.php

    line 46

    function called: GetAssoc("SELECT user_id,user_id FROM utils_watchdog_subscription WHERE category_id=%d AND internal_id=%s", Array ("2", "P:9"))

File: /var/www/crm/modules/CRM/Tasks/TasksCommon_0.php

    line 258

    function called: get_subscribers("contact", "P:9")

[PHP core called function]

    function called: submit_task(Array (#12), "added")

File: /var/www/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 701

    function called: call_user_func(Array ("CRM_TasksCommon", "submit_task"), Array (#12), "added")

File: /var/www/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 756

    function called: record_processing("task", Array (#12), "added")

File: /var/www/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 1125

    function called: new_record("task", Array (#12))

[PHP core called function]

    function called: view_entry("add", null, Array ("Kontynuacja: Zapytać o zainteresowanie wiertarką.", "0", "2", "Jakaś uwaga. ", "2012-02-10 16:25:53", Array (#2), "P:9", 0, Array (#3)))

File: /var/www/crm/include/module.php

    line 793

    function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry"), Array ("add", null, Array (#9)))

File: /var/www/crm/include/module.php

    line 713

    function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("add", null, Array (#9)), "view_entry")

File: /var/www/crm/modules/Base/Box/Box_0.php

    line 144

    function called: display_module("Object (Utils_RecordBrowser)", Array ("add", null, Array (#9)), "view_entry")

File: /var/www/crm/include/epesi.php

    line 209

    function called: body()

File: /var/www/crm/include/epesi.php

    line 265

    function called: go(Object (Base_Box))

File: /var/www/crm/process.php

    line 32

    function called: process("_qf__libs_qf_58c7c29e15f8efaa13b67ddfcf33410b=&submited=1&title=Znale%C5%BA%C4%87%20now%C4%85%20wiertark%C4%99%20moc%3D111&description=Ma%20bud%C5%BCet%20do%205tys.z%C5%82&&&employees=__SEP__4&status=0&deadline=02%2F14%2F2012&permission=0&priority=2&customers__search=&&customers=__SEP__P%3A9&__action_module__=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_fccfaae765da6468172aa0e28ff8b023", false)
This is on my second instalation with PostgreSQL 8.3.
Best regards,
Daniel
Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge
