Defect #14141
closed
Error when loading default data to SQL
0%
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
Updated by Daniel Felix over 11 years ago
Did you run db:migrate without error?
Any Plugins installed?
Updated by Andrew Dugrenier over 11 years ago
Yes, migrate ran without error.
I followed the installation specified and everything ran ok up to the default data install.
Updated by Jean-Philippe Lang over 11 years ago
Please, give the full output of rake redmine:load_default_data --trace
Updated by Jean-Philippe Lang over 11 years ago
- Status changed from New to Needs feedback
Updated by Andrew Dugrenier over 11 years ago
- File production.log production.log added
- File development.log development.log added
log files attached.
Updated by Andrew Dugrenier over 11 years ago
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?
Updated by Etienne Massip over 11 years ago
Andrew Dugrenier wrote:
That's not the right way to do this: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?
- 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.
Updated by Andrew Dugrenier over 11 years ago
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
Updated by Go MAEDA about 6 years ago
- Status changed from Needs feedback to Closed
- Resolution set to Invalid