Hi All,<br><br>Thanks for your support. We have finally analyzed the issue and found the quick fix for it. Please follow the trac ticket below for more details:<br><br><a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/6205">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/6205</a><br>
<br><div><span class="gmail_quote">On 7/27/09, <b class="gmail_sendername">Prasad</b> <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br><br>If InnoDB support is turned-off for the MySQL server, 'SHOW TABLE STATUS' returns NULL value result for InnoDB tables.<br><br><span style="font-style: italic;">How to reproduce the issue?</span><br><div style="margin-left: 40px;">
You will end up with the described result if you have the following MySQL configuration.<br>[mysqld]<br>default-storage-engine=MyISAM<br>skip-innodb<br></div><br>Please note, for vtiger CRM to work properly you will need to have InnoDB support enabled in MySQL.<br>
<br><span style="font-style: italic;">How to avoid the issue?</span><br><div style="margin-left: 40px;">[mysqld]<br>default-storage-engine=INNODB<br>#skip-innodb<br></div>
<br>Regards,<br><span class="sg">Prasad<br>vtiger Team<br><br></span><div><span class="q"><span class="gmail_quote">On 7/27/09, <b class="gmail_sendername">den jean</b> <<a href="mailto:djeandot@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">djeandot@gmail.com</a>> wrote:</span></span><div>
<span class="e" id="q_122bd194b640a02f_4"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>What are we supposed to have like error ?<br>Regards,<br><br><div class="gmail_quote">2009/7/27 Asha <span dir="ltr"><<a href="mailto:asha@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asha@vtiger.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><span>
Hi All,<br><br>People have been reporting us a major issue with migration, where the script that changes the MyISAM tables to InnoDB tables is not working.<br><br>We are trying to reproduce this issue in our test labs and have not succeeded yet.<br>
<br>Whole problem is around the query '<span style="font-weight: bold; font-style: italic;">SHOW TABLE STATUS FROM <database-name>'.<br><span style="font-style: italic;"><span style="font-weight: bold;"><span style="font-style: italic;"><span style="font-weight: bold;"><br>
<span style="font-style: italic;"></span></span></span></span></span></span>Would be great if anyone can provide us a helping hand in analyzing or resolving the issue. Possibly if anyone can reproduce this issue on their servers and can give us the access to the server, that would help a lot.<br>
<br>Hoping to get a resolution for this issue soon so that people can migrate to vtiger 5.1.0 smoothly.<span style="font-weight: bold; font-style: italic;"><span style="font-style: italic;"><span style="font-weight: bold;"><span style="font-style: italic;"><span style="font-weight: bold;"><span style="font-style: italic;"></span><br clear="all">
</span></span></span></span></span><br>-- <br>Regards,<br>Asha<br>vtiger Team
<br></span></div>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> <br></blockquote></div><br>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> <br></blockquote></span></div></div><br>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br><br clear="all"><br>-- <br>
Regards,<br>Asha<br>vtiger Team