phpScheduleIt
May 24, 2013, 11:29:07 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: New 2.3.4 install, issue migrating from 1.2.12  (Read 135 times)
1adam12
Newbie
*

Karma: 0
Posts: 4


« on: November 07, 2012, 02:16:36 PM »

Hi,
Nick, just have to let you know that we've been running two instances of v. 1.2.x at a client of mine for about 5 years with *zero* issues. Great work and thanks for all of your hard work on this!

Now, to the current challenge. I'm hoping to upgrade these two instances to the latest build of 2.3.x. I've got a test instance of 2.3.4 running OK. The problem is that when I run the migration.php script, it runs for a little bit and then throws an error. I had enabled debug logging firts, and here's the output:

11/07/12 13:44:32,393 [2736] DEBUG default - Start migrating schedules
11/07/12 13:44:39,276 [2736] DEBUG default - Done migrating schedules (2 schedules)
11/07/12 13:44:39,276 [2736] DEBUG default - Start migrating resources
11/07/12 13:44:49,854 [2736] DEBUG default - Done migrating resources (34 resources)
11/07/12 13:44:49,854 [2736] DEBUG default - Start migrating accessories
11/07/12 13:44:49,882 [2736] DEBUG default - Done migrating accessories (0 accessories)
11/07/12 13:44:49,882 [2736] DEBUG default - Start migrating groups
11/07/12 13:44:49,913 [2736] DEBUG default - Done migrating groups (0 groups)
11/07/12 13:44:49,913 [2736] DEBUG default - Start migrating users
11/07/12 13:44:50,241 [2736] ERROR default - Uncaught exception: exception 'Exception' with message 'There was an error executing your query\nColumn 'language' cannot be null' in C:\xampp\htdocs\myserver\rooms2\lib\Database\MySQL\MySqlConnection.php:114
Stack trace:
#0 C:\xampp\htdocs\myserver\rooms2\lib\Database\MySQL\MySqlConnection.php(98): MySqlConnection->_handleError(false)
#1 C:\xampp\htdocs\myserver\rooms2\lib\Database\Database.php(97): MySqlConnection->Execute(Object(RegisterUserCommand))
#2 C:\xampp\htdocs\myserver\rooms2\Web\install\migrate.php(484): Database->ExecuteInsert(Object(RegisterUserCommand))
#3 C:\xampp\htdocs\myserver\rooms2\Web\install\migrate.php(174): MigrationPresenter->MigrateUsers(Object(Database), Object(Database))
#4 C:\xampp\htdocs\myserver\rooms2\Web\install\migrate.php(151): MigrationPresenter->Migrate()
#5 C:\xampp\htdocs\myserver\rooms2\Web\install\migrate.php(44): MigrationPresenter->PageLoad()
#6 C:\xampp\htdocs\myserver\rooms2\Web\install\migrate.php(725): MigrationPage->PageLoad()
#7 {main}

Any ideas? Many thanks!
Logged
Nick
Administrator
Hero Member
*****

Karma: 15
Posts: 5419


WWW
« Reply #1 on: November 07, 2012, 04:11:31 PM »

Try changing line 477 of /Web/install/migrate.php to:

Code:
empty($row['lang']) ?  Configuration::Instance()->GetKey(ConfigKeys::LANGUAGE) :$row['lang'] ,
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!