HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install. - Mozilla

This is a discussion on HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install. - Mozilla ; We have had a bugzilla installation running fine for over two years, and have added a new bugzilla installation. Adding and configuring the new one was no problem. Until I changed the cookiepath property on the new installation. At that ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install.

  1. HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install.

    We have had a bugzilla installation running fine for over two years,
    and have added a new bugzilla installation.
    Adding and configuring the new one was no problem. Until I changed
    the cookiepath property on the new installation. At that point
    everything went to hell and a handbasket.... (I successfully fixed
    it temporarily by deleting the C:\Windows\Temp\#sql_c50_0.MYD, but now
    it is back) Any ideas would be appreciated.

    NOTE: I changed the cookie path back to /, but that didn't help and
    any user accessing this now recieves the following errror message...

    Template->process() failed twice.
    First error: undef error - DBD::mysql::db selectall_arrayref failed:
    Can't create/write to file 'C:\WINDOWS\TEMP\#sql_c50_0.MYD' (Errcode:
    17) [for Statement " SELECT DISTINCT groups.id, groups.name,
    groups.description FROM groups, user_group_map, group_group_map AS ggm
    WHERE user_group_map.user_id = ? AND ((user_group_map.isbless = 1 AND
    groups.id=user_group_map.group_id) OR (groups.id = ggm.grantor_id AND
    ggm.grant_type = ? AND user_group_map.group_id = ggm.member_id AND
    user_group_map.isbless = 0)) ORDER BY name"] at Bugzilla/User.pm line
    343 Bugzilla::User::bless_groups('Bugzilla::User=HASH( 0x1867d50)')
    called at Bugzilla/User.pm line 596
    Bugzilla::User::can_bless('Bugzilla::User=HASH(0x1 867d50)') called at
    data\template\template\en\custom\global\useful-links.html.tmpl line
    103 eval {...} called at data\template\template\en\custom\global
    \useful-links.html.tmpl line 103 eval {...} called at data\template
    \template\en\custom\global\useful-links.html.tmpl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x218e154)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'global/useful-links.html.tmpl') called at data\template\template\en
    \custom\global\footer.html.tmpl line 27 eval {...} called at data
    \template\template\en\custom\global\footer.html.tm pl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x216b280)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'global/footer.html.tmpl') called at data\template\template\en\custom
    \index.html.tmpl line 90 eval {...} called at data\template\template\en
    \custom\index.html.tmpl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x20f0b2c)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'Template:ocument=HASH(0x20f0b2c)') called at C:/Perl/site/lib/
    Template/Service.pm line 97 eval {...} called at C:/Perl/site/lib/
    Template/Service.pm line 94
    Template::Service:rocess('Template::Service=HASH(0x1f7f0c0)',
    'index.html.tmpl', 'HASH(0x1efab2c)') called at C:/Perl/site/lib/
    Template.pm line 76
    Template:rocess('Bugzilla::Template=HASH(0x1f2f14c)',
    'index.html.tmpl', 'HASH(0x1efab2c)') called at D:/www/FMA/index.cgi
    line 61
    Second error: undef error - DBD::mysql::db selectall_arrayref failed:
    Can't create/write to file 'C:\WINDOWS\TEMP\#sql_c50_0.MYD' (Errcode:
    17) [for Statement " SELECT DISTINCT groups.id, groups.name,
    groups.description FROM groups, user_group_map, group_group_map AS ggm
    WHERE user_group_map.user_id = ? AND ((user_group_map.isbless = 1 AND
    groups.id=user_group_map.group_id) OR (groups.id = ggm.grantor_id AND
    ggm.grant_type = ? AND user_group_map.group_id = ggm.member_id AND
    user_group_map.isbless = 0)) ORDER BY name"] at Bugzilla/User.pm line
    343 Bugzilla::User::bless_groups('Bugzilla::User=HASH( 0x1867d50)')
    called at Bugzilla/User.pm line 596
    Bugzilla::User::can_bless('Bugzilla::User=HASH(0x1 867d50)') called at
    data\template\template\en\custom\global\useful-links.html.tmpl line
    103 eval {...} called at data\template\template\en\custom\global
    \useful-links.html.tmpl line 103 eval {...} called at data\template
    \template\en\custom\global\useful-links.html.tmpl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x218e154)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'global/useful-links.html.tmpl') called at data\template\template\en
    \custom\global\footer.html.tmpl line 27 eval {...} called at data
    \template\template\en\custom\global\footer.html.tm pl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x216b280)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'global/footer.html.tmpl') called at data\template\template\en\custom
    \global\code-error.html.tmpl line 1232 eval {...} called at data
    \template\template\en\custom\global\code-error.html.tmpl line 16
    Template::Provider::__ANON__('Template::Context=HA SH(0x1faebb4)')
    called at C:/Perl/site/lib/Template/Document.pm line 140 eval {...}
    called at C:/Perl/site/lib/Template/Document.pm line 138
    Template:ocument:rocess('Template:ocument=HASH(0x21ef2c8)',
    'Template::Context=HASH(0x1faebb4)') called at C:/Perl/site/lib/
    Template/Context.pm line 350 eval {...} called at C:/Perl/site/lib/
    Template/Context.pm line 320
    Template::Context:rocess('Template::Context=HASH(0x1faebb4)',
    'Template:ocument=HASH(0x21ef2c8)') called at C:/Perl/site/lib/
    Template/Service.pm line 97 eval {...} called at C:/Perl/site/lib/
    Template/Service.pm line 94
    Template::Service:rocess('Template::Service=HASH(0x1f7f0c0)',
    'global/code-error.html.tmpl', 'HASH(0x1867f18)') called at C:/Perl/
    site/lib/Template.pm line 76
    Template:rocess('Bugzilla::Template=HASH(0x1f2f14c)', 'global/code-
    error.html.tmpl', 'HASH(0x1867f18)') called at Bugzilla/Error.pm line
    116
    Bugzilla::Error::ThrowTemplateError('Template::Exc eption=ARRAY(0x215f9f8)')
    called at D:/www/FMA/index.cgi line 61


    I


  2. Re: HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install.

    Paul,

    2008/4/21, PaulWoll :
    > Can't create/write to file 'C:\WINDOWS\TEMP\#sql_c50_0.MYD' (Errcode:
    > 17) [for Statement " SELECT DISTINCT groups.id, groups.name,


    this is most certainly not related to a modification of one of
    Bugzilla's parameter. Check why MySQL cannot write to the mentioned
    file. Maybe http://bugs.mysql.com/bug.php?id=9551 is of help.

    Regards
    Marc

  3. Re: HELP! Changing cookiepath on a new bugzilla install caused thefollowing error on our other bugzilla install.

    On Apr 21, 9:10*am, "Marc Schumann" wrote:
    > Paul,
    >
    > 2008/4/21, PaulWoll :
    >
    > > *Can't create/write to file 'C:\WINDOWS\TEMP\#sql_c50_0.MYD' (Errcode:
    > > *17) [for Statement " SELECT DISTINCT groups.id, groups.name,

    >
    > this is most certainly not related to a modification of one of
    > Bugzilla's parameter. Check why MySQL cannot write to the mentioned
    > file. Maybehttp://bugs.mysql.com/bug.php?id=9551is of help.
    >
    > * *Regards
    > * * * Marc


    Actually it definitely was related to changing the cookiepath property
    on a single instance while some other user might have been logged in
    or logging in.
    (At the time I did not have access to the other bugzilla instance to
    change its cookiepath property). The error occurred immediately after
    I made the change.

    I have since changed both installations cookie paths properties to be
    unique and then deleted the temp file. This seemed to resolve the
    problem. I will post back if this problem persists.

    -Paul


+ Reply to Thread