Im using Version 2.0.1.1
I deleted 500 products via the admin > Products, filtered to find the ones i needed then hit the delete button. Done, i may have even deleted another 200, im not sure. So 500 - 700 products were deleted. Now every time i go back to ADMIN>Products. The screen/List of products will load, but then the entire site crashes. So if I try to load any page front end or back end, the wheel just spins and nothing loads. I know i have my server settings set to run for a long time to allow such long operations. But my point is that something now from deleting those products, in a 95,000 product database, is now causing this problem. Any ideas?
vitalvintage,
Use this to report some information as to get a clue to what is hapening at the time - http://www.randemsystems.com/support/op ... perations/
BTW, what are your memory settings?
Deleting that many products should be done at the database level not at the software level...
Use this to report some information as to get a clue to what is hapening at the time - http://www.randemsystems.com/support/op ... perations/
BTW, what are your memory settings?
Deleting that many products should be done at the database level not at the software level...
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
What happened to my previous posts????
I fixed my problem...
I could load my Admin>Catalog>Product Page
But then, after two large deletions of products...
that is where my site would crash and After opening my product page from the admin... my site is crashed front and back. And crashed until several minutes.. 5 to 10 had passed. when my site was back alive again. i could access all areas again. until i loaded the admiin>cataalog>product page.. again the page would load... my list of 100 products (as set in the settings for admin side) but at that point my site would again be crashed until the timeout im sure expired in my server settings 5 to ten minutes later and then my site would be back live again.
I fixed my problem...
I could load my Admin>Catalog>Product Page
But then, after two large deletions of products...
that is where my site would crash and After opening my product page from the admin... my site is crashed front and back. And crashed until several minutes.. 5 to 10 had passed. when my site was back alive again. i could access all areas again. until i loaded the admiin>cataalog>product page.. again the page would load... my list of 100 products (as set in the settings for admin side) but at that point my site would again be crashed until the timeout im sure expired in my server settings 5 to ten minutes later and then my site would be back live again.
Well it sounds like the database was crashing.
Your previous post talked about adding some code to the index which I removed because it was a bad idea. Not quite sure why that should have fixed anything other than you disabled vQmod from working so no vQmods would run. That then leads me to believe that maybe you had some vQmod script that was causing a problem and by disabled vQmod completely, you in-turn disabled that one vQmod script. But you shouldn't need to disable vQmod, you simply need to find which file in the vqmod/xml folder was causing the issue if that was indeed the problem.
Alternatively, it may be that your db can't load all 100 items at once and maybe you should drop it to 50 and see if that is any better. The deleting of 500 products might very well have been a coincidence and the extra db processing that was needed set off some thresholds within the database process.
Your previous post talked about adding some code to the index which I removed because it was a bad idea. Not quite sure why that should have fixed anything other than you disabled vQmod from working so no vQmods would run. That then leads me to believe that maybe you had some vQmod script that was causing a problem and by disabled vQmod completely, you in-turn disabled that one vQmod script. But you shouldn't need to disable vQmod, you simply need to find which file in the vqmod/xml folder was causing the issue if that was indeed the problem.
Alternatively, it may be that your db can't load all 100 items at once and maybe you should drop it to 50 and see if that is any better. The deleting of 500 products might very well have been a coincidence and the extra db processing that was needed set off some thresholds within the database process.
I see your point...
I believe it maybe from either the SEO mod
or
xml mod
Ive noticed both not showing in my admin side panel. so obviously those lines of code in the index.php files were not there on fresh load and as such there was the break down probably between one of the two, my guess first would be the seo.
I believe it maybe from either the SEO mod
or
xml mod
Ive noticed both not showing in my admin side panel. so obviously those lines of code in the index.php files were not there on fresh load and as such there was the break down probably between one of the two, my guess first would be the seo.
Forgot to add this to the admin... index.php
so what ever causing the issue must be a the vqmod extensions.
//VirtualQMOD
require_once('../vqmod/vqmod.php');
VQMod::bootup();
// VQMODDED Startup
require_once(VQMod::modCheck(DIR_SYSTEM . 'startup.php'));
so what ever causing the issue must be a the vqmod extensions.
//VirtualQMOD
require_once('../vqmod/vqmod.php');
VQMod::bootup();
// VQMODDED Startup
require_once(VQMod::modCheck(DIR_SYSTEM . 'startup.php'));
So immediately after adding that line back, thus as you said re-enabling vqmod. The problem begins again. So now i guess ill back track to distinguesh between the two extensions i believe that may be causing the issue.
I can not get your debug file to save with my info:
you say to replace the save path on two different lines and i can not get it to save my info.
and for all these hours later i still have no idea how, why or which extension is causing the problem. ive tried taking out all the vqmod>xml fiiles and the problem remains.. ive tried lowering the number of items to be displayed in admin settings to only 20, and the problem remains.
you say to replace the save path on two different lines and i can not get it to save my info.
and for all these hours later i still have no idea how, why or which extension is causing the problem. ive tried taking out all the vqmod>xml fiiles and the problem remains.. ive tried lowering the number of items to be displayed in admin settings to only 20, and the problem remains.
You are talking to me, yes?
What is your root path?
You have to have VQMOD working for it to work?
What is your root path?
You have to have VQMOD working for it to work?
NEVER take serious; anyone who gives negative impact statements with no ABSOLUTE proof!
OpenCart Helpful Information * Upgrade 1.5 to 2.1 * Upgrade 2.1 to 2.2
"Why do people NEVER have enough time to do it right but ALWAYS enough time to do it over?"
DO NOT EVER GIVE SOMEONE YOU DON"T KNOW ADMIN ACCESS TO ANYTHING!
I am NOT affiliated with OpenCart
/ var / www / vhosts / vitalvintagecoalition.com / httpdocs / vvctech/
I have finally found out that it is my xml sitemap generator that is the problem.
I have finally found out that it is my xml sitemap generator that is the problem.
Who is online
Users browsing this forum: No registered users and 73 guests
