BillMax Nextusagedate is '0000-00-00'

When entering new services, I was having this error, and I couldn’t figure out why:

Checking Table 'service'   ERROR: 10813...service(number=XXXXXXX): Nextusagedate is '0000-00-00' (FIX MANUALLY)

BillMax support promptly acknowledged that it is a bug that cause this behavior under rare circumstances.  The solution is to run on the billmax database the following SQL:

update service set nextusagedate=invdate where number=<XXXXXXX>;
Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Blogplay
  • email
  • LinkedIn
  • PDF
  • Ping.fm
  • RSS
  • Slashdot
  • Twitter
This entry was posted in Uncategorized and tagged , , , , , . Bookmark the permalink.
blog comments powered by Disqus