<div dir="ltr">We are reviewing this - hoping it would not push our target too far.</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 Sun, Aug 24, 2014 at 2:35 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">
<div>Hi Prasad,<br>
<br>
Thank you for the fast change in the SVN.<br>
<br>
There is a <i><b>note </b></i>related to the mysqli / php 5.5.x
support.<br>
Debugging this part I have realized the used <b>ADOdb library is
quite outdated from 8 June of 2006</b>.<br>
<br>
@version <font color="#ff0000"><b>V4.90 8 June 2006</b></font>
(c) 2000-2006 John Lim (jlim#<a href="http://natsoft.com.my" target="_blank">natsoft.com.my</a>). All rights reserved.<br>
( ...\libraries\adodb\adodb.inc.php )<br>
<br>
Is there a specific reason to use these old libraries, now in
2014?<br>
<br>
There is a new ADOdb library, maintained and updated version <font color="#3333ff"><b>5.19 from 23-Apr-2014</b></font>.<br>
<a href="http://adodb.sourceforge.net/docs-adodb.htm#changelog" target="_blank">http://adodb.sourceforge.net/docs-adodb.htm#changelog</a><br>
<br>
Download:<br>
<a href="http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-519-for-php5/" target="_blank">http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-519-for-php5/</a><br>
<br>
Here is the changeset related to (direct only the) <b>mysqli
support</b> of ADOdb library:<br>
<big><b><br>
</b><b>5.16 26 March 2012</b></big><br>
mysql, mysqli and informix: added MetaProcedures. Metaprocedures
allows to retrieve an array list of all procedures in database.
<a href="http://phplens.com/lens/lensforum/msgs.php?id=18414" target="_blank">http://phplens.com/lens/lensforum/msgs.php?id=18414</a><br>
<b><big><br>
5.07 26 Dec 2008</big></b><br>
MetaForeignKeys in mysql and mysqli drivers had this problem: A
table can have two foreign keys pointing to the same column in the
same table. The original code will incorrectly report only the
last column. Fixed.
<a href="https://sourceforge.net/tracker/index.php?func=detail&aid=2287278&group_id=42718&atid=433976" target="_blank">https://sourceforge.net/tracker/index.php?func=detail&aid=2287278&group_id=42718&atid=433976</a><br>
<br>
<b><big>4.990/5.05 11 Jul 2008</big></b><br>
Added support for multiple recordsets in mysqli "Geisel Sierote"
geisel#<a href="http://4up.com.br" target="_blank">4up.com.br</a>. See
<a href="http://phplens.com/lens/lensforum/msgs.php?id=15917" target="_blank">http://phplens.com/lens/lensforum/msgs.php?id=15917</a><br>
<br>
<b><big>4.98/5.04 13 Feb 2008</big></b><br>
Added mysqli support to adodb_getcount().<br>
<br>
<b><big>4.97/5.03 22 Jan 2008 </big></b><br>
Removed $arg3 from mysqli SelectLimit. See
<a href="http://phplens.com/lens/lensforum/msgs.php?id=16243" target="_blank">http://phplens.com/lens/lensforum/msgs.php?id=16243</a>. Thx Zsolt
Szeberenyi.<br>
<br>
<b><big>4.96/5.02 24 Sept 2007</big></b><br>
Added better support for MetaType() in mysqli when using an array
recordset.<br>
<b><big><br>
4.94 23 Jan 2007</big></b><br>
mysqli had bugs in BeginTrans() and EndTrans(). Fixed.<br>
<br>
<b><big>4.93 10 Oct 2006</big></b><br>
Path disclosure problem in mysqli fixed. Thx Andy.<br>
<br>
<br>
I did an experiment.<br>
I tested the vtiger SVN 14224 instance simple with replacing the
outdated ADOdb library v4.90 with the latest v5.19 ADOdb library.<br>
All basic database functionality works as it was expected.<br>
<br>
Basic module data save, update, CustomModule data save, update
works well with new ADOdb library.<br>
<br>
So, I suggest the ADOdb library update to the latest and test
vtiger 6.1 beta with this. It will improve the mysqli support as
it shown in the library changeset.<br>
<br>
Kindest regards:<br>
Istvan<br>
<br>
<br>
<div>ü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>
2014.08.24. 8:06 keltezéssel, Prasad írta:<br>
</div>
<blockquote type="cite">
<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">Istvan,</span><br>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">We
have fixed it.</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">Regards,</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">Prasad</span></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 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>
</blockquote>
<br>
</div>
</blockquote></div><br></div>