Re: BillMax questions -- service definitions error

[Douglas Dalrymple <doug@billmax.com>]

This error message is as a result of a new routine in dbck that was added in
2.0.6. The fix technique given by Eric is appropriate.

Eric Osterberg - Systems Admin wrote:

>That depends on what you want the resources to be on the old services.
>If the change in resources was a correction, you most likely want to fix
>the old services with the mysql backend.
>
>Something like this should fix the service one at a time.
>UPDATE service SET resources = '31' WHERE number = '7';
>
>This is most likely going to be better, as it will update all the services
>with the same servdef.
>UPDATE service SET resources = '31' WHERE servdef = '5';
>
>
>		Eric Osterberg
>
>Network Administrator      e: staff@scc.net      Personal Email ejo1@scc.net
>Sound Choice Internet      v: 651 999-0999       Office Hours: M-F 9a-6p
>Saint Paul, Minnesota      f: 651 644-7990       Support Hours: 7d/24hrs
>
>On Sat, 22 Feb 2003, Dustin Hansen wrote:
>  
>
>>Having trouble with service definitions and resources, this is what we are
>>getting in our error log;
>>
>>....service(number=7): Service (resources=7) don't match the corresponding
>>(servdef=5) (resources=31) (FIX MANUALLY)
>>....service(number=8): Service (resources=7) don't match the corresponding
>>(servdef=6) (resources=31) (FIX MANUALLY)
>>....service(number=12): Service (resources=7) don't match the corresponding
>>(servdef=1) (resources=31) (FIX MANUALLY)
>>
>>One of our employees did go in and change some the of the resources and I'm
>>guessing that is what caused this, does anyone know of a fix??? We are
>>running billmax v2.0.6.
>>
>>Thanks,
>>Dustin Hansen
>>All Idaho Internet
>>http://allidaho.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.
>  
>

-- 
Doug Dalrymple, Systems Integrator                     doug@billmax.com
iSpark Group, Inc./dba BillMax Billing Solutions      Tel: 817-446-7776
67737 Brentwood Stair Rd.,  Suite 210                 Fax: 817-446-7773
Fort Worth TX 76112                              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.