Cross-Sell Advanced!

[pivey]

I get this error after installing the contrib:

1146 Table 'testbase.table_products_xsell' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from products p, products_description pd, TABLE_PRODUCTS_XSELL px where p.products_id = pd.products_id and p.products_id = px.products_id and pd.language_id ='1' group by p.products_id]


Fresh 1.3.5 install, No additional Mod's..no modifications
Database created succesful, i checked, is there....

[DrByte]

pivey, sounds like you're missing the file that contains the define() statement for TABLE_PRODUCTS_XSELL, which likely looks like this:

define('TABLE_PRODUCTS_XSELL', 'products_xsell');

and should be in the extra_datafiles folder in the contribution's files

[pivey]

Yes, that exactly is the error caused.
The file is already on the ftp. But I just realized that it is corrupt.
Whatever I try, can't make it work.

Can't open the file in editor either. Have downloaded the zip 10 times, extracted 10 times. I can only open the file only as soon as I extract the zip. Seems that something goes wrong during or after upload to FTP.

First time such a stupid bug?
Has anyone dealed with such an error?

[DrByte]

Well ... try creating a new file of similar name and content, and upload that.

maybe try a new zip program, or a different computer?

[pivey]

Thank you doctor.
I will do that....always this Tach Crash...@^*)...

[jhosford]

Hi guys,

Everytime I try to patch my database (Using the normal admin screen) I get the following errors:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true','false'), ', now())' at line 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array('true','false'), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I've downloaded both V1.3 and Advanced and it does this with both sql files. Being absolutely new to sql databases, I'm nowhere near qualified to troubleshoot this one. Any help is appreciated.

Jon

[jhosford]

Hello,

Thanks for the help...

I fixed this by editing the database directly in MySQL. Never did figure out the problem.