Added postgres compatibility

iCAPLyon1 / BlogBundle

A Claroline plugin to add blog resources.

https://github.com/claroline/Claroline

4 stars 5 forks source link

Closed kitan191 closed 10 years ago

kitan191 commented 10 years ago

Modifications in Archives and Calendar panels
Removed SUBSTRING(post.publicationDate, ...) in DQL requests because POSTGRES doesn't support this method on a datetime
Added required treatment in PHP code for correct display of the Archives panel and the events of the Calendar panel

maxailloud commented 10 years ago

Have you tested using DQL functions ? Theorically it's here for that case.

I think it can be clearer instead of adding PHP treatment.

kitan191 commented 10 years ago

Yes, I've tried but couldn't extract YEAR and MONTH as done in the original request.

Sure it's clearer without the PHP treatment but couldn't find another way.

maxailloud commented 10 years ago

Okay, too bad it didn't worked.

I guess you tested in your browser your changes?

kitan191 commented 10 years ago

Yes, I've tested with Chromium in Ubuntu.

maxailloud commented 10 years ago

Ok so deal.