similar to: MySQL adapter bug? Date col being set to NULL when default is 0000-00-00

Hello all, I posted an article about an issue with sqlyog and mysql database program. After I upgraded to wine 1.41 the issue appears to resolve itself. Thanks for fixing the ntlldr issue! Fyi John

We at Webyog produce the SQLyog program. SQLyog is an advanced graphical client for MySQL. SQLyog records at winehg.com applications database are available here: http://appdb.winehq.org/appview.php?appId=1328 As you can read versions up to 5.0.x worked fine with Wine. Basically version 5.1.x does too. However we have two issues with two new features of SQLyog version 5.1.x (we tested primarily

I am writing a library module to handle certain StatementInvalid type AR exceptions. I wish to catch the case where the db adapter in use is not supported by the module. I would like to test this situation and have only a vague idea as to how to proceed. My exception handling method selects the parsing method based on the adapter_name value. def hll_ar_exception(exception) raise

Hi, Fedora 14, wine version 1.3.18 when i try to connect to linux mysql server with command line: wine mysql.exe -h localhost -u root -p i got this error: ERROR 2005 (HY000): Unknown MySQL server host 'localhost' (10093) with this command line is all ok. wine mysql.exe -h 127.0.0.1 -u root -p linus hosts file /etc/hosts: 127.0.0.1 localhost 127.0.0.1 localhost.localdomain

I don't know what happened but now i cannot use it any more and i really need it! The following error occurs when any user interaction is needed: Code: demian at demian-desktop:~/.wine/drive_c/Program Files/SQLyog$ wine SQLyog.exe fixme:ntdll:NtLockFile I/O completion on lock not implemented yet fixme:ntdll:find_reg_tz_info Can't find matching timezone information in the registry for

hello can anybody help me with this bug, (this sometimes occur sometimes passes) 1) ActiveRecord::StatementInvalid in ''MailReader on Simple Tasks should not accept duplicate email'' Mysql::Error: MySQL server has gone away: ROLLBACK TO SAVEPOINT active_record_1 /home/poldz/.gem/ruby/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in

Hello, I'm trying to run sqlyog under wine in Linux Mint 12, gnome to use with mysql database. The application launches and seems to work and connect to the database, but when you try to create a query or table, it quits without warning or message. The debug log shows the below. How can I fix this? fixme:ntdll:NtLockFile I/O completion on lock not implemented yet

I''m struggling with activerecord and mysql blobs (uploading files)... blobs over 400K-ish cause the below exception... ActiveRecord::StatementInvalid in File#upload Mysql::Error: Lost connection to MySQL server during query: I''ve tried blob, mediumblob, and longblob... I''m using windows xp for development - and have not installed the mysql gem... simlar google

i have this model: class LineItem < ActiveRecord::Base belongs_to :quote end in the console: >>l = LineItem.create ActiveRecord::StatementInvalid: Mysql::Error: 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 '' , , , )'' at line 1: INSERT INTO line_items (`qty`, `quote_id`,

Hi, I just upgraded to rails 1.1 this morning and i am getting a variety of errors from tests that were passing effortlessly on the previous edge release (i froze several weeks ago, so I not sure what version that was). Has anyone else experienced these types errors with the new rails: I have several errors that are grouped around create and destroy commands the errors are similar, first the

We are currntly running mongrel v 1.1.4 mongrel_cluster 1.0.5 mysql gem 2.7.5 (built from source) rails 2.0.2 ruby 1.8.6 mysql version 4.1 this is run on a remote server. We are consistently getting "ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone away: SELECT * FROM...." errors. When i then try and stop mongrel some (various) of the mongrels are in error state

I''m using RailsCron, and it''s working out very well for me. However, I''m having one problem right now. I use the acts_as_background on one of my model objects. In order to get it to add the cron job to the table, I have to make sure the model is loaded in environment.rb. MyObject.load However, I''m running 2-3 fcgi process on my server. Most of the time when

Hello, I am having this mysql error in my ruby on rails application. ActiveRecord::StatementInvalid occurred in > event#lg: > Mysql::Error: Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > operation ''='': select * from locations where country = ''HU'' and > geo_state = ''08'' and city

Hi all, I know stored procedures are considered evil around, but there are times when you just have to use them. In the project I''m working on, I needed to call a mysql5 stored procedure, but I only got an error message saying "ActiveRecord::StatementInvalid: Mysql::Error: PROCEDURE vc.testsp can''t return a result set in the given context: call testsp()" I found out

Hi have add issues with stuck pending jobs on my puppet dashboard. Here is the error message from my delayed_job.log file in /usr/share/puppet-dashboard/log directory. Report.create_from_yaml_file failed with ActiveRecord::StatementInvalid: Mysql::Error: Incorrect string value: ''\x96 $bas...'' for column ''details'' at row 1: INSERT INTO `delayed_job_failures`

Hello all I am using acts_as_ferret in user model. Error Message: -------------- ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE `users` SET `updated_at` = ''2009-12-28 14:31:50'', `active_till` = ''2009-12-28 14:31:50'' WHERE `id` = 21 Where: ------ calls#audit

Had this error when trying to add comments to another user''s photo. ActiveRecord::StatementInvalid in User photosController#show Mysql::Error: Unknown column ''comments.user_id'' in ''on clause'': SELECT photos.`id` AS t0_r0, photos.`user_id` AS t0_r1, photos.`title` AS t0_r2, photos.`body` AS t0_r3, photos.`created_at` AS t0.... I did create a user_id

Hi all, Ive been getting this error on one particular query repeatedly for the past few days. ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE `posts` SET `updated_at` = ''2010-03-17 05:35:00'', `view_count` = 54 WHERE `id` = 158 Googling around, I found that this is basically because the transaction times out after

I am getting 193 failures that all have "Mysql::Error: Incorrect datetime value:" how do i fix this??? i am new to rspec and restful_auth, so if i am doing something wrong, let me know!!! windows xp rails 2.1.1 rails testproject cd testproject # create my databases and edit database.yml git init git submodule add git://github.com/dchelimsky/rspec.git vendor/plugins/ rspec git

Hello, Does anyone see the following error? Is it possible that it has something to do with the connection maintained by active record timing out? /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'': Mysql::Error: MySQL server has gone away: SELECT * FROM toys WHERE (toys.id = 28) LIMIT 1