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

[Holbok István]

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/20140824/707d9dbf/attachment-0001.html>