peter.3.edwards(a)bt.com wrote:
Is an error
like this normal when doing the db install?
ERROR 1064 (42000): 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 'VIEW usr_preferences_view AS SELECT id, username,
domain, attribute, type AS att' at line 1
Hi, Nick.
Not that it helps you much - but, no, I don't think that's normal - I
didn't get this when installing on MySQL 5.0.24 (latest stable version),
compiled from source. You might get compatibility issues if your
version of MySQL is out of date ... what are you running?
mysql-4.1.20-1
There's no 5 built for centos yet, but this should be fairly up to date...
I'm sure Mike Williams will be along to help you debug it ...
The program works.. but I'm not sure what that error might cause in way
of bugs, or whatever.
By the way, while ruby on rails might be a great
development
platform,
it's a right pain in the behind to install.
Completely agree - especially when you're in a network which requires
the use of a proxy to reach the web ...
Bleugh.
Still, once it's up and running it should be easy to maintain, or so I'm
led to believe!
I had no end of problems installing mysql-ruby in the end, I ended up
running the extern.rb with some command line options --with-mysql-config
and that got the makefile built.
BTW, what version of mysql-ruby should I be running, I'm using 2.5.1 at
the moment, 2.6 and 2.7 were also available
Peter.