Tried to migrate store to another domain

  • Posts: 146
  • Thank you received: 2
10 years 3 months ago #199554

-- url of the page with the problem -- : www.modelmisconduct.com
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- Error-message(debug-mod must be tuned on) -- : Warning: vsprintf(): Too few arguments in /home/intelli7/public_html/model/libraries/joomla/language/text.php on line 92

I wanted to move my store from one domain to another. The newsite already had hikashop (and hikamarket, not sure if that matters) already installed. I originally just tried to import the products, but realized I would have to redo all my settings as well.

Instead, I exported all the tables from the old site. Renamed all existing hikashop tables on the new site to newtemp, then imported the tables from the old site. I then renamed the table prefix to match the original old site's database name.

I am getting the following error message, when clicking on a product in the backend:

1054 Unknown column 'field_products' in 'where clause' SQL=SELECT * FROM model_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,21,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,14,%' OR field_categories LIKE '%,21,%')))AND (field_products="" OR field_products LIKE '%,253,%') ORDER BY a.`field_ordering` ASC

Also getting the following server error, though I am not sure if it is related:
Warning: vsprintf(): Too few arguments in /home/intelli7/public_html/model/libraries/joomla/language/text.php on line 92

Also not sure it it matters, but for some reason, a table from the old site called menu was imported, even though I double checked and only exported hikashop tables. I tried to rename that table, but sql rejected, due to a duplicate table in the new site.

Any ideas what I did wrong?

I attached the .sql export of the old site, in case that helps.

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13673
  • MODERATOR
10 years 3 months ago #199636

Hi,

That's normal. It means that your 2 websites don't have the same version of HikaShop.
After you do that migration of the tables, you need to install the HikaShop install package of the latest version on the new website so that it can add the missing things in the database, synchronize the users etc.

Please Log in or Create an account to join the conversation.

  • Posts: 146
  • Thank you received: 2
10 years 3 months ago #199802

Ok. Upgraded and that error went away. Went to export the products to change some descriptions and had a big error page. I tried to save the entire page in a screenshot for your review, but it crashes my screen capture tool it's so big. I have two clips that look representative of the errors.

It looks like the page generated the export directly on the page, rather than generating a file.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13673
  • MODERATOR
10 years 3 months ago #199888

Hi,

Turn off the "error reporting" option of the Joomla configuration and try again. It should then work properly.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum