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!

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

Thank you - but where is the latest data stored?

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'

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'

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

and got the error shown above

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.

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