From: Eugen L. <eu...@le...> - 2008-07-18 13:30:42
|
I've upgraded a pre- 1.x.x Mantis installation to 1.1.2, using the upgrade method described on http://www.mantisbt.org/manual/manual.installation.upgrading.php since I had trouble upgrading MySQL on that (SPARC) host I went to http://yoursite/mantis-release/admin/upgrade.php dumped the database and imported the result on a new (Linux) host in a fresh Mantis install. I used the below method create backup: mysqldump --opt -u<username> -p<password> <database name> > <backup file> restore backup: mysql --force -u<username> -p<password> <database name> < <backup file> to dump and import the database. I had to manually drop the database in the new installation of Mantis, and installed it from the dump with --force. The database contents were fully preserved, as far as I can see. Unfortunately, I'm still getting problems, e.g. APPLICATION ERROR #401 Database query failed. Error received from database was #1146: Table 'bugtracker.mantis_email_table' doesn't exist for the query: INSERT INTO mantis_email_table ( email, subject, body, submitted, metadata) VALUES ( 'el...@in...', '[Test 0000199]: sdfsfsfsfsadfsdfdsfasffads', 'On 2008-07-18 11:00, eleitl sent you this reminder about: \n\nhttp://bug.infochem.de/view.php?id=199', '2008-07-18 11:00:18', 'a:3:{s:8:"priority";s:1:"3";s:7:"charset";s:5:"utf-8";s:8:"hostname";s:15:"bug.infochem.de";}' ) when I need to send email notifications, or APPLICATION ERROR #401 Database query failed. Error received from database was #1146: Table 'bugtracker.mantis_tag_table' doesn't exist for the query: SELECT t.*, b.user_id as user_attached, b.date_attached FROM mantis_tag_table as t LEFT JOIN mantis_bug_tag_table as b on t.id=b.tag_id WHERE b.bug_id='199' Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. when the 'Tags' field is displayed. Is that a known issue, and easily fixable by a couple SQL statements, or am I screwed? I couldn't find anything online. Thanks. -- Eugen* Leitl <a href="http://leitl.org">leitl</a> http://leitl.org ______________________________________________________________ ICBM: 48.07100, 11.36820 http://www.ativel.com http://postbiota.org 8B29F6BE: 099D 78BA 2FD3 B014 B08A 7779 75B0 2443 8B29 F6BE |
From: Glenn H. <thr...@lo...> - 2008-07-18 15:40:08
|
On 18-Jul-08, at 9:30 AM, Eugen Leitl wrote: > > I've upgraded a pre- 1.x.x Mantis installation to 1.1.2, using > the upgrade method described on > > http://www.mantisbt.org/manual/manual.installation.upgrading.php > > since I had trouble upgrading MySQL on that (SPARC) host I went to > http://yoursite/mantis-release/admin/upgrade.php > dumped the database and imported the result on a new > (Linux) host in a fresh Mantis install. > You probably need to upgrade the database to the current version by running http://<your mantis>/admin/install.php. This should read the existing configuration and add the missing tables. ... Glenn -- Glenn Henshaw Logical Outcome Ltd. e: thr...@lo... w: www.logicaloutcome.ca Mantis Developer and User |
From: Eugen L. <eu...@le...> - 2008-07-25 15:28:27
|
On Fri, Jul 18, 2008 at 11:39:55AM -0400, Glenn Henshaw wrote: > > On 18-Jul-08, at 9:30 AM, Eugen Leitl wrote: > > > > > I've upgraded a pre- 1.x.x Mantis installation to 1.1.2, using > > the upgrade method described on > > > > http://www.mantisbt.org/manual/manual.installation.upgrading.php > > > > since I had trouble upgrading MySQL on that (SPARC) host I went to > > http://yoursite/mantis-release/admin/upgrade.php > > dumped the database and imported the result on a new > > (Linux) host in a fresh Mantis install. > > > > You probably need to upgrade the database to the current version by > running http://<your mantis>/admin/install.php. This should read the > existing configuration and add the missing tables. Thanks Glenn -- that did the trick. I could have sworn I did that step, but apparently I skipped it the second time. Thanks again, things seem to be working fine so far. -- Eugen* Leitl <a href="http://leitl.org">leitl</a> http://leitl.org ______________________________________________________________ ICBM: 48.07100, 11.36820 http://www.ativel.com http://postbiota.org 8B29F6BE: 099D 78BA 2FD3 B014 B08A 7779 75B0 2443 8B29 F6BE |