Eugen Leitl | 18 Jul 15:26
Favicon

application error #401


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@...',
'[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

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

Gmane