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

[Ivan Kohler]

On Thu, Jul 31, 2008 at 12:30:13PM +0200, Twanny Azzopardi wrote:
> 
> 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?

Fixed in CVS, will be in 1.9.3.  (MySQL-specific)

-- 
_ivan