imp 2.2.4 -- error in db.mysql -- mysql_db_query deprecated

Gary Casterline casterln@nature.Berkeley.EDU
Fri, 18 May 2001 11:50:38 -0700


Hi,

horde: 1.2.4
imp: 2.2.4
php: 4.0.7-dev (from cvs May 16)
mysql: 2.33.38
horde/test.php3 indicates sessions and phplib are working

I'm seeing these errors:

Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query()
instead in /opt/apache/htdocs/horde/imp/lib/db.mysql on line 53

Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query()
instead in /opt/apache/htdocs/horde/imp/lib/db.mysql on line 110

line #53 is
53         elseif (!($result = mysql_db_query($default->db_name, $sql, $db
53 ))) { $_imp_prefs_exist = false; }

line #110 is
110         elseif (!($result = mysql_db_query($default->db_name, "select r
110 eplyto from $default->db_pref_table where user='$user@$server'", $db)))
110  { $_imp_from = false; }

Shall I try to rewrite these?  Or is there a better way?

Thanks,

 _Gary


>From  Fri May 18 14:12:56 2001
Return-Path: <mhilty@artic.edu>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 53576 invoked from network); 18 May 2001 19:25:52 -0000
Received: from pixie.artic.edu (198.40.30.132)
  by horde.org with SMTP; 18 May 2001 19:25:52 -0000
Received: from [198.40.24.166] (24166.artic.edu [198.40.24.166])
	by pixie.artic.edu (Postfix) with ESMTP id 0870F1683D
	for <imp@lists.horde.org>; Fri, 18 May 2001 14:21:28 -0500 (CDT)
Mime-Version: 1.0
X-Sender: mhilty@pop.artic.edu (Unverified)
Message-Id: <v04210128b72b17599228@[198.40.24.166]>
In-Reply-To: <990207564.3b055e4cd9726@marina.horde.org>
References: <982870438.3a9569a6bc073@marina.horde.org>
 <v0421011ab729f3cf09ac@[198.40.24.166]>
 <990207564.3b055e4cd9726@marina.horde.org>
Date: Fri, 18 May 2001 14:12:56 -0500
To: imp@lists.horde.org
From: Matthew Hilty <mhilty@artic.edu>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"
Subject: Re: [imp] mime types - everything application/octet-stream?

Hi,
	The helper apps selections are all consistent with standard 
MIME type and files extensions, and Netscape is configured to "Use 
this MIME type for outgoing attachments" for each of the standard 
attachment types I'm dealing with (image/jpeg = jpg,jpeg,jpe and 
application/msword = doc for example.)
	Apache uses /etc/mime.types to manage MIME types while 
_sending_ files to clients, and all the mime types are also correctly 
associated with file extensions there: (evinced by the fact that 
properly encoded MIME attachments, sent by Eudora, OE, and 
Communicator are all viewable as MIME attachments when _reading_ mail 
with IMP.) So, my browsers are just not sending a MIME type that IMP 
accepts/understands, which is provided for in compose.php3:

<snip>
From:
  File: compose.php3
  $Author: chuck $
  $Revision: 2.35.2.81 $
  $Date: 2000/11/03 20:24:46 $

  /* some browsers do not send mime type */
                                 if (strcmp($attachments_type[$i], '')) {
  
$file_part->parse_full_type($attachments_type[$i]);
                                 } else {
  
$file_part->parse_full_type('application/octet-stream');
                                 }

                                 $file_part->name = $attachments_name[$i];
</snip>

There must be something that I'm either overlooking or 
overcomplicating, judging by the lack of discussion on this topic, 
but I'm not sure what it is. Sorry for wasting bandwidth and 
mailspace if I am, but the very same browsers worked flawlessly with 
2.2.1 and without requiring any tweaking of /etc/mime/types or 
resetting mime types in the browser....baffling!

	The closest I can come to finding anything relevant in bugs is:

http://bugs.horde.org/show_bug.cgi?id=406

but that doesn't really hit the mark....Again, thanks for your 
patience and hard work ---

happy fryday!

matt



>Quoting Matthew Hilty <mhilty@artic.edu>:
>
> > 	So, if it really is a case of stupid user/browser, where
> > would I specify in my browser how to correctly associate file types
> > (based on extension?) with the correct MIME type?
>
>In the "helpers" section or similar, where you tell the browser what 
>to do with
>certain file types. Also, I'm not sure if Apache has anything to do with
>setting it.
>
>-chuck
>
>--
>Charles Hagenbuch, <chuck@horde.org>
>Black and white and grey, all the shades of truth.
>
>--
>IMP mailing list: http://horde.org/imp/
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: imp-unsubscribe@lists.horde.org







Matthew Hilty
Information Services
The Art Institute of Chicago
116 S. Michigan Avenue | Chicago, Illinois 60603

tel: 312.899.7431
email:mhilty@artic.edu