<div dir="ltr">Mariusz,<div><br></div><div>When creating any table we first check if it already exists, if it does not exist then only we create the table.</div><div>If the table exists then we dont create the table.</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Hi</div><div><br></div><div><b>Why during installation module is the called query when the table does not exist?</b> Here is an example of the log:</div>
</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">
10/22/13 10:44:56,431 [1676] DEBUG VT - Prepared sql query being executed : SELECT 1 FROM vtiger_osspasswords LIMIT 1<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 exist<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>
... </blockquote></div><br clear="all"><div><div><b>Z poważaniem / <span style="font-size:10pt">Best regards</span></b></div><span class="HOEnZb"><font color="#888888"><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>
</b></div></font></span></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>