About when my driver will be included: I hope in 2.5.1 for an sqlsrv problem (its code already present in platform and cms) that collide with some of my cms code, so we have to fix platform differences before and then add in cms.
About soundex: some time ago someone sent this link in a discussion inside this list or in platform one. http://www.postgresonline.com/journal/archives/158-Where-is-soundex-a... I've read this and investigating about enabling soundex or other functions (I think double metaphone works better than soundex, expecially for language other than english, but it's not installed by default in other databases), seems that in postgresql I've to run code inside sql file as superuser. It's better check if PHP's soundex works as MySQL's one, to let use this instead of database specific code.
When I try to install it, I have the following message at the 2nd
step : Fatal error: Declaration of JDatabasePostgreSQL::select() must
be compatible with that of JDatabase::select() in D:\Website
\joomla_sites\thematiques\j25\libraries\joomla\database\database
\postgresql.php on line 1225
Did I miss something?
Thomas
On 6 jan, 21:49, "84.le0n" <84.l...@gmail.com> wrote:
> Hi folks,
> I'm searching tester of CMS on PostgreSQL database, there's someone
> who can help me trying to play on it and finding possible bugs ?
> The repository ishttps://github.com/gpongelli/joomla-cms/tree/postgresql > feel free to fork and make issues and pull request, signaling how replicate it.
> For someone interested, after install is completed, edit
> configuration.php and set
> $sef = '0'
> $debug = '1'
> to have site correcly working and have necessary debug, useful during
> sending issue report to me.
Have you used code from https://github.com/gpongelli/joomla-cms/tree/postgresql ? It's very strange because yesterday I did a fresh install and I haven't received this error. Pull it again, I've never had this error and looking my code I've no "select" declaration at line 1225 .
Hi all, I've pushed now a SOUNDEX replacement, created with PL/pgSQL language inside joomla.sql and correctly handled in database.php file of installation folder. Creation is ok, after installation I've used SOUNDEX inside queries and it works.
I've start testing it and, after enabled smart search plugins, doing "index" I get "undefined null null" in a modal window. Can anyone help me debugging that?
Thank you, Eng. Gabriele Pongelli
AVVERTENZE AI SENSI DEL D.LGS. 196/2003 Le informazioni contenute in questo messaggio di posta elettronica e negli eventuali files allegati, sono da considerarsi strettamente riservati. Il loro utilizzo č consentito esclusivamente al destinatario del messaggio, per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore questo messaggio, Vi preghiamo cortesemente di darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema; costituisce comportamento contrario ai principi dettati dal D.lgs. 196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą diverse. This electronic transmission is strictly confidential and intended solely for the addresses. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us and delete the received data as soon as possible.
This is usually what you get when the indexer has stopped with a fatal error. Check your error logs to see what the problem is. A common cause is not having write access to /logs as the indexer currently puts out lots of diagnostic stuff into /logs/indexer.php.
Chris.
On 10 February 2012 07:17, 84.le0n <84.l...@gmail.com> wrote:
> Hi all, > I've pushed now a SOUNDEX replacement, created with PL/pgSQL language > inside joomla.sql and correctly handled in database.php file of > installation folder. > Creation is ok, after installation I've used SOUNDEX inside queries and it > works.
> I've start testing it and, after enabled smart search plugins, doing > "index" I get "undefined null null" in a modal window. > Can anyone help me debugging that?
> Thank you, > Eng. Gabriele Pongelli
> AVVERTENZE AI SENSI DEL D.LGS. 196/2003 > Le informazioni contenute in questo messaggio di posta elettronica e negli > eventuali files allegati, sono da considerarsi strettamente riservati. Il > loro utilizzo č consentito esclusivamente al destinatario del messaggio, > per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore > questo messaggio, Vi preghiamo cortesemente di darcene notizia > all'indirizzo e-mail di cui sopra e di procedere alla distruzione del > messaggio stesso, cancellandolo dal Vostro sistema; costituisce > comportamento contrario ai principi dettati dal D.lgs. 196/2003 il > trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad > altri soggetti, copiarlo, od utilizzarlo per finalitą diverse. > This electronic transmission is strictly confidential and intended solely > for the addresses. It may contain information which is covered by legal, > professional or other privilege. If you are not the intended addressee, you > must not disclose, copy or take any action in reliance of this > transmission. If you have received this transmission in error, please > notify us and delete the received data as soon as possible.
> -- > You received this message because you are subscribed to the Google Groups > "Joomla! CMS Development" group. > To post to this group, send an email to joomla-dev-cms@googlegroups.com. > To unsubscribe from this group, send email to > joomla-dev-cms+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
-- Chris Davenport Joomla Leadership Team - Production Working Group Joomla Documentation Coordinator
AVVERTENZE AI SENSI DEL D.LGS. 196/2003 Le informazioni contenute in questo messaggio di posta elettronica e negli eventuali files allegati, sono da considerarsi strettamente riservati. Il loro utilizzo č consentito esclusivamente al destinatario del messaggio, per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore questo messaggio, Vi preghiamo cortesemente di darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema; costituisce comportamento contrario ai principi dettati dal D.lgs. 196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą diverse. This electronic transmission is strictly confidential and intended solely for the addresses. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us and delete the received data as soon as possible.
Il giorno 13/feb/2012, alle ore 11:33, Chris Davenport <chris.davenp...@joomla.org> ha scritto:
> This is usually what you get when the indexer has stopped with a fatal error. Check your error logs to see what the problem is. A common cause is not having write access to /logs as the indexer currently puts out lots of diagnostic stuff into /logs/indexer.php.
> Chris.
> On 10 February 2012 07:17, 84.le0n <84.l...@gmail.com> wrote: > Hi all, > I've pushed now a SOUNDEX replacement, created with PL/pgSQL language inside joomla.sql and correctly handled in database.php file of installation folder. > Creation is ok, after installation I've used SOUNDEX inside queries and it works.
> I've start testing it and, after enabled smart search plugins, doing "index" I get "undefined null null" in a modal window. > Can anyone help me debugging that?
> Thank you, > Eng. Gabriele Pongelli
> AVVERTENZE AI SENSI DEL D.LGS. 196/2003 > Le informazioni contenute in questo messaggio di posta elettronica e negli eventuali files allegati, sono da considerarsi strettamente riservati. Il loro utilizzo č consentito esclusivamente al destinatario del messaggio, per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore questo messaggio, Vi preghiamo cortesemente di darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema; costituisce comportamento contrario ai principi dettati dal D.lgs. 196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą diverse. > This electronic transmission is strictly confidential and intended solely for the addresses. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us and delete the received data as soon as possible.
> -- > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group. > To post to this group, send an email to joomla-dev-cms@googlegroups.com. > To unsubscribe from this group, send email to joomla-dev-cms+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
> -- > Chris Davenport > Joomla Leadership Team - Production Working Group > Joomla Documentation Coordinator > -- > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group. > To post to this group, send an email to joomla-dev-cms@googlegroups.com. > To unsubscribe from this group, send email to joomla-dev-cms+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
I know the topic of PostgreSQL in the CMS hasn't come up really in a little
while, but I think now would be a great time to revisit it and make the push
to get it integrated for 3.0.
I can't offer to test every change thoroughly, but I've got a PostgreSQL
instance set up on my systems that I could test with to help with the
integration, and I'll help where I can on code issues to keep compatibility
with our other supported drivers.
I know Gabriele has spent a lot of time working on this, and I think it
would be a shame to lose all his work.
Can we see this one through to being committed into the CMS?
On Thursday, July 5, 2012 10:41:02 PM UTC-4, Michael Babker wrote:
> I know the topic of PostgreSQL in the CMS hasn't come up really in a > little while, but I think now would be a great time to revisit it and make > the push to get it integrated for 3.0.
> I can't offer to test every change thoroughly, but I've got a PostgreSQL > instance set up on my systems that I could test with to help with the > integration, and I'll help where I can on code issues to keep compatibility > with our other supported drivers.
> I know Gabriele has spent a lot of time working on this, and I think it > would be a shame to lose all his work.
> Can we see this one through to being committed into the CMS?
Hi all,
If I remember correctly, my cms' pull request last update was for 2.5.4 and I've thought to update to 2.5.5 or 3.0 opening a new pull request.
I haven't seen 3.0 branch but, if it contains at least 12.1 platform, it already contains my driver.
I've also a pull request on platform repository to improve installation phase, but it's not yet merged.
I can try to let italian joomla's users do test on cms, but before I've to adapt 2.5 code and see 3.0 news. In cc there's www.joomla.it forum administrator, head of italian translation team, talk with him on how let user test this version.
bye,
Eng. Gabriele Pongelli
AVVERTENZE AI SENSI DEL D.LGS. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e negli eventuali files allegati, sono da considerarsi strettamente riservati. Il loro utilizzo č consentito esclusivamente al destinatario del messaggio, per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore questo messaggio, Vi preghiamo cortesemente di darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema; costituisce comportamento contrario ai principi dettati dal D.lgs. 196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą diverse.
This electronic transmission is strictly confidential and intended solely for the addresses. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us and delete the received data as soon as possible.
Within the next few days, there should be a Platform merge on the master
branch on the CMS repo (since it's now being used for 3.0). Once the
Platform merge is done, you should be able to get your branch set up with
the current Platform code and merge in the changes you need to get
PostgreSQL working. IIRC, the first 3.0 Alpha is scheduled for next week
and was only going to contain the Platform merge with the necessary CMS
tweaks to keep things running.
On 7/6/12 2:04 PM, "84.le0n" <84.l...@gmail.com> wrote:
>Hi all,
>If I remember correctly, my cms' pull request last update was for 2.5.4
>and I've thought to update to 2.5.5 or 3.0 opening a new pull request.
>I haven't seen 3.0 branch but, if it contains at least 12.1 platform, it
>already contains my driver.
>I've also a pull request on platform repository to improve installation
>phase, but it's not yet merged.
>I can try to let italian joomla's users do test on cms, but before I've
>to adapt 2.5 code and see 3.0 news. In cc there's www.joomla.it forum
>administrator, head of italian translation team, talk with him on how let
>user test this version.
>bye,
>Eng. Gabriele Pongelli
>AVVERTENZE AI SENSI DEL D.LGS. 196/2003
>Le informazioni contenute in questo messaggio di posta elettronica e
>negli eventuali files allegati, sono da considerarsi strettamente
>riservati. Il loro utilizzo č consentito esclusivamente al destinatario
>del messaggio, per le finalitą indicate nel messaggio stesso. Qualora
>riceveste per errore questo messaggio, Vi preghiamo cortesemente di
>darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla
>distruzione del messaggio stesso, cancellandolo dal Vostro sistema;
>costituisce comportamento contrario ai principi dettati dal D.lgs.
>196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte,
>distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą
>diverse.
>This electronic transmission is strictly confidential and intended solely
>for the addresses. It may contain information which is covered by legal,
>professional or other privilege. If you are not the intended addressee,
>you must not disclose, copy or take any action in reliance of this
>transmission. If you have received this transmission in error, please
>notify us and delete the received data as soon as possible.
>-- >You received this message because you are subscribed to the Google Groups
>"Joomla! CMS Development" group.
>To post to this group, send an email to joomla-dev-cms@googlegroups.com.
>To unsubscribe from this group, send email to
>joomla-dev-cms+unsubscribe@googlegroups.com.
>For more options, visit this group at
>http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
Really it's easy enough to put postgres support into alpha mode once any tweaks are done. All we have to do is change the supported databases field on the installation and it's ready to go. I'd say let's do that for alpha if we can, that's the only way we're ever going to get enough real world testing for the release.
On Friday, July 6, 2012 3:42:53 PM UTC-4, Michael Babker wrote:
> Within the next few days, there should be a Platform merge on the master > branch on the CMS repo (since it's now being used for 3.0). Once the > Platform merge is done, you should be able to get your branch set up with > the current Platform code and merge in the changes you need to get > PostgreSQL working. IIRC, the first 3.0 Alpha is scheduled for next week > and was only going to contain the Platform merge with the necessary CMS > tweaks to keep things running.
> On 7/6/12 2:04 PM, "84.le0n" <84.l...@gmail.com> wrote:
> >Hi all, > >If I remember correctly, my cms' pull request last update was for 2.5.4 > >and I've thought to update to 2.5.5 or 3.0 opening a new pull request. > >I haven't seen 3.0 branch but, if it contains at least 12.1 platform, it > >already contains my driver.
> >I've also a pull request on platform repository to improve installation > >phase, but it's not yet merged. > >I can try to let italian joomla's users do test on cms, but before I've > >to adapt 2.5 code and see 3.0 news. In cc there's www.joomla.it forum > >administrator, head of italian translation team, talk with him on how let > >user test this version.
> >bye, > >Eng. Gabriele Pongelli
> >AVVERTENZE AI SENSI DEL D.LGS. 196/2003 > >Le informazioni contenute in questo messaggio di posta elettronica e > >negli eventuali files allegati, sono da considerarsi strettamente > >riservati. Il loro utilizzo č consentito esclusivamente al destinatario > >del messaggio, per le finalitą indicate nel messaggio stesso. Qualora > >riceveste per errore questo messaggio, Vi preghiamo cortesemente di > >darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla > >distruzione del messaggio stesso, cancellandolo dal Vostro sistema; > >costituisce comportamento contrario ai principi dettati dal D.lgs. > >196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, > >distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą > >diverse. > >This electronic transmission is strictly confidential and intended solely > >for the addresses. It may contain information which is covered by legal, > >professional or other privilege. If you are not the intended addressee, > >you must not disclose, copy or take any action in reliance of this > >transmission. If you have received this transmission in error, please > >notify us and delete the received data as soon as possible.
> >-- > >You received this message because you are subscribed to the Google Groups > >"Joomla! CMS Development" group. > >To post to this group, send an email to joomla-dev-cms@googlegroups.com. > >To unsubscribe from this group, send email to > >joomla-dev-cms+unsubscribe@googlegroups.com. > >For more options, visit this group at > >http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
Hi,
I think I'll try to put cms' changes on 3.0 branch after new platform will be merged, so changes are relative only for cms' modules and components without touching libraries folder.
About 2.5.x I can try to add Postgresql driver, but I don't want an unmaintainable situation with two similar branches, 2.5 and 3.0, and with 2.5.x branch that it's used only to see if it works (it could not be merged because of changes inside libraries platform).
Bye,
Eng. Gabriele Pongelli
AVVERTENZE AI SENSI DEL D.LGS. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e negli eventuali files allegati, sono da considerarsi strettamente riservati. Il loro utilizzo č consentito esclusivamente al destinatario del messaggio, per le finalitą indicate nel messaggio stesso. Qualora riceveste per errore questo messaggio, Vi preghiamo cortesemente di darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema; costituisce comportamento contrario ai principi dettati dal D.lgs. 196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą diverse.
This electronic transmission is strictly confidential and intended solely for the addresses. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us and delete the received data as soon as possible.
Il giorno 06/lug/2012, alle ore 22:30, elin <elin.war...@gmail.com> ha scritto:
> Really it's easy enough to put postgres support into alpha mode once any tweaks are done. All we have to do is change the supported databases field on the installation and it's ready to go. I'd say let's do that for alpha if we can, that's the only way we're ever going to get enough real world testing for the release.
> Elin
> On Friday, July 6, 2012 3:42:53 PM UTC-4, Michael Babker wrote:
> Within the next few days, there should be a Platform merge on the master > branch on the CMS repo (since it's now being used for 3.0). Once the > Platform merge is done, you should be able to get your branch set up with > the current Platform code and merge in the changes you need to get > PostgreSQL working. IIRC, the first 3.0 Alpha is scheduled for next week > and was only going to contain the Platform merge with the necessary CMS > tweaks to keep things running.
> On 7/6/12 2:04 PM, "84.le0n" <84.l...@gmail.com> wrote:
> >Hi all, > >If I remember correctly, my cms' pull request last update was for 2.5.4 > >and I've thought to update to 2.5.5 or 3.0 opening a new pull request. > >I haven't seen 3.0 branch but, if it contains at least 12.1 platform, it > >already contains my driver.
> >I've also a pull request on platform repository to improve installation > >phase, but it's not yet merged. > >I can try to let italian joomla's users do test on cms, but before I've > >to adapt 2.5 code and see 3.0 news. In cc there's www.joomla.it forum > >administrator, head of italian translation team, talk with him on how let > >user test this version.
> >bye, > >Eng. Gabriele Pongelli
> >AVVERTENZE AI SENSI DEL D.LGS. 196/2003 > >Le informazioni contenute in questo messaggio di posta elettronica e > >negli eventuali files allegati, sono da considerarsi strettamente > >riservati. Il loro utilizzo č consentito esclusivamente al destinatario > >del messaggio, per le finalitą indicate nel messaggio stesso. Qualora > >riceveste per errore questo messaggio, Vi preghiamo cortesemente di > >darcene notizia all'indirizzo e-mail di cui sopra e di procedere alla > >distruzione del messaggio stesso, cancellandolo dal Vostro sistema; > >costituisce comportamento contrario ai principi dettati dal D.lgs. > >196/2003 il trattenere il messaggio stesso, divulgarlo anche in parte, > >distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitą > >diverse. > >This electronic transmission is strictly confidential and intended solely > >for the addresses. It may contain information which is covered by legal, > >professional or other privilege. If you are not the intended addressee, > >you must not disclose, copy or take any action in reliance of this > >transmission. If you have received this transmission in error, please > >notify us and delete the received data as soon as possible.
> >-- > >You received this message because you are subscribed to the Google Groups > >"Joomla! CMS Development" group. > >To post to this group, send an email to joomla-dev-cms@googlegroups.com. > >To unsubscribe from this group, send email to > >joomla-dev-cms+unsubscribe@googlegroups.com. > >For more options, visit this group at > >http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
> -- > You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> To view this discussion on the web, visit https://groups.google.com/d/msg/joomla-dev-cms/-/t5XYvAsL3QYJ.
> To post to this group, send an email to joomla-dev-cms@googlegroups.com.
> To unsubscribe from this group, send email to joomla-dev-cms+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
