Gossamer Forum
Home : Products : Gossamer Links : Discussions :

mysql5 problem?

Quote Reply
mysql5 problem?
Hi,

I am trying to setup glinks for a site with mysql 5 and we have the following prolems:

1) mysql_sock = xxx. Mysql5 requires this info to connect properly. If we don't have it, there is no way to connect to mysql.

2) Some new reserved words have included in the newest version of mysql like "Condition" and the old tables/codes won't work. If we quoted these words with ``, glinks will ignore that field. It seems glinks treats these as two words

Can these be fixed? Thanks!

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] mysql5 problem? In reply to
Sorry, I'm not sure what you're referring to. I'm currently developing use MySQL 5.0.84 without any problems.

Adrian
Quote Reply
Re: [brewt] mysql5 problem? In reply to
Thanks for your reply.

The issues 1) seems fine now.

For the 2), when we ar trying to update a field - Condition in a table, we got the below error:
Code:
DBD::mysql::st execute 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 'Condition = 'xxx' at line 1 at
xxx/admin/GT/SQL/Driver/sth.pm
line 101.

The command of that is somethink like this: $db->update($updatesets,{ID => $id});

If I quoted that field - "Condtion" as `Condition`, the field is not updated and there is no error.
So, I have to use a "raw" query like: my $query = qq|update table xxx set `Condition` = "yyy"|; $db->do($query);
And that works fine but there are two update commands now and that is not good.

Is there a way to avoid that?

Cheers,

Dat

Programming and creating plugins and templates
Blog