vtiger

[reetp]

Today I decided to do some house keeping and mark as completed the campaigns that I knew we had finished.

I used Quickedit to change the status but didn't check the records.

One of my users logged in this afternoon and Lo ! each Campaign marked as completed has lost the contacts and leads associated with it.

That's a whole lot of work lost as we had separated out customers into different groups so we could duplicate the campaigns.

Anyway, the important thing is trying to track down why it happened and prevent it repeating.

I have tried to create a new campaign, add in contacts & leads and then come back and change its status, but the records were still there.

Any other ideas where I can look or do I post a bug ?

B. Rgds
John

[pratim]

Hi john,
I can not able to produce the issue.Have you given any sharing access rule for Contacts and Leads that means have you made them private in the Sharing access so the other user can not see those.If this is not the case then can you share some information like the platform you ran vtiger, The operating system used, php version, apache version, mysql in use.So I can able to produce the issue.

Regards,
Pratim
VtigerTeam

[reetp]

Hi Pratim,

Thanks for replying.

Quote: I can not able to produce the issue.Have you given any sharing access rule for Contacts and Leads that means have you made them private in the Sharing access so the other user can not see those.


No

Quote: If this is not the case then can you share some information like the platform you ran vtiger, The operating system used, php version, apache version, mysql in use.So I can able to produce the issue.

Details as below. I have been looking though the various campaigns. Some have got odd contacts or leads left in there. Some have none. One seems to have EVERY record in my contacts !!

It looks like the Campaign section of the database has been well and truly mangled at some point.........

I have noticed problems in the past when sending to a large number of people with an attachment - I operate on the end of a slowish broadband link to my server. The 'email' section of the contacts does not always update correctly to show that a mail has been sent by the Campaign.

http://forums.vtiger.com/viewtopic.php?t=20834&highlight=

Also think that the email from Clement Chazarra 29/7/08 on the developers mailing list may have some bearing on the subject :


Quote:
At the moment I am testing to send emails with attachment, and actually it takes about 20 sec, which is a little bit excessive in my point of view.
After debugging I finally get to the class.smtp.php file, in the Data() function, the 'while' condition from line 331 is parsing the message to be sent on the smtp server.

With no attachment the process is really fast, but once you attach a file to the mail, the file is also parsed, line by line and that's what take so long, depending on the file size.
I am not a smtp specialist, so I would like to ask the community if this seems to be the only way, or most fast way to send an attachment to an smtp server.
I would love to talk about it with the vTiger Developer working on the mail module, because I think that it is an issue which needs to be fixed.


With a slow link, a thousand emails with say a 1mb attachment takes quite a while to send. I also had situations when using Firefox 2 that the send window sometimes did not close, and maybe somewhere things are not updating correctly.

If you want further information then please let me know.

B. Rgds
John

SME server Based on CentOS (www.contribs.org)
Kernel : 2.6.9-67.0.7.EL

Various installed packages :

rpm -qa|grep apache
e-smith-apache-1.2.0-16.el4.sme

httpd -v
Server version: Apache/2.0.52
Server built: Jan 14 2008 08:20:27

rpm -qa|grep php
php-common-5.1.6-3.el4s1.8
php-pear-HTTP-1.4.0-7.el4.centos
php-mysql-5.1.6-3.el4s1.8
php-pear-Net-Socket-1.0.6-5.el4.centos
php-pear-Mail-1.1.14-1.el4.centos
php-5.1.6-3.el4s1.8
php-pear-Net-SMTP-1.2.8-5.el4.centos
php-gd-5.1.6-3.el4s1.8
php-pear-XML-Parser-1.2.7-4.el4.centos
e-smith-php-1.12.0-4.el4.sme
php-pear-1.4.11-1.el4s1.1
php-xml-5.1.6-3.el4s1.8
php-pear-DB-1.7.6-6.el4.centos
php-pdo-5.1.6-3.el4s1.8
smeserver-phpmyadmin-multiuser-2.11.3-1.el4.sme
smeserver-phpsysinfo-2.5.4-0dmay
php-pear-Auth-SASL-1.0.2-4.el4.centos
php-mbstring-5.1.6-3.el4s1.8
php-ldap-5.1.6-3.el4s1.8
php-cli-5.1.6-3.el4s1.8
php-imap-5.1.6-3.el4s1.8

php -v
PHP 5.1.6 (cli) (built: Oct 26 2007 13:49:00)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

rpm -qa|grep mysql
php-mysql-5.1.6-3.el4s1.8
mysql-5.0.58-1.el4.centos
smeserver-nagios-plugins-mysql-1.0.2-0
mysqlclient14-4.1.14-4.2.c4.1
mysql-server-5.0.58-1.el4.centos
warning: only V3 signatures can be verified, skipping V4 signature
e-smith-mysql-1.12.0-15.el4.sme
mysql-libs-5.0.58-1.el4.centos
mysql-server-5.0.58-1.el4.centos

mysql -v
Server version: 5.0.58 Source distribution

[reetp]

Pratim, have you any further thoughts on this ?