Project

General

Profile

Actions
Copy link

Defect #14141

closed

Error when loading default data to SQL

Added by Andrew Dugrenier almost 11 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:
2.3.1

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

Download all files
production.log (2.06 KB) production.log Andrew Dugrenier, 2013-06-03 17:04
development.log (38.7 KB) development.log Andrew Dugrenier, 2013-06-03 17:04
Actions
Copy link
 #1

Updated by Daniel Felix almost 11 years ago

Did you run db:migrate without error?
Any Plugins installed?

Actions
Copy link
 #2

Updated by Daniel Felix almost 11 years ago

  • Priority changed from High to Normal
Actions
Copy link
 #3

Updated by Andrew Dugrenier almost 11 years ago

Yes, migrate ran without error.
I followed the installation specified and everything ran ok up to the default data install.

Actions
Copy link
 #4

Updated by Andrew Dugrenier almost 11 years ago

No plug-ins.

Actions
Copy link
 #5

Updated by Jean-Philippe Lang almost 11 years ago

Please, give the full output of rake redmine:load_default_data --trace

Actions
Copy link
 #6

Updated by Jean-Philippe Lang almost 11 years ago

  • Status changed from New to Needs feedback
Actions
Copy link
 #7

Updated by Andrew Dugrenier almost 11 years ago

log files attached.

Actions
Copy link
 #8

Updated by Andrew Dugrenier almost 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?

Actions
Copy link
 #9

Updated by Etienne Massip almost 11 years ago

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.

Actions
Copy link
 #10

Updated by Andrew Dugrenier almost 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

Actions
Copy link
 #11

Updated by Go MAEDA over 5 years ago

  • Status changed from Needs feedback to Closed
  • Resolution set to Invalid
Actions
Copy link

Also available in: Atom PDF