imp 2.3.7cvs (20010914) and OCI8 weirdness

[Liam Hoekenga]

> Things work fine with mysql, but when I switch to oci8, I get this message in
> my php errorlog:
>
> [14-Sep-2001 17:29:17] PHP Warning:  Undefined index:  pref_name in
> /usr/local/projects/webmail/html-ssl/horde/lib/Prefs/sql.php on line 166

ok.  i figured it out.

I had to change to change all of the table and field references in
horde/lib/Prefs/sql.php to upper case.

it struck me that IMP was happy saving stuff, when it knew that it could just
refer to stuff as horde_prefs/pref_name (when it just expected that the table
was there and that field existed).

but... when it went to search for stuff...  it had problems finding it.  table
and field names aren't case sensitive, but I'm guessing that when you do a sql
query in oracle, it probably returns it's results in uppercase, while mysql
returns it in lowercase.

kinda illustrated by...

PL/SQL Release 8.1.5.0.0 - Production

SQL> select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
HORDE_PERMS                    TABLE
HORDE_PREFS                    TABLE
KRONOLITH_EVENTS               TABLE
TURBA_OBJECTS                  TABLE

mysql> show tables;
+------------------+
| Tables_in_horde  |
+------------------+
| horde_perms      |
| horde_prefs      |
| kronolith_events |
| turba_objects    |
+------------------+
8 rows in set (0.00 sec)

I'm guessing the sql code needs to be made case insensitive.

oh yeah - since a recent CVS update, i can't send email any more.  my php
error log doesn't say anything useful and all the composition screen says
is "There was an error sending your message".  If i switch back to a
tarball from about a month ago, I can send mail - so it's not my php
configuration.  Help?

Liam