Virtuemart error after installation

Hello!

I've just installed the ecommerce template, I have problems in the virtuemart component:

1. When I click to the Product categories I cannot see any categories, and I get an error message in the top of the virtuemart mnodul: vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_categories_hu_hu' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `sg3yi_virtuemart_categories_hu_hu` l JOIN `sg3yi_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `sg3yi_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name DESC

2. When I click on the Products, I cannot see any products, and I get an error message:


vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_products_hu_hu' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `sg3yi_virtuemart_products_hu_hu` as l JOIN `sg3yi_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 10
vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_categories_hu_hu' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `sg3yi_virtuemart_categories_hu_hu` l JOIN `sg3yi_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `sg3yi_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC

3. When I click on the Custom fields I get an error message:

vmError: The field with id 5 and title I'm a Child link is not longer valid, please delete it from the list
vmError: The field with id 10 and title User Comment is not longer valid, please delete it from the list

4. Inventory is empty, and the error message: vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_products_hu_hu' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `sg3yi_virtuemart_products_hu_hu` as l JOIN `sg3yi_virtuemart_products` AS p using (`virtuemart_product_id`) WHERE ( p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 10

5. Reviews ans Ratings is empty, and the error message: vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_products_hu_hu' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS r.*,p.`product_name` FROM `sg3yi_virtuemart_ratings` AS `r` JOIN `sg3yi_virtuemart_products_hu_hu` AS `p` USING (`virtuemart_product_id`) ORDER BY created_on DESC LIMIT 0, 10

5. Ordesr: vmError: exeSortSearchListQuery Table 'taijihu_vm25.sg3yi_virtuemart_paymentmethods_hu_hu' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,u.email as order_email,pm.payment_name AS payment_method FROM sg3yi_virtuemart_orders as o LEFT JOIN sg3yi_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN sg3yi_virtuemart_paymentmethods_hu_hu as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 10

etc...

I've installed the sample datas, everything were fine through the installation process.
Here is the page: taiji.hu/taiji.hu

Can you help me?

Susan

Go to extension manger, database tab if you see some button syaing something like click here to repair database click on it.

That problem is not rear, maybe you will have to create table sg3yi_virtuemart_categories_hu_hu by replicating table sg3yi_virtuemart_categories directly in db, same stands for other tables reported by errors as missing

Hello!

Under Extension manager/Warnings I see following:
The PHP temporary directory is not set
The PHP temporary directory is the directory that PHP uses to store an uploaded file before Joomla! can access this file. Whilst the directory not being set isn't always a problem, if you are having issues with manifest files not being detected or uploaded files not being detected, setting this in your php.ini file might fix the issue.

But there is no repair possibility.

I've created the table, but yje error messeages still there>
For example Product categories:

vmError: exeSortSearchListQuery Unknown column 'l.category_description' in 'field list' SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `sg3yi_virtuemart_categories_hu_hu` l JOIN `sg3yi_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `sg3yi_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name DESC

Go to global configuration and set tmp path to ./tmp and log path to ./logs

Read that message - do you have that table in database and if you have it do you have that columns reported missing