Tagged Questions

0
votes
2answers
18 views

Importing CSV files to database - Rejecting certain rows

If I want to import a csv file, which would include an email column, is there a way to only accept rows that have a valid email format and reject rows that have invalid formats?
-1
votes
1answer
23 views

Mysql migration error

I'm recieveing the following error when trying to migrate my database. Mysql2::Error: BLOB/TEXT column 'overview' can't have a default value: ALTER TABLE `habitat_versions` CHANGE `description` ...
-1
votes
0answers
15 views

Ruby on Rails and acid compliance with MySQL / Innodb

Is there a discussion of how well Rails supports ACID compliance (Rails 3.2.13 and MySQL 5.5)? Specifically, I'm looking for situations where a model is created and then other models are created ...
0
votes
0answers
16 views

Rails 4 Heroku Mysql to Postgres Dump Pending Migrations

I've converted my mysql db to postgres. I'm used the following to import it to the db: heroku pgbackups:restore database 'http://app.com' --app This creates all the tables and imports the data. ...
0
votes
0answers
16 views

get values from sql in a rake task

I am looking to retrieve some values from my SQL database. In my rake task I need to check if a table has any values and if so I need to do them in a variable. @db = ...
0
votes
1answer
24 views

Avoid default activerecord primary index creation

I am trying to workout how to advise/tell activerecord not to create it's primary index by default. Anyone know how i can achieve this ? class CreateHouse < ActiveRecord::Migration def change ...
0
votes
1answer
28 views

Filtering MySQL data by rails session parameter

I've got a rails application, backed by MySQL. It's using a row-level permissions model. i.e. I have a few columns (permission1, permission2, permission3) on a table called projects and I need to ...
0
votes
1answer
28 views

ruby mysql2 gem install error

I am having problems installing mysql2 gem on my windows machine, usually it worked, but now I get Failed to build native extension. I googled around, but there were a lot of linux fixes. I know its ...
0
votes
2answers
33 views

Cant create Ruby on Rails app on Windows - Mysql error

After installing rubyinstaller i tried creating a new mysql app with mysql and i get the below error that has to do with mysql... Console : C:\rails>rails new secret -d mysql create ...
0
votes
0answers
27 views

Mysql Error Table test.accounts doesn't exist

Hi I am recieving this error: ActiveRecord::StatementInvalid in AccountsController#new Mysql2::Error: Table 'test.accounts' doesn't exist: SHOW FULL FIELDS FROM accounts I know that the error is ...
0
votes
2answers
28 views

Operand should contain 1 column(s) ruby on rails

I have 3 model Shop Section and Price, Section have shop_id and Price have section_id How can i show prices in Shop view? controller/shop_controller.rb ... def show @metod_one = ...
-2
votes
0answers
11 views

helios-framework MySql integration issue [on hold]

I am trying to integrate the helios-framework(https://github.com/helios-framework/helios) to my existing rails3 (ruby 1.9.2)- Mysql web app , and I am now confused. Can you please help me to integrate ...
0
votes
2answers
33 views

Postgresql error (heroku) - works locally on mysql

It's a zip code search that's working fine in development using mysql but when deployed to heroku it's blowing up. ActiveRecord::StatementInvalid (PG::Error: ERROR: syntax error at end of input LINE ...
1
vote
1answer
25 views

Creating Controllers in ROR for MYSQL tables

I have created a new MySQL DB app through ruby console giving below command rails new -demo -d mysql Then I created 1 table through MySQL editor. In Ruby Console I started rails server and its ...
0
votes
1answer
69 views

ArgumentError (wrong number of arguments (2 for 1)) - `find' and `create' for RoR app

Thanks for any help you can provide! I've reviewed other topics related to this error but haven't been able to find a solution for my situation. I've got an HTML form and two MYSQL database tables ...

1 2 3 4 5 … 168
15 30 50 per page