How to set up related products

[paulsch]

Now it works for me.
The Problem was the Version of the Database. My Version was 3.23.58 . I updatet the
Database to Version 4.1.22 and it works great. Now i can start with my shop.
If you make a update to an new Version be sure that you have a Backup of your Database, downgrade is not possible only if you drop the Database and import the older one again.

[samoht]

it makes sense that the AJAX wont speak to the server (or will get stuck while connecting) if the server is running old versions of MySql and php. The developers could probably write some backwards compatible script - but it would be better for people on there local servers to update there server software.

[Mackelito]

Problem is still there for me... I have been running Database Version: 4.1.21-standard and PHP Version: 5.2.3.

Could it be fixed by upgrading from version 4.1.21 to 4.1.22?

[Tachikoma]

Ok, so on hostgator where related products work, I have:

Apache version 1.3.37 (Unix)
PHP version 4.4.4
MySQL version 4.1.22-standard

And on My server, where it does not, I have:

Apache/1.3.34
PHP/4.4.4
MySQL 3.23.33

Based on these alone, could it be that I need a more recent version of MySQL?

[Mackelito]

hmmm... perhaps that could be the problem.. but it would seem strange to me that basic fuctions in VM would require such a "new" version of mysql... most of the hosts still run MySQL 4 right?

[Mackelito]

If this is the problem.. is there a workaround if I can´t get my host to update the mysql?

[Mackelito]

perhaps not to use AJAX?

[Mackelito]

Any ideas?

[Tachikoma]

I didnt even touch this this weekend. Hopefully tomorrow I can have more.

[jaddi01]

*Bump*

Any new developments?  Upgrading our SQL if that is the solution, is pretty much a no no for us.  So any other suggestions would be welcomed.

[Mackelito]

So strange... I tried installing it on another account... same server... no problem???

This lead me to think something was wrong with the files.. perhaps an error when uploading but I re uploaded the files and still the same issue...

[Mackelito]

On the site that dont work we used CVSimproved to import from another VM shop (version 1.0)...

Could that be the problem? Perhaps some database related issue?

[maxmillion]

Hi Guys, just wanted to share my feedback here.
I had this same issue, Related Products just wont work until I typed in the full category name ( just pick any name from your existing categories ) like Music, Speakers, etc, whatever you got!

Type in the full category name in the related products search field and it should automatically load all products available in that category for you to select. Just make sure the full name word is typed and no spelling mistakes.

I spent about 2 days banging my head here and the solution was right in front of me without any coding / debugging required.

I hope this helps!
Worked for me.
Thanks 

[Mackelito]

tried it.. no good

[chrisb123]

You're admin session may have timed out, try logging back into your admin panel and go straight to the option and try again