Aaaarrrrgggghhhh Help

[richwalker]

I have spent my weekend trying to upgrade from 2.5. When it comes to importing the data into v3.0.3. My Recurring Invoices don't import and half of my clients & services duplicate.

 

I have increase the timeout in php as the import manager timesout. When it does timeout i wait process to finish (via ssh "top") before viewing the data in blesta.

 

Anyone got any ideas whats going on. I having to go back to V2.5 now because my account dept haven't been able to process any invoices this weekend.

 

 

 

 

[Paul]

Blesta 2.5 doesn't have recurring invoices, so no recurring invoices could be imported into v3. Or do you mean services?

 

Every time you attempt to do an import, you should be doing it on a fresh install (ie no clients, services, packages, etc). If you need to, do a fresh install of v3 in the same location you have it, and then make a backup of the database so that you can just restore it if you have to run the import again.

 

If your next import doesn't get everything after a fresh install you can do some debugging..

 

 

Try the following to enable debugging during import. Then attempt to import again from a fresh database.

 

Open /config/blesta.php and change (line 11):

 

Configure::errorReporting(0);

 

to

 

Configure::errorReporting(-1);

 

Then open /plugins/import_managers/components/migrators/blesta/2.5/blesta2_5.php and change (lines 199-201):

 

            //echo $e->getMessage();

            //echo $e->getTraceAsString();

            //continue;

to:

 

            echo $e->getMessage();

            echo $e->getTraceAsString();

            die;

 

Then, let us know what, if any errors are displayed.

 

Also, make sure you're following the steps listed here http://docs.blesta.com/display/user/Migrating+to+Blesta to migrate from 2.5 to 3.0.

[richwalker]

Hi Paul

 

Thanks. Yes we get an error. What should we do?

 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '100' for key 'username'#0 /var/www/vhosts/domain.com/httpdocs/lib/model.php(124): PDOStatement->execute(Array) #1 /var/www/vhosts/domain.com/httpdocs/components/record/record.php(215): Model->query('INSERT INTO `us...', Array) #2 /var/www/vhosts/domain.com/httpdocs/plugins/import_manager/components/migrators/blesta/2.5/blesta2_5.php(320): Record->insert('users', Array) #3 /var/www/vhosts/domain.com/httpdocs/plugins/import_manager/components/migrators/blesta/2.5/blesta2_5.php(196): Blesta2_5->importClients() #4 /var/www/vhosts/domain.com/httpdocs/plugins/import_manager/models/import_manager_importer.php(113): Blesta2_5->import() #5 /var/www/vhosts/domain.com/httpdocs/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('blesta', '2.5', Array) #6 /var/www/vhosts/domain.com/httpdocs/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /var/www/vhosts/domain.com/httpdocs/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /var/www/vhosts/domain.com/httpdocs/index.php(21): Dispatcher::dispatch('/admin/settings...') #9 {main}

[Paul]

It looks like there may be 2 usernames that are the same. Since usernames must be unique, you're bumping into this error.

 

Cody can probably provide more information about how to fix such a case, but if you're able to find and correct any duplicate usernames in v2.5 prior to doing an import (And make sure that no users were added in v3 that also exist in 2.5) you may be able to get around this issue.

[richwalker]

I have been through and changed the duplicate username names but i'm still hitting the same problem.

[Cody]

You sure it's the same exact error? If so, then you've still got a few duplicates users in there. Also, are you sure you're starting with a fresh Blesta 3 database each time you run the import?

[richwalker]

Cody

It's timing out now after 5 mins & I'm still getting my clients doubling. I can see the process running in ssh after it timeout.

Can I pay you guys to do the import as I just haven't got the time to mess with it anymore.

[richwalker]

Yes it's a fresh install

[richwalker]

Can you guys do for me? I'm happy to pay

[richwalker]

You sure it's the same exact error? If so, then you've still got a few duplicates users in there. Also, are you sure you're starting with a fresh Blesta 3 database each time you run the import?

 

Cody

I have been through contacts and users table and remove any duplicates. Most of the time the FireFox times out so no error messages. Any Ideas?

I have also submitted a support ticket as well.