Project

General

Profile

Actions
Copy link

Bug #1863

closed

db:convert:prod2dev fails on the roles and settings tables

Added by Greg Sutcliffe over 11 years ago. Updated almost 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
DB migrations
Target version:
-
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Converting MySQL to Sqlite3 on a foreman 1.0.1 box, I get:

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 '"roles" LIMIT 10000 OFFSET 0' at line 1: SELECT `roles`.* FROM "roles" LIMIT 10000 OFFSET 0

If you skip roles in lib/tasks/convert.rb then you get the same error for settings. I did ensure the schemas were consistent with:

  1. bundle exec rake db:migrate RAILS_ENV=production
  2. bundle exec rake db:drop RAILS_ENV=development
  3. bundle exec rake db:migrate RAILS_ENV=development
Actions
Copy link
 #1

Updated by Benjamin Papillon almost 11 years ago

bump? :)

Actions
Copy link
 #2

Updated by Greg Sutcliffe almost 11 years ago

  • Status changed from New to Closed

Thanks Benjamin, I'll close this for now, we can re-open if it resurfaces.

Actions
Copy link

Also available in: Atom PDF