ODP: Problems with Bugzilla and MySQL - Bajonski Lukasz - com.mysql.lists.mysql

1 message in com.mysql.lists.mysqlODP: Problems with Bugzilla and MySQL

From	Sent On	Attachments
Bajonski Lukasz	15 Dec 1999 06:34

Subject:	ODP: Problems with Bugzilla and MySQL
From:	Bajonski Lukasz (Luka...@handlobank.com.pl)
Date:	12/15/1999 06:34:24 AM
List:	com.mysql.lists.mysql

-----Oryginalna wiadomość----- Od: sin...@mysql.com [mailto:sin...@mysql.com] Wysłano: 14 grudnia 1999 17:37 Do: Luka...@handlobank.com.pl DW: mys...@lists.mysql.com Temat: Re: Problems with Bugzilla and MySQL

Bajonski Lukasz writes:

Hi ! I have a big problem when installing Bugzilla program :( While trying to install new tables I get message: "DBD::mysql::db do failed: parse error near 'text not null, isbuggroup tinyint not null, userregexp tinytext not null,

unique(bit), unique(name) )' at line 4 at ./checksetup.pl line 674. Uncaught exception from user code: Could not create table 'groups'. Please check your 'mysql' access."

Is anyone know what I am doing wrong ? Please help.

Luke from Poland

No, we can not fathom what are you doing wrong, unless you send us the entire create table syntax, together with MySQL version you are running.

Sinisa

System: Mandrake Linux 6.1 on Intel Celeron Kernel: 2.2.13-7mdk MySQL ver: 3.22.25 rel 4mdk (included in Mandrake) msql-mysql-modules ver: 1.2018 Bugzilla ver: 2.8

I could only guess the syntax becouse tables are (should be) created by a checksetup.pl script. Line 674: " $dbh->do("CREATE TABLE $tabname (\n$fielddef\n)") or die "Could not create table '$tabname'. Please check your '$db_base'"

Whole chapter:

########################################################################### # Create tables ###########################################################################

# The current DBI::mysql tells me to use this: #my @tables = map { $_ =~ s/.*\.//; $_ } $dbh->tables(); # but that doesn't work on a freshly created database, so I still use my @tables = $dbh->func('_ListTables'); #print 'Tables: ', join " ", @tables, "\n";

# add lines here if you add more --LOCAL-- config vars that end up in the enums:

my $severities = '"' . join('", "', @severities) . '"'; my $priorities = '"' . join('", "', @priorities) . '"'; my $opsys = '"' . join('", "', @opsys) . '"'; my $platforms = '"' . join('", "', @platforms) . '"';

# go throught our %table hash and create missing tables while (my ($tabname, $fielddef) = each %table) { next if grep /^$tabname$/, @tables; print "Creating table $tabname ...\n";

# add lines here if you add more --LOCAL-- config vars that end up in # the enums:

$fielddef =~ s/\$severities/$severities/; $fielddef =~ s/\$priorities/$priorities/; $fielddef =~ s/\$opsys/$opsys/; $fielddef =~ s/\$platforms/$platforms/;

$dbh->do("CREATE TABLE $tabname (\n$fielddef\n)") or die "Could not create table '$tabname'. Please check your '$db_base' }

############################################################################ ###

Maybe perl modules cause problems ? make test in Msql-Mysql-modules-1.2018 directory receive errors:

t/dbdadmin..........Use of uninitialized value at t/lib.pl line 238. Use of uninitialized value at t/lib.pl line 238. FAILED tests 4, 21 Failed 2/22 tests, 90.91% okay t/mysql2............ok t/mysql.............ok Failed Test Status Wstat Total Fail Failed List of failed

----------------------------------------------------------------------------