[freeside-users] cannot list customers by active trouble tickets

[Twanny Azzopardi]

Error executing "SELECT cust_main.*, ( select count(*) from tickets
join links on ( tickets.id = links.localbase )
where ( status = 'new' or status = 'open' or status = 'stalled' )
and target = 'freeside://freeside/cust_main/' || custnum
) as tickets FROM cust_main WHERE ( agentnum = 1 OR agentnum IS NULL ) ORDER BY tickets DESC LIMIT 100": Table 'freeside.tickets' doesn't exist at /var/www/html/freeside/search/cust_main.cgi line 155

Regarding this error, maybe it's because all the tables, except one, created by rt are first letter capitalized and the cgi is referring to them with lower case?

Regards,
Twanny.
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE