Closed Bug 395958 Opened 18 years ago Closed 18 years ago

testopia should run under bugzilla 3.0.x

Categories

(Testopia :: General, enhancement)

Product:
Testopia
Platform:
Other
Linux
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: tom, Assigned: gregaryh)

References

Details

User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/522.11.1 (KHTML, like Gecko) Version/3.0.3 Safari/522.12.1 Build Identifier: 1.3 Patch seems to encounter some troubles when running against bugzilla 3.0.1, and running checksetup.pl doesn't indicate that testopia is present. Install log: 122 root@nyp-webdev[/usr/share/bugzilla]: patch -p0 -i testopia/patch-3.0 patching file editusers.cgi patching file enter_bug.cgi patching file Bugzilla/DB/Schema/Pg.pm patching file Bugzilla/DB/Schema/Mysql.pm patching file Bugzilla/WebService.pm patching file Bugzilla/Template.pm patching file template/en/default/global/common-links.html.tmpl patching file template/en/default/global/header.html.tmpl patching file Bugzilla/DB/Schema.pm Reversed (or previously applied) patch detected! Assume -R? [n] y Hunk #1 succeeded at 1211 with fuzz 1 (offset -120 lines). patching file Bugzilla/User.pm Hunk #5 succeeded at 1596 (offset 20 lines). patching file Bugzilla/WebService/Constants.pm patching file Bugzilla/WebService/User.pm patching file Bugzilla/DB/Mysql.pm patching file votes.cgi patching file Bugzilla/Install/Filesystem.pm Hunk #1 succeeded at 110 (offset 2 lines). 123 root@nyp-webdev[/usr/share/bugzilla]: ./checksetup.pl * This is Bugzilla 3.0.1 on perl 5.8.8 * Running on Linux 2.6.22.4-65.fc7 #1 SMP Tue Aug 21 21:50:50 EDT 2007 Checking perl modules... Checking for CGI (v2.93) ok: found v3.15 Checking for TimeDate (v2.21) ok: found v2.22 Checking for DBI (v1.41) ok: found v1.53 Checking for PathTools (v0.84) ok: found v3.25 Checking for Template-Toolkit (v2.12) ok: found v2.18 Checking for Email-Send (v2.00) ok: found v2.185 Checking for Email-MIME-Modifier (any) ok: found v1.441 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) ok: found v1.49 Checking for DBD-mysql (v2.9003) ok: found v3.0008 The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.35 Checking for Template-GD (any) ok: found v1.56 Checking for Chart (v1.0) ok: found v2.4.1 Checking for GDGraph (any) ok: found v1.44 Checking for GDTextUtil (any) ok: found v0.86 Checking for XML-Twig (any) ok: found v3.29 Checking for MIME-tools (v5.406) ok: found v5.420 Checking for libwww-perl (any) ok: found v2.033 Checking for PatchReader (v0.9.4) ok: found v0.9.5 Checking for PerlMagick (any) ok: found v6.3.2 Checking for perl-ldap (any) ok: found v0.34 Checking for SOAP-Lite (any) ok: found v0.68 Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.313 Checking for Email-Reply (any) ok: found v1.201 Checking for mod_perl (v1.999022) ok: found v2.000003 Checking for CGI (v3.11) ok: found v3.15 Checking for Apache-DBI (v0.96) ok: found v1.06 Reading /etc/bugzilla/localconfig... Checking for DBD-mysql (v2.9003) ok: found v3.0008 Checking for MySQL (v4.1.2) ok: found v5.0.16 Removing existing compiled templates ... Precompiling templates... Fixing file permissions... 124 root@nyp-webdev[/usr/share/bugzilla]: ======== Attempted pageload displays: Bugzilla has suffered an internal error. Please save this page and send it to tom@razz.com with details of what you were doing at the time this message appeared. URL: xxx Template->process() failed twice. First error: undef error - DBD::mysql::db selectall_arrayref failed: Table 'bugzilla.test_named_queries' doesn't exist [for Statement "SELECT name, query FROM test_named_queries WHERE userid = ? AND isvisible = 1"] at Bugzilla/User.pm line 336 Bugzilla::User::testopia_queries('Bugzilla::User=HASH(0x19c3310)') called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 128 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 128 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x22fe200)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'hook/global/common-links.html.tmpl/links/testopia.html.tmpl') called at Bugzilla/Template/Plugin/Hook.pm line 101 Bugzilla::Template::Plugin::Hook::process('Bugzilla::Template::Plugin::Hook=HASH(0x20ce410)', 'links') called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 219 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 219 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x22e3670)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'global/common-links.html.tmpl', 'HASH(0x22bd7f0)') called at /var/lib/bugzilla/data/template/template/en/default/global/header.html.tmpl line 599 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x2141c30)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'global/header.html.tmpl', 'HASH(0x20a1190)') called at /var/lib/bugzilla/data/template/template/en/default/index.html.tmpl line 25 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/index.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x20bbde0)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'Template::Document=HASH(0x20bbde0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Service.pm line 94 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x19cd460)', 'index.html.tmpl', 'HASH(0x19c3c90)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x19c4a70)', 'index.html.tmpl', 'HASH(0x19c3c90)') called at /usr/share/bugzilla/index.cgi line 71 Second error: undef error - DBD::mysql::db selectall_arrayref failed: Table 'bugzilla.test_named_queries' doesn't exist [for Statement "SELECT name, query FROM test_named_queries WHERE userid = ? AND isvisible = 1"] at Bugzilla/User.pm line 336 Bugzilla::User::testopia_queries('Bugzilla::User=HASH(0x19c3310)') called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 128 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 128 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/hook/global/common-links.html.tmpl/links/testopia.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x22fe200)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'hook/global/common-links.html.tmpl/links/testopia.html.tmpl') called at Bugzilla/Template/Plugin/Hook.pm line 101 Bugzilla::Template::Plugin::Hook::process('Bugzilla::Template::Plugin::Hook=HASH(0x22a5850)', 'links') called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 219 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 219 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/common-links.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x22e3670)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'global/common-links.html.tmpl', 'HASH(0x2383dd0)') called at /var/lib/bugzilla/data/template/template/en/default/global/header.html.tmpl line 599 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x2141c30)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'global/header.html.tmpl') called at /var/lib/bugzilla/data/template/template/en/default/global/code-error.html.tmpl line 1779 eval {...} called at /var/lib/bugzilla/data/template/template/en/default/global/code-error.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x23504b0)', 'Template::Context=HASH(0x1a77fc0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1a77fc0)', 'Template::Document=HASH(0x23504b0)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Service.pm line 94 eval {...} called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x19cd460)', 'global/code-error.html.tmpl', 'HASH(0x1b92100)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x19c4a70)', 'global/code-error.html.tmpl', 'HASH(0x1b92100)') called at Bugzilla/Error.pm line 144 Bugzilla::Error::ThrowTemplateError('Template::Exception=ARRAY(0x22d4590)') called at /usr/share/bugzilla/index.cgi line 71 Reproducible: Always Steps to Reproduce: 1. install bugzilla 3.0.1 2. install testopia 1.3 3. cackle with delight
Testopia is not (yet) supported on bugzilla 3.0.1. Did you find docs that suggested otherwise?
Severity: critical → enhancement
Summary: Installation under Bugzilla 3.0.1 failing - checksetup.pl doesn't create tables → testopia should run under bugzilla 3.0.1
HI, Vance. Thanks for the rapid response. As to your question: none whatsoever, save the VM image that my co-worker had thoughtfully used to evaluate testopia, which seems to be testopia 1.3 installed under bugzilla 3.0.1. I certainly can't point a finger in your direction. It looks like a very capable solution. Consider me anxiously awaiting 3.0.1 support.
As I recall, the Bugzilla/DB/Schema.pm patch is to fix a bug in 3.0 that is now fixed in 3.0.1. So when you answered "yes" to patch's question, it actually removed the fix. :-) So, replacing your Bugzilla/DB/Schema.pm with the one from 3.0.1 should do the trick.
Note, however, that 3.0.1 is not supported until this bug is marked fixed.
Status: UNCONFIRMED → ASSIGNED
Ever confirmed: true
Hi Vance: Appreciate the idea -- gave it a whirl (denied that hunk of the patch), checksetup, copied the schema back from pre-patch to be sure, checksetup, same problem after login. checksetup just doesn't seem to get that it needs to create the tables, for whatever reason. *shrug* I'll try to poke a little deeper and see what I can dig up.
Just wanted to chime in that the VM referred to is probably this one: http://www.vmware.com/appliances/directory/807
hi, eventually i managed to make it work with Bugzilla 3.0.1 as suggested by the provided steps /above/. As newbee to Testopia I can say only that there are some instantly observed flaws, which I will review and probably provide feedback to what I've managed to accomplish using Testopia. Thanks for the great work btw. Waiting forward for the official release of the supported version.
Summary: testopia should run under bugzilla 3.0.1 → testopia should run under bugzilla 3.0.x
There is now a patch-3.0.x for all releases 3.0.1 - 3.0.4
Status: ASSIGNED → RESOLVED
Closed: 18 years ago
Resolution: --- → FIXED
where might we find the patch-3.0.x ? It isn't included in testopia-1.3-BETA2.tar.gz
Correct. Those instructions refer to Testopia 2.0
You need to log in before you can comment on or make changes to this bug.