New Migration error: Unrecognized option: -publish-sb-site

[dalydesign]

Trying to migrate an existing domain from 11.5 to 12.5 servers. Experiencing this new error, never seen this before.

  `- error: Failed to transfer WPB sites of subscription 'mydomain.com'
  Migration tools tried to perform operation in 3 attempts.
  ----------------------------------------------------------------------------
  Attempt #1 failed with the following error:
  Command  --update  -publish-sb-site true -sb-site-id  with arguments {'site_id': 'be04c5de-e23f-a212-100e-b4f34e97e056', 'plesk_bin_domain': u'/usr/local/psa/bin/domain', 'domain_name': u'mydomain.com'} failed with exit code 1
  stdout:
  stderr: Unrecognized option: '-publish-sb-site'
 
  Unrecognized option: '-sb-site-id'
 
 
  '
  ----------------------------------------------------------------------------
  Attempt #2 failed with the following error:
  Command  --update  -publish-sb-site true -sb-site-id  with arguments {'site_id': 'be04c5de-e23f-a212-100e-b4f34e97e056', 'plesk_bin_domain': u'/usr/local/psa/bin/domain', 'domain_name': u'trainingengland.com'} failed with exit code 1
  stdout:
  stderr: Unrecognized option: '-publish-sb-site'
 
  Unrecognized option: '-sb-site-id'
 
 
  '
  ----------------------------------------------------------------------------
  Attempt #3 failed with the following error:
  Command  --update  -publish-sb-site true -sb-site-id  with arguments {'site_id': 'be04c5de-e23f-a212-100e-b4f34e97e056', 'plesk_bin_domain': u'/usr/local/psa/bin/domain', 'domain_name': u'mydomain.com'} failed with exit code 1
  stdout:
  stderr: Error occured while sending feedback. HTTP code returned: 502
  Unrecognized option: '-publish-sb-site'
 
  Unrecognized option: '-sb-site-id'

Any help would be appreciated.

Thanks.

 

[abdi]

Hi Paul,

If you are transferring a single domain name, then you are better of transferring it manually than trying to troubleshoot that error ...You will spend more time than manual transfer ..

If you need help with the manual transfer, just let me know!

 

[dalydesign]

Thanks for the info. Thankfully it's only 1 domain!

It did migrate the data across successfully. but it threw up the error. I tested the domain and mail, and it all appears ok.

I tried a plesk repair on the domain and it found no errors.

I wonder if it was rogue records as my suspicion is those errors relate to sitebuilder and we've never used sitebuilder.

 

[IgorG]

What is output of following SQL query in psa database on source server:

select domains.name, SBSites.id, SBSites.sb_site_id from psa.domains, psa.SBSites where virtualHost_id=domains.id;

Make sure that you have any domain related record in SBSites table.

 

[dalydesign]

ERROR 1146 (42S02): Table 'psa.SBSites' doesn't exist

 

[IgorG]

Output of

mysql> select * from upgrade_history;

on source server?

 

[dalydesign]

ERROR 1046 (3D000): No database selected

 

[IgorG]

Are you sure you entered to Plesk database before running these commands?

# plesk db

mysql> select * from upgrade_history;
+---------------------+--------------+------------+
| upgrade_date | version_info | db_version |
+---------------------+--------------+------------+
| 2015-11-27 06:55:52 | 11.5.30 | 11.5.30 |
| 2015-11-27 06:55:53 | 11.5.30 | 11.5.30 |
+---------------------+--------------+------------+
2 rows in set (0.00 sec)

 

[dalydesign]

Igor, Do you suspect this is a serious issue? or is it a sitebuilder related issue that I can ignore as we don't use sitebuilder?

 

[dalydesign]

source server is a 11.5 installation.

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

]# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 76772
Server version: 5.0.95-log Source distribution

Copyright (c) 2000, 2011, 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.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from upgrade_history;
ERROR 1046 (3D000): No database selected
mysql>

 

[IgorG]

It's up to you how to consider this problem reported by you.

source server is a 11.5 installation.

I know. Just run

# plesk db

or correct command:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

if you need to use Plesk 'psa' database.

Igor, Do you suspect this is a serious issue? or is it a sitebuilder related issue that I can ignore as we don't use sitebuilder?

It's up to you how to consider this reported problem.

 

[dalydesign]

Sorry! I didn't realise the 'psa' was not entered.

Also 11.09, not 11.5 (barely any sleep this week)


Here it is:

+---------------------+------------------------------+------------+
| upgrade_date | version_info | db_version |
+---------------------+------------------------------+------------+
| 2010-06-09 13:13:47 | 9.2.2 CentOS 5 92090714.19 | 0922 |
| 2010-12-20 12:19:15 | 9.5.2 CentOS 5 95100504.10 | 01090 |
| 2010-12-20 12:19:18 | 9.5.2 CentOS 5 95100504.10 | 01090 |
| 2010-12-20 13:55:00 | 10.0.1 CentOS 5 109101029.18 | 01090 |
| 2010-12-20 14:02:20 | 10.0.1 CentOS 5 109101029.18 | 01090 |
| 2011-02-24 12:48:57 | 10.0.1 CentOS 5 109101029.18 | 010101 |
| 2012-01-13 20:26:39 | 10.4.4 | 10.1.1 |
| 2012-01-13 20:26:40 | 10.4.4 | 10.4.4 |
| 2012-01-17 17:55:51 | 10.4.4 | 10.4.4 |
| 2012-01-17 17:59:00 | 10.4.4 | 10.4.4 |
| 2012-01-17 18:08:35 | 10.4.4 | 10.4.4 |
| 2012-01-17 18:24:58 | 10.4.4 | 10.4.4 |
| 2012-01-17 20:52:46 | 10.4.4 | 10.4.4 |
| 2013-05-14 11:13:43 | 10.4.4 | 10.4.4 |
| 2013-06-04 14:12:37 | 11.0.9 | 11.0.9 |
| 2013-09-20 12:40:54 | 11.0.9 | 11.0.9 |
| 2013-09-20 15:24:39 | 11.0.9 | 11.0.9 |
| 2013-09-20 15:30:51 | 11.0.9 | 11.0.9 |
| 2013-09-20 16:39:23 | 11.0.9 | 11.0.9 |
| 2013-09-20 18:36:07 | 11.0.9 | 11.0.9 |
| 2014-11-07 20:55:11 | 11.0.9 | 11.0.9 |
+---------------------+------------------------------+------------+
21 rows in set (0.00 sec)

 

[IgorG]

This is more important - http://talk.plesk.com/threads/new-m...ed-option-publish-sb-site.336005/#post-791708

 

[dalydesign]

It returned this:

Empty set (0.00 sec)

 

[IgorG]

Any records in SBSites table?

 

[dalydesign]

No. Its empty.



mysql> select * from SBSites;
Empty set (0.01 sec)

 

[IgorG]

Run

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` sitebuilder5

and check records in table 'site' especially for 'be04c5de-e23f-a212-100e-b4f34e97e056'
As you see - it is necessary to find in database record with this strange 'be04c5de-e23f-a212-100e-b4f34e97e056'

 

[dalydesign]

mysql> select * from site;
+----+----------------------------------+----------------------------------+--------------------------------------+----------------------------------+---------------+---------------+---------------------------+-------------+--------------------------+--------------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+-------------+-------------------------------------------+-------------+-----------------------+-------------+-----------------------------------+--------------+--------------+-------+-------------------------+---------+--------------------------+---------------+----------+-----------+
| id | dir_name                         | site_id                          | uuid                                 | alias                            | password_hash | password_salt | creation_date             | template_id | site_publish_settings_id | company_name | pages_use_name | description                                                                                                                                                      | keywords                                                                        | logo_name   | logo_path                                 | custom_head | google_analytics_code | locale_code | is_changed_since_last_publication | is_published | site_page_id | state | is_facebook_integration | plan_id | initial_site_template_id | site_owner_id | ecwid_id | disqus_id |
+----+----------------------------------+----------------------------------+--------------------------------------+----------------------------------+---------------+---------------+---------------------------+-------------+--------------------------+--------------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+-------------+-------------------------------------------+-------------+-----------------------+-------------+-----------------------------------+--------------+--------------+-------+-------------------------+---------+--------------------------+---------------+----------+-----------+
|  1 | 1817106a0015399155bdec6f01aa0c5f | 1817106a0015399155bdec6f01aa0c5f | 2979a9da-214d-fc42-4c08-03a24222fdad | 1817106a0015399155bdec6f01aa0c5f | NULL          | NULL          | 2010-12-21T12:06:08+00:00 |           1 |                        1 | My website   |              1 | Thorough fitness assessment and a variety of fitness classes with the certified instructors to help you determine your abilities and achieve your fitness goals. | courts,swimming,pool,aerobics,trainer,weight,training,fitness,athletics,athlete | logo5-white | /attachments/builtin/Logo/logo5-white.png | NULL        | NULL                  | en_US       |                              NULL |            0 |           16 |     2 |                       1 |       2 |                       28 |          NULL |     NULL | NULL      |
|  2 | 777a9c827a986f57524b3bbb415e6191 | 777a9c827a986f57524b3bbb415e6191 | 69ec525c-36c3-d22f-1e2f-380366106ea5 | 777a9c827a986f57524b3bbb415e6191 | NULL          | NULL          | 2011-02-15T11:20:17+00:00 |        NULL |                        2 | NULL         |              1 | NULL                                                                                                                                                             | NULL                                                                            |             |                                           | NULL        | NULL                  | en_US       |                              NULL |            0 |         NULL |     2 |                       1 |       2 |                     NULL |          NULL |     NULL | NULL      |
|  3 | ea835c928f5eb3dd83c17908ae6d8ab4 | ea835c928f5eb3dd83c17908ae6d8ab4 | 23fee447-2bdd-363e-53c6-2897cb6913ce | ea835c928f5eb3dd83c17908ae6d8ab4 | NULL          | NULL          | 2011-07-30T23:39:40+01:00 |           1 |                        3 | NULL         |              1 | NULL                                                                                                                                                             | NULL                                                                            |             |                                           | NULL        | NULL                  | en_US       |                              NULL |            0 |         NULL |     2 |                       1 |       2 |                     NULL |          NULL |     NULL | NULL      |
|  4 | e0314f092d3ec762b36394569d308e1d | e0314f092d3ec762b36394569d308e1d | 11403d6a-8045-60e3-d724-c3406b4a5c7f | e0314f092d3ec762b36394569d308e1d | NULL          | NULL          | 2011-08-11T14:09:23+01:00 |           1 |                        4 | NULL         |              1 | NULL                                                                                                                                                             | NULL                                                                            |             |                                           | NULL        | NULL                  | en_US       |                              NULL |            0 |         NULL |     2 |                       1 |       2 |                     NULL |          NULL |     NULL | NULL      |
| 25 | 015ea7599ae64b7b2df735a0fe28b6b3 | 015ea7599ae64b7b2df735a0fe28b6b3 | be04c5de-e23f-a212-100e-b4f34e97e056 | 015ea7599ae64b7b2df735a0fe28b6b3 | NULL          | NULL          | 2011-11-14T12:49:58+00:00 |           1 |                        5 | NULL         |              1 | NULL                                                                                                                                                             | NULL                                                                            |             |                                           | NULL        | NULL                  | en_US       |                              NULL |            0 |         NULL |     2 |                       1 |       2 |                     NULL |          NULL |     NULL | NULL      |
+----+----------------------------------+----------------------------------+--------------------------------------+----------------------------------+---------------+---------------+---------------------------+-------------+--------------------------+--------------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------+-------------+-------------------------------------------+-------------+-----------------------+-------------+-----------------------------------+--------------+--------------+-------+-------------------------+---------+--------------------------+---------------+----------+-----------+

 

[IgorG]

Record with id = 25 is suspicious and contains this be04c5de-e23f-a212-100e-b4f34e97e056. I'd suggest you remove it.

 

[dalydesign]

That's great thanks. Will Do.

Most appreciated. :O)