Contributions

Features (Category Index)
Search: 

PEF with language support

Add language support to 'Products Extra Fields'

Expand All / Collapse All

Couple of bugfixes Cormac Bracken 5 Dec 2004

1)
I got an SQL error message, "can't create table". It seems to be because my original OSC tables are MyISAM type, and the SQL code here specifies "InnoDB" (so a specified foreign key doesn't match). Solution - I removed the type line. I'm not a db expert, but I assume my original tables were MyISAM because it's my host's server default.. I also guess that it's not absolutely necessary to specify the table type here.

2)
In point 2.2.3, item 6, we are instructed to search for a code fragment that ends with:
...vspace="5"');
but in fact the relevant code line ends with:
vspace="5"') . $pInfo->products_description; ?></td>
The inserted code needs to go between the ; and the ? So I've updated the instructions to look for the point up to the ; . It's a bit messy, because now you must insert code before the end of the physical line, which "feels" wrong. But it should work ok, providing you follow the instructions very precisely.
I assume this was caused by a minor update to the main OSC code.

3)
In point 2.2.7 (English language file), the new variable name is given as BOX_CATALOG_PRODUCTS_EXTRA_FIELDS, it should be BOX_CATALOG_PRODUCTS_EXTRA_FIELDS_WITH_LANGUAGE. The French edits in 2.2.8 work fine :-)

Again, I'm not experienced in either MySQL or PHP, these changes are just what I needed to resolve my own install. Hope they help.

Thanks for a very useful contribution,
Cormac

PEF with language support Christophe CRIER 8 Nov 2004

Note: Contributions are used at own risk.