Problem adding a product - Mozilla

This is a discussion on Problem adding a product - Mozilla ; When I add a product, the following happens (it is not a very big problem, since the product is created): Adding new product Software error: DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default value [for Statement "INSERT INTO groups ...

+ Reply to Thread
Results 1 to 6 of 6

Thread: Problem adding a product

  1. Problem adding a product

    When I add a product, the following happens (it is not a very big problem,
    since the product is created):


    Adding new product
    Software error:
    DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    value [for Statement "INSERT INTO groups (name, description, isbuggroup,
    last_changed) VALUES ('test', 'Access to bugs in the test product', 1,
    NOW())"] at Bugzilla/DB.pm line 84
    Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    For help, please send mail to this site's webmaster, giving this error
    message and the time and date of the error.

    [Thu Mar 2 15:15:57 2006] editproducts.cgi: DBD::mysql::st execute failed:
    Field 'userregexp' doesn't have a default value [for Statement "INSERT INTO
    groups (name, description, isbuggroup, last_changed) VALUES ('test', 'Access
    to bugs in the test product', 1, NOW())"] at Bugzilla/DB.pm line 84 [Thu Mar
    2 15:15:57 2006] editproducts.cgi: Bugzilla:B::SendSQL('INSERT INTO groups
    (name, description, isbuggroup, last_chang...') called at
    C:\bugzilla\editproducts.cgi line 559



    Do you have any ideas?
    Thank you,
    Matthias



  2. Re: Problem adding a product

    i get that, i think, when i dont put a milestone date in, or an incorrect
    formatted date, i dont use the field, so i always get the error, and your
    right, seems to work fine, even with the error, you might try making a
    product with a dated milestone, if that still throws error, then it is
    trying to parse one of the other fields and it's prob. empty or incorrect
    formatted data

    jay
    http://ichibancomputers.com


    "Matthias Buchebner" wrote in message
    news:bpqdnVXRd-8PYpvZ4p2dnA@mozilla.org...
    > When I add a product, the following happens (it is not a very big problem,
    > since the product is created):
    >
    >
    > Adding new product
    > Software error:
    > DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    > value [for Statement "INSERT INTO groups (name, description, isbuggroup,
    > last_changed) VALUES ('test', 'Access to bugs in the test product', 1,
    > NOW())"] at Bugzilla/DB.pm line 84
    > Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    > last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    > For help, please send mail to this site's webmaster, giving this error
    > message and the time and date of the error.
    >
    > [Thu Mar 2 15:15:57 2006] editproducts.cgi: DBD::mysql::st execute failed:
    > Field 'userregexp' doesn't have a default value [for Statement "INSERT

    INTO
    > groups (name, description, isbuggroup, last_changed) VALUES ('test',

    'Access
    > to bugs in the test product', 1, NOW())"] at Bugzilla/DB.pm line 84 [Thu

    Mar
    > 2 15:15:57 2006] editproducts.cgi: Bugzilla:B::SendSQL('INSERT INTO

    groups
    > (name, description, isbuggroup, last_chang...') called at
    > C:\bugzilla\editproducts.cgi line 559
    >
    >
    >
    > Do you have any ideas?
    > Thank you,
    > Matthias
    >
    >




  3. Re: Problem adding a product

    Hi,
    I fixed it. I just deselected "makeproductgroups" in editparams.cgi.
    However, it is still a bug. It is in the mysql database structure, the table
    does not provide a default value for the variable "userregexp".
    Matthias
    "Matthias Buchebner" wrote in message
    news:bpqdnVXRd-8PYpvZ4p2dnA@mozilla.org...
    > When I add a product, the following happens (it is not a very big problem,
    > since the product is created):
    >
    >
    > Adding new product
    > Software error:
    > DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    > value [for Statement "INSERT INTO groups (name, description, isbuggroup,
    > last_changed) VALUES ('test', 'Access to bugs in the test product', 1,
    > NOW())"] at Bugzilla/DB.pm line 84
    > Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    > last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    > For help, please send mail to this site's webmaster, giving this error
    > message and the time and date of the error.
    >
    > [Thu Mar 2 15:15:57 2006] editproducts.cgi: DBD::mysql::st execute failed:
    > Field 'userregexp' doesn't have a default value [for Statement "INSERT
    > INTO groups (name, description, isbuggroup, last_changed) VALUES ('test',
    > 'Access to bugs in the test product', 1, NOW())"] at Bugzilla/DB.pm line
    > 84 [Thu Mar 2 15:15:57 2006] editproducts.cgi:
    > Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    > last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    >
    >
    >
    > Do you have any ideas?
    > Thank you,
    > Matthias
    >
    >




  4. Re: Problem adding a product

    Finally I found and fixed the bug:
    this is the solution, you have to put this lines into editproduct.cgi at
    line 559:
    SendSQL("INSERT INTO groups " .

    "(name, description, isbuggroup, last_changed, userregexp) " .

    "VALUES (" .

    SqlQuote($productgroup) . ", " .

    SqlQuote("Access to bugs in the $product product") . ", 1, NOW()," .

    SqlQuote(" ") . ")");



    cheers,

    Matthias



    "Matthias Buchebner" wrote in message
    news:bpqdnVXRd-8PYpvZ4p2dnA@mozilla.org...
    > When I add a product, the following happens (it is not a very big problem,
    > since the product is created):
    >
    >
    > Adding new product
    > Software error:
    > DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    > value [for Statement "INSERT INTO groups (name, description, isbuggroup,
    > last_changed) VALUES ('test', 'Access to bugs in the test product', 1,
    > NOW())"] at Bugzilla/DB.pm line 84
    > Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    > last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    > For help, please send mail to this site's webmaster, giving this error
    > message and the time and date of the error.
    >
    > [Thu Mar 2 15:15:57 2006] editproducts.cgi: DBD::mysql::st execute failed:
    > Field 'userregexp' doesn't have a default value [for Statement "INSERT
    > INTO groups (name, description, isbuggroup, last_changed) VALUES ('test',
    > 'Access to bugs in the test product', 1, NOW())"] at Bugzilla/DB.pm line
    > 84 [Thu Mar 2 15:15:57 2006] editproducts.cgi:
    > Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    > last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    >
    >
    >
    > Do you have any ideas?
    > Thank you,
    > Matthias
    >
    >




  5. Re: Problem adding a product

    see https://bugzilla.mozilla.org/show_bug.cgi?id=305927


    "Matthias Buchebner" wrote in message
    news:urmdneVXx5ZripXZ4p2dnA@mozilla.org...
    > Finally I found and fixed the bug:
    > this is the solution, you have to put this lines into editproduct.cgi at
    > line 559:
    > SendSQL("INSERT INTO groups " .
    >
    > "(name, description, isbuggroup, last_changed, userregexp) " .
    >
    > "VALUES (" .
    >
    > SqlQuote($productgroup) . ", " .
    >
    > SqlQuote("Access to bugs in the $product product") . ", 1, NOW()," .
    >
    > SqlQuote(" ") . ")");
    >
    >
    >
    > cheers,
    >
    > Matthias
    >
    >
    >
    > "Matthias Buchebner" wrote in message
    > news:bpqdnVXRd-8PYpvZ4p2dnA@mozilla.org...
    >> When I add a product, the following happens (it is not a very big
    >> problem, since the product is created):
    >>
    >>
    >> Adding new product
    >> Software error:
    >> DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    >> value [for Statement "INSERT INTO groups (name, description, isbuggroup,
    >> last_changed) VALUES ('test', 'Access to bugs in the test product', 1,
    >> NOW())"] at Bugzilla/DB.pm line 84
    >> Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    >> last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    >> For help, please send mail to this site's webmaster, giving this error
    >> message and the time and date of the error.
    >>
    >> [Thu Mar 2 15:15:57 2006] editproducts.cgi: DBD::mysql::st execute
    >> failed: Field 'userregexp' doesn't have a default value [for Statement
    >> "INSERT INTO groups (name, description, isbuggroup, last_changed) VALUES
    >> ('test', 'Access to bugs in the test product', 1, NOW())"] at
    >> Bugzilla/DB.pm line 84 [Thu Mar 2 15:15:57 2006] editproducts.cgi:
    >> Bugzilla:B::SendSQL('INSERT INTO groups (name, description, isbuggroup,
    >> last_chang...') called at C:\bugzilla\editproducts.cgi line 559
    >>
    >>
    >>
    >> Do you have any ideas?
    >> Thank you,
    >> Matthias
    >>
    >>

    >
    >




  6. Re: Problem adding a product

    On Thu, 2006-03-02 at 15:22 +0100, Matthias Buchebner wrote:
    > When I add a product, the following happens (it is not a very big problem,
    > since the product is created):
    >
    > DBD::mysql::st execute failed: Field 'userregexp' doesn't have a default
    > value [snip]


    Are you using MySQL 5? What version of Bugzilla are you using? If
    you're using MySQL 5, I highly recommend using at least 2.20.1.

    -Max
    --
    http://www.everythingsolved.com/
    Competent, Friendly Bugzilla Services. And Everything Else, too.


+ Reply to Thread