vQMod crashes saving edited products with MANY Options

Fresh Installed 1.5.1.1 with Spanish Language, vQMod 123, vQMod Manager and Not one more mod.


I'm getting the following error when i try to edit a previously saved Product with Options:

Notice: Undefined index: option_value_id in /home/xxxxxxxx/public_html/used/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/used/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/used/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/used/admin/model/catalog/product.php on line 169Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxxx/public_html/used/admin/index.php:83) in /home/xxxxxxx/public_html/used/vqmod/vqcache/vq-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxxx/public_html/used/admin/index.php:83) in /home/xxxxxxxx/public_html/used/vqmod/vqcache/vq-system_engine_controller.php on line 29

The same happens if i Duplicate a product with options. The Duplicate "Completes" with no problems. The problem comes when i Edit this product and try to save it with the new product name and Model.

Ok 24 hours after this problem i feel very frustrated. So 've decided to delete all the OC installation and start all over. i even tried a new root name, new database name, everything new.

1.5.1.1, vQMod 123, vQMod Manager, Export / Import Mod and Spanish Language installed

I've now created one product with like 17 options. Everything worked perfect.

Now i duplicated this product. Perfect.

Now i enter this duplicated product just to make some changes. This includes adding two more options with respective Values. Now this is what i get while trying to save it:

[bold]Notice: Undefined index: option_value_id in /home/xxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/xxxxxxxx/public_html/webstore/admin/model/catalog/product.php on line 169Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxxx/public_html/webstore/admin/index.php:83) in /home/xxxxxxxx/public_html/webstore/vqmod/vqcache/vq-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxx/public_html/webstore/admin/index.php:83) in /home/xxxxxxxx/public_html/webstore/vqmod/vqcache/vq-system_engine_controller.php on line 29[/bold]

I'm desperated. All the work of DAYS have gone to the toilet. I was hoping that an error on my previous install was causing this problem but evidently not.

I posted this in the 1.5.1.1 bug thread but it got deleted there so here i'm posting it.

Any help would be appreciated.

Ok. I just UNINSTALLED the vQmod via ADMIN and it STILL Crashes.

The only Mod left is Spanish Language. I will switch to English and try.

No fix after eliminating Spanish language:


Notice: Undefined index: option_value_id in /home/realjee1/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/realjee1/public_html/webstore/admin/model/catalog/product.php on line 169Notice: Undefined index: option_value_id in /home/realjee1/public_html/webstore/admin/model/catalog/product.php on line 169Warning: Cannot modify header information - headers already sent by (output started at /home/realjee1/public_html/webstore/admin/index.php:83) in /home/realjee1/public_html/webstore/vqmod/vqcache/vq-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/realjee1/public_html/webstore/admin/index.php:83) in /home/realjee1/public_html/webstore/vqmod/vqcache/vq-system_engine_controller.php on line 29

So far i've edited 10 demo products that come with the OC 1.5.1.1 install. None of them failed to duplicate, edit, add / Remove one or two options, and finally Saved. All of these Succeded saving many times.....


EXCEPT...

The product "Apple Cinema 30". This demo product is the only one that comes with 9 options and 64 values total. After 10 products edited and saved successfully, this one crashed.

The funny thing is.. in my live store, the product that keeps crashing when trying to edit / duplicate, ALSO HAS MANY OPTIONS and it Crashes when trying to edit it. It even will not call back all the saved options values when you open it for editing: Take a look:

http://realjeeps.com/webstore/index.php ... duct_id=52

I will install a completely FRESH 1.5.1.1 OC with NO MODS at all. Not even Spanish language and try.

Thank you Q for taking the time.

As you can see i'm doing my homework

I just performed a fresh install of OC 1.5.1.1 new subdomain, new Database and no vQMod (123 NOR Manager) and everything works PERFECT!!.

I have CREATED / EDITED / DUPLICATED / EDITED AGAIN / Created AGAIN some products with lots of Options (previously created by me) and OC works like a charm.

So what do you think? Is it really a problem with my Server's Max Upload Size?? Or do you think it's something inside vQMod ??

What about options with blank values / lost values when trying to edit?

I'm in no way trying to bash your great vQMod.. just trying to figure out before calling my server's Customer Service.

Thanks.

we have been experiencing the same problem and seem to have found the solution, line 149 of the vqmod.php file needs changing from false to true. This should prevent the options from loading slowly and crashing.
line 149: public $useCache = TRUE;

we are now experiencing another issue where we cannot go back and edit an option like adding another value after we have created it. we get this error Undefined index: option_value_description. don't know if anyone can help?

you may also want to disable logging by setting it to false, a couple of line below usecache in the vqmod.php file.

uksitebuilder wrote:you may also want to disable logging by setting it to false, a couple of line below usecache in the vqmod.php file.

Worked for me so far!!! I changed $useCache to TRUE and also changed Logging to FALSE and so far it seems to solve the problem. Kudoos to you uksitebuilder !!!

So these problems have to do with vQMod???

What about you danicmyk? Did changing Logging to FALSE solved the probs for you???

It may be an ajax + vQmod problem.. your server likely doesn't have to work as hard for the options when not loading through vQmod and logging.. a larger max upload size and/or post size and/or timeout would be the real fix. I think the issue combined with vQmod may just be putting you just over the cusp but if you had no vQmod and tried a few more options you'd likely run into the problem anyway

Also be sure you are using v1.2.3 of vQmod as that has a lot of performance improvements

Thanks Q. I'll then ask for more "max upload size" and larger Timeout.

What parameters for upload size / Timeout should i ask for?

The php.ini file tries to force them. But most hosts don't allow php.ini to override the defaults
The htaccess file also has the option but they are commented out because it can cause ISE 500 errors when the server doesn't allow.

So first try enabling

# php_value upload_max_filesize 999M
# php_value post_max_size 999M
# php_value max_execution_time 200

by removing the # in the front

If that doesn't work or causes Internal Service Error 500, then add the # back and contact your host.

I found more than one htaccess files so i edited the one in the root directory..

INTERNAL SERVER ERROR ):

Time to open a Support Ticket on my server's customer service.

Will let you know.

Spoke too soon. Problem still there.

Even when i changed the line 149 in vqmod.php: public $useCache = TRUE; and also changed line 152 Public $logging to FALSE.

danicmyk wrote:we have been experiencing the same problem and seem to have found the solution, line 149 of the vqmod.php file needs changing from false to true. This should prevent the options from loading slowly and crashing.
line 149: public $useCache = TRUE;

we are now experiencing another issue where we cannot go back and edit an option like adding another value after we have created it. we get this error Undefined index: option_value_description. don't know if anyone can help?

Not sure if this will help or not

You may want to add some indexes to the database tables

for example

option_description table
add index to name

option_value table
add index to option_id

option_value_description table
add indexes to option_id and name

** Please backup your DB before doing the above changes.

I got the max increase parameters possible for my hosting package to:

max_execution_time = 30
upload_max_filesize = 10M
post_max_size = 8M

Is this acceptable or not even helping?

jomeza001 wrote:I got the max increase parameters possible for my hosting package to:

max_execution_time = 30
upload_max_filesize = 10M
post_max_size = 8M

Is this acceptable or not even helping?

well does the page take 30 secs to load after hitting submit?

Well.. i just performed three product edits. Same product with 15 options and a total values of 423 (including price, +-, qtty and so on).


All three times the page refreshed in nine seconds and no crashes (vqmod unistalled via vQMod Manager).

Q , what you think? Why it crashes if vqmod v.123 is enabled?

I come across this problem too not so long ago writing one of my mods, and the problem was partially down to vQmod, but I suppose it's more of an OpenCart flaw with over-using jquery.

What was happening, when editing a product all the option values are retrieved via an AJAX call. Because so many calls were happening at the same time (each one calling vQmod), there was a write error with the cached files (as it was still being written too by the previous call). This then in turn wouldn't respond with the correct responce (just a write error), so the required hidden option_value_id box that should of been created by jQuerys ajax call wasnt created - hence this error.

If you think... 5xoptions, each with 15x values = 75AJAX calls all firing at once.

I got round this by rewriting the ajax call so it only happened ONCE per option, rather that for every option value, and put in a check so that if it DID fail again, it would re-try the ajax call again.


A simple check to see if exactly the same is happening for you - when you click on edit product, go through EVERY option and see if any of the dropdowns HAVENT populated with the values - if they havent and you click save, then you will get this error.


So, it's partially down to vQmod because it's that wanting to write the new files... but also opencart for the way ajax has been implimented.