354324 - Testopia installation encountered errors (missing tables) and has resulted in server error page on loading bugzilla

Status: RESOLVED FIXED

(Testopia :: General, defect)

Description

[bmcelduff]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7

The following cout was displayed on executing the 
perl tr_install.pl command

[root@sydney bugzilla]# Bugzilla version 2.18rc2 detected.
Patch file chosen: patch-2.18

Now patching ...


Done.

Recovering original permissions ...
Done.

Congratulations, patch worked flawless!

A backup copy of the modified files has been saved with the .orig sufix.

Setting file permissions ...
chmod: failed to get attributes of `testopia/temp': No such file or directory
  Webserver group: apache
chown: failed to get attributes of `testopia/temp': No such file or directory
Done.

Checking Testopia database ...
  Make  : mysql
  Host  : localhost
  Port  : 3306
  Name  : bugs
  User  : bugs
  Socket:

  No Testopia database was detected. Need to create it ...
ERROR 1064 at line 24: You have an error in your SQL syntax near 'Serial,
        plan_id Bigint UNSIGNED,
        case_id Bigint UNSIGNED,
        submitter_id Medium' at line 2

Could not create Testopia's tables. See previous errors.

When logging onto Bugzilla's homepage the following is displayed:
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Is it possible to uninstall testopia or how can I proceed in order to successfully install the tool?

Reproducible: Always

Comment 1

[Greg Hendricks]

What version of MySQL are you running? Serial data types require mysql 4.x.

Also, Testopia 1.0 has not been tested against bugzilla 2.18. It supports 2.20 and 2.22 at this point. Testrunner (Tesopia's predicessor) does suppor 2.18 however.

Comment 2

[bmcelduff]

Hi, I was able to successfully install TestRunner and add users to the groups:
edittestcases amd managetestplans.
However, when I click on the 'manage' link I  observe the following error in the httpd log:
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] Can't locate Text/Diff.pm in @INC (@INC contains: . /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl) at tr_btpm_util.pl line 458., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] BEGIN failed--compilation aborted at tr_btpm_util.pl line 458., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] Compilation failed in require at /var/www/html/old-bugz/tr_edittestplans.cgi line 29 (#1), referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     (F) You said to do (or require, or use) a file that couldn't be, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     found. Perl looks for the file in all the locations mentioned in @INC,, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     unless the file name included the full path to the file.  Perhaps you, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     need to set the PERL5LIB or PERL5OPT environment variable to say where, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     the extra library is, or maybe the script needs to add the library name, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     to @INC.  Or maybe you just misspelled the name of the file.  See, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     perlfunc/require and lib., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211]     , referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] Uncaught exception from user code:, referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] !Can't locate Text/Diff.pm in @INC (@INC contains: . /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl) at tr_btpm_util.pl line 458., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] BEGIN failed--compilation aborted at tr_btpm_util.pl line 458., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] Compilation failed in require at /var/www/html/old-bugz/tr_edittestplans.cgi line 29., referer: http://sydney/old-bugz/enter_bug.cgi
[Fri Sep 29 15:30:30 2006] [error] [client 172.25.1.211] Premature end of script headers: tr_edittestplans.cgi, referer: http://sydney/old-bugz/enter_bug.cgi

Any help would be much appreciated! Thanks in advance.

Comment 3

[Greg Hendricks]

Testopia requires the Text::Diff module. checksetup does not check for this module and so there is no warning if you do not have it installed. You can get it from CPAN.

Comment 4

[Greg Hendricks]

Added checks for Text::Diff during install

Comment 5

[bmcelduff]

I installed the text::diff module as explained but I am now encountering this error:
2.25.2.163] Premature end of script headers: tr_edittestplans.cgi, referer: http://sydney/old-bugz/
[Mon Oct 02 14:08:42 2006] [error] [client 172.25.2.163] Can't locate Algorithm/Diff.pm in @INC (@INC contains: . /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl
2.25.2.163] Premature end of script headers: tr_edittestplans.cgi, referer: http://sydney/old-bugz/

Comment 6

[Greg Hendricks]

This is very Odd. Which version of Perl are you using? Algorithm::Diff is a requirement of Text::Diff. It should have been installed automatically if you used CPAN to install Text::Diff. 

You can try installing Algorithm::Diff manually as well. 

Out of curiosity, why are you using Testrunner 0.7 instead of Testopia?

Comment 7

[bmcelduff]

Thanks for all your help, that worked.  The version of Bugzilla I am using is 2.18 and Testopia does not support it unfortunately.