| Summary | SQL Error |
| Queue | Turba |
| Queue Version | 2.2-RC1 |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | mrubinsk (at) horde (dot) org |
| Requester | f.rust (at) tu-bs (dot) de |
| Created | 01/23/2008 (6500 days ago) |
| Due | |
| Updated | 01/23/2008 (6500 days ago) |
| Assigned | 01/23/2008 (6500 days ago) |
| Resolved | 01/23/2008 (6500 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
listTimeObjects() behaviour, which is basically returning all the
objects in a source and then checking them for the proper date range.
But, like chuck said, we don't really support mySQL 3 and you'll get
much better performance from this part of the code (especially with
large address books) with newer versions of MySQL.
Assigned to Michael Rubinsky
State ⇒ Assigned
general we don't support MySQL 3.
across all major RDBMs. There are really still people running MySQL 3?
:-)
I use mysql 3.23.58.
From mysql Documentation:
`SUBSTR()' is a synonym for `SUBSTRING()', added in MySQL 4.1.1.
Since everything seems to run fine with V3.23 I suggest to simply
change the SUBSTR to SUBSTRING to get more backwards compatibility.
State ⇒ Feedback
Priority ⇒ 2. Medium
Priority ⇒ 3. High
State ⇒ Unconfirmed
Queue ⇒ Turba
Summary ⇒ SQL Error
Type ⇒ Bug
turba/lib/Driver/sql.php:508:
$where = array('sql' => $bday . ' IS NOT NULL AND SUBSTR(' . $bday
should be:
$where = array('sql' => $bday . ' IS NOT NULL AND SUBSTRING(' . $bday