Displaying 3 results from an estimated 3 matches for "mysql_sqlstate".
2009 Jul 08
0
mysql gem error on solaris 10 sparc
...create:all
(in /opt/gitorious)
Character set ''utf8'' is not a compiled character set and is not
specified in the ''/usr/sfw/share/mysql/charsets/Index'' file
ld.so.1: ruby: fatal: relocation error: file
/opt/ruby/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.so: symbol
mysql_sqlstate: referenced symbol not found
Killed
--
Posted via http://www.ruby-forum.com/.
2006 Jan 18
3
legacy database on remote host
I''m getting this error in webrick then it crashes leaving nothing in the
log.
ruby: symbol lookup error:
/usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.so: undefined symbol:
mysql_sqlstate
Here is the standard query I would normally write to get the data.
select * from child,parent
where CONCAT(SUBSTRING(child.item_number,1,14,''00'') =
parent.order_number and parent.order_number = ''4444444444444400''
Here are my models and my database.yml
clas...
2008 May 23
20
Rails validation is inefficient
Hi,
I have a User model, with a validates_uniqueness_of :login
The generated SQL for the validation is:
SELECT * FROM `users` WHERE (LOWER(users.login) = ''fernando'' AND
users.id <> 10001) LIMIT 1;
and it takes 0.13s to happen (my table has 10.000 rows)
When I use the EXPLAIN instruction on it, it shows that it will use the
primary_key as index, but this is not