[Vtigercrm-developers] Accepting patches for MySQL 5 support (some help needed)

[Michel JACQUEMES]

Sorry, preceding message is incomplete.

 

I agree with both of you on mysql 5 support, but I need some help on
database schema regarding expected results on numeric fields.

 

You could first have a look to the following page, incompatibility on
decimal data :

 

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

 

What I mean is that I cannot understand which format is expected in
DatabaseSchema.xml. Example in table potstagehistory :

 

            <field name="probability" type="N" size="2.3"></field>

 

XMLSchema produce probability DECIMAL(4.3) which means a maximum value of
9.999

It produces a query error with mssql, that's how I found it.

 

If you use :

 

            <field name="probability" type="N" size="5.3"></field>

 

Which is, I think, the right value, the result is correct : DECIMAL(5.3).

The question is, what is the value expected by vtiger?

 

If I am right, this patch is easy to apply but not easy to define, all the
numeric fields in database are concerned. It refers to both versions, 4.2 &
5.0.

 

-----Message d'origine-----

De : vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] De la part de
Fathi BOUDRA

Envoyé : samedi 25 février 2006 22:50

À : Mike Fedyk

Cc : vtigercrm-developers at lists.vtigercrm.com

Objet : Re: [Vtigercrm-developers] Accepting patches for MySQL 5 support
(was: 4.2.4 installer creates tables as MyISAM)

 

> I use mysql 4.0.24-10sarge1 and php 4.3.10-16 for development.  I'll

> test any mysql 5 support patches against mysql 4.0 and php4.3 so we can

> make sure our minimum version is supported.  If it passes that and the

> patch looks good, it can't be any worse for the 5.0 users than the

> current situation.

> 

> We need to have at least one developer stick with mysql 4.0.

> 

> I'll post a message in the forum asking for mysql 5 support patches

> after 4.2.4 releases if everyone agrees.

> 

> Mike

 

sure, i agree :)

_______________________________________________

This vtiger.com email is sponsored by: Zoho Writer. Are you still using your
desktop word processor for typing documents? Try the AJAX enabled,
collaboration-friendly online word processor, Zoho Writer for FREE instead!

http://zohowriter.com/?vt 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060227/116d69da/attachment-0005.html