Artist Sidebox

[shen]

OK followup on that.
I installed the sidebox without bothering with the SQL.
It works for artists with only one release in my catalog, but if an artist has multiple releases the customer is taken to the main page.
(see ethnosuperlounge.com/eslshop if you like)

[jbible]

Maybe its with 1.3.7

On mine when an artist has multiple titles they appear in a list when selected.

For instance...

goto : http://www.experimedia.net/
and select 'jeremy bible & jason henry' from the artists dropdown box.

[jbible]

Now next on my wish list for an artist sidebox......
1. multiple artists per product
2. syncronization of artists sidebox and product availability (ie: when a product of a certain artist is sold out it is automatically remitted from the sidebox...ie2: or rather...the sidebox only lists artists of in stock products)

[morcom]

OK followup on that.
I installed the sidebox without bothering with the SQL.
It works for artists with only one release in my catalog, but if an artist has multiple releases the customer is taken to the main page.
(see ethnosuperlounge.com/eslshop if you like)

I'm running 1.3.8 and also couldn't run the SQL patch but find that the side box seems to work ok at the moment.
However, the box has the title of "BOX_HEADING_RECORD_ARTISTS".
With my VERY limited knowledge I found an entry on line 38 of the "artists.php" file which looks like this
$title = '<label>' . BOX_HEADING_RECORD_ARTISTS . '</label>';
When I try and alter the title - disaster, so I quickly restored as above.
Can anyone please point me in the right direction for a fix?

[Silver Kamel]

Some weeks ago I posted a zip file with all the files I am using and the quite simple changes to the sql database. If the sql routine you are trying to run isn't working, I suggest adding the fields mentioned before manually.. It worked for me.

Bless and stay healthy... Kamel

[BlessIsaacola]

Not sure if someone got this working but the SQL is wrong. This is the SQL included with the mod but it's not working. Table zencart doesn't exist.

INSERT INTO `zencart`.`exp_get_terms_to_filter` (
`get_term_name` ,
`get_term_table` ,
`get_term_name_field`
)
VALUES (
'artists_id', 'TABLE_RECORD_ARTISTS', 'artists_name'
);

[BlessIsaacola]

Here is the correct SQL:

INSERT INTO `get_terms_to_filter` (`get_term_name`, `get_term_table`, `get_term_name_field`) VALUES
('artists_id', 'TABLE_RECORD_ARTISTS', 'artists_name');

[impalor]

OK followup on that.
I installed the sidebox without bothering with the SQL.
It works for artists with only one release in my catalog, but if an artist has multiple releases the customer is taken to the main page.
(see ethnosuperlounge.com/eslshop if you like)

you need to run sql file.
INSERT INTO exp_get_terms_to_filter` (
`get_term_name` ,
`get_term_table` ,
`get_term_name_field`
)
VALUES (
'artists_id', 'TABLE_RECORD_ARTISTS', 'artists_name'
);

you might have get_terms_to_filter instead of exp_get_terms_to_filter.

i also have the same issue and after i run the sql everything was perfect.

[osmizk]

This SQL worked for me.

INSERT INTO `get_terms_to_filter` (
`get_term_name` ,
`get_term_table` ,
`get_term_name_field`
)
VALUES (
'artists_id', 'TABLE_RECORD_ARTISTS', 'artists_name'
);