Re: [Refdb-users] Cannot create database in MySQL

[Torsten B. <br...@ph...>]

Hallöchen!

Markus Hoenicka writes:

> Torsten Bronger writes:
>
>>     CREATE DATABASE references CHARACTER SET 'utf8'
>> 1064: 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
>> references CHARACTER SET 'utf8'' at line 1
>
> Which mysql version are you using? I'd like to check why mysql
> complains about the syntax (which apparently works ok in versions
> 4.1 through 5.0).

I must correct myself.  First, I mixed up the MySQL version on two
of my machines.  The server runs with 5.0.51a.

Secondly, the name "references" is bad for the database because it
seems to be a reserved word or something like that (unfortunately,
at the same time it's a good name for a references DB ;-).  With
"biblio", it worked.

However, I run into trouble here and there because "deb
http://refdb.sourceforge.net/debian/svn testing main" gives me an
outdated version (from March 2007 or so).  Is it feasible to update
this?  If not, I'm highly probably able to install the SVN version.
:)

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: tor...@ja...