<div dir="ltr"><div>Hi</div><div><br></div><div>Better solution to checking for an existing table is a query (not generate an error):</div><div><br></div><div class="gmail_extra"><b>SHOW TABLES LIKE "vtiger_account";</b><br>
</div><div class="gmail_extra"><br clear="all"><div><div><b>Z poważaniem / <span style="font-size:10pt;color:rgb(0,0,0)">Best regards</span></b></div><div><b>Mariusz Krzaczkowski</b> <b><br></b></div><div><b><a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a><br>
<font color="#888888"><span style="color:rgb(127,127,127)"></span></font><font color="#888888"><span style="color:rgb(127,127,127)"><a href="http://www.opensaas.pl/" target="_blank">www.OpenSaaS.pl</a></span></font></b></div>
<div><br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span style="font-family:arial,sans-serif;font-size:13px">---------- Wiadomość przekazana dalej ----------<br>
</span><span style="font-family:arial,sans-serif;font-size:13px">From: Vikas Jain <<a href="mailto:vikas@vtiger.com">vikas@vtiger.com</a>><br></span><span style="font-family:arial,sans-serif;font-size:13px">To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
</span><span style="font-family:arial,sans-serif;font-size:13px">Cc: <br></span><span style="font-family:arial,sans-serif;font-size:13px">Date: Tue, 22 Oct 2013 17:14:05 +0530<br></span><span style="font-family:arial,sans-serif;font-size:13px">Subject: Re: [Vtigercrm-developers] Error during module installation<br>
</span>Mariusz,<br>When creating any table we first check if it already <span class="">exists</span>, if it does not <span class="">exist</span> then only we create the table.<br>If the table <span class="">exists</span> then we dont create the table.<br>
<br>On 22 October 2013 16:28, Mariusz Krzaczkowski <span dir="ltr"><<a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a>></span> wrote:<br>Hi<br><b>Why during installation module is the called query when the table does not <span class="">exist</span>?</b> Here is an example of the log:<br>
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 <span class="">exist</span><br>
10/22/13 10:44:56,432 [1676] DEBUG VT - SQL: CREATE TABLE `vtiger_osspasswords` (<br><span style="white-space:pre-wrap">                          </span>`osspasswordsid` int(11) NOT NULL,<br><span style="white-space:pre-wrap">                            </span>`osspassword_no` varchar(30) NOT NULL,<br>
                `passwordname` varchar(100) NOT NULL,<br><span style="white-space:pre-wrap">                              </span>`username` varchar(100) NOT NULL,<br><span style="white-space:pre-wrap">                             </span>`password` varbinary(200) NOT NULL,<br>
<span style="white-space:pre-wrap">                             </span>`link_adres` varchar(100) DEFAULT NULL,<br>                `linkto` varchar(100) default NULL,<br><span style="white-space:pre-wrap">                          </span>PRIMARY KEY  (`osspasswordsid`),<br>
<span style="white-space:pre-wrap">                             </span>CONSTRAINT `fk_1_vtiger_osspasswords` FOREIGN KEY (`osspasswordsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE<br><span style="white-space:pre-wrap">                        </span>) ENGINE=InnoDB DEFAULT CHARSET=utf8<br>
             ... <br clear="all"><b>Z poważaniem / <span style="font-size:10pt">Best regards</span></b><br><b>Mariusz Krzaczkowski</b> <br><b><a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a></b><br>
_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br><br clear="all"><br>-- <br>Regards<br>Vikas<br>Vtiger Team</blockquote><div class="gmail_quote">
<div class="gmail_extra" style="font-family:arial,sans-serif;font-size:13px"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr"><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">10/22/13 10:44:56,431 [1676] DEBUG VT - Prepared sql query being executed : SELECT 1 FROM vtiger_osspasswords LIMIT 1<br>
</blockquote></div></div></blockquote></div></div></div></div></div>