Re: BillMax questions -- Trying to Add New Service Def Results in SQLError

[Douglas Dalrymple <doug@billmax.com>]

This is an error in the billmax/cfg/cgiaction.txt . I can be fixed by
creating a backup of the cgiaction.txt file then editing it as follows:

find the line starting with 'servdef,nums' (no quotes). The ##Dnumber#
strings in the following two lines need to have single quotes (') around
them. Save, then run billmax/bin/mkca to update the cgiaction table in
the database.


Paul Krensky wrote:
> 
> After installing BillMax, loging in, adding an admin
> account, first company and one resource, trying to add
> the first Service Definition results in the following
> error:
> 
> -------------------
> 
> bad SQL: 'SELECT count(*) FROM service WHERE
> service.servdef= AND state!=1'
> 
> error: You have an error in your SQL syntax near 'AND
> state!=1' at line 1
> 
> -----------------------
> 
> Have tried reinstalling, not sure if there is
> something else I need to configure prior to defining
> services or if there is an error in Version: 2.0.2
> Date: Aug 20 2002.
> 
> BillMax is running on RedHat 7.2 using the BillMax
> supplied Apache and MySQL.
> 
> Any help would be great.
> 
> Thanks,
> 
> Paul
> -----------------------------------------------------------------------------
> To unsubscribe from the "BillMax Questions" mailing list, please
> send a message to "majordomo@billmax.com" with "unsubscribe questions"
> in the message body. The message must be sent from the exact email
> address on the list.

-- 
Doug Dalrymple                                        Tel: 817-429-4440
Systems Integrator
iSpark Group, Inc.
doug@billmax.com                                 http://www.billmax.com
-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.