Anonymous Login
2019-12-12 11:06 PST

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001111Third-party ModulesHelpdeskpublic2014-06-11 22:09
Reporterqualitypro 
Assigned Tocaseydk 
PrioritynormalSeveritytweakReproducibilitysometimes
StatusresolvedResolutionfixed 
Product Version 
Target VersionFixed in Version 
Summary0001111: Helpdesk Module Error by add contact
Descriptioni have an error by adding an contact by add a new heldeskp object.


click to visit web2Project site
/var/www/web2project/classes/w2p/Database/Query.class.php(1121): query failed(SELECT DISTINCT contact_company FROM ((`contacts` AS contacts)) WHERE contact_id IN (undefined)) - error was: Unknown column 'undefined' in 'where clause'

ERROR: /var/www/web2project/classes/w2p/Database/Query.class.php(1121) : query failed(SELECT DISTINCT contact_company FROM ((`contacts` AS contacts)) WHERE contact_id IN (undefined)) - error was: Unknown column 'undefined' in 'where clause'
Backtrace:
0 /var/www/web2project/classes/w2p/Database/Query.class.php:1121 dprint()
1 /var/www/web2project/classes/w2p/Database/Query.class.php:1239 exec()
2 /var/www/web2project/modules/public/contact_selector.php:66 loadColumn()
3 /var/www/web2project/index.php:282 require()
Unknown column 'undefined' in 'where clause'
Additional Information2.4 Patch:

After line 60 of modules->public->contact_selector.php:

Code:

$q = new w2p_Database_Query;


I added the following to line 62:

Code:

$show_all = TRUE;


Fixed it for me!
TagsNo tags attached.
Attached Files

-Relationships
+Relationships

-Notes

~0003453

caseydk (administrator)

Resolved in latest development:
https://github.com/caseysoftware/web2project-helpdesk
+Notes

-Issue History
Date Modified Username Field Change
2012-03-26 08:28 qualitypro New Issue
2012-04-21 19:07 caseydk Project v2.4 Release (Closed) => v3.0 Release
2012-07-13 22:40 caseydk Project v3.0 Release => Third-party Modules
2014-04-05 17:44 caseydk Category General => Helpdesk
2014-04-05 17:44 caseydk Product Version 2.4 =>
2014-06-11 22:09 caseydk Note Added: 0003453
2014-06-11 22:09 caseydk Status new => resolved
2014-06-11 22:09 caseydk Resolution open => fixed
2014-06-11 22:09 caseydk Assigned To => caseydk
+Issue History