#4 dbh->tables fails for Ingres 6.4

[Anonymous]

perl 5.00404
DBI 1.3

In CONFIG.pm -
$dbtype = "Ingres";
$default_table = '';
@active_tables = ();

In DBBROWSER.pm -
added $INGRES to @EXPORT
added $INGRES to use vars qw(....

added to $dbtype if construct
} elsif ($dbtype eq 'Ingres') {

$INGRES = 1;
$DBROWIDNAME = 'rowid';
$DBLIKENAME = 'like';

@ftypes_text = ('-37', '37');
@ftypes_extendedtext = ('-20', '20', '-21', '21');
@ftypes_numeric = ('-5', '5', '-30', '30', '-
31', '31');
@ftypes_date = ('-3', '3');
@ftypes_bool = ();
}

The types were taken from the Ingres manuals.

When running search.cgi I get
DBD::Ingres::db tables failed: E_US0B67 line 6,
Conversion of types 'longtext' and 'longtext' to the
same type is ambiguous.

I created a small perl script that just connects to a
dB and does a @some_var = $dbh_tables; command and am
able to generate the same error.

Looking at perldoc for DBI says that $dbh->tables and
$dbh->table_info are new functions and may not be
supported in later releases.

If I set $default_table to something the browser won't
display the page because of malformed headers.

If I set $default_table to something and run
search.cgi from the command line, and Ctrl-D out of
the request for input parameters, and redirect the
output to a file, and then move that file to the
htdocs directory with an .html extension it will
display in the browser.

Any pointers of what I should be looking for would be
appreciated.

If you would like me to attach files, please let me
know.

Thanks

Dennis

[Nobody/Anonymous]

Logged In: NO

I was able to work around the ambiguous longtext conversion
error by changing the following in the table_info sub in
Ingres.pm

SELECT null, table_owner, table_name, 'TABLE'
FROM IITABLES
WHERE table_type ='T'
UNION
SELECT null, table_owner, table_name, 'VIEW'
FROM IITABLES
WHERE table_type ='V'

to

SELECT '', table_owner, table_name, 'TABLE'
FROM IITABLES
WHERE table_type ='T'
UNION
SELECT '', table_owner, table_name, 'VIEW'
FROM IITABLES
WHERE table_type ='V'

I still get the malformed header error when trying to run
one of the cgi scripts through a browser.

[Chris Hardie]

Logged In: YES
user_id=8993

Thank you for submitting a DB_Browser bug report. Before
we can assist you, we need more information about your problem.
Please make sure to send

-Your name and information about how you can be contacted

-A description of your system setup: operating system,
database type and version, perl version, and DB_Browser version

-A full description of the problem you are having

-Any useful error messages from web server and/or database
error logs

-The output from running \"search.cgi\" on the command line

-A copy of your DB_Browser configuration (found in the top
section of the browse_lib.pl OR DBBROWSER.pm files). Make sure
you don\'t include any sensitive passwords.

Thank you!

[Dennis Roesler]

Logged In: YES
user_id=490085

-Your name and information about how you can be contacted
Dennis Roesler dennis_roesler@agilent.com

-A description of your system setup: operating system,
database type and version, perl version, and DB_Browser
version
HP-UX 10.20 perl 5.00404 db_browser 1.4

-A full description of the problem you are having
See summary

-Any useful error messages from web server and/or database
error logs
Apache error log:
access to /opt/apache/cgi-bin/db_browser/search.cgi failed
for <my web server>, reason: malformed header from script.
Bad header=For unknown reasons.

-The output from running \"search.cgi\" on the command
line
How do I attach a file?

-A copy of your DB_Browser configuration (found in the top
section of the browse_lib.pl OR DBBROWSER.pm files).

[Chris Hardie]

Logged In: YES
user_id=8993

Marked as bug to pursue these issues for next version.