1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Product Sales Report, "field not modifiable"

Discussion in 'Optigold ISP' started by thenickberry, Jan 2, 2007.

  1. #1
    While running a Product Sales Report, we're getting the error "this field is not modifiable"
    SEMrush
    [​IMG]

    Has anyone had this before? Any suggestions?
     
    thenickberry, Jan 2, 2007 IP
    SEMrush
  2. thenickberry

    thenickberry Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    forums.digitalpoint.com/showthread.php?t=16560

    How would I know if my database files were locked? How can I unlock them?
     
    thenickberry, Jan 3, 2007 IP
  3. thenickberry

    thenickberry Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I also cannot print invoices...

    "Printing could not be completed because there are no records in this file or your password does not allow access to field definitions or scripts"

    Last Friday, we deleted approximately 4000 records (everything with a termination date prior to 1/1/2006 and status set to Closed).

    The only two things that have happened between now and when this worked last week were the deletion and the new year. I can't imagine there is a Y2K7 bug, so could the deletion have made this mess? Or is something else going on?

    Anyone?
     
    thenickberry, Jan 3, 2007 IP
  4. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #4
    ColinR, Jan 3, 2007 IP
  5. thenickberry

    thenickberry Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ColinR: how do you do an update from to same version?

    I finally fixed the issue. After shutting down FM Server, I made a backup copy of the database files and I recovered every file under C:\Program Files\Optigold ISP. After renaming the new files (tedious), I opened Optigold under FM Pro and was able to run the reports as well as print invoices. Started FM Server back up and everything is working as it did before.

    Thanks mcolvin and ColinR for you help
     
    thenickberry, Jan 4, 2007 IP
  6. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #6
    just have your files in c:\program files\optigold isp\
    the setup program should detect them and ask if you want to upgrade
    Test it first :)
     
    ColinR, Jan 4, 2007 IP