Chrome user agent overriding my css for CP

More
11 years 8 months ago #1258 by Zian
Hi Andrea,

I'm resurrecting this topic from the dead because I still haven't been able to get it working with VM :( Could you please try to do it as I seem to be stuck and cannot get it to work properly..

Thanks,

Zian

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

More
11 years 8 months ago - 11 years 8 months ago #1276 by Zian
Okay so i got it to work in VM so I can add the tags to the products and it saves them. But if I search for the item it still doesn't show up :/

As an example if you choose Kleers under "Proizvajalec" it should show one of the Kleers products but it throws out an error not found... site found at enigma.golar.net

Also when I try to enter the "Assign custom properties" I get an error

500 - An error has occurred.

DB function failed with error number 1146
Table 'anzetb.jos_vm_product' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS c.product_id AS id ,c.product_name as title ,c.product_publish as state ,'' AS category FROM jos_vm_product AS c WHERE 1 AND c.product_publish >= 0 ORDER BY c.product_name LIMIT 0, 20


What I can see is, it added the DB name (anzetb) as a prefix. Any thoughts on this?

Thanks in advance,

Zian
Last edit: 11 years 8 months ago by Zian.

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

More
11 years 8 months ago - 11 years 8 months ago #1277 by Zian
It seems that Virtuemart 2 has transferred some of the columns from virtuemart_products to virtuemart_products_sl_si.

So the fields are now split betwen two tabels...

virtuemart_products_sl_si contains:
title
titlealias
id
introtext
fulltext

and virtuemart_products contains:
id
catid
created
state

I've attached my version of the connector. Could you please take a look at it and help me figure out where I went wrong?

www.mediafire.com/?p6ny2zot9xlatf4

When I use it it says:

DB function failed with error number 1054
Unknown column 'c.published' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS c.virtuemart_product_id AS id ,c.product_name as title ,c.published as state ,'' AS category FROM jos_virtuemart_products_sl_si AS c WHERE 1 AND c.published >= 0 ORDER BY c.product_name LIMIT 0, 20


Zian
Last edit: 11 years 8 months ago by Zian.

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

More
11 years 8 months ago - 11 years 8 months ago #1278 by andrea_4g
Replied by andrea_4g on topic Chrome user agent overriding my css for CP

It seems that Virtuemart 2 has transferred some of the columns from virtuemart_products to virtuemart_products_sl_si.

Unfortunately this is bad news for your site.

Custom Properties do not support that "2-tables-split-fields" configuration.

A contentent element connectors maps 2 tables only:
1 content table
1 category table

(BTW: the SQL error means that CP is looking for a field named 'published' into 'jos_virtuemart_products_sl_si' table, which doesn't exists)
Last edit: 11 years 8 months ago by andrea_4g.

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

More
11 years 8 months ago #1279 by Zian
Thanks for the reply Andrea, even if it is bad news for me :/ We'll try to find another way to acomplish this then :)

Best regards,

Zian

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

Time to create page: 0.144 seconds