|
Friday 18 July 2008 2:59:11 am
Thanks André, much appreciated. Maybe there should be a brief note to that effect in the documentation? Sadly, like much of the scripting available, this one also seems to be built only for MySQL and fails without any kind of helpful information when used on a PostgreSQL installation. This line:
SELECT remote_id, COUNT(*) cnt FROM ezcontentobject GROUP BY remote_id HAVING cnt > 1;
won't even successfully complete from the command line (psql), and should be changed to
SELECT remote_id, count(*) AS cnt FROM ezcontentobject GROUP BY remote_id HAVING count(*) > 1;
This isn't enough to get things working, though, because if you jump 2 lines higher where the DB object is instantiated and follow that with a simple "who are you" query
print( $db->databaseName() );
you'll be answered with "mysql" on my system, which is a bit odd since it's not even installed. Forgive my saying something critical here, but do you guys even have a QA for PostgreSQL support? I chose to deploy this product exactly because it claimed to use PG, but in several years of use, I think the only script which has ever run without my intervention has been runcronjobs.php. And even that won't obey the --quiet option any more. Andy
|
