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)

x86
Windows XP
defect
Not set
major

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
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
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
Status: NEW → ASSIGNED
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.
BTW, the "Bugzilla/WebService.pm fails to patch" piece of this bug is described in https://bugzilla.mozilla.org/show_bug.cgi?id=387379
/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.