Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

JoomSEF not creating the SEF URL of products
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 4 (Joomla 1.6/1.7/2.5+ compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.

TOPIC: JoomSEF not creating the SEF URL of products

Re: JoomSEF not creating the SEF URL of products 10 years, 4 months ago #41874

I have the same problem
The topic has been locked.

Re: JoomSEF not creating the SEF URL of products 10 years, 4 months ago #41892

Hi tuthenstein,

The problem is the latest update virtuemart extension of JoomSEF... is wrong.

I have solved the problem changing the file

your web/ components / com_sef / sef_ext / com_virtuemart.php and com_virtuemart.xml using an older version... and all works properly

See if Artio instead of complaining that it's not their problem they fix it in a future release... took almost 3 weeks with the problem until I found the cause ... and artio badly for their support

Cheers,
Manuel
Last Edit: 10 years, 4 months ago by mdelreal.
The topic has been locked.

Re: JoomSEF not creating the SEF URL of products 10 years, 4 months ago #41893

I'm having the same problem but don't have an earlier version to fall back to. However, you posting which files you changed helped me find the problem.

Looking through the code in com_virtuemart.php, there is a section where it looks up the product info from the database. The logic always assumes that the table '#__virtuemart_products_en_gb' exists. In my case, I'm using the language en_US, and the table I mentioned does NOT exist in the database.

 
if ($table == '#__virtuemart_products_en_gb') {
// This is EN
$query = "SELECT `p`.`product_sku`, `l`.`product_name`, `l`.`slug`, `l`.`{$descrow}`";
$query .= " FROM `#__virtuemart_products` AS `p`";
$query .= " INNER JOIN `{$table}` AS `l` ON `p`.`virtuemart_product_id` = `l`.`virtuemart_product_id`";
$query .= " WHERE `p`.`virtuemart_product_id` = '{$productId}'";
}
else {
// Join also EN table for fallback
$query = "SELECT `p`.`product_sku`, COALESCE(`l`.`product_name`, `le`.`product_name`) AS `product_name`,";
$query .= " COALESCE(`l`.`slug`, `le`.`slug`) AS `slug`, COALESCE(`l`.`{$descrow}`, `le`.`{$descrow}`) AS `{$descrow}`";
$query .= " FROM `#__virtuemart_products` AS `p`";
$query .= " LEFT JOIN `#__virtuemart_products_en_gb` AS `le` ON `p`.`virtuemart_product_id` = `le`.`virtuemart_product_id`";
$query .= " LEFT JOIN `{$table}` AS `l` ON `p`.`virtuemart_product_id` = `l`.`virtuemart_product_id`";
$query .= " WHERE `p`.`virtuemart_product_id` = '{$productId}'";
}
 


This is the logic in the code. My language is not en_US, so it's going to skip the first block and fall to the 'else' block which tries to run a query that joins with the non-existent '#__virtuemart_products_en_gb' table. The query fails and so never returns any information and therefore the error log message that it cannot find the Product ID.

I changed the first line above to read:
if ($table == '#__virtuemart_products_en_gb' || $table == '#__virtuemart_products_en_us') {

This makes it work for me, but it is not the proper solution.

I'm posting my finding here to help others with the same problem, and so ArtIO can put a fix in the next release.
The topic has been locked.

Re: JoomSEF not creating the SEF URL of products 10 years, 4 months ago #41894

I hope this example will serve to be heard from Artio users and do not try to redirect to a paid support.

There are times that the problems are caused by them and not for inexperienced users who do not know how to use their products
The topic has been locked.

Re: JoomSEF not creating the SEF URL of products 10 years, 4 months ago #41895

mdelreal and kingramon0 thank you for your kind effort.

I have purchased many joomla products but I think this is the worst support (and also product).

I have aprrocahed to paypal for refund and artio canceled my order status. But no refund yet! I am waiting for a refund.

I am using default joomla sef and seoboss for meta tags etc... half price, double performance and no headache.

I do not want to see any artio name.

If you canceled my order status, then pay my money back. It is so simple.
The topic has been locked.

Re: JoomSEF not creating the SEF URL of products 10 years, 3 months ago #41986

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,

The problem should be fixed in the latest version of VM extension (3.0.18) released on Friday.
I'm sorry it took so long.
ARTIO Support Team
The topic has been locked.
User Login Empty