[Vtigercrm-developers] Error during module installation

[Mariusz Krzaczkowski]

Hi

Better solution to checking for an existing table is a query (not generate
an error):

*SHOW TABLES LIKE "vtiger_account";*

*Z poważaniem / Best regards*
*Mariusz Krzaczkowski* *
*
*m.krzaczkowski at opensaas.pl
www.OpenSaaS.pl <http://www.opensaas.pl/>*

---------- Wiadomość przekazana dalej ----------
> From: Vikas Jain <vikas at vtiger.com>
> To: vtigercrm-developers at lists.vtigercrm.com
> Cc:
> Date: Tue, 22 Oct 2013 17:14:05 +0530
> Subject: Re: [Vtigercrm-developers] Error during module installation
> Mariusz,
> When creating any table we first check if it already exists, if it does
> not exist then only we create the table.
> If the table exists then we dont create the table.
>
> On 22 October 2013 16:28, Mariusz Krzaczkowski <m.krzaczkowski at opensaas.pl
> > wrote:
> Hi
> *Why during installation module is the called query when the table does
> not exist?* Here is an example of the log:
> 10/22/13 10:44:56,432 [1676] INFO VT - PearDatabase ->ADODB error  Query
> Failed:SELECT 1 FROM vtiger_osspasswords LIMIT 1::->[1146]Table
> 'vtiger6_4.vtiger_osspasswords' doesn't exist
> 10/22/13 10:44:56,432 [1676] DEBUG VT - SQL: CREATE TABLE
> `vtiger_osspasswords` (
> `osspasswordsid` int(11) NOT NULL,
> `osspassword_no` varchar(30) NOT NULL,
>                 `passwordname` varchar(100) NOT NULL,
> `username` varchar(100) NOT NULL,
> `password` varbinary(200) NOT NULL,
> `link_adres` varchar(100) DEFAULT NULL,
>                 `linkto` varchar(100) default NULL,
> PRIMARY KEY  (`osspasswordsid`),
> CONSTRAINT `fk_1_vtiger_osspasswords` FOREIGN KEY (`osspasswordsid`)
> REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
>              ...
> *Z poważaniem / Best regards*
> *Mariusz Krzaczkowski*
> *m.krzaczkowski at opensaas.pl*
> _______________________________________________
> http://www.vtiger.com/
>
>
> --
> Regards
> Vikas
> Vtiger Team

10/22/13 10:44:56,431 [1676] DEBUG VT - Prepared sql query being executed :
>> SELECT 1 FROM vtiger_osspasswords LIMIT 1
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20131024/2a7f286b/attachment.html>