Defect #14141
closed
Error when loading default data to SQL
Added by Andrew Dugrenier over 11 years ago.
Updated about 6 years ago.
Description
I'm Running on a Windows Server.
Redmine V2.3.1
Ruby 1.8.7
MS SQL Server 2008R2
everything seems to be installing OK.
after running rake db:migrate, I ran rake redmine:load_defautl_data
I received the error message:
Error: TinyTds::Error: Invalid column name 'builtin'. EXEC sp_executesql N'SELECT
TOP (1) 1 AS one FROM [roles] WHERE [roles].[builtin] = 0'
default configuration data not loaded.
Files
Did you run db:migrate without error?
Any Plugins installed?
- Priority changed from High to Normal
Yes, migrate ran without error.
I followed the installation specified and everything ran ok up to the default data install.
Please, give the full output of rake redmine:load_default_data --trace
- Status changed from New to Needs feedback
OK,
I loaded a different computer with the windows version and got redmine 2.3.1-1 running. The database initialized OK.
On the old virtual machine version 1.3.2-0 I backed up the mysql database, copied all the apps/redmine/files files.
On the new machine with 2.3.1-1 I used the PHPMyAdmin to import the sql data to the bitnami_redmine database. I placed the copied redmine files in the apps/redmine/htdocs/files folder.
Now I can see my projects, but the files,tasks and calander etc do not work.
Can anyone help?
Andrew Dugrenier wrote:
OK,
I loaded a different computer with the windows version and got redmine 2.3.1-1 running. The database initialized OK.
On the old virtual machine version 1.3.2-0 I backed up the mysql database, copied all the apps/redmine/files files.
On the new machine with 2.3.1-1 I used the PHPMyAdmin to import the sql data to the bitnami_redmine database. I placed the copied redmine files in the apps/redmine/htdocs/files folder.
Now I can see my projects, but the files,tasks and calander etc do not work.
Can anyone help?
That's not the right way to do this:
- copy your old DB to new Redmine instance
- upgrade your new DB using
rake db:migrate RAILS_ENV=production
If you create a new DB then import old data you'll miss some of the DB upgrade with migration, specifically the one concerning data.
Please read RedmineUpgrade.
The upgrade document concerns upgrading on the current machine.
In my case I have 2 computers:
One is running a Virtual Machine version Redmine 1.2.3-0 with an Ubanutu op system.
The second is a Windows op system with a Windows install of Redmine 2.3.1-1
Copying the redmine files is no problem, but will the migrate be the same? How would it know where to get the data from? I backed up the mysql database to a backup.sql file.
Thanks,
Andy
- Status changed from Needs feedback to Closed
- Resolution set to Invalid
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by