This is a big db. What cache method do you use? Definitely try reducing any tables you can see if that improved performance.Quote:
Originally Posted by Doodlebuckets
Printable View
This is a big db. What cache method do you use? Definitely try reducing any tables you can see if that improved performance.Quote:
Originally Posted by Doodlebuckets
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.Quote:
Originally Posted by jeking
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?
I have define('SQL_CACHE_METHOD', 'none');Quote:
Originally Posted by jeking
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 :)
It at the end of includes/configure.php called define('SQL_CACHE_METHOD', 'database');Quote:
Originally Posted by Doodlebuckets
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.Quote:
Originally Posted by jeking
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.
Quote:
Originally Posted by 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.PHP Code:/***** 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 *****/
Hope this helps.
Quote:
Originally Posted by xzistance
I do have the same question with 1.3.9B.Quote:
Originally Posted by MikeyG
Have any one test this module fully through 1.3.9?
BTW: did you install module manager,and which version you have installed?
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.Quote:
Originally Posted by xzistance
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.
I am having the very same problems as hamid84.Quote:
Originally Posted by 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!