Closed
Bug 387377
Opened 17 years ago
Closed 17 years ago
SQL syntax error during INSERT INTO test_case_run_status
Categories
(Testopia :: General, defect)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: patrick.lam, Assigned: vrb)
References
()
Details
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; MEGAUPLOAD 2.0) Build Identifier: Testopia 1.3 after I run "C:\Bugzilla\testopia\tools\patch.exe -p0 -i C: \Bugzilla\testopia\patch-3.0.bat" It shown: patching file editusers.cgi patching file Bugzilla.pm patching file enter_bug.cgi patching file Bugzilla/DB/Schema/Pg.pm patching file Bugzilla/DB/Schema/Mysql.pm patching file Bugzilla/WebService.pm Reversed (or previously applied) patch detected! Assume -R? [n] -R Apply anyway? [n] y Hunk #1 FAILED at 14. Hunk #2 FAILED at 50. Hunk #3 succeeded at 158 (offset 52 lines). Hunk #4 FAILED at 231. 3 out of 4 hunks FAILED -- saving rejects to file Bugzilla/ WebService.pm.rej 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 Hunk #1 succeeded at 1211 with fuzz 1 (offset -120 lines). patching file Bugzilla/User.pm patching file Bugzilla/WebService/Constants.pm patching file Bugzilla/WebService/User.pm patching file Bugzilla/DB/Mysql.pm It failed to patch in "Bugzilla/WebService.pm". and I tried to run "checksetup.pl" The error is shown as same before: An error occurred processing hook install-update_db in extension ./extensions/testopia: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers ion for the right syntax to use near 'INSERT INTO test_case_run_status (name, so rtkey) VALUES ('PASSED', 2) INSERT INT' at line 2 at ./extensions/testopia/code/install- update_db.pl line 32 5 Bugzilla::Hook::populateMiscTables() called at ./extensions/ testopia/cod e/install-update_db.pl line 259 Bugzilla::Hook::testopiaUpdateDB() called at ./extensions/ testopia/code/ install-update_db.pl line 31 require ./extensions/testopia/code/install-update_db.pl called at Bugzil la/Hook.pm line 46 Bugzilla::Hook::process('install-update_db') called at Bugzilla/Install/ DB.pm line 529 Bugzilla::Install::DB::update_table_definitions() called at C: \Bugzilla\ checksetup.pl line 195 Reproducible: Always Steps to Reproduce: 1.run "C:\Bugzilla\testopia\tools\patch.exe -p0 -i C:\Bugzilla\testopia\patch-3.0.bat" 2.3 out of 4 hunks FAILED -- saving rejects to file Bugzilla/ WebService.pm.rej 3.run "checksetup.pl" 4.An error occurred processing hook install-update_db in extension ./extensions/testopia: DBD::mysql::db do failed: You have an error in your SQL syntax; Actual Results: An error occurred processing hook install-update_db in extension ./extensions/testopia: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers ion for the right syntax to use near 'INSERT INTO test_case_run_status (name, so rtkey) VALUES ('PASSED', 2) INSERT INT' at line 2 at ./extensions/testopia/code/install- update_db.pl line 32 5 Bugzilla::Hook::populateMiscTables() called at ./extensions/ testopia/cod e/install-update_db.pl line 259 Bugzilla::Hook::testopiaUpdateDB() called at ./extensions/ testopia/code/ install-update_db.pl line 31 require ./extensions/testopia/code/install-update_db.pl called at Bugzil la/Hook.pm line 46 Bugzilla::Hook::process('install-update_db') called at Bugzilla/Install/ DB.pm line 529 Bugzilla::Install::DB::update_table_definitions() called at C: \Bugzilla\ checksetup.pl line 195
Assignee | ||
Comment 1•17 years ago
|
||
Changed summary -- one bug per bug report, please.
Status: UNCONFIRMED → ASSIGNED
Ever confirmed: true
Summary: SQL syntax error during INSERT INTO test_case_run_status AND Bugzilla/WebService.pm fails to patch → SQL syntax error during INSERT INTO test_case_run_status
Assignee | ||
Comment 2•17 years ago
|
||
Here's the interesting part of comment 0: An error occurred processing hook install-update_db in extension ./extensions/testopia: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO test_case_run_status (name, sortkey) VALUES ('PASSED', 2) INSERT INT' at line 2 at ./extensions/testopia/code/install-update_db.pl line 325
Assignee: ghendricks → vrb
Status: ASSIGNED → NEW
Assignee | ||
Updated•17 years ago
|
Status: NEW → ASSIGNED
Assignee | ||
Comment 3•17 years ago
|
||
r3095 | vrb | 2007-07-16 13:21:53 -0600 (Mon, 16 Jul 2007) | 5 lines Changed paths: M /trunk/extensions/testopia/code/install-update_db.pl D /trunk/testopia/testopia.insert.sql All of testopia/testopia.insert.sql is now inside extensions/testopia/code/install-update_db.pl.
Assignee | ||
Comment 4•17 years ago
|
||
BTW, the "Bugzilla/WebService.pm fails to patch" piece of this bug is described in https://bugzilla.mozilla.org/show_bug.cgi?id=387379
Comment 5•17 years ago
|
||
/cvsroot/mozilla/webtools/testopia/extensions/testopia/code/install-update_db.pl,v <-- install-update_db.pl new revision: 1.4; previous revision: 1.3
Status: ASSIGNED → RESOLVED
Closed: 17 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•