Anonymous | Login | Signup for a new account | 2021-01-16 10:49 GMT | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0000773 | SiT! | setup/config | public | 2009-07-13 21:01 | 2009-08-16 14:38 | ||||
Reporter | mfeider67 | ||||||||
Assigned To | ivan | ||||||||
Priority | normal | Severity | major | Reproducibility | have not tried | ||||
Status | closed | Resolution | fixed | ||||||
Platform | OS | OS Version | |||||||
Product Version | 3.45 | ||||||||
Target Version | 3.50 | Fixed in Version | 3.50 | ||||||
Summary | 0000773: upgrading to svn 3.50 - error | ||||||||
Description | Please see attached picture (in place of text below - the text is hard to read) 1. table Trigger doesn't seem to have a 'type' column, but line 2760 in setup-schema.php seems to think it should 2. not sure what is wrong here, myphpadmin doesn't like it either 3. there is an extra character at the end of line 2761 in setup-scheme.php that is causing this one - running in myphpadmin works fine with the removal of this character. 4. I didn't look into the missing trigger function. I am guessing a missing library call though. | ||||||||
Additional Information | Support Incident Tracker - Installation & Setup Connected to database - ok Installed OK Updating schema from 3.45 to v3.50… A MySQL error occurred: [1064] 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 'TABLE `triggers` SET `type` = 'built-in' WHERE id < 35' at line 1 You may have found a bug, if you think this is the case please report it. Raw SQL: UPDATE TABLE `triggers` SET `type` = 'built-in' WHERE id < 35 A MySQL error occurred: [1064] 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 'TABLE `noticetemplates` SET `description` = 'strNoticeMinsHeldEmailDesc', `text`' at line 1 You may have found a bug, if you think this is the case please report it. Raw SQL: UPDATE TABLE `noticetemplates` SET `description` = 'strNoticeMinsHeldEmailDesc', `text` = 'strNoticeMinsHeldEmail' WHERE `name` = 'NOTICE_MINS_HELD_EMAIL' AND `description` = 'strNoticeNewUserDesc' AND `text` = 'strNoticeNewUser' A MySQL error occurred: [1064] 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 'i UPDATE `emailtemplates` SET `type` = 'system' WHERE id < 28 AND id > 1 AND ty' at line 1 You may have found a bug, if you think this is the case please report it. Raw SQL: i UPDATE `emailtemplates` SET `type` = 'system' WHERE id < 28 AND id > 1 AND type != 'incident' Summary: 3 Error(s) occurred while updating the schema, please resolve the problems reported and then try running setup again. See the doc/UPGRADE file for further upgrade instructions and help. Upgrade complete Upgraded to v3.50 Fatal error: Call to undefined function trigger() in /var/www/sit-3.45/setup.php on line 1358 | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | ![]() | ||||||||
![]() |
|
ivan (administrator) 2009-07-16 10:19 |
Hi Matt, Thanks for the bug report. Ivan |
ivan (administrator) 2009-07-17 12:18 |
Confirmed by Tomse and Legoman |
ivan (administrator) 2009-07-21 22:04 |
Fixed in trunk svn r5547 |
ivan (administrator) 2009-08-16 14:38 |
Released in 3.50rc1 |
![]() |
|||
Date Modified | Username | Field | Change |
2009-07-13 21:01 | mfeider67 | New Issue | |
2009-07-13 21:01 | mfeider67 | File Added: sit_3.50erroronupgrade.png | |
2009-07-16 10:19 | ivan | Note Added: 0001316 | |
2009-07-16 10:19 | ivan | Status | new => acknowledged |
2009-07-17 12:18 | ivan | Note Added: 0001338 | |
2009-07-17 12:18 | ivan | Status | acknowledged => confirmed |
2009-07-20 22:00 | ivan | Target Version | => 3.50 |
2009-07-21 21:21 | ivan | Status | confirmed => assigned |
2009-07-21 21:21 | ivan | Assigned To | => ivan |
2009-07-21 22:04 | ivan | Note Added: 0001365 | |
2009-07-21 22:04 | ivan | Status | assigned => resolved |
2009-07-21 22:04 | ivan | Resolution | open => fixed |
2009-07-21 22:04 | ivan | Fixed in Version | => Current SVN |
2009-08-16 13:16 | ivan | Fixed in Version | Current SVN => 3.50 |
2009-08-16 14:38 | ivan | Note Added: 0001625 | |
2009-08-16 14:38 | ivan | Status | resolved => closed |
Copyright © 2000 - 2021 MantisBT Team |