Just another Cross-Sell mod (support thread)

[jeking]

My xsell table has 118,516 entries at 4.2MiB. That's That's 75% of my entries and 26% of my size. My banner history is huge so I think I'm going to empty that. I'm really trying to get lean and mean! Any advice is welcome :)

This is a big db. What cache method do you use? Definitely try reducing any tables you can see if that improved performance.

[Doodlebuckets]

This is a big db. What cache method do you use? Definitely try reducing any tables you can see if that improved performance.

How do I check my cache method? In my config.php file? My store was just redone so I'm not sure how my webmaster set it.

I have been emptying a lot of really old stuff. I wish there was a tool to get rid of old orders, customers, banner history, etc prior to a certain date. You know of anything?

[Doodlebuckets]

This is a big db. What cache method do you use? Definitely try reducing any tables you can see if that improved performance.

I have define('SQL_CACHE_METHOD', 'none');
but my admin of 5 years was imported so there may be a lot in there that could be cleared out. I always set my cache to go to file when I did my own design...What difference does it make? So much still to learn :)

[jeking]

How do I check my cache method? In my config.php file? My store was just redone so I'm not sure how my webmaster set it.

I have been emptying a lot of really old stuff. I wish there was a tool to get rid of old orders, customers, banner history, etc prior to a certain date. You know of anything?

It at the end of includes/configure.php called define('SQL_CACHE_METHOD', 'database');

I believe database, file and none are options. If I remember correctly (which is dangerous), file is recommended for small to medium sites and database for large ones. But the database method can cause large databases. I'm not sure why mine is database (set it up too long ago to remember) but it should probably be file.

I'd be a little concerned about an automated way to remove things from the db. I'd think doing it manually, backing up first, is best. That way you know 'exactly' what's being removed.

[Doodlebuckets]

It at the end of includes/configure.php called define('SQL_CACHE_METHOD', 'database');

I believe database, file and none are options. If I remember correctly (which is dangerous), file is recommended for small to medium sites and database for large ones. But the database method can cause large databases. I'm not sure why mine is database (set it up too long ago to remember) but it should probably be file.

I'd be a little concerned about an automated way to remove things from the db. I'd think doing it manually, backing up first, is best. That way you know 'exactly' what's being removed.

I have been manually doing that. Still seems rather large though. I think the xsell table just is what it is and we'll have to deal with it.

[xzistance]

Hey Sheryll,

Have you found a solution for this by chance? I'm getting the same issue. I can add products to cross-sell, but editing/deleting/searching all break on this error. Basically the admin aspect of this is breaking. I'm looked in to the error more and that function just doesn't exist.. pretty ridiculous, but I'm trying to figure out what exactly it was doing and seeing if I can replicate what it should be doing.

Okay, so I got it installed and it was working great, however, when I try to edit current cross sells I get this error:

Fatal error: Call to undefined method RIXsell::db_result_to_string() in /home/diva/public_html/templates/admin/xsell_advanced.php on line 41

[xzistance]

So, I figured this out. Looking around I found post #452, which shows actual code for the init_yclass.php file. I took the functions from the yclass and put them at the bottom of my /admin/includes/classes/xsell_advanced.php file, like so:

/***** START ADDING Y-CLASS METHODS NEVER INCLUDED IN INSTALLATION *****/
    function db_result_to_string($glue, $db_result){
        $temp_array = array();
        if($this->is_obj($db_result,'queryFactoryResult')){
            // We need to clone, because we don't want to touch the real object
            while(!$db_result->EOF){
                $temp_array[] = $db_result->fields['products_'.XSELL_FORM_INPUT_TYPE];
                $db_result->MoveNext();
            }
            $db_result->Move(0);
            $db_result->MoveNext();
        }
        
        return implode($glue,$temp_array);
    }
    
    // This function does not work for all languages! BEWARE
    function array_to_upper(&$entries){
        foreach($entries as $entry){
            $entry = strtoupper($entry);
        }
    }
    
    // http://us3.php.net/manual/en/function.is-object.php#66370
    function is_obj( &$object, $check=null, $strict=true ){
        if (is_object($object)) {
            if ($check == null) {
                return true;
              } else {
                $object_name = get_class($object);
                return ($strict === true)?( $object_name == $check ):( strtolower($object_name) == strtolower($check) );
              }   
          } else {
            return false;
          }
    }
    /***** END ADDING Y-CLASS METHODS NEVER INCLUDED IN INSTALLATION *****/ 

Everything seems to work fine now in the admin area.
Hope this helps.

Hey Sheryll,

Have you found a solution for this by chance? I'm getting the same issue. I can add products to cross-sell, but editing/deleting/searching all break on this error. Basically the admin aspect of this is breaking. I'm looked in to the error more and that function just doesn't exist.. pretty ridiculous, but I'm trying to figure out what exactly it was doing and seeing if I can replicate what it should be doing.

[reeme]

Is this running okay in version 1.3.9b - when I try to install I loose all my admin pages after logon

I do have the same question with 1.3.9B.
Have any one test this module fully through 1.3.9?

BTW: did you install module manager,and which version you have installed?

[Sheryll]

So, I figured this out. Looking around I found post #452, which shows actual code for the init_yclass.php file. I took the functions from the yclass and put them at the bottom of my /admin/includes/classes/xsell_advanced.php file, like so:

Everything seems to work fine now in the admin area.
Hope this helps.

Hi xzistance, thanks for the fix! It semi works for me. I don't know why, but I have two different links for xsell under "catalog" in admin. One is "Cross-Sell Products" and the other is "Advanced Cross-Sell". When I try to edit in "Advanced Cross-Sell", it still breaks but editing in the other one works like a charm.

I honestly haven't played with it for months now since I last posted and finally thought about it again today. Do you have these two links as well in admin? For now I am content with using it under "Cross Sell Products" since it is technically working, but if someone figures out how to fix the admin for "Advanced Cross-Sell" I would like to try to fix that too.

[dropbop]

I uploaded all the files and after that i can't open admin page.

It's just blank white page.

What have i missed during installation? Do you i need to upload any sql patches as i did not do it.

I am having the very same problems as hamid84.

I have gone over it a few times and still getting a blank white admin. Ive been at this for hours. I have installed everything exaxtly as described in the txt files.

I am in need of some help pretty badly cause I have hundreds of products to add to the site and cant access admin to do it.

I have looked back at some of the posts for a solution, but all the ones posted dont seem to be working for me.

I will hang on for a reply before I go trying to remove all the files and all the stuff in the database.

If anyone can figure this out I will gladly give a years free hosting or something,

the site is legavenuedropship.com the admin folder is still as normal so you will be able to see what i mean if you try and go to admin. not even a log in box, nothing!