Sample Data

I found some sample data and imported it into the database, but the shop component doen't recognize it. Is there some way to refresh the shop and make the data show up?

I have tested hika before, and it was more work than I needed for less than 10 products, but this time I have a client that expects to have more products, and I need to show her how a page full of products looks like.

Thank You Guys!

Your data sample is probably too old.
Here is a new export of the demo website hikashop tables. You should use this one.

Works good!

For database newbies:
The newer Joomla have random prefixes for the tables in the databse. Not all table names begin with jos_ anymore.
Occasionally importing the file in PHPadmin gives a primary key error. Today I got some wierd message about needing to be SuperAdmin. Whatever.

So I edit the file with Text Wrangler to find and replace in the file for the table name prefixes to match my 1.7 joomla tables that hika installed for the component itself. I changed the name of the file to match the prefix of my database, and all was good. I have cpanel on Linus server, so I could just did a restore from backup in the backup part of my cpanel,

Just got this error when trying to import into database.

Can you advise on how to fix.


SQL query:

-- -- テーブルのデータをダンプしています `aq1_hikashop_category` -- INSERT INTO `aq1_hikashop_category` (`category_id`, `category_parent_id`, `category_type`, `category_name`, `category_description`, `category_published`, `category_ordering`, `category_left`, `category_right`, `category_depth`, `category_namekey`, `category_created`, `category_modified`, `category_access`, `category_menu`, `category_keywords`, `category_meta_description`) VALUES (1, 0, 'root', 'ROOT', '', 0, 0, 1, 56, 0, 'root', 0, 0, 'all', 0, '', ''), (2, 1, 'product', 'product category', '', 1, 1, 2, 31, 1, 'product', 0, 1307798875, 'all', 0, '', ''), (3, 1, 'tax', 'taxation category', '', 1, 2, 32, 37, 1, 'tax', 0, 0, 'all', 0, '', ''), (4, 1, 'status', 'order status', '', 1, 3, 38, 49, 1, 'status', 0, 0, 'all', 0, '', ''), (5, 4, 'status', 'created', 'When a customer finishes a checkout, an order is created with the status created', 1, 1, 39, 40, 2, 'created', 0, 0, 'all', 0, '', ''), (6, 4, 's[...]

MySQL said:

#1062 - Duplicate entry '1' for key 1

That's an old package. Please try again. I've updated it with the latest version of the data.

Thank you - but where is the latest data stored?

It's the same link. I've just replaced the file.

so how do I get rid of the old data

JUST GOT ANOTHER ERROR WITH THE NEW FILE

Error

SQL query:

--
-- テーブルのデータをダンプしています `aq1_hikashop_cart_product`
--
INSERT IGNORE INTO `aq1_hikashop_cart_product` ( `cart_product_id` , `cart_id` , `product_id` , `cart_product_quantity` , `cart_product_parent_id` , `cart_product_modified` , `cart_product_option_parent_id` , `test` , `amount` )
VALUES ( 265, 93, 192, 1, 0, 1336100480, 0, NULL , NULL ) , ( 264, 92, 10, 1, 0, 1336015093, 0, NULL , NULL ) , ( 266, 93, 214, 1, 0, 1337377208, 0, NULL , '50' ) , ( 267, 94, 192, 1, 0, 1337623428, 0, NULL , NULL ) , ( 268, 95, 58, 1, 0, 1337623559, 0, NULL , NULL ) ;

MySQL said: Documentation
#1054 - Unknown column 'test' in 'field list'

You will have to delete the hikashop tables in the database before importing the file.

I uninstalled Hikashop - deleted all tables - reinstalled Hikashop - went to imported .... Got the following error.


Error

SQL query:

--
-- テーブルのデータをダンプしています `aq1_hikashop_cart_product`
--
INSERT IGNORE INTO `aq1_hikashop_cart_product` ( `cart_product_id` , `cart_id` , `product_id` , `cart_product_quantity` , `cart_product_parent_id` , `cart_product_modified` , `cart_product_option_parent_id` , `test` , `amount` )
VALUES ( 265, 93, 192, 1, 0, 1336100480, 0, NULL , NULL ) , ( 264, 92, 10, 1, 0, 1336015093, 0, NULL , NULL ) , ( 266, 93, 214, 1, 0, 1337377208, 0, NULL , '50' ) , ( 267, 94, 192, 1, 0, 1337623428, 0, NULL , NULL ) , ( 268, 95, 58, 1, 0, 1337623559, 0, NULL , NULL ) ;

MySQL said: Documentation
#1054 - Unknown column 'test' in 'field list'

Of course.

Do like that:
deleted all hikashop tables -> import

Nicholas - you don't understand - I DID IT ALREADY -

and got the error shown above

That's not possible. The table definition is included in the SQL file. If you get that error, it means that you still have that table in the database before the import and thus, the table from the demo website cannot be created.

Well not really -

Step 1 - uninstall hikashop
Step 2 - delete tables
Step 3 - reinstall hikashop .... at this point the table will have been recreated.

Or do I just delete tables without touching the Hikashop component install.

Ok just deleted the db without uninstalling hika.

data imported except

Products have no images.

Yes, the images are saved in the media/com_hikashop/upload folder, not in the database. You would have to download them directly on our demo website and upload them on your website.
For example:
demo.hikashop.com/media/com_hikashop/upl...tolia_20227750_s.jpg

I tried to add products ...
But it shows ERROR

Warning: include_once(/home/dubota/public_html/new/administrator/components/com_hikashop/types/acl.php) [function.include-once]: failed to open stream: No such file or directory in /home/dubota/public_html/new/administrator/components/com_hikashop/helpers/helper.php on line 783

Warning: include_once() [function.include]: Failed opening '/home/dubota/public_html/new/administrator/components/com_hikashop/types/acl.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dubota/public_html/new/administrator/components/com_hikashop/helpers/helper.php on line 783

Fatal error: Call to a member function display() on a non-object in /home/dubota/public_html/new/administrator/components/com_hikashop/views/product/tmpl/common.php on line 119


Also check the IMage

You are missing some of the files of HikaShop.
You must have had a problem during the installation.

Please try to install again and report any error you might have.
If all goes well, please try again to add products.