Just another Cross-Sell mod (support thread)

[yellow1912]

@HeathenMagic
Try to download JAXSell/admin/control_panel/includes/functions/extra_functions/xsell_advanced.php, see if that fixes the problem. If not, please take a screenshot and send to me.

[HeathenMagic]

Hello there,

I just went to the download location and downloaded that file and uploaded to the server. I have the same thing going on. It just has those errors I quoted and the rest is all blank space. I will have a play around and see if I can notice any pattern, as two of the edit buttons work for two cross sells.

Heathenmagic

[yellow1912]

Hello there,

I just went to the download location and downloaded that file and uploaded to the server. I have the same thing going on. It just has those errors I quoted and the rest is all blank space. I will have a play around and see if I can notice any pattern, as two of the edit buttons work for two cross sells.

Heathenmagic

Which edit buttons? The ones under Current Cross Sells?
Does this only happen for some specific products? Or does this happen randomly?
Do you notice anything special? (Products have different product types, etc...)

[HeathenMagic]

Not sure just yet, looking through them. Noticed this when you try and delete any product cross sell:-

1054 Unknown column 'Earrings' in 'where clause'
in:
[delete from zen_products_xsell where products_id= Earrings]
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 have used the sql patches as included in the mod. I don't know if this error means anything?

Heathenmagic

[yellow1912]

Are you using "model" ?

[yellow1912]

Try to download this file again and reupload:
JAXSell/admin/control_panel/includes/functions/extra_functions/xsell_advanced.php (new version)

[HeathenMagic]

Hello again,

It has made some of the ones that didn't work, work with the edit button. Can't really see a pattern now. But something has helped it along.

Regards,

Heathenmagic

[yellow1912]

Hello again,

It has made some of the ones that didn't work, work with the edit button. Can't really see a pattern now. But something has helped it along.

Regards,

Heathenmagic

And does the delete work now?

yellow1912

PS: To some of you who may have missed the previous page, there is a new version of JAXS now:
https://svn.rubikintegration.com/zen...sell_advanced/

[HeathenMagic]

Hello there,

The delete button still does the same thing at the moment.

Regards,

Heathenmagic

[yellow1912]

If you still get this error:

1054 Unknown column 'Earrings' in 'where clause'
in:
[delete from zen_products_xsell where products_id= Earrings]
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. 

That means you have NOT updated your JAXSell/admin/includes/functions/extra_functions/xsell_advanced.php to the latest version.
With the code inside the latest version of this file, there is no way you can get the same error.