Restoring Bugzilla 3.2 mysql backup on bugzilla 3.6.3 mysql

Hi Everyone -


*         Installed Bugzilla 3.6.3 on new machine

*         Took the MYSQL backup from old Bugzilla 3.2.

*         Restored the MYSQL back up on Bugzilla 3.6.3, now while login I a=
m getting:
Software error:
DBD::mysql::db do failed: Column 'ipaddr' cannot be null [for Statement "IN=
SERT INTO logincookies (cookie, userid, ipaddr, lastused)
              VALUES (?, ?, ?, NOW())"] at Bugzilla/Auth/Persist/Cookie.pm =
line 66
        Bugzilla::Auth::Persist::Cookie::persist_login('Bugzilla::Auth::Per=
sist::Cookie=3DHASH(0x2a709b4)', 'Bugzilla::User=3DHASH(0x2b2affc)') called=
 at Bugzilla/Auth.pm line 150
        Bugzilla::Auth::_handle_login_result('Bugzilla::Auth=3DHASH(0x157a1=
04)', 'HASH(0x2b3af0c)', 2) called at Bugzilla/Auth.pm line 95
        Bugzilla::Auth::login('Bugzilla::Auth=3DHASH(0x157a104)', 2) called=
 at Bugzilla.pm line 329
        Bugzilla::login('Bugzilla', 0) called at C:/bugzilla/index.cgi line=
 40

Steps followed in creating MYSQL database


*         Created MYSQL database

*         Ran Checksetup.pl (without any errors)

*         Restored the backup of Bugzilla 3.2.

Let me know what I am doing wrong......


Regards,
Bharat Chadha

________________________________

DISCLAIMER:
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail. Please notify the sender immediately=
 by e-mail if you have received this e-mail by mistake and delete this e-ma=
il from your system. E-mail transmission cannot be guaranteed to be secure =
or error-free as information could be intercepted, corrupted, lost, destroy=
ed, arrive late or incomplete, or contain viruses. The sender therefore doe=
s not accept liability for any errors or omissions in the contents of this =
message, which arise as a result of e-mail transmission. If verification is=
 required please request by email to support@svam.com with the following in=
formation Company X, Suite# 1, Street, City, Country, www.company.com.


SVAM International Inc. | 233 East Shore Road | Suite 201 | Great Neck, New=
 York 11023 | USA
0
Bharat
11/17/2010 2:33:13 AM
mozilla.support.bugzilla 10162 articles. 0 followers. Post Follow

6 Replies
1340 Views

Similar Articles

[PageSpeed] 27

On 11/16/2010 6:33 PM, Bharat Chadha wrote:

> Steps followed in creating MYSQL database
>
> *         Created MYSQL database
>
> *         Ran Checksetup.pl (without any errors)
>
> *         Restored the backup of Bugzilla 3.2.
>
> Let me know what I am doing wrong......

You did the last two steps backwards.  Run checksetup.pl to upgrade your 
database from 3.2 to 3.6.3.
0
Steve
11/17/2010 2:55:10 AM
Tried that as well..

checksetup.pl fails while creating table Bugzilla_fulltext


Regards,
Bharat Chadha
Infrastructure Architect
 SVAM International, Inc | 233 East Shore Road, Suite 201,Great Neck, NY 11=
023, USA
(D) 516-284-0560 Extn: 243 |Support: 516-466-6655 Extn:33| Mobile: 516-661-=
8940| www.svam.com

-----Original Message-----
From: support-bugzilla-bounces+bchadha=3Dsvam.com@lists.mozilla.org [mailto=
:support-bugzilla-bounces+bchadha=3Dsvam.com@lists.mozilla.org] On Behalf O=
f Steve Wendt
Sent: Tuesday, November 16, 2010 9:55 PM
To: support-bugzilla@lists.mozilla.org
Subject: Re: Restoring Bugzilla 3.2 mysql backup on bugzilla 3.6.3 mysql

On 11/16/2010 6:33 PM, Bharat Chadha wrote:

> Steps followed in creating MYSQL database
>
> *         Created MYSQL database
>
> *         Ran Checksetup.pl (without any errors)
>
> *         Restored the backup of Bugzilla 3.2.
>
> Let me know what I am doing wrong......

You did the last two steps backwards.  Run checksetup.pl to upgrade your da=
tabase from 3.2 to 3.6.3.
_______________________________________________
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 rep=
ly.

________________________________

DISCLAIMER:
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail. Please notify the sender immediately=
 by e-mail if you have received this e-mail by mistake and delete this e-ma=
il from your system. E-mail transmission cannot be guaranteed to be secure =
or error-free as information could be intercepted, corrupted, lost, destroy=
ed, arrive late or incomplete, or contain viruses. The sender therefore doe=
s not accept liability for any errors or omissions in the contents of this =
message, which arise as a result of e-mail transmission. If verification is=
 required please request by email to support@svam.com with the following in=
formation Company X, Suite# 1, Street, City, Country, www.company.com.


SVAM International Inc. | 233 East Shore Road | Suite 201 | Great Neck, New=
 York 11023 | USA
0
Bharat
11/17/2010 5:21:10 AM
On 17/11/10 05:21, Bharat Chadha wrote:
> Tried that as well..
>
> checksetup.pl fails while creating table Bugzilla_fulltext

That is not a sufficiently helpful explanation of what went wrong. Try 
again :-)

Gerv
0
Gervase
11/17/2010 8:22:54 AM
On 11/16/2010 9:21 PM, Bharat Chadha wrote:

> checksetup.pl fails while creating table Bugzilla_fulltext

1) Drop your database

2) Restore the backup of 3.2

3) Run checksetup.pl to upgrade it

0
Steve
11/17/2010 5:54:25 PM
Go this:


C:\bugzilla>perl checksetup.pl
* This is Bugzilla 3.6.3 on perl 5.12.2
* Running on Win2003 Build 3790 (Service Pack 2)

Checking perl modules...
Checking for              CGI.pm (v3.33)   ok: found v3.49
Checking for          Digest-SHA (any)     ok: found v5.48
Checking for            TimeDate (v2.21)   ok: found v2.24
Checking for            DateTime (v0.28)   ok: found v0.65
Checking for   DateTime-TimeZone (v0.79)   ok: found v1.23
Checking for                 DBI (v1.41)   ok: found v1.613
Checking for    Template-Toolkit (v2.22)   ok: found v2.22
Checking for          Email-Send (v2.16)   ok: found v2.198
Checking for          Email-MIME (v1.861)  ok: found v1.906
Checking for Email-MIME-Encodings (v1.313)  ok: found v1.313
Checking for Email-MIME-Modifier (v1.442)  ok: found v1.906
Checking for                 URI (any)     ok: found v1.55

Checking available perl DBD modules...
Checking for              DBD-Pg (v1.45)    not found
Checking for           DBD-mysql (v4.00)   ok: found v4.017
Checking for          DBD-Oracle (v1.19)   ok: found v1.24

The following Perl modules are optional:
Checking for                  GD (v1.20)   ok: found v2.45
Checking for               Chart (v2.1)    ok: found v2.4.2
Checking for         Template-GD (any)     ok: found v1.56
Checking for          GDTextUtil (any)     ok: found v0.86
Checking for             GDGraph (any)     ok: found v1.44
Checking for            XML-Twig (any)     ok: found v3.37
Checking for          MIME-tools (v5.406)  ok: found v5.428
Checking for         libwww-perl (any)     ok: found v5.835
Checking for         PatchReader (v0.9.4)  ok: found v0.9.5
Checking for           perl-ldap (any)     ok: found v0.4001
Checking for         Authen-SASL (any)     ok: found v2.15
Checking for          RadiusPerl (any)     ok: found v0.17
Checking for           SOAP-Lite (v0.710.06)  not found
Checking for            JSON-RPC (any)     ok: found v0.96
Use of uninitialized value in open at C:/Perl/site/lib/Test/Taint.pm line 3=
34, <
DATA> line 522.
Checking for          Test-Taint (any)     ok: found v1.04
Checking for         HTML-Parser (v3.40)   ok: found v3.68
Checking for       HTML-Scrubber (any)     ok: found v0.08
Checking for Email-MIME-Attachment-Stripper (any)     ok: found v1.316
Checking for         Email-Reply (any)     ok: found v1.202
Checking for         TheSchwartz (any)      not found
Checking for      Daemon-Generic (any)      not found
Checking for            mod_perl (v1.999022)  not found
***********************************************************************
* OPTIONAL MODULES                                                    *
***********************************************************************
* Certain Perl modules are not required by Bugzilla, but by           *
* installing the latest version you gain access to additional         *
* features.                                                           *
*                                                                     *
* The optional modules you do not have installed are listed below,    *
* with the name of the feature they enable. Below that table are the  *
* commands to install each module.                                    *
***********************************************************************
*    MODULE NAME * ENABLES FEATURE(S)                                 *
***********************************************************************
*      SOAP-Lite * XML-RPC Interface                                  *
*    TheSchwartz * Mail Queueing                                      *
* Daemon-Generic * Mail Queueing                                      *
*       mod_perl * mod_perl                                           *
***********************************************************************
* Note For Windows Users                                              *
***********************************************************************
* In order to install the modules listed below, you first have to run *
* the following command as an Administrator:                          *
*                                                                     *
*   ppm repo add theory58S http://cpan.uwinnipeg.ca/PPMPackages/10xx/
***********************************************************************
COMMANDS TO INSTALL OPTIONAL MODULES:

      SOAP-Lite: ppm install SOAP-Lite
    TheSchwartz: ppm install TheSchwartz
 Daemon-Generic: ppm install Daemon-Generic
       mod_perl: ppm install mod_perl

Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

    http://cyberelk.net/tim/patchutils/

Checking for           DBD-mysql (v4.00)   ok: found v4.017
Checking for           MySQL (v4.1.2)  ok: found v5.1.52-community

Adding new table bugs_fulltext ...
DBD::mysql::db do failed: Table 'bugs_fulltext' already exists [for Stateme=
nt "C
REATE TABLE bugs_fulltext (
        bug_id  mediumint NOT NULL PRIMARY KEY,
        short_desc      varchar(255) NOT NULL,
        comments        mediumtext,
        comments_noprivate      mediumtext
) ENGINE =3D MYISAM "] at Bugzilla/DB.pm line 680
        Bugzilla::DB::_bz_add_table_raw('Bugzilla::DB::Mysql=3DHASH(0x5455b=
ac)', '
bugs_fulltext') called at Bugzilla/DB.pm line 646
        Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=3DHASH(0x5455bac)',=
 'bugs_
fulltext') called at Bugzilla/DB.pm line 435
        Bugzilla::DB::bz_setup_database('Bugzilla::DB::Mysql=3DHASH(0x5455b=
ac)') c
alled at Bugzilla/DB/Mysql.pm line 577
        Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=3DHASH(=
0x5455b
ac)') called at checksetup.pl line 147


Regards,
Bharat Chadha

-----Original Message-----
From: support-bugzilla-bounces+bchadha=3Dsvam.com@lists.mozilla.org [mailto=
:support-bugzilla-bounces+bchadha=3Dsvam.com@lists.mozilla.org] On Behalf O=
f Steve Wendt
Sent: Wednesday, November 17, 2010 12:54 PM
To: support-bugzilla@lists.mozilla.org
Subject: Re: Restoring Bugzilla 3.2 mysql backup on bugzilla 3.6.3 mysql

On 11/16/2010 9:21 PM, Bharat Chadha wrote:

> checksetup.pl fails while creating table Bugzilla_fulltext

1) Drop your database

2) Restore the backup of 3.2

3) Run checksetup.pl to upgrade it

_______________________________________________
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 rep=
ly.

________________________________

DISCLAIMER:
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail. Please notify the sender immediately=
 by e-mail if you have received this e-mail by mistake and delete this e-ma=
il from your system. E-mail transmission cannot be guaranteed to be secure =
or error-free as information could be intercepted, corrupted, lost, destroy=
ed, arrive late or incomplete, or contain viruses. The sender therefore doe=
s not accept liability for any errors or omissions in the contents of this =
message, which arise as a result of e-mail transmission. If verification is=
 required please request by email to support@svam.com with the following in=
formation Company X, Suite# 1, Street, City, Country, www.company.com.


SVAM International Inc. | 233 East Shore Road | Suite 201 | Great Neck, New=
 York 11023 | USA
0
Bharat
11/17/2010 7:22:41 PM
On 11/17/2010 11:22 AM, Bharat Chadha wrote:
> DBD::mysql::db do failed: Table 'bugs_fulltext' already exists

	That means that either now or at some time in the past you did not
properly follow the upgrade, backup, or restore instructions. Hopefully
your database backup is not corrupt.

	You probably want to read this:

	https://wiki.mozilla.org/Bugzilla:Move_Installation

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
0
Max
11/21/2010 4:05:43 AM
Reply:

Similar Artilces:

[ANN] Release of Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
Today we have four new releases. One new development snapshot (3.7.3), one new stable release (3.6.2) and two security updates for the old stable releases (3.4.8 and 3.2.8). Bugzilla 3.6.2 is our latest stable release. It contains various useful bug fixes and security improvements for the 3.6 branch. Bugzilla 3.4.8 and 3.2.8 are security updates for the 3.4 branch and the 3.2 branch, respectively. Bugzilla 3.7.3 is our third unstable development release leading to Bugzilla 4.0. We have done a fair amount of QA on this release. However, QA found many bugs that have not ye...

[ANN] Security Advisory for Bugzilla 3.2.6, 3.4.6, 3.6, and 3.7
-----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: * Everybody could search for time-tracking information, not just members of the timetrackinggroup. * Under suexec, "localconfig" was world-readable, meaning that local users with shell access to the Bugzilla server may have been able to see the database password and the site_wide_secret. All affected installations are encouraged to upgrade as so...

[ANN] Security Advisory for Bugzilla 3.2.8, 3.4.8, 3.6.2, and 3.7.3
-----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: * There is a way to inject both headers and content to users, causing a serious Cross-Site Scripting vulnerability. * It was possible to see graphs from Old Charts even if you did not have access to a particular product, and you could browse a particular URL to see all product names. * YUI 2.8.1, which shipped with Bugzilla starting with 3.7.x, contain...

Upgrade Bugzilla 2.22.3 to Bugzilla 3.4.6 under Windows-XP. #2
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01CB059F.E89B4560 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hello, =20 * I=92m using the Bugzilla-2.22.3 under Windows-XP and would like upgrading to new release of Bugzilla-3.4.6 (also under Windows-XP).=20 =20 * I have followed the instructions of the following (correspondingly to Windows-XP): http://www.bugzilla.org/docs/3.4/en/html/upgrade.html.=20 =20 * I have installed the full required Perl-modules regarding the output of checks...

[ANN] Release of Bugzilla 3.2.2, 3.0.8, and 3.3.3
Bugzilla 3.2.1, 3.0.7, and 3.3.2 contained a bug that was critical for any installation running under mod_perl, due to an unintentional interaction between the various security fixes in those releases. We are releasing three new releases today to fix the critical issue: 3.2.2, 3.0.8, and 3.3.3. They are identical to the previous release except that they have this one fix for installations running under mod_perl. Download -------- Bugzilla is available at: http://www.bugzilla.org/download/ Security Advisory ----------------- Details of the fix are in the Security Adviso...

[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...

[ANN] Security Advisory for Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.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: * It was possible to (at least partially) determine the membership of any group using the Search interface. * It was possible to use the 'sudo' feature without sending a notification to the user being impersonated. * The 'Reports' and 'Duplicates' pages let you guess the name of products you could not see, due to the error message ...

Upgrade Bugzilla 2.22.3 to Bugzilla 3.4.6 under Windows-XP.
Hi All, * We are using the Bugzilla 2.22.3 under Windows-XP and would like upgrading to new release of Bugzilla 3.4.6 (also under Windows-XP). * I have followed the instructions of the following (correspondingly to Windows-XP): http://www.bugzilla.org/docs/3.4/en/html/upgrade.html * Unfortunately this upgrade process is not working, maybe because of this upgrade process will work only if the Bugzilla server installed on Linux or Solaris? * I got the following error when tried to access to the Bugzilla server (after the upgrade process): Software error...

error after upgrading Bugzilla from 3.2.2 to 3.2.3
Hi, I have two Windows Server 2003 machines running Bugzilla 3.2.2 + Testopia 2.2, one is production and the other is for test, both have same configuration. I tried to upgrade it with patch file bugzilla-3.2.2-to-3.2.3.diff.gz, and my steps are: 1) Shut down your Bugzilla installation by putting some HTML or text in the shutdownhtml parameter 2) untar the .diff file and use unix2dos.exe to replace Unix line feed characters with Windows carriage returns 3) run the command: path -p1 < bugzilla-3.2.2-to-3.2.3.diff 4) run the command: perl checksetup.pl 5) remove the text of shut...

Security Advisory for Bugzilla 3.0.3, 3.1.3, 2.22.3, and 2.20.5
--Sig_/7+QS=YT68me2o8pI2lL1LPd Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Summary =3D=3D=3D=3D=3D=3D=3D Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. This advisory covers three security issues that have recently been fixed in the Bugzilla code: * Users without the "canconfirm" privilege could enter a bug as NEW or ASSIGNED by using the XML-RPC interface. * When viewing several bugs at once, there was a Cross-Site Scripting hole. * The inbound email interface allowed you t...

[ANN] Release of Bugzilla 3.2.9, 3.4.9, 3.6.3, and 4.0rc1
Today we are announcing the first Release Candidate for Bugzilla 4.0, in addition to one new stable release and two security-only updates for the 3.2.x and 3.4.x series. Bugzilla 4.0rc1 is our first Release Candidate for Bugzilla 4.0. This release has received QA testing, and should be considerably more stable than the development releases before it. It is still not considered fully stable, and so you should understand that if you use it, you use it at your own risk. In particular, certain aspects of the WebServices have not yet been tested as part of this Release Candidate, so ...

Security Advisory for Bugzilla 3.2.3 and 3.3.4
Summary ======= Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. This advisory covers one security issue that has recently been fixed in the Bugzilla code: * Bug reporters could confirm their bugs and change their bugs' statuses, even if they didn't have the appropriate permissions. All affected installations are encouraged to upgrade as soon as possible. Vulnerability Details ===================== Class: Unauthorized Bug Change Versions: 3.1.1 through 3.2.3, 3.3.1 through 3.3.4 Fixed In: 3.2.4, 3.4rc1 D...

[ANN] Release of Bugzilla 3.2.3 and 3.3.4
Today we have two new versions of Bugzilla for you. Bugzilla 3.2.3 is our latest stable release. It contains various useful bug fixes and security improvements. Bugzilla 3.3.4 is an unstable development release. This release has not received QA testing from the Bugzilla Project, and should not be used in production environments. If you find a bug in this development release (or you don't like how some feature works) please tell us by filing a bug. Both of today's releases contain a security fix. Please see our latest Security Advisory for details. Note that old...

Bugzilla Upgrade
Hi Support Team, =20 I plan to upgrade from Bugzilla 3.0.3 to 3.2.2 . Our bugzilla setup has a lot of "Custom fileds" .=20 I went thro' the upgrade notes but that does not explicitly=20 mention about the steps that I need to follow with "Custom Fields".=20 Do I need to copy some files from template/en/custom to the new location ? Please let me know the steps that I need to follow for the upgrade with custom fields.=20 =20 Thanks for your help! -J ...

Web resources about - Restoring Bugzilla 3.2 mysql backup on bugzilla 3.6.3 mysql - mozilla.support.bugzilla

Restoring Family Links - Wikipedia, the free encyclopedia
The activities are carried out by the components of the RFL is sometimes also referred to as tracing. The ICRC and National Red Cross and Red ...

Michele Bachmann - Restoring Honor rally - Flickr - Photo Sharing!
Rep. Michele Bachmann (R-MN) holds her own Tea Party rally after Glenn Beck's "Restoring Honor" rally on the National Mall in Washington, D.C. ...

Restoring the State Capitol Rotunda - YouTube
The most-visited public area of the State Capitol, the Rotunda, is completely closed for renovation work. Learn what's happening behind the temporary ...

In MSNBC Promo, Matthews Supplies Secret To Restoring Washington's Good Name: More Big-Government Programs ...
... nation's capital is in such ill-repute that if George Washington were around, he might sue to have his name taken off it. But never fear: restoring ...

Restoring the glory of ancient Babylon
New project aims to save key cultural heritage sites in Babylon, one of the most famed cities of antiquity and now an important archaeological ...

Big Idea: Restoring Aboriginal place names
Victoria has Mt Buggery. NSW has a Nobby's Head and a Chinaman's Knob. Tasmania has Dismal Swamp, South Australia has Foul Bay and Useless Loop ...

Attorney-General Brad Hazzard says restoring QCs 'is not my highest priority'
Attorney-General Brad Hazzard has weighed into an increasingly bitter debate about the reintroduction of the title of Queen's Counsel for senior ...

Restoring a 140-year-old Bowral home to its former glory involves much labour and love
The Cedar House has experienced many transformations in its 140-year history.

Herd approach restoring arid land
Allan Savory once killed 40,000 African elephants. Your local supermarket designs lighting specifically to deceive you that its food is more ...

US airlines begin restoring flights as weather warms
(Updates cancellation total in second paragraph.)

Resources last updated: 12/19/2015 4:37:12 PM