-- 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.