Download & Extend

PostgreSQL Compatability for workspace.module

Project:Workspace
Version:4.6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Frank Ralf
Status:closed (fixed)

Issue Summary

PostgreSQL has two minor quibbles with the SQL in the Workspace: it doesn't like double quotes in queries, and it apparently wants JOIN syntax to immediately follow the joined table in the FROM clause, not simply anywhere after the FROM clause. I've attached a patch, which works with Drupal 4.6, PostgreSQL 8, Apache 1.3, PHP 4.3.10. I haven't tested it with MySQL yet.

AttachmentSize
workspace_pgsql.patch1.06 KB

Comments

#1

Hi all,

I implemented a very simliar change to get it to work on my site with Drupal 4.7.2 and PostgreSQL 8.1.4. I downloaded the http://ftp.osuosl.org/pub/drupal/files/projects/workspace-4.7.0.tar.gz and workspace-cvs.tar.gz this morning. Neither of them had this change applied.

I'm reasonably sure that this will work with MySQL, has anyone tested?

What will it take to make this part of the distro?

#2

Assigned to:Anonymous» Frank Ralf
Status:active» closed (fixed)

Pertains to an outdated version. Please create new issue if problem persists.

TIA
Frank