<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Rishab,<br>
<br>
I have just finished a fresh install with the latest SVN Changeset
14295, where the MYSQLI hotfix was released.<br>
<br>
It partly resolved the issue described in my earlier letter sent
to the list:<br>
<a class="moz-txt-link-freetext" href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/2014-August/029214.html">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/2014-August/029214.html</a><br>
<div class="moz-signature"><br>
<b>The issue was</b>: despite the fact that the server MySQL
(5.6) default engine was InnoDB, the most of tables in vtiger DB
were created as MyISAM at the install time.<br>
<br>
I repeated the install with different 6.1 beta version on this
server (CentOS, C-panel, MySQL 5.6.17) but the result were too
same -> the most of tables in vtiger DB were created as
MyISAM at the install time.<br>
<br>
<b>Using the SVN 14295 this issue was partly resolved in this
server.</b><br>
Now, the most of tables are InnoDB, only some of tables are
MyISAM. For example the all tables where the table name end with
<b>_seq</b> are MyISAM and few others e.g. <b>vtiger_asteriskincomingevents</b>
also MyISAM.<br>
<br>
My note was that time: It indicates there is some <b>uncertainty
</b>and the SQL table install depended in this case from some
environment variables.<br>
<br>
If you would like to check the created DB I can send you a dump-<br>
<br>
Kindest regards:<br>
István<br>
<br>
<br>
</div>
2014.09.22. 13:31 keltezéssel, Rishab K írta:<br>
</div>
<blockquote
cite="mid:CAHU-C+=KMo_4DWxUaFWkVvym_G6GYs7Am2fixYCFWakzR=r01w@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Refer </div>
Trac Link: <a moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255</a>
<div><br>
</div>
<div>For the modified mysqli patch.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Rishab</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 22, 2014 at 4:59 PM, Rishab
K <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:rishab.k@vtiger.com" target="_blank">rishab.k@vtiger.com</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">Please check <a moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255.The"
target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255.The</a>
patch has some changes to be taken
<div><br>
</div>
<div>Regards,</div>
<div>Rishab</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>
<div class="h5">On Mon, Sep 22, 2014 at 4:41 AM,
Manuel Fernando <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:ptdesigner@gmail.com"
target="_blank">ptdesigner@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="h5">
<div style="word-wrap:break-word">Just one thing.
<div><br>
</div>
<div>I never had this before:</div>
<div>In module tickets if click in related
module Services, get this</div>
<div><br>
</div>
<div><b>Warning</b>: Invalid argument supplied
for foreach() in <b>/home/testtest/public_html/vtiger61/include/Webservices/WebserviceField.php</b>
on line <b>200</b></div>
<div><span
style="font-size:medium;white-space:nowrap">result
is not an object</span><b><br>
</b>
<div style="margin:5em auto;width:70%"> </div>
<div>Best Regards</div>
<div>Manuel</div>
<div><br>
</div>
<div>
<div>No dia 21/09/2014, às 12:49, Manuel
Fernando <<a moz-do-not-send="true"
href="mailto:ptdesigner@gmail.com"
target="_blank">ptdesigner@gmail.com</a>>
escreveu:</div>
<div>
<div><br>
<blockquote type="cite">
<div style="word-wrap:break-word">Ho
Yea, very good.
<div><br>
</div>
<div>no we are talking about!!!</div>
<div><br>
</div>
<div>Works great and solved lots of
users problems believe me,
problems like cannot creat web
forms etc</div>
<div><br>
</div>
<div>After i will send related
tickets on trac that you can close
that are already solved with this
change</div>
<div><br>
</div>
<div>Best regards </div>
<div>Manuel</div>
<div><br>
<div>
<div>No dia 21/09/2014, às
11:41, Prasad <<a
moz-do-not-send="true"
href="mailto:prasad@vtiger.com"
target="_blank">prasad@vtiger.com</a>>
escreveu:</div>
<br>
<blockquote type="cite">
<div dir="ltr">adodb seem to
be missing schema parsing
support for mysqli - patch
suggested:
<div><a
moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255#comment:1"
target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255#comment:1</a><br>
</div>
<div><br>
</div>
<div>Please try and suggest
your feedback.</div>
</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
moz-do-not-send="true"
href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)"
target="_blank">Twitter</a> <b>I</b> <a
moz-do-not-send="true"
href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall"
style="color:rgb(0,0,204)"
target="_blank">Facebook</a> <b>I</b> <a
moz-do-not-send="true"
href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)"
target="_blank">Blog</a><b> I</b> <a
moz-do-not-send="true"
href="http://wiki.vtiger.com/index.php/Main_Page"
style="color:rgb(0,0,204)"
target="_blank">Wiki</a> <b>I </b><a
moz-do-not-send="true"
href="https://discussions.vtiger.com/" style="color:rgb(0,0,204)"
target="_blank">Forums </a><b>I</b> <a
moz-do-not-send="true"
href="https://www.vtiger.com/" style="color:rgb(0,0,204)"
target="_blank">Website</a></span></div>
<br>
<div class="gmail_quote">On
Sun, Sep 21, 2014 at 8:01
AM, Prasad <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:prasad@vtiger.com" target="_blank">prasad@vtiger.com</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">Noted: <a
moz-do-not-send="true"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255"
target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8255</a>
-
<div>(seems like bug
in adodb lib will
review soon)</div>
</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
moz-do-not-send="true" href="http://twitter.com/vtigercrm"
style="color:rgb(0,0,204)"
target="_blank">Twitter</a> <b>I</b> <a
moz-do-not-send="true"
href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall"
style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a
moz-do-not-send="true"
href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)"
target="_blank">Blog</a><b> I</b> <a
moz-do-not-send="true" href="http://wiki.vtiger.com/index.php/Main_Page"
style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a
moz-do-not-send="true"
href="https://discussions.vtiger.com/" style="color:rgb(0,0,204)"
target="_blank">Forums </a><b>I</b> <a
moz-do-not-send="true" href="https://www.vtiger.com/"
style="color:rgb(0,0,204)"
target="_blank">Website</a></span></div>
<br>
<div
class="gmail_quote">
<div>
<div>On Sat, Sep
20, 2014 at 9:10
PM, Manuel
Fernando <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:ptdesigner@gmail.com"
target="_blank">ptdesigner@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:0 0
0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div>
<div
style="word-wrap:break-word">
<div>As Prasad
said here</div>
<div><br>
</div>
<div><a
moz-do-not-send="true"
href="https://discussions.vtiger.com/index.php?p=/discussion/173157/vtiger-6-1-ga-live-demo"
target="_blank">https://discussions.vtiger.com/index.php?p=/discussion/173157/vtiger-6-1-ga-live-demo</a></div>
<div><br>
</div>
<div>"If you
are not sure -
all tables
other than
_seq tables
should be
InnoDB for
establishing
the foreign
key
constraints. "</div>
<div><br>
</div>
<div><br>
</div>
<div>Why
installation
put all tables
MyISAM?</div>
<div><br>
</div>
<br>
<div>
<div>No dia
20/09/2014, às
16:35, Manuel
Fernando <<a
moz-do-not-send="true" href="mailto:ptdesigner@gmail.com"
target="_blank">ptdesigner@gmail.com</a>>
escreveu:</div>
<div><br>
<blockquote
type="cite">
<div
style="word-wrap:break-word">Yes,
it depends and
i understand
if i use php
5.5 but i’m
using php
5.3.29
<div><br>
</div>
<div>so
installation
should control
that depending
of of the
versions and
apply InnoDB
to the
necessary
tables.</div>
<div><br>
</div>
<div>Because
after will
create
problems in
the search
area (well,
more
complicated).<br>
<div><br>
<div>
<div> No dia
20/09/2014, às
16:27, Zebra
Hosting <<a
moz-do-not-send="true" href="mailto:support@zebrahosting.eu"
target="_blank">support@zebrahosting.eu</a>>
escreveu:</div>
<br>
<blockquote
type="cite">
<div
style="word-wrap:break-word;font-size:14px;font-family:Calibri,sans-serif">
<div>Manual, I
just did a
fresh install
from the SVN
files and all
are InnoDB.
Might depend
on other
things too.</div>
<div><br>
</div>
<div>I used
Ubuntu 14 with
PHP 5.5. And
MySQL 5.5</div>
<div><br>
</div>
<div>Bastiaan
Houtkooper</div>
<div>Zebra
Hosting</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<span>
<div
style="font-family:Calibri;font-size:11pt;text-align:left;border-width:1pt
medium
medium;border-style:solid
none
none;padding:3pt
0in
0in;border-top-color:rgb(181,196,223)">
<span
style="font-weight:bold">From:
</span>Manuel
Fernando <<a
moz-do-not-send="true" href="mailto:ptdesigner@gmail.com"
target="_blank">ptdesigner@gmail.com</a>><br>
<span
style="font-weight:bold">Reply-To:
</span>"<a
moz-do-not-send="true"
href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a>"
<<a
moz-do-not-send="true"
href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a>><br>
<span
style="font-weight:bold">Date:
</span>zaterdag
20 september
2014 17:13<br>
<span
style="font-weight:bold">To:
</span>"<a
moz-do-not-send="true"
href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a>"
<<a
moz-do-not-send="true"
href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a>><br>
<span
style="font-weight:bold">Subject:
</span>[Vtigercrm-developers]
Mysqli
unsupport<br>
</div>
<div><br>
</div>
<div>
<div
style="word-wrap:break-word">
Last source
from svn
doesn’t act
correct on
mysqli.
<div><br>
</div>
<div>It create
all tables
with
engine MyISAM
instead InnoDB</div>
<div><br>
</div>
<div>It
install a lot
faster but all
tables
with MyISAM</div>
<div><br>
</div>
<div><br>
<div>
<div
style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div
style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div
style="font-variant:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div
style="font-family:Helvetica;font-size:12px;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"><span><print.jpg></span><br>
<br>
</div>
<div
style="font-family:Helvetica;font-size:12px;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">Best
Regards</div>
<div
style="font-family:Helvetica;font-size:12px;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">Manuel</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</span>
</div>
<span><print.jpg></span>_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
</div>
<br>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a
moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/"
target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
<br>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>