Hi all,
We have recently ran into a problem (error message quoted below). It occurs when a users clicks the 'Sales Opportunities' tab from the overview page of a company [Premium_SalesOpportunity -> company_addon()]. We're still running version 1.6.5, as I thought it wouldn't be a good idea to run an upgrade with this error present.
Any ideas, assistance or solutions are greatly appreciated. Thanks in advance!
Type: E_USER_ERROR (256)
Message: Argument 0 is not number(%d):
• SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))
• Array ( [0] => C:168 )
File: /crm.website.com/public_html/include/database.php
Line=155
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "Argument 0 is not number(%d):
• SELECT COUNT() FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))
• Array ( [0] => C:168 )
", "/crm.website.com/public_html/include/database.php", 155, Array ("SELECT COUNT() FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))", Array (#1), Array (#3), "SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = ", 0, 1, "%d"))
File: /crm.website.com/public_html/include/database.php
line 155
function called: trigger_error("Argument 0 is not number(%d):
• SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))
• Array ( [0] => C:168 )
", 256)
File: /crm.website.com/public_html/include/database.php
line 504
function called: TypeControl("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))", "Array (#1)")
File: /crm.website.com/public_html/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1247
function called: GetOne("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_customers = %d AND r.f_customers IS NOT NULL)))", Array ("C:168"))
File: /crm.website.com/public_html/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 919
function called: get_records_count("premium_salesopportunity", Object (Utils_RecordBrowser_Crits), false, Array ())
[PHP core called function]
function called: show_data(Array (Array (#1)), Array (), Array ("DESC"))
File: /crm.website.com/public_html/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "show_data"), Array (Array (#1), Array (#0), Array (#1)))
File: /crm.website.com/public_html/include/module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#1), Array (#0), Array (#1)), "show_data")
File: /crm.website.com/public_html/modules/Premium/SalesOpportunity/SalesOpportunity_0.php
line 94
function called: display_module(Object (Utils_RecordBrowser), Array (Array (#1), Array (#0), Array (#1)), "show_data")
[PHP core called function]
function called: company_addon(Array (#21), Object (Utils_RecordBrowser))
File: /crm.website.com/public_html/include/module.php
line 898
function called: call_user_func_array(Array (Object (Premium_SalesOpportunity), "company_addon"), Array (Array (#21), Object (Utils_RecordBrowser)))
File: /crm.website.com/public_html/include/module.php
line 818
function called: get_html_of_module(Object (Premium_SalesOpportunity), Array (Array (#21), Object (Utils_RecordBrowser)), "company_addon")
[PHP core called function]
function called: display_module(Object (Premium_SalesOpportunity), Array (Array (#21), Object (Utils_RecordBrowser)), "company_addon")
File: /crm.website.com/public_html/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 120
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "display_module"), Array ("Object (Premium_SalesOpportunity)", Array (#2), "company_addon"))
File: /crm.website.com/public_html/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 85
function called: display_contents(Array (1, Array (#2), Array (#3), false), 1, true)
[PHP core called function]
function called: body()
File: /crm.website.com/public_html/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())
File: /crm.website.com/public_html/include/module.php
line 818
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)
File: /crm.website.com/public_html/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1544
function called: display_module(Object (Utils_TabbedBrowser))
File: /crm.website.com/public_html/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1209
function called: view_entry("view", "168", Array (), true)
[PHP core called function]
function called: view_entry_with_REQUEST("view", "168", Array (), true, Array ())
File: /crm.website.com/public_html/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "168", Array (#0), true, Array (#0)))
File: /crm.website.com/public_html/include/module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "168", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
File: /crm.website.com/public_html/modules/Base/Box/Box_0.php
line 138
function called: display_module(Object (Utils_RecordBrowser), Array ("view", "168", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
File: /crm.website.com/public_html/include/epesi.php
line 246
function called: body()
File: /crm.website.com/public_html/include/epesi.php
line 291
function called: go(Object (Base_Box))
File: /crm.website.com/public_html/process.php
line 41
function called: process("action_module=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_2ec22891e8a6728b6edb5d2a8954bf28%2FUtils_TabbedBrowser%7Crecordbrowser_addons_company_168&%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_2ec22891e8a6728b6edb5d2a8954bf28%2FUtils_TabbedBrowser%7Crecordbrowser_addons_company_168_page=1", "")
