Welcome, Guest
Username: Password: Remember me

TOPIC: Sample Data

Sample Data 2 years 9 months ago #36554

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!

File Attachment:

File Name: Screen_Shot_2012_01_24_at_5.png
File Size: 54283
Screen_Shot_2012_01_24_at_5.png
The administrator has disabled public write access.

Re: Sample Data 2 years 9 months ago #36593

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
Your data sample is probably too old.
Here is a new export of the demo website hikashop tables. You should use this one.

File Attachment:

File Name: demo.zip
File Size: 183287
The administrator has disabled public write access.

Re: Sample Data 2 years 9 months ago #36599

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,
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50985

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
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50991

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
That's an old package. Please try again. I've updated it with the latest version of the data.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50992

Thank you - but where is the latest data stored?
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50994

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
It's the same link. I've just replaced the file.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50995

so how do I get rid of the old data
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50996

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'
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #50998

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
You will have to delete the hikashop tables in the database before importing the file.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51002

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'
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51004

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
Of course.

Do like that:
deleted all hikashop tables -> import
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51006

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

and got the error shown above
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51008

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
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.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51016

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.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51017

Ok just deleted the db without uninstalling hika.

data imported except

Products have no images.
The administrator has disabled public write access.

Re: Sample Data 2 years 5 months ago #51108

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
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
The administrator has disabled public write access.

Re: Sample Data 2 years 3 months ago #57772

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
Attachments:
The administrator has disabled public write access.

Re: Sample Data 2 years 3 months ago #57774

  • nicolas
  • nicolas's Avatar
  • NOW ONLINE
  • Posts: 39428
  • Thank you received: 4282
  • MODERATOR
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.
The administrator has disabled public write access.
Time to create page: 0.326 seconds
Powered by Kunena Forum