<div dir="ltr">Mariusz,<div><br></div><div>I agree this is a better solution, we will change this to use this solution.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 24 October 2013 12:20, Mariusz Krzaczkowski <span dir="ltr"><<a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 class="im"><div><b>Z poważaniem / <span style="font-size:10pt">Best regards</span></b></div><div><b>Mariusz Krzaczkowski</b> <b><br></b></div></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" target="_blank">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" target="_blank">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><div class="im">Mariusz,<br>When creating any table we first check if it already <span>exists</span>, if it does not <span>exist</span> then only we create the table.<br>If the table <span>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>exist</span>?</b> Here is an example of the log:<br>
</div><div class="im">
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>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</div></blockquote><div class="im">
<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></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards<br>Vikas<br>Vtiger Team
</div>