Error when a specific user wants to login

lifechangeat

Hi Team,

I got a strange error but only with one certain user. When this user tries to login I get the following error message:

[list:h0usopux]
Type: E_USER_ERROR (256)
Message: Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __809__812__ )

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
Line=131
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __809__812__ )

", "/home/www/zhb/crm.zenker-hausbau.at/include/database.php", 131, Array ("SELECT f_login FROM contact_data_1 WHERE id=%d", Array (#1), Array (#3), "SELECT f_login FROM contact_data_1 WHERE id=", 0, 1, "%d"))

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
line 131
function called: trigger_error("Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __809__812__ )

", 256)

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
line 479
function called: TypeControl("SELECT f_login FROM contact_data_1 WHERE id=%d", "Array (#1)")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 262
function called: GetOne("SELECT f_login FROM contact_data_1 WHERE id=%d", Array ("__809__812__"))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1451
function called: get_value("contact", "__809__812__", "login")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1618
function called: check_record_against_crits("task", Array (#25), Array ("5", "5"))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 2063
function called: get_access("task", "view", Array (#25))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 2125
function called: get_edit_details_modify_record("task", "9", "2", true)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/CRM/Tasks/TasksCommon_0.php
line 239
function called: watchdog_label("task", "Aufgaben", "9", Array ("C", "E_2", "D", "E_40"), "title", true)

[PHP core called function]
function called: watchdog_label("9", Array ("C", "E_2", "D", "E_40"))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/Watchdog/Watchdog_0.php
line 67
function called: call_user_func(Array ("CRM_TasksCommon", "watchdog_label"), "9", Array ("C", "E_2", "D", "E_40"))

[PHP core called function]
function called: applet(Array (#11), Array ("Watchdog - Alle", true, null, false, "body", Array (#0), Array (#0), Array (#0), "52"), "52")

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_Watchdog), "applet"), Array (Array (#11), "Array (\"Watchdog - Alle\", true, null, false, \"body\", Array (#0), Array (#0), Array (#0), \"52\")", "52"))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Dashboard/Dashboard_0.php
line 192
function called: get_html_of_module(Object (Utils_Watchdog), Array (Array (#11), "\"Array (\\"Watchdog - Alle\\", true, null, false, \\"body\\", Array (#0), Array (#0), Array (#0), \\"52\\")\"", "52"), "applet")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Dashboard/Dashboard_0.php
line 126
function called: display_dashboard("7")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Dashboard/Dashboard_0.php
line 29
function called: dashboard()

[PHP core called function]
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Dashboard), "body"), Array ())

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 713
function called: get_html_of_module(Object (Base_Dashboard), null, "body")

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 886
function called: display_module("Object (Base_Dashboard)", null, "body")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/HomePage/HomePage_0.php
line 24
function called: pack_module("Base/Dashboard", null, "body", null)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/HomePage/HomePage_0.php
line 17
function called: show_home_page(Array ("Base/Dashboard"))

[PHP core called function]
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_HomePage), "body"), Array ())

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 713
function called: get_html_of_module(Object (Base_HomePage), null, null)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Box/Box_0.php
line 146
function called: display_module("Object (Base_HomePage)")

File: /home/www/zhb/crm.zenker-hausbau.at/include/epesi.php
line 213
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/epesi.php
line 258
function called: go(Object (Base_Box))

File: /home/www/zhb/crm.zenker-hausbau.at/process.php
line 32
function called: process("Base_HomePage_load=1", false)
[/list:u:h0usopux]

Can you give me a hint on what's going wrong there?

Thx and Greetz, Hannes

ajb

There is a watchdog notification pending for this user. For task id=9. To generate label RecordBrowsers checks permissions to this record and it looks like multiselect record field has been changed to the single select type. And value hasn't been changed. Employees (@ tasks recordset) field is now single selection? To fix this issue you can try to edit this record (task id 9) Admin -> RecordBrowser or in database.

Regards,
Adam

lifechangeat

Hi Adamn,

thanks for your help but I don't exactly know, what to do.

Yep, I changed the Employees Field to single selection, according to customers wish.

Now I saw, that this task ID-9 had been deleted and also the test customer it was assigned to. I reactivated both (customer and Task-ID9) and reentered the employee Machhammer as owner of this task.

But it still gives me:

[quote:in45vu2d]Hide
Type: E_USER_ERROR (256)
Message: Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __788__809__ )

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
Line=131
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __788__809__ )

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
line 131
function called: trigger_error("Argument 0 is not number(%d):

SELECT f_login FROM contact_data_1 WHERE id=%d
Array ( [0] => __788__809__ )

", 256)

File: /home/www/zhb/crm.zenker-hausbau.at/include/database.php
line 479
function called: TypeControl("SELECT f_login FROM contact_data_1 WHERE id=%d", "Array (#1)")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1451
function called: get_value("contact", "__788__809__", "login")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1618
function called: check_record_against_crits("task", Array (#25), Array ("5", "5"))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 2063
function called: get_access("task", "view", Array (#25))

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 2125
function called: get_edit_details_modify_record("task", "10", "12", true)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/CRM/Tasks/TasksCommon_0.php
line 239
function called: watchdog_label("task", "Aufgaben", "10", Array ("C", "E_12", "D", "E_43"), "title", true)

[PHP core called function]
function called: watchdog_label("10", Array ("C", "E_12", "D", "E_43"))

[PHP core called function]
function called: applet(Array (#11), Array ("Watchdog - Alle", true, null, false, "body", Array (#0), Array (#0), Array (#0), "52"), "52")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Dashboard/Dashboard_0.php
line 126
function called: display_dashboard("7")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Dashboard/Dashboard_0.php
line 29
function called: dashboard()

[PHP core called function]
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Dashboard), "body"), Array ())

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 713
function called: get_html_of_module(Object (Base_Dashboard), null, "body")

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 886
function called: display_module("Object (Base_Dashboard)", null, "body")

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/HomePage/HomePage_0.php
line 24
function called: pack_module("Base/Dashboard", null, "body", null)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/HomePage/HomePage_0.php
line 17
function called: show_home_page(Array ("Base/Dashboard"))

[PHP core called function]
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_HomePage), "body"), Array ())

File: /home/www/zhb/crm.zenker-hausbau.at/include/module.php
line 713
function called: get_html_of_module(Object (Base_HomePage), null, null)

File: /home/www/zhb/crm.zenker-hausbau.at/modules/Base/Box/Box_0.php
line 146
function called: display_module("Object (Base_HomePage)")

File: /home/www/zhb/crm.zenker-hausbau.at/include/epesi.php
line 213
function called: body()

File: /home/www/zhb/crm.zenker-hausbau.at/include/epesi.php
line 258
function called: go(Object (Base_Box))

File: /home/www/zhb/crm.zenker-hausbau.at/process.php
line 32
function called: process("", "0")[/quote:in45vu2d]

What should I do now? Can you give me a hint?

Thanks a lot in advance,

Hannes

ajb

If record has been removed then you should not bother with this notifications as probably they are worthless. Just restore it's state(delete them) and remove all watchdog events for this record.



$users = DB::GetCol("SELECT id FROM user_login");

foreach ($users as $user_id) Utils_WatchdogCommon::user_notified($user_id, 'task', 10);

Regards,
Adam

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge