Re: DBD::mysql::db selectrow_hashref failed: Unknown column 'profiles.is_enabled' in 'field list'

[PG]

I'm getting this same error when I try to login to Bugzilla. I am trying to
migrate from one server to another and at the same time from version 3.2.2
to 4.2.3. I installed 4.2.3 on a new computer and was able to get bugzilla
running fine with a new bugs database. So I dropped the bugs database and
followed the instructions in
http://www.bugzilla.org/docs/4.2/en/html/upgrade.html and
https://wiki.mozilla.org/Bugzilla:Move_Installation. Copied bugzilla/data
and localconfig. Exported and imported SQL data. Ran checksetup.pl. Now
can't login!



--
View this message in context: http://mozilla.6506.n7.nabble.com/DBD-mysql-db-selectrow-hashref-failed-Unknown-column-profiles-is-enabled-in-field-list-tp68241p266538.html
Sent from the Bugzilla - Users mailing list archive at Nabble.com.

[Thorsten Schöning]

Guten Tag PG,
am Montag, 17. Dezember 2012 um 17:18 schrieben Sie:

> http://www.bugzilla.org/docs/4.2/en/html/upgrade.html and
> https://wiki.mozilla.org/Bugzilla:Move_Installation. Copied bugzilla/data
> and localconfig. Exported and imported SQL data. Ran checksetup.pl. Now
> can't login!

Check if the column mentioned in the error message exists and re-run
checksetup.pl. Check it's output, there surely is a an error message
or the column form the error message exists, so have a look again. If
it exists you surely configured something wrong, like localconfig is
still using the wrong database or stuff like that.

Importing the database and running checksetup.pl normally is enough to
upgrade the schema. Everything else depends on errors printed by
checksetup.pl or configuration.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail:Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[itsu...@virgoinnovation.com]

[Thorsten Schöning]

Guten Tag itsu...@virgoinnovation.com,
am Mittwoch, 23. Januar 2019 um 10:26 schrieben Sie:

> On Monday, December 17, 2012 at 9:48:46 PM UTC+5:30, PG wrote:
>> I'm getting this same error when I try to login to Bugzilla. I am trying to

[...]

Your question is pretty much unreadable, it's not clear if you are
asking something or answering to someone. Additionally it's not clear
how your problem is related to the original topic ofg this thread.

Please read the following carefully if you want someone to care about
your questions:

http://www.catb.org/esr/faqs/smart-questions.html

>> [...]Now can't login!

That is not a very helpful error description. Regarding what you have
done, you most likely didn't ran checksetup.pl after importing the old
database again or have simply mixed up configurations and databases.
Of course it might as well be that you are using the wrong credentials
for some reason.

In any case, run checksetupl.pl and look at its output. Check that you
really configured the correct database in the correct version and that
it e.g. contains your username you are using to login. Consider using
"--make-admin" or "--reset-passwd":

https://www.bugzilla.org/docs/4.4/en/html/api/checksetup.html

If that didn't fix your problem, describe it mor edetailed, e.g. the
error messages you get etc. Remember that you have answered to a
thread regarding database problems instead of just not being able to
login, with otherwise working Bugzilla. That unnecessary confuses
people.

[gangaram...@gmail.com]

Fixing file permissions...
DBD::mysql::db selectrow_arrayref failed: MySQL server has gone away [for Statement "SELECT COUNT(id) FROM fielddefs WHERE sortkey >= 100"] at Bugzilla/Install/DB.pm line 74.
Bugzilla::Install::DB::update_fielddefs_definition() called at ./checksetup.pl line 164

[Thorsten Schöning]

Guten Tag gangaram...@gmail.com,
am Mittwoch, 23. Januar 2019 um 13:01 schrieben Sie:

Sorry, but no:

http://www.catb.org/esr/faqs/smart-questions.html

[itsu...@virgoinnovation.com]

On Monday, December 17, 2012 at 9:48:46 PM UTC+5:30, PG wrote:

[Thorsten Schöning]

Guten Tag itsu...@virgoinnovation.com,
am Freitag, 25. Januar 2019 um 07:54 schrieben Sie:

> On Monday, December 17, 2012 at 9:48:46 PM UTC+5:30, PG wrote:

>> I'm getting this same error when I try to login to Bugzilla.[...]

Seriously?

http://www.catb.org/esr/faqs/smart-questions.html
https://groups.google.com/d/msg/mozilla.support.bugzilla/WVwW8kmf8Gc/ZX0tVXxOFgAJ