Issue With Migrating Bugzilla 3.0.5 to Bugzilla 4.0.2

ERROR: There are invalid values for the assigned_to column in the bugs
table. (These values do not exist in the profiles table, in the userid
column.) Before continuing with checksetup, you will need to fix these
values, either by deleting these rows from the database, or changing
the values of assigned_to in bugs to point to valid values in
profiles.userid. The bad values from the bugs.assigned_to column are:
13, 16, 22, 23, 38, 40
0
Krishnaraj
12/1/2011 11:33:23 AM
mozilla.support.bugzilla 10157 articles. 0 followers. Post Follow

2 Replies
842 Views

Similar Articles

[PageSpeed] 54

On 01/12/11 11:33, Krishnaraj B wrote:
> ERROR: There are invalid values for the assigned_to column in the bugs
> table. (These values do not exist in the profiles table, in the userid
> column.) Before continuing with checksetup, you will need to fix these
> values, either by deleting these rows from the database, or changing
> the values of assigned_to in bugs to point to valid values in
> profiles.userid. The bad values from the bugs.assigned_to column are:
> 13, 16, 22, 23, 38, 40

This seems pretty clear to me. What is the problem? :-)

Gerv
0
Gervase
12/1/2011 12:01:21 PM
Krishnaraj,

 You will have to update the bugs table directly. For this, use the SQL
update syntax to replace all the below values in assigned_to column of
bugs table with any existing users userid(profiles.userid); preferably
do it with the product/component owners userid.

 I remember seeing a similar issue being answered few days back on this
forum. Check the mail archives for the correct syntax if needed.

~raghu

On Thu, 2011-12-01 at 03:33 -0800, Krishnaraj B wrote:
> ERROR: There are invalid values for the assigned_to column in the bugs
> table. (These values do not exist in the profiles table, in the userid
> column.) Before continuing with checksetup, you will need to fix these
> values, either by deleting these rows from the database, or changing
> the values of assigned_to in bugs to point to valid values in
> profiles.userid. The bad values from the bugs.assigned_to column are:
> 13, 16, 22, 23, 38, 40
> _______________________________________________
> support-bugzilla mailing list
> support-bugzilla@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you reply.


Any comments or statements made in this email are not necessarily those of Tavant Technologies.
The information transmitted is intended only for the person or entity to which it is addressed and may 
contain confidential and/or privileged material. If you have received this in error, please contact the 
sender and delete the material from any computer. All e-mails sent from or to Tavant Technologies 
may be subject to our monitoring procedures.

0
Raghu
12/1/2011 12:02:36 PM
Reply:

Similar Artilces:

Recommendations and questions for bugzilla 3.0.8 and testopia 2.2 upgrade to Bugzilla 4.4.5 and Testopia 2.5
Hi. At work i have the projecto to upgrade bugzilla and testopia from bugzilla 3.0.8 and testopia 2.2 to latest version (bz 4.4.5 & testopia 2.5) but have a few questions; hope you can help. I see a lot of changes, but what the most significant? Is there a manual to upgrade? When i upgrade, my information on MySQL will be deleted? What do you recommend to havea nice upgrade and don't lose info? Thanks, regards. Guten Tag davidarredondolopez@gmail.com, am Freitag, 1. August 2014 um 02:33 schrieben Sie: > I see a lot of changes, but what the most significant? You ...

[ANN] Security Advisory for Bugzilla 3.0.10, 3.2.5, 3.4.4, and 3.5.2
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. This advisory covers two security issues that have recently been fixed in the Bugzilla code: + Some files stored on the web server are not correctly protected against external access and can be viewed from a web browser. + Restricting a bug to a group while moving the bug to another product has no effect if the group is not used by both products. The bug may become public if no other group restriction applies. All...

bugzilla upgrade from bugzilla 4.0.2 to 4.4.5
Hi When i ugrade bugzilla from 4.0.2 to 4.4.5 i am getin the below error Not a reference at Bugzilla/DB/Schema.pm line 2786. How to resolve this. i have few custom fields in my bugzilla 4.0.2 New parameter: default_search_limit The following parameters are no longer used in Bugzilla, and so have been moved from your parameters file into ./data/old-params.txt: usebugaliases, allow_attach_url, specific_search_allow_empty_words Removing existing compiled templates... Precompiling templates...done. Fixing file permissions... Populating new field_visibility table... Deleting...

Security advisory for Bugzilla 4.5.3, 4.4.3, 4.2.8, and 4.0.12
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * The login form had no CSRF protection, meaning that an attacker could force the victim to log in using the attacker's credentials. * Dangerous control characters can be inserted into Bugzilla, notably into bug comments, which can then be used to execute local commands. All affected installations are encouraged to upgrade as soon as possible. Vuln...

[ANN] Release of Bugzilla 4.5.3, 4.4.3, 4.2.8, and 4.0.12
Today we are releasing 4.4.3, 4.2.8, 4.0.12, and the unstable development snapshot 4.5.3. All of today's releases contain security fixes. We recommend all Bugzilla administrators to read the Security Advisory linked below. Bugzilla 4.4.3 is our latest stable release. It contains various useful bug fixes, performance improvements and security fixes for the 4.4 branch. Bugzilla 4.2.8 and 4.0.12 are security updates for the 4.2 branch and the 4.0 branches, respectively. 4.2.8 also contains several bug fixes. Note that 4.5.3 is an unstable development release a...

[ANN] Release of Bugzilla 3.0.10, 3.2.6, 3.4.5, and 3.5.3
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Today we have four new releases: Bugzilla 3.4.5 is our latest stable release. It contains various useful bug fixes and security improvements. Bugzilla 3.2.6 is a security update for the 3.2 branch, and Bugzilla 3.0.11 is a security update for the 3.0 branch. Bugzilla 3.5.3 is our latest unstable development release. We are now feature-frozen for 3.6, so though there will be a few functional changes between now and the final release, this is mostly what 3.6 will look like when it comes out. As usual with development release...

Problem migrating database from bugzilla 2.20.2 to bugzilla 3.0
hi all, I installed bugzilla 3.0 and was working fine till I tried migrating the mysql db from previous version of bugzilla 2.20.2. These two versions are on different machines. I created .dmp file to get the data in bugzilla 2.20.2 to update it to bugzilla 3.0. Tables seemed to be updated(not sure if there is mismatch between the table structure), but after that upon trying to run checksetup.pl script, I am getting the following message ------------------------------------------------ "There was an error connecting to MySQL: Access denied for user 'bugs'@'localh...

[ANN] Release of Bugzilla 3.4.2, 3.2.5, and 3.0.9
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Today the Bugzilla Project is releasing Bugzilla 3.4.2, 3.2.5, and 3.0.9. All of these releases contain a VERY IMPORTANT SECURITY FIX. See the Security Advisory for details. If you are running 2.23 or later, you should upgrade immediately. If you are unable to update to the latest version, then please apply the patches for the issues as described in the Security Advisory. Bugzilla 3.4.2 is our latest stable release, and in addition to the security fixes, it contains various useful bug fixes and minor improvements. Bugzilla 3....

[ANN] Release of Bugzilla 4.1.2, 4.0.1, 3.6.5, and 3.4.11
Today we are releasing 4.0.1, 3.6.5, 3.4.11, and the unstable development snapshot 4.1.2. Many users had difficulty installing Bugzilla 4.0, 3.6.4, and 3.4.10, due to a bug related to the "Math::Random::Secure" library. These releases fix that bug among other issues. Note that 4.1.2 is an unstable development release and should not be used in production environments. However, we are getting very close to feature freeze for 4.2, so now is the time to give us feedback on 4.1.2 if you want its behavior to change significantly before we release. Download -------...

Security advisory for Bugzilla 4.4rc2, 4.2.5, 4.0.10 and 3.6.13 #2
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * When viewing a bug report, a bug ID containing random code is not correctly sanitized in the HTML page if the specified page format is invalid. This can lead to XSS. * When running a query in debug mode, it is possible to determine if a given confidential field value (such as a product name) exists. Bugzilla 4.1 and newer are not affected by this issue....

Upgrading bugzilla 2.x to bugzilla-3.0.5
I am trying to upgrade my bugzilla 2.20.6 to bugzilla-3.0.5 the only online upgrade guide I've been able to find is http://polydevmono.blogspot.com/2008/03/upgrading-to-bugzilla-302-from-2x.html Please take a look to see if those instructions cover the upgrade exercise, or alternativly if you can recommend another walk-thru/ upgrade howto link. Many thx -Ravinder On Aug 19, 8:42 am, Ravinder Singh <ravinder.si...@isango.com> wrote: > I am trying to upgrade my bugzilla 2.20.6 to bugzilla-3.0.5 > the only online upgrade guide I've been able to find is ...

Security advisory for Bugzilla 4.3.2, 4.2.2, 4.0.7 and 3.6.10
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * In HTML bugmails, an improper validation of the permissions of the addressee can lead to confidential information about bugs and attachments to be visible to the addressee. * The description of a private attachment can be visible to a user who hasn't permissions to access this attachment if the attachment ID is mentioned in a comment in a bug. Al...

[ANN] Release of Bugzilla 4.3.2, 4.2.2, 4.0.7, and 3.6.10
Today we are releasing 4.2.2, 4.0.7, 3.6.10, and the unstable development snapshot 4.3.2. All of today's releases contain security fixes. We recommend all Bugzilla administrators to read the Security Advisory linked below. Bugzilla 4.2.2 is our latest stable release. It contains various useful bug fixes and security fixes for the 4.2 branch. Bugzilla 4.0.7 and 3.6.10 are security updates for the 4.0 branch and the 3.6 branch, respectively. 4.0.7 also contains several bug fixes. Note that 4.3.2 is an unstable development release and should not be used in producti...

migration from bugzilla 3.0.5 to 4.4.5 [data integrity problem]
Hello, =20 I would like to migrate bugzilla from version 3.0.5 to 4.4.5 Before the object import, I need to fix the sanity check which shows the = following errors. =20 Do you know how can I fix them? Is deletion of the record necessary = here. How to create delete statement for it? =20 =20 Bugzilla - Sanity Check =20 =20 OK, now running sanity checks. =20 Checking references to classifications.id =20 .... from products.classification_id =20 Checking references to keyworddefs.id =20 .... from keywords.keywordid =20 Checking refer...

Web resources about - Issue With Migrating Bugzilla 3.0.5 to Bugzilla 4.0.2 - mozilla.support.bugzilla

Thunderclap Migrating From Twitter to Facebook
Thunderclap, a mass-messaging service that gained popularity on Twitter, has set its sights on Facebook . Twitter recently booted Thunderclap ...

Facebook Migrating Unofficial Page Fans to Official Pages at Brand Owner’s Request
Rupesh Mandal is such an avid fan of the Opera Mini web browser that he set up a Page on Facebook totally devoted to celebrating it, and then ...

Teens Migrating From Facebook To Comments Section Of Slow-Motion Deer Video - YouTube
Subscribe to The Onion on YouTube: http://bit.ly/xzrBUA Trendwatchers say more and more teens are leaving Facebook and Twitter in favor of the ...

UAE is the global leader in attracting migrating professionals, study finds
... with 28 per cent, was the leading source of professionals, according to the LinkedIn study. The UAE is the global leader in attracting migrating ...

Record Numbers of New Zealanders Migrating to Australia
Acting on impulse: why the Kiwis keep coming ... and coming and coming

The krilling season: Whales keep tourists migrating south
Earlybird whale watchers in Eden have been rewarded with astounding acrobatic displays in the bay.

Migrating Swans were bound for glory, says great
Migrating Swans were bound for glory, says great

Researchers say Irukandji jellyfish migrating further south along Qld coast
Researchers say climate change could be altering the migration patterns of the dangerous Irukandji jellyfish along Qld's east coast.

Apple chip supplier TSMC announces record profits, migrating to more advanced technology
... Company , iPhone , and iPad continue reading at 9to5Mac . What do you think? Discuss "Apple chip supplier TSMC announces record profits, migrating ...

More eBay Merchants Migrating to Amazon in Search of Sales Growth
EBay's once-loyal merchants are moving more of their business to Amazon, saying they get more for their money by selling merchandise via the ...

Resources last updated: 12/23/2015 3:16:18 AM