tsiedsma

Welcome to the wonderful world of the Beta importer. I'm stuck waiting for a fix to my issues, nobody has even addressed my post on a previous page...

Ugh, this is one thing I HATE about WHMCS. Doing reports at the end of the year for taxes has always been a challenge. The numbers never add up. I can't wait to have a more reliable system that knows how to do simple math.

A white page generally means there was an error, check your error_log file or the Apache error log and see what it says.

Agreed! What they need is for people like us to keep testing and finding issues so they can fix it. As the thread title indicates, this is still in Beta.

None of my tickets came over, it didn't even enabled the support manager.

I had this issue where some client names were blank. I just did a mass update UPDATE tblclients SET lastname = 'Smith' WHERE lastname = ''; That will work for country too, UPDATE tblclients SET country='US' WHERE country=''; Edit: nevermind, I read your post wrong, you've already corrected the null country.

I disagree that I was selling domain for different registrars. I personally think you should only import active products and services. There are some old expired enom domains and such. I think each individual tld is a single product with 1-10 pricing configs and register / renew / transfer pricing options.

I disagree...

PM sent

I guess I don't follow. Each TLD product shows pricing for 1-10 years. They are all identical...

I just realized that no support tickets, departments or anything came over. Also, support is missing from the header and the support manager does not appear to be installed / activated. Edit: I found the cause of the issue with tabs not working as expected. By having System.benchmark set to true, the tabs were broken. This is an easy thing to replicate. Kind of an odd thing to happen.

I'll do more digging to see what I can find wrong with the import but I did notice that all domain tlds were imported multiple times with different modules. I don't see any difference between the different tld entries except the module they are linked to. I also have issues changing views. On the Invoices page, when I click on Past Due, it changes the url to /admin/billing/invoices/past_due/ but the content doesn't change. If I refresh the page, it loads the past_due invoices. This is true for the products page too where the domains were listed. Edit: It imported 4 whole client services. Clicking tabs on the manage service page also require a refresh to load the content. This is frustrating in itself. Only a few hosting products where imported fully including pricing terms. The prices are all set to 0.00 even for monthly and annual payment terms.

Ugh, The import completed but the following errors ocurred: importServices: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module_row_id' cannot be null on line 124 importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 execution time: 7931.23912191 seconds (132 minutes)

This most likely made things start working. That combined with my MySQL changes above. This will be a problem for me too.

It's working!!! It did all clients, contacts, invoices and invoice line items. It takes for freaking ever though. I'm going to start over and do a run through with everything and see how it goes. I did a search and replace in the WHMCS database for empty first and last names which fixed the previous error. Here's my my.cnf file. I have to admit, I don't know what all of the config options do, but I found this example on a site claiming to be a very optimized config file. Some of the vars were different than what I had and it's working now so I'm ok with it. Anyone with more mysql server experience might be able to slim this down or tweak it a bit more. [mysqld] back_log = 75 max_connections = 500 key_buffer = 384M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1800 thread_cache_size = 384 wait_timeout = 7200 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M max_connect_errors = 1000 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 4M query_cache_size =128M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 default-storage-engine = MyISAM innodb_buffer_pool_size=100M innodb_file_per_table=1 innodb_stats_on_metadata=0 log_error=/var/log/mysql/mysqld.log log_warnings=2 [safe_mysqld] pid-file="/var/lib/mysql/mysql.pid" nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysql.server] user=mysql

It didn't come through. its just my forum username @lithiumhosting.com Thanks for your help.

I got a new error. I made some more mysql and php changes and restarted the import. I get this error now: It comes up after the import has supposedly completed but doesn't say the usual import successful message. I only did a partial import, the services and everything are commented out as I am still troubleshooting. If this is because one person didn't have a last name specified, maybe the error can be less of an error and just an info notice with a link to the user so we can modify them. I'm trying the import with a larger data set now, including invoices and transactions.

Ugh, I kind of wish someone else was having the troubles I am. Any chance you can shoot me a copy of your my.cnf and php.ini? Are you importing a copy of your full whmcs database, or are you using a smaller test database? email: my username @lithiumhosting.com

This was logged in the hostname.err log. 131023 14:07:33 [Warning] Aborted connection 88 to db: 'blesta_whmcs' user: 'blesta_blesta' host: 'localhost' (Got timeout reading communication packets) That was 10 minutes prior to the import failing. No other errors anywhere. The import completed but the following errors ocurred: importClients: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away on line 124

It failed again. Cody, I already started before you suggested commenting out the other migration options. I have commented them out as you suggested. Paul, I cleared the db and only enabled the import manager and am starting now. Cody, I did configure those PHP settings and set my mysql allowed_packet_size to 64M

I'll try the php settings. I doubled the packet size with no change. The import didn't grab more data or less for that matter. It dies before all clients are imported and the number of imported clients is very close either way.

That's pretty much what I said I did... Took a backup of the database for later restores. Import failed again, no usable errors.

This is my last attempt today. I'm getting frustrated. I did a fresh install of Blesta. I enabled cPanel and LogicBoxes. Also enabled Support Manager and Import Manager, then I backed up my database for later restores if this fails. Import started, crossing fingers.

Ugh, it died again. No queries in the general query log look bad or broken. I'm at a loss here. Mysql is up and did not die. From what I can tell, this is towards the end of the migration where it eventually fails. 1 Query INSERT INTO `contact_numbers` (`contact_id`, `number`, `type`, `location`) VALUES ('[redacted]', '[redacted]', 'phone', 'home') 1 Query SELECT `id` FROM `modules` WHERE `company_id` = '1' AND `class` = 'universal_module' 1 Query SELECT COUNT(*) AS `total` FROM ((SELECT * FROM `companies` WHERE `id` = '1')) AS `t_381380570` 1 Query INSERT INTO `modules` (`company_id`, `class`, `name`, `version`) VALUES ('1', 'universal_module', 'Universal Module', '1.0.10') 1 Query INSERT INTO `module_rows` (`module_id`) VALUES ('3') 1 Query INSERT INTO `module_row_meta` (`key`, `value`, `serialized`, `encrypted`, `module_row_id`) VALUES ('name', 'generic_server', '0', '0', '3')

That doesn't tell me anything I don't already know... The wait_timeout is large enough, the service didn't restart. I'll confirm again after this next import attempt. Import failed again, got more clients imported than last time though. execution time: 619.885823011 seconds [~]# mysqladmin version mysqladmin Ver 8.42 Distrib 5.1.70, for unknown-linux-gnu on x86_64 Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.1.70-cll Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 39 min 23 sec Threads: 2 Questions: 382740 Slow queries: 1 Opens: 194045 Flush tables: 1 Open tables: 1024 Queries per second avg: 161.972