[Vtigercrm-developers] Help Required to support postgres in vtigerCRM 5.0

[Jens Hamisch]

Hi Don,
hi Richie,
hi *,

I've recently upgraded to SVN version 8840 and discovered, that one
of my postgres fixes needs to be adapted because the regarding
database table has changed.

Also I figured out 2 problems in the 8440 revision: Missing entries
in the 'blue' style sheet (though it is not used by default) and a
include_once that has been forgotten to change when the Activities.php
went to the Calendar module.

If attached my fixed to this mail.

Jens


On Tue, Aug 08, 2006 at 05:49:41AM -0700, don wrote:
> 
> Hi Jens,
> 
> Sorry to disturb you again. 
> 
> I havent yet received the following files:
> 
> include/database/Postgres8.php
> include/DatabaseUtil.php
> PearDatabase.php
> 
> Kindly send these files to me at the earliest.
> 
> Thanks & Regards,
> Don
> 
> 
> 
> ---- On Mon, 07 Aug 2006 Jens Hamisch <jens at Strawberry.COM> wrote ---- 
> 
> Hi Don,
> 
> 
> sorry I first read your mail today, so I wasn't aware of the release
> planned for this week. However I've prepared a patch and added it to
> thgis mail. During the weekend I was able to drag down and fix even the
> transcations problems, so everything now wors fine for me.
> 
> The patch relates to SVN version 8640.
> It will update the following files:
> 
>  adodb/drivers/adodb-postgres64.inc.php
>  adodb/adodb-datadict.inc.php
>  include/database/PearDatabase.php
>  include/freetag/freetag.class.php
>  include/utils/CommonUtils.php
>  include/utils/EditViewUtils.php
>  include/utils/SearchUtils.php
>  include/utils/UserInfoUtil.php
>  include/RelatedListView.php
>  install/1checkSystem.php
>  install/5createTables.inc.php
>  install/4createConfigFile.php
>  modules/Vendors/ListView.php
>  modules/Potentials/ListView.php
>  modules/Notes/ListView.php
>  modules/Leads/ListView.php
>  modules/Invoice/ListView.php
>  modules/Campaigns/ListView.php
>  modules/SalesOrder/ListView.php
>  modules/Products/ListView.php
>  modules/Activities/ListView.php
>  modules/Activities/Event.php
>  modules/PurchaseOrder/ListView.php
>  modules/Calendar/calendarLayout.php
>  modules/Accounts/ListView.php
>  modules/Quotes/ListView.php
>  modules/HelpDesk/ListView.php
>  modules/PriceBooks/ListView.php
>  modules/Users/User.php
>  modules/Users/DefaultDataPopulator.php
>  modules/Users/Authenticate.php
>  modules/Faq/ListView.php
>  modules/Contacts/ListView.php
> 
> 
> 
> Besides the postgres fixes it also addresses some installation
> problems (regarding file names).
> 
> 
> Kind regards,
> Jens
> 
> n Fri, Aug 04, 2006 at 12:38:27AM -0700, don wrote:
> > Hi Jens,
> > 
> > It would be good if you can send me the postgres patch at the earliest by today. We are planning to do a release by 
> > next week and by this weekend we have to freeze the developments.
> > 
> > Also I looked into your earlier patches.  Can you tell me how to interpret them. 
> > 
> > there are lines starting with ! or + or -  What does these symbols indicate.
> > 
> > 
> > Thanks & Regards,
> > Don 
> > 
> > 
> > 
> > ---- On Thu, 03 Aug 2006 Jens Hamisch <jens at Strawberry.COM> wrote ---- 
> > 
> > Hi Don,
> > 
> > 
> > in which timeframe do you need this? Currently I have a running
> > version in which I had to disable postgres transactions. I'm in the
> > process of dragging down the transactions probs and hope I will
> > be finished on that up to this weekend ...
> > 
> > Do you want to wait a few days? Otherwise I can produce a current
> > snapshot this evening.
> > 
> > 
> > 
> > Jens
> > 
> > 
> > On Thu, Aug 03, 2006 at 12:14:15AM -0700, don wrote:
> > > Hi all,
> > > 
> > > I am going to integrate the changes done to support postgres8 in vtigerCRM 5.0.  It will be good if you can send
> > >  me a consolidated patch that would help me in integrating most of  the changes required for postgres8 in one shot.
> > > 
> > > 
> > > Thanks & Regards,
> > > Don
> > > 
> > > 
> > >  
> > 
> > -- 
> > 
> > --------------------------------------------------------------------------------
> >      /
> >  +##+|##+   STRAWBERRY                     Jens Hamisch
> > +v#+v v##+  EDV-Systeme GmbH               Managing director
> > / v    v\v
> > | . .  . |  Waldeckstr. 9a                 Car (Voice):  (+49 172) 81 04 162
> > |     .  |  D-82515 Wolfratshausen         Voice:        (+49 8171) 41805-0
> >  | .     |                                 Fax:          (+49 8171) 41805-59
> >  \   .  /   Tel.: (+49 8171) 41805-0       Email:        jens at Strawberry.COM
> >   \____/    Strawberry at Strawberry.COM      
> 
> -- 
> 
> --------------------------------------------------------------------------------
>      /
>  +##+|##+   STRAWBERRY                     Jens Hamisch
> +v#+v v##+  EDV-Systeme GmbH               Managing director
> / v    v\v
> | . .  . |  Waldeckstr. 9a                 Car (Voice):  (+49 172) 81 04 162
> |     .  |  D-82515 Wolfratshausen         Voice:        (+49 8171) 41805-0
>  | .     |                                 Fax:          (+49 8171) 41805-59
>  \   .  /   Tel.: (+49 8171) 41805-0       Email:        jens at Strawberry.COM
>   \____/    Strawberry at Strawberry.COM      
> 

-- 

--------------------------------------------------------------------------------
     /
 +##+|##+   STRAWBERRY                     Jens Hamisch
+v#+v v##+  EDV-Systeme GmbH               Managing director
/ v    v\v
| . .  . |  Waldeckstr. 9a                 Car (Voice):  (+49 172) 81 04 162
|     .  |  D-82515 Wolfratshausen         Voice:        (+49 8171) 41805-0
 | .     |                                 Fax:          (+49 8171) 41805-59
 \   .  /   Tel.: (+49 8171) 41805-0       Email:        jens at Strawberry.COM
  \____/    Strawberry at Strawberry.COM      

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Patches_8840.tgz
Type: application/octet-stream
Size: 886 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060812/c9ffd02e/attachment-0003.obj