Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hello Im using GMFO w/SQL 7. Tod
- Thread starter ddeegan
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
check to see if your lookup.ini file is still in the goldmine directory....
- Thread starter
- #3
RobColborne
MIS
The Lookup.ini file has nothing to do with F2 Lookups.
Run the following query in GoldMine:
Select * from Lookup
And see what is returned?
There would be no reason that lookups would suddently vanish, would anyone been doing any maintenance on the database, or creating new databases?
Robert Colborne
CRM Solutions with GoldMine and HEAT
Run the following query in GoldMine:
Select * from Lookup
And see what is returned?
There would be no reason that lookups would suddently vanish, would anyone been doing any maintenance on the database, or creating new databases?
Robert Colborne
CRM Solutions with GoldMine and HEAT
- Thread starter
- #5
Hi Rob, I pulled a backup and ran a statement to see which ones were missing. There were records in my backup lookup that were not in my live table.
I imported from my backup. I also have never heard of anything like this, but the records were definately gone. I have been trying to figure out what happened but come up to a brick wall.
Below was part of what I found.
There were 3 users that had ability to delete records, I thought this might be it, but this means that they removed every lookup for every field, some of them they did not have access to.
We had another installation of GMFO, but made the GM.ini the same as the others. This may redirect where to look for the lookup (*maybe to GMBase dbf), but wouldn't have deleted records from my SQL.
I created a test F2 lookup, it wrote to the correct LOOKUP, no problem.
This only seemed to affect LOOKUP. I looked at some of the other GMBase files, and did not notice any records missing.
I tried finding information from conttlog, but this did not reveal anything.
Retrieving from backup was time consuming, once I had the records back, I moved on to everything I was behind on. If you have any other ideas, please post them. I'm still interested in figuring this out so I can prevent it from happening again, plus my own curiosity is killing me.
Thanks for responding
Dave
I imported from my backup. I also have never heard of anything like this, but the records were definately gone. I have been trying to figure out what happened but come up to a brick wall.
Below was part of what I found.
There were 3 users that had ability to delete records, I thought this might be it, but this means that they removed every lookup for every field, some of them they did not have access to.
We had another installation of GMFO, but made the GM.ini the same as the others. This may redirect where to look for the lookup (*maybe to GMBase dbf), but wouldn't have deleted records from my SQL.
I created a test F2 lookup, it wrote to the correct LOOKUP, no problem.
This only seemed to affect LOOKUP. I looked at some of the other GMBase files, and did not notice any records missing.
I tried finding information from conttlog, but this did not reveal anything.
Retrieving from backup was time consuming, once I had the records back, I moved on to everything I was behind on. If you have any other ideas, please post them. I'm still interested in figuring this out so I can prevent it from happening again, plus my own curiosity is killing me.
Thanks for responding
Dave
- Status
Similar threads