-
A lot of the joins are built by code and metadata, so you may not see them explicitly in PHP. I reworked the repository structure last night (finally got into branches/tags/trunk layout) and have installed a local copy using MySQL as the database. I normally use PostgreSQL for development and production.
2009-11-16 23:56:10 UTC by mdean
-
Example (wrong sql query within dcl "Select Organization", mysql):
Error executing query: SELECT COUNT(*) FROM dcl_org LEFT JOIN dcl_org_phone ON LEFT JOIN dcl_org_email ON LEFT JOIN dcl_org_url ON WHERE (dcl_org.active='Y')
Solution (tested on commandline, mysql):
SELECT COUNT (*) FROM dcl_org LEFT JOIN dcl_org_phone ON ( dcl_org.org_id = dcl_org_phone.org_id ) LEFT JOIN...
2009-11-16 20:47:23 UTC by kruthoff
-
mdean committed revision 138 to the Double Choco Latte SVN repository, changing 75 files.
2009-11-16 07:02:22 UTC by mdean
-
mdean committed revision 137 to the Double Choco Latte SVN repository, changing 1 files.
2009-11-16 06:50:51 UTC by mdean
-
mdean committed revision 136 to the Double Choco Latte SVN repository, changing 2 files.
2009-11-16 06:00:55 UTC by mdean
-
The SQL syntax is incomplete:
`Information [ Backtrace
2009-11-15 21:12:39 UTC by kruthoff
-
I'm having the same problem with the most recent version of DCL from svn 0.9.5RC11, mysql 5.1.37, php 5.2.10. It isn't possible to add a new user within system setup.
2009-11-14 22:53:50 UTC by kruthoff
-
Thanks for the find, kruthoff. I've checked in the updated file.
2009-11-14 20:58:29 UTC by mdean
-
mdean committed revision 135 to the Double Choco Latte SVN repository, changing 1 files.
2009-11-14 20:57:05 UTC by mdean
-
I've found the bug: `dcl/inc/class.schema_proc_mysql.inc.php, line 509` reads:
return ($oProc->m_odb->Query($sSQL) != -1);
but should be:
return ($oProc->m_odb->Query($sSQL) !== -1);
After this was changed, the fresh installation worked without any issues.
2009-11-14 20:28:36 UTC by kruthoff
