Re: Error in Checksetup with Syntax

Got past this too now I receive the following error:

DBD::mysql::db selectrow_hashref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups WHERE name = 'editbugs'' at line 1 [for Statement "SELECT groups.id,groups.name,groups.description,groups.isbuggroup,groups.userregexp,groups.isactive,groups.icon_url FROM group
s WHERE name = ?"] at Bugzilla/Object.pm line 161.

        Bugzilla::Object::_load_from_db("Bugzilla::Group", HASH(0xbfba400)) called at Bugzilla/Object.pm line 82
        Bugzilla::Object::new("Bugzilla::Group", HASH(0xbfba400)) called at Bugzilla/Install.pm line 216
        Bugzilla::Install::update_system_groups() called at C:\bugzilla\checksetup.pl line 182

the line in the file is:

= $dbh->selectrow_hashref("SELECT $columns FROM $table WHERE $condition",

I got by this by adding bugs. before $table

THEN I received the following:

DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to you
r MySQL server version for the right syntax to use near 'groups ORDER BY isbuggroup, name' at line 1 [for Statement "SEL
ECT groups.id,groups.name,groups.description,groups.isbuggroup,groups.userregexp,groups.isactive,groups.icon_url FROM gr
oups ORDER BY isbuggroup, name"] at Bugzilla/Object.pm line 403.

line 403 is  
    $objects = $dbh->selectall_arrayref($sql, {Slice => {}}, @untainted);


Again all of these errors seem to be because the tablename groups is used without the db identifier in front of it.  

It seems that Bugzilla wont properly install without correcting these items so therefore it seems that it wont install with the latest version of Mysql.  

Can you recommend as to what my next steps should be?

Thanks.





_______________________________________________
support-bugzilla mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [email protected] in the To: field when you reply.