[Vtigercrm-developers] a note to the mysqli support - why we don't use the latest ADOdb library

[Prasad]

We are reviewing this - hoping it would not push our target too far.

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* Facebook
<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I* Blog
<https://blogs.vtiger.com/>* I* Wiki
<http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
<https://discussions.vtiger.com>*I* Website <https://www.vtiger.com/>


On Sun, Aug 24, 2014 at 2:35 PM, Holbok István <holbok at gmail.com> wrote:

>  Hi Prasad,
>
> Thank you for the fast change in the SVN.
>
> There is a *note *related to the mysqli / php 5.5.x support.
> Debugging this part I have realized the used *ADOdb library is quite
> outdated from 8 June of 2006*.
>
> @version *V4.90 8 June 2006*  (c) 2000-2006 John Lim (jlim#natsoft.com.my).
> All rights reserved.
> ( ...\libraries\adodb\adodb.inc.php )
>
> Is there a specific reason to use these old libraries, now in 2014?
>
> There is a new ADOdb library, maintained and updated version *5.19 from
> 23-Apr-2014*.
> http://adodb.sourceforge.net/docs-adodb.htm#changelog
>
> Download:
>
> http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-519-for-php5/
>
> Here is the changeset related to (direct only the) *mysqli support* of
> ADOdb library:
>
> *5.16 26 March 2012*
> mysql, mysqli and informix: added MetaProcedures. Metaprocedures allows to
> retrieve an array list of all procedures in database.
> http://phplens.com/lens/lensforum/msgs.php?id=18414
>
> * 5.07 26 Dec 2008*
> 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.
> https://sourceforge.net/tracker/index.php?func=detail&aid=2287278&group_id=42718&atid=433976
>
> *4.990/5.05 11 Jul 2008*
> Added support for multiple recordsets in mysqli "Geisel Sierote" geisel#
> 4up.com.br. See http://phplens.com/lens/lensforum/msgs.php?id=15917
>
> *4.98/5.04 13 Feb 2008*
> Added mysqli support to adodb_getcount().
>
> *4.97/5.03 22 Jan 2008 *
> Removed $arg3 from mysqli SelectLimit. See
> http://phplens.com/lens/lensforum/msgs.php?id=16243. Thx Zsolt Szeberenyi.
>
> *4.96/5.02 24 Sept 2007*
> Added better support for MetaType() in mysqli when using an array
> recordset.
>
> * 4.94 23 Jan 2007*
> mysqli had bugs in BeginTrans() and EndTrans(). Fixed.
>
> *4.93 10 Oct 2006*
> Path disclosure problem in mysqli fixed. Thx Andy.
>
>
> I did an experiment.
> I tested the vtiger SVN 14224 instance simple with replacing the outdated
> ADOdb library v4.90 with the latest v5.19 ADOdb library.
> All basic database functionality works as it was expected.
>
> Basic module data save, update, CustomModule data save, update works well
> with new ADOdb library.
>
> 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.
>
> Kindest regards:
> Istvan
>
>
> üdvözlettel:
>
> *Holbok István*
>
> +3670-342-0900
> *e-mail:* holbok at gmail.com
> *SkyPe:* holboki
>
>  2014.08.24. 8:06 keltezéssel, Prasad írta:
>
> Istvan,
>
>  We have fixed it.
>
>  Regards,
> Prasad
>
> *Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* Facebook
> <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I* Blog
> <https://blogs.vtiger.com/>* I* Wiki
> <http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
> <https://discussions.vtiger.com>*I* Website <https://www.vtiger.com/>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140826/a6bb2844/attachment.html>