<div dir="ltr">InnoDB is preferable. Please the default engine type to the same.</div><div class="gmail_extra"><br clear="all"><div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect with us on: </b><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/index.php/Main_Page" style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a href="https://discussions.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Forums </a><b>I</b> <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></span></div>
<br><br><div class="gmail_quote">On Sat, Aug 30, 2014 at 4:18 PM, Holbok István <span dir="ltr"><<a href="mailto:holbok@gmail.com" target="_blank">holbok@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Dear vtiger Team,<br>
<br>
One of my vtiger 6.1.0 EA instance has a totally different MySQL
database structure then others.<br>
If I knew well, the preferred database engine of vtiger 6.1 is <b>InnoDB
</b>due to using foreign_keys. <br>
In a my XAMPP / <b>MySQL 5.5</b> instance all table was InnoDB.<br>
In an other XAMPP instance with <b>MySQL 5.6</b> all table was
InnoDB as well.<br>
<br>
I have just checked an other instance LINUX (CentOS, C-panel, MySQL
5.6.17)<br>
The MySQL basic setup (in my.cnf file) was the same as in the
Windows /XAMPP MySQl 5.6 -> the default database engine was
InnoDB (this is the 5.6 default).<br>
But the vtiger instance has InnoDB engine in only ~20% of table, all
other table engines is MyISAM.<br>
<br>
It indicates there is some <b>uncertainty </b>and the SQL table
install depended in this case from some environment variables. <br>
<br>
The file .../schema/DatabaseSchema.xml defines InnoDB engine for
all tables.<br>
The function <b>initialize()</b> in
.../modules/Install/models/InitSchema.php uses it:
$adb->createTables("schema/DatabaseSchema.xml");<br>
But in this case the result failed as it shown here (under the
screenshoot, printable part of phpmyadmin output):<br>
<br>
<img alt="" src="cid:part1.06020705.04020900@gmail.com" height="914" width="1159"><br>
<br>
<br>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Tábla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Sorok</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Méret</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflows</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">23</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">10.7 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
19:22</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflows_seq</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">1</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtasks</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">22</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">21.9 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
19:22</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtasks_entitymethod</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">10</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">4.1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtasks_entitymethod_seq</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">1</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtasks_seq</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">1</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtask_queue</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:46</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflowtemplates</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflow_activatedonce</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">1 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">com_vtiger_workflow_tasktypes</th>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">7</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">MyISAM</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;white-space:nowrap;background-color:rgb(255,255,255)">2.5 KB</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)" width="100%">
<tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Létrehozva:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Utolsó
frissítés:</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">2014. Aug 28.
18:45</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
etc.etc.<br>
<br>
<br>
How to handle it?<br>
<br>
Kindest regards:<br>
István<span class="HOEnZb"><font color="#888888"><br>
<br>
<div>-- <br>
üdvözlettel:<br>
<br>
<b>Holbok István</b><br>
<br>
+3670-342-0900<br>
<b>e-mail:</b> <a href="mailto:holbok@gmail.com" target="_blank">holbok@gmail.com</a><br>
<b>SkyPe:</b> holboki<br>
<br>
</div>
</font></span></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>