(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Import Gone Awry and Can't Delete
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Import Gone Awry and Can't Delete (Read 505 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Import Gone Awry and Can't Delete
Apr 19th, 2012 at 2:25am
Print Post Print Post  
Hi all,

One of my staff attempted an import that went horribly awry ... the records went to the wrong fields, and I need to delete them.

However, as of this moment, I can't delete any records in the database -- not by F3, not by Mass Delete ... what can I do to fix this?

Thanks,
Blair
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Import Gone Awry and Can't Delete
Reply #1 - Apr 19th, 2012 at 12:50pm
Print Post Print Post  
What happens when you try to delete records? Do you have a NotifyForm flag set that prevents delete?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Import Gone Awry and Can't Delete
Reply #2 - Apr 19th, 2012 at 2:38pm
Print Post Print Post  
Hi Blair,

Retrieve the records you wish to delete
Run a Mass Update on the first record that has just
Code
Select All
NotifyForm(0)

Choose Mass Delete on the Menu tree.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Import Gone Awry and Can't Delete
Reply #3 - Apr 19th, 2012 at 5:29pm
Print Post Print Post  
I ended up restoring a pre-import backup in the wee small hours and that seems to do it. 

It may have been a NotifyForm issue, as there was also an upgrade to our database yesterday ... I'm going through the code that was added today.

Thanks for the suggestions!
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge