Posted by ken-ichi on July 4, 2005 at 5:26pm
Jump to:
| 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.
| Attachment | Size |
|---|---|
| workspace_pgsql.patch | 1.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
Pertains to an outdated version. Please create new issue if problem persists.
TIA
Frank