- Posts: 10
- Thank you received: 0
Chrome user agent overriding my css for CP
- Zian
- Topic Author
- Offline
- New Member
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.
- Zian
- Topic Author
- Offline
- New Member
- Posts: 10
- Thank you received: 0
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
Please Log in or Create an account to join the conversation.
- Zian
- Topic Author
- Offline
- New Member
- Posts: 10
- Thank you received: 0
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
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
- Posts: 1122
- Thank you received: 163
Unfortunately this is bad news for your site.It seems that Virtuemart 2 has transferred some of the columns from virtuemart_products to virtuemart_products_sl_si.
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)
Please Log in or Create an account to join the conversation.
- Zian
- Topic Author
- Offline
- New Member
- Posts: 10
- Thank you received: 0
Best regards,
Zian
Please Log in or Create an account to join the conversation.