mantis_tag_table doesn't exist

[Ernesto]

Hi guys, can you help us to upgrade Mantis tool from 1.0.5 version to 1.1.1?

We have followed the installation/upgrade instructions from this URL:

http://manual.mantisbt.org/manual.insta ... rading.php

But we have the following error

======================================================================================================================================
APPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table 'mantis_111.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='563'

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.

======================================================================================================================================

Where “mantis_111” is the name of MYSQL database.
We don’t have this table (mantis_tag_table) in mantis_111 database.

Thanks in advance.
Best Regards,
Ernesto

[Kirill]

You don't run upgrade script. Please read reference to upgrade db.
http://manual.mantisbt.org/manual.insta ... rading.php

[Ernesto]

Hi Kirill, thanks for you fast response.
I've run the following steps:

1) Create the a database instance on MYSQL Server (mantis_111).
2) /usr/local/mysql-max-4.1.13-sun-solaris2.8-sparc-64bit/bin/mysql -u[username] -P3308 -S/tmp/mysqld-new4.sock -p [database_name] < [filename]
where filename is the backup of 1.0.5 mantis database
3) Insert the customizations done in custom_strings_inc.php, custom_constants_inc.php, and custom_functions_inc.php ...
4) Call http://my.mantis_111/admin/check.php
5) Call http://my.mantis_111/admin/install.php

In 5th step we have this warning

================================================================
Schema CreateTableSQL ( mantis_config_table ) BAD
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 0, access_reqd INTEGER DEFAULT 0, type INTEGER DEFAULT 90, value LONGTEXT NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )TYPE=MyISAM
Table 'mantis_config_table' already exists
================================================================

But ... for example in http://my.mantis_111/view.php?id=561 .. in "TAGS FIELD" we have the same problem.

Could you tell me the right steps to follow?

Best regards.
Ernesto

[Kirill]

try create manualy

Code: Select all

CREATE TABLE `mantis_tag_table` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` longtext NOT NULL,
  `date_created` datetime NOT NULL default '1970-01-01 00:00:01',
  `date_updated` datetime NOT NULL default '1970-01-01 00:00:01',
  PRIMARY KEY  (`id`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

[Ernesto]

Hi Kirill, thanks for your help.
I've executed your msql command successfully, but we need to create "mantis_bug_tag_table" table too.
Please, could you send me the sql command to create it?

Best regards.
Ernesto

[Kirill]

Code: Select all

CREATE TABLE `mantis_bug_tag_table` (
  `bug_id` int(10) unsigned NOT NULL default '0',
  `tag_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `date_attached` datetime NOT NULL default '1970-01-01 00:00:01',
  PRIMARY KEY  (`bug_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Please.
Sorry, I forgot paste this table

[Ernesto]

Hi Kirill, thanks for your precious support.
I've execute your mysql scripts and now it works fine.

Thanks and best regards.
Ernesto

[Ernesto]

Hi Kirill, sorry but I have found some errors.

1) When we create a new account appears this error::

====================================================================================================================================
Database query failed. Error received from database was #1146: Table 'mantis_111.mantis_email_table' doesn't exist for the query: INSERT INTO mantis_email_table
( email,
subject,
body,
submitted,
metadata)
VALUES
( 'pippo.pluto@society.com',
'[CAD-DDM-Mantis] Account registration',
'Thank you for registering. You have account with username \'Pippo Pluto\'. In order to complete your registration, visit the following URL (make sure it is entered as the single line) and set your own access password: \n\nhttp://mymantis_111/verify.php?id=105&confirm_hash=d9211b01c00294fac07dba5f90f8eb00 \n\nIf you didn\'t request any registration, ignore this message and nothing will happen.\n\nDO NOT REPLY TO THIS MESSAGE',
'2008-01-23 10:35:53',
'a:3:{s:8:"priority";s:1:"3";s:7:"charset";s:5:"utf-8";s:8:"hostname";s:14:"mymantis_111";}'
)
====================================================================================================================================

The account has been created and he can connect on Mantis, but he didn't receive the mail about the registration.

2) When we insert a new issue appears this error:

====================================================================================================================================
Database query failed. Error received from database was #1054: Unknown column 'target_version' in 'field list' for the query: INSERT INTO mantis_bug_table
( project_id,
reporter_id, handler_id,
duplicate_id, priority,
severity, reproducibility,
status, resolution,
projection, category,
date_submitted, last_updated,
eta, bug_text_id,
os, os_build,
platform, version,
build,
profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version,
target_version
)
VALUES
( '25',
'2', '0',
'0', '30',
'11', '70',
'10', '10',
10, 'Bug',
'2008-01-23 10:59:36','2008-01-23 10:59:36',
10, '565',
'', '',
'', '',
'',
'0', 'Test for DDM Group', '10', '0', '0', '',
''
)

====================================================================================================================================

I have the following table in my mantis database (mantis_111):

mantis_bug_file_table
mantis_bug_history_table
mantis_bug_monitor_table
mantis_bug_relationship_table
mantis_bug_table
mantis_bug_tag_table (CREATED BY YOUR SCRIPT)
mantis_bug_text_table
mantis_bugnote_table
mantis_bugnote_text_table
mantis_config_table
mantis_custom_field_project_table
mantis_custom_field_string_table
mantis_custom_field_table
mantis_filters_table
mantis_news_table
mantis_project_category_table
mantis_project_file_table
mantis_project_hierarchy_table
mantis_project_table
mantis_project_user_list_table
mantis_project_version_table
mantis_sponsorship_table
mantis_tag_table (CREATED BY YOUR SCRIPT)
mantis_tokens_table
mantis_user_pref_table
mantis_user_print_pref_table
mantis_user_profile_table
mantis_user_table

could you verify your database and send me the mysql script to create the missing table/s.
Thanks in advance and best regards.
Ernesto

[Kirill]

not see for plugin* tables.

[Ernesto]

Hi Kirill.
I don't have mantis_email_table and mantis_plugins*_table.
Could you send me the mysql scripts to create them.

Best regards.
Ernesto

[Kirill]

Code: Select all

CREATE TABLE `mantis_email_table` (
  `email_id` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(64) NOT NULL default '',
  `subject` varchar(250) NOT NULL default '',
  `submitted` datetime NOT NULL default '1970-01-01 00:00:01',
  `metadata` longtext NOT NULL,
  `body` longtext NOT NULL,
  PRIMARY KEY  (`email_id`),
  KEY `idx_email_id` (`email_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3495 ;

Plugins is solution by deboutv.
http://deboutv.free.fr/mantis/index.php

[Ernesto]

Hi Kirill, I've a little doubt about mantis_pluging* tables.

1) Are these tables Mantis standard tables?
2) What are the benefits about these tables?

=======================================================================
About the 2th error, in the previous post, could you help me?
Mantis searches 'target_version' column in "mantis_bug_table" table.
Sorry but I don't understand because this column doesn't exists!!!
=======================================================================

In the past I've upgraded, in one shot, from 0.19.4 to 1.0.5 using a Mantis mysql script.
Does it exits a mysql script to upgrade the mantis mysql database from 1.0.5 to 1.1.1?

Thanks in advance and best regards.
Ernesto

[Kirill]

1. Not. This plugin table

2.

Code: Select all

CREATE TABLE `mantis_bug_table` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `project_id` int(10) unsigned NOT NULL default '0',
  `reporter_id` int(10) unsigned NOT NULL default '0',
  `handler_id` int(10) unsigned NOT NULL default '0',
  `duplicate_id` int(10) unsigned NOT NULL default '0',
  `priority` smallint(6) NOT NULL default '30',
  `severity` smallint(6) NOT NULL default '50',
  `reproducibility` smallint(6) NOT NULL default '10',
  `status` smallint(6) NOT NULL default '10',
  `resolution` smallint(6) NOT NULL default '10',
  `projection` smallint(6) NOT NULL default '10',
  `category` varchar(64) NOT NULL,
  `date_submitted` datetime NOT NULL default '1970-01-01 00:00:01',
  `last_updated` datetime NOT NULL default '1970-01-01 00:00:01',
  `eta` smallint(6) NOT NULL default '10',
  `bug_text_id` int(10) unsigned NOT NULL default '0',
  `os` varchar(32) NOT NULL,
  `os_build` varchar(32) NOT NULL,
  `platform` varchar(32) NOT NULL,
  `version` varchar(64) NOT NULL,
  `fixed_in_version` varchar(64) NOT NULL,
  `build` varchar(32) NOT NULL,
  `profile_id` int(10) unsigned NOT NULL default '0',
  `view_state` smallint(6) NOT NULL default '10',
  `summary` varchar(128) NOT NULL,
  `sponsorship_total` int(11) NOT NULL default '0',
  `sticky` tinyint(4) NOT NULL default '0',
  `target_version` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `idx_bug_sponsorship_total` (`sponsorship_total`),
  KEY `idx_bug_fixed_in_version` (`fixed_in_version`),
  KEY `idx_bug_status` (`status`),
  KEY `idx_project` (`project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=497 ;

Can you send you backup? I want try update you mantis system.

[Ernesto]

Hi Kirill, thank you for all.
I have changed the steps to upgrade mantis from 1.0.5 to 1.1.1.
I have followed these steps:

1) Create Mantis table by mantis "install.php" script
2) Export data from old database (Mantis_105)
3) Import data in new database (Mantis_111)

Now I testing all MANTIS flow and I will say you the news about the upgrade.

Best regards.
Ernesto