Shopping Basket

 x 

Cart empty


Log In

Find Us Elsewhere

SSL

Forum Search

Keyword

Errorr SQL 1064

  • jpbl
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 years 3 months ago #3163 by jpbl
Errorr SQL 1064 was created by jpbl
Hello,
If i create a feed select only some categories (not all) ---> Error Sql with the label language.
If i want change category map or product overwrite, the component does not explore my spanish categories/products, only the example categories/products (english).

Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #3164 by boggler
Replied by boggler on topic Errorr SQL 1064
Hello, try setting the feed language option to your shop language, it may be that your default language is set as english, which is why there are problems picking up the correct language.

Also, please could you repost the screenshot of the SQL error message but at a high enough resolution to be able to read it, I would like to see what it says, but I cannot read it.

Or just tell me what the SQL error message says exactly, it would be very helpful.

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago #3165 by boggler
Replied by boggler on topic Errorr SQL 1064
Actually, could you send me the login details for an administrator on your site? I will fix this myself. We do our best to make the feed work properly with any site language, but it can get very complex and the only way to be sure it all works is to try it out on an actual site.

Please send the log in (if you wish) to the address from which you received your order confirmation, that is customer at spiral scripts.

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago - 4 years 3 months ago #3166 by boggler
Replied by boggler on topic Errorr SQL 1064
Actually we have found the source of the SQL error now - thanks for notifying us. If you wish to fix it yourself you can edit the file components/com_googlebasexml/models/googlebasexml.php, line 245change
			//get the category mapping
			if(!empty($category))
			{
				$query = "SELECT * FROM #__googlebasexml_cats WHERE virtuemart_category_id IN('".$category."')";
				//$query = "SELECT * FROM #__googlebasexml_categories";
				
			}
			else
			{
				$query = "SELECT * FROM #__googlebasexml_cats";
			}
		    $db = $this->getDBO();
			if(!empty($this->vmlang))
			{
				$query .= " WHERE language=".$db->quote($this->vmlang);
			}

to
		    $db = $this->getDBO();

			//get the category mapping
			if(!empty($category))
			{
				$query = "SELECT * FROM #__googlebasexml_cats WHERE virtuemart_category_id IN('".$category."')";
				if(!empty($this->vmlang))
				{
					$query .= " AND language=".$db->quote($this->vmlang);
				}
				
			}
			else
			{
				$query = "SELECT * FROM #__googlebasexml_cats";
				if(!empty($this->vmlang))
				{
					$query .= " WHERE language=".$db->quote($this->vmlang);
				}
				
			}

We will release a new version with this fix very soon, probably tomorrow. We will also add some improvements to the selection of the product overrides and categories so that it is possible to see them in all languages. However I think that you can probably solve this problem yourself by making sure that your language is the default language in your Virtuemart configuration.
Last edit: 4 years 3 months ago by boggler.

Please Log in or Create an account to join the conversation.

  • jpbl
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 years 3 months ago #3172 by jpbl
Replied by jpbl on topic Errorr SQL 1064
Solved.
Excellent and fast support.

Thanks.

Please Log in or Create an account to join the conversation.

Moderators: boggler
Time to create page: 3.381 seconds

Donate to Us

If you like our extensions, consider making a donation to say thanks.