Hello,
I have my virtuemart site working for 2 years without any problem. Last week i had a problem that i can't saw the list of orders. I resolve this problem updating the tables. (The problem has something about one missing table...user middle name i think).
But right now when i try to access to list of products i have about 90s of waiting. Only in this page i have problems. I already insert a new product and without any problems. If i save is fast but if i "save and quit" i have to wait the 90s.
Can everyone help me? I have a lot of new products to put and i can't because of that.
If you need access to my site admin please advise.
Thank you.
I've given up on trying to make guesses. http://forum.virtuemart.net/index.php?topic=79799.0
Sorry
VM 2.0.8
Joomla 2.5
Reduce the list, of course it can be slow, when you let display 400 items
VM2.0.8? Really?? See http://forum.virtuemart.net/index.php?topic=118683.0
I have 5500 products but i list only 15 each page. The problem is recent so isn't that problem.
Like i said i only have this problem in the backoffice and in the page that list the products. It takes almost 2m to open.
jenkinhill i know that i have a old version but i made a lot of customization and everything works fine.
It may work fine, but will be about as secure as a Ferrari left in a Liverpool street with doors open & key in the ingition.
If this used to work OK then check if the host made any changes, check error files, clear all caches, check for database errors.
Thank you for the help.
I already clean the cache but the problem keeps the same. I don't detect any error files but i made a test and detect something:
I have +/- 5000 products and about 100 manufacturers. If i filter the list from the any manufacturer all products appears really fast expect for one manufacturer.
Let's saw that i have manufacturer A,B,C,D...
If i filter for show only the products form A,B and C no problem, it's fast. If i filter from D it takes about 90s. Almost the same time that and don't put any filter.
Any idea?
Certainly a mysql table problem.
Try to make a backup, with akeeba backup and try in another server, to see if this resolve it.
Or use https://dev.mysql.com/doc/refman/5.6/en/mysqlcheck.html
Of course, make a backup
I already have done that and the problem continues. I debug the page and receive this:
(https://dl.dropboxusercontent.com/u/29810428/admin.JPG)
How can i resolve this problem?
Thank you.
The second bug(for MIME type) seems to come from noframework, certainly a template framework ?
Perhaps cheking in the plugin from noframework, if you are in admin or front-end solve this bug.
Contact the plugin author.
The other bug is a date formating error, perhaps this can add an error on save, but never slow down your HMTL render.
Thank you for this quick reply.
The MIME bug can cause the 5min of delay that i have in the index.php file?
I don't think, the mime type cause the slowdown, but perhaps the script.js file from framework.