get SQL when logging in after 2.18.1 upgrade

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

get SQL when logging in after 2.18.1 upgrade

Andrew Schultz
I upgraded last week from Bugzilla 2.18 to 2.18.  This seemed to be OK,
but I can no longer log in.  I get:

Software error:

DBD::mysql::st execute failed: Unknown column 'obsolete' in 'where
clause' [for Statement "SELECT name, description FROM fielddefs WHERE
obsolete = 0 AND name NOT IN ('estimated_time', 'remaining_time',
'work_time', 'percentage_complete') ORDER BY sortkey"] at Bugzilla/DB.pm
line 62
        Bugzilla::DB::SendSQL('SELECT name, description FROM fielddefs WHERE
obsolete = 0 AN...') called at globals.pl line 667
        main::GetFieldDefs() called at /var/www/bugzilla/query.cgi line 338


I poked around and discovered that line is new in 2.18.1, from bug
279910, along a corresponding change to checksetup.pl.  I ran
checksetup.pl after upgrading and just tried running it again, but it
didn't print anything either time (I noticed that it should print
something if the relevant code gets executed).

What am I missing?

--
Andrew Schultz
[hidden email]
http://www.sens.buffalo.edu/~ajs42/
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: get SQL when logging in after 2.18.1 upgrade

Max Kanat-Alexander
On Wed, 2005-05-18 at 11:32 -0400, Andrew Schultz wrote:
> DBD::mysql::st execute failed: Unknown column 'obsolete' in 'where
> clause' [for Statement "SELECT name, description FROM fielddefs WHERE
> obsolete = 0 AND name NOT IN ('estimated_time', 'remaining_time',
> 'work_time', 'percentage_complete') ORDER BY sortkey"] at Bugzilla/DB.pm
> line 62
> Bugzilla::DB::SendSQL('SELECT name, description FROM fielddefs WHERE
> obsolete = 0 AN...') called at globals.pl line 667
> main::GetFieldDefs() called at /var/www/bugzilla/query.cgi line 338
>

        Interesting... have you made any local modifications to your database?

        What's the output of the following SQL:

        DESCRIBE fielddefs

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: get SQL when logging in after 2.18.1 upgrade

Andrew Schultz
In reply to this post by Andrew Schultz
Max Kanat-Alexander wrote:
> Interesting... have you made any local modifications to your database?

none.

> What's the output of the following SQL:
>
> DESCRIBE fielddefs

mysql> DESCRIBE fielddefs;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| fieldid     | mediumint(9) |      | PRI | NULL    | auto_increment |
| name        | varchar(64)  |      | UNI |         |                |
| description | mediumtext   |      |     |         |                |
| mailhead    | tinyint(4)   |      |     | 0       |                |
| sortkey     | smallint(6)  |      | MUL | 0       |                |
+-------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)


--
Andrew Schultz
[hidden email]
http://www.sens.buffalo.edu/~ajs42/
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: get SQL when logging in after 2.18.1 upgrade

Max Kanat-Alexander
On Thu, 2005-05-19 at 09:19 -0400, Andrew Schultz wrote:
> > What's the output of the following SQL:
> >
> > DESCRIBE fielddefs

        That's certainly strange... checksetup should have added the field to
fielddefs, yet it most definitely didn't. That looks like a 2.18
fielddefs table.

        What's the output of "cvs status checksetup.pl" in the bugzilla
directory? And what's the output of "cat CVS/Tag" in the bugzilla
directory?

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: get SQL when logging in after 2.18.1 upgrade

Andrew Schultz-2
In reply to this post by Andrew Schultz
Max Kanat-Alexander wrote:

> On Thu, 2005-05-19 at 09:19 -0400, Andrew Schultz wrote:
>
>>> What's the output of the following SQL:
>>>
>>> DESCRIBE fielddefs
>
>
> That's certainly strange... checksetup should have added the field to
> fielddefs, yet it most definitely didn't. That looks like a 2.18
> fielddefs table.
>
> What's the output of "cvs status checksetup.pl" in the bugzilla
> directory? And what's the output of "cat CVS/Tag" in the bugzilla
> directory?

checksetup.pl was ok.  But SELinux was protected me from its evil
effects by suppressing all output and killing it (SELinux thought it was
a cgi script).  I discovered this after looking through checksetup.pl
and noticing that it should be printing *something* no matter what.

thanks anyway!  :)

--
Andrew Schultz
[hidden email]
http://www.sens.buffalo.edu/~ajs42/
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools