[Vtigercrm-developers] All records which have been deleted fromRecycle Bin will be still in the mysql database.

[Holbok István]

Hi Uma,

This issue is still valid for the custom modules as well:
http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8084#comment:4

Please find the comment 4 in the track, I think the solution is in the 
comment.
The issue was tested in vtiger 6.1.0 svn 14155 (latest version).

Kindest regards:
Istvan

üdvözlettel:

*Holbok István*

+3670-342-0900
*e-mail:* holbok at gmail.com
*SkyPe:* holboki

2014.06.06. 14:59 keltezéssel, Uma S írta:
> Hi,
>
> The problem is due to foreign key reference of vtiger_invoice table 
> with vtiger_salesorder by salesorderid column.
>
>
> On Fri, Jun 6, 2014 at 12:44 PM, 忍.... <896177346 at qq.com 
> <mailto:896177346 at qq.com>> wrote:
>
>     Hello,
>
>     after Empty Recycle Bin, it can only permanently remove all the
>     deleted records from the database for Account,Contact,Leads
>     module, but not for other module such as SalesOrder, Invoice ... .
>
>     For example,  you delete a record from invoice module and Empty
>     Recycle Bin,
>     then you can check the database tablename vtiger_crmentity and
>     vtiger_invoice,
>     in the table vtiger_crmentity, the deleted records are removed,
>     but in the table vtiger_invoice, the deleted records are still
>     there, that's the problem we said.
>
>     please check.
>
>     Regards!
>     Andy
>
>
>     ------------------ 原始邮件 ------------------
>     *发件人:* "Rishab K";<rishab.k at vtiger.com
>     <mailto:rishab.k at vtiger.com>>;
>     *发送时间:* 2014年6月6日(星期五) 下午3:02
>     *收件人:* "vtigercrm-developers"<vtigercrm-
>     developers at lists.vtigercrm.com
>     <mailto:vtigercrm-developers at lists.vtigercrm.com>>;
>     *主题:* Re: [Vtigercrm-developers] All records which have been
>     deleted fromRecycle Bin will be still in the mysql database.
>
>     We have updated the trac
>     <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8084> .Have a look
>     at it.Please let us know if we are missing something here.
>
>     Reagrds,
>
>     Rishab-Vtiger team
>
>
>     On Fri, Jun 6, 2014 at 11:05 AM, Uma S <uma.s at vtiger.com
>     <mailto:uma.s at vtiger.com>> wrote:
>
>         Hi,
>
>         I have raised a ticket for same in trac
>         <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8084>. We will
>         look into this soon.
>
>
>         On Thu, Jun 5, 2014 at 7:46 PM, Alan Lord
>         <alanslists at gmail.com <mailto:alanslists at gmail.com>> wrote:
>
>             On 05/06/14 15:14, Stencel, Maciej wrote:
>
>                 If You delete record from crm it is only marked as
>                 deleted.
>
>                 It is just hidden.
>
>                 It is wiped out of database if you delete it from
>                 Recycle Bin module.
>
>
>             Not if it is a vtlib module it isn't... ;-)
>
>             As I discovered today on a VT6.0.0 installation.
>
>             Al
>
>
>             _______________________________________________
>             http://www.vtiger.com/
>
>
>
>
>         -- 
>         With
>         Best Regards
>         Uma.S
>         Vtiger Team
>
>         _______________________________________________
>         http://www.vtiger.com/
>
>
>
>     _______________________________________________
>     http://www.vtiger.com/
>
>
>
>
> -- 
> With
> Best Regards
> Uma.S
> Vtiger Team
>
>
> _______________________________________________
> http://www.vtiger.com/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140629/94d8016c/attachment.html>