Home » Forums » Ubercart » Support

Slow Product and Product Kit Node Saving and Timeouts

Submitted by excellira on Wed, 11/26/2008 - 22:09
excellira
Posts: 11
 Joined: 09/13/2008

I'm noticing that, when saving product and product kit nodes, it takes so long that it times out. I modified php.ini (max_execution_time and memory) so now, rather than timing out, the save process continues ad nauseum. I do not see this issue on other node types within the site. So, for example, a content type of page will save properly within a reasonable time. Not so with products. I'm running Uber 5.x-1.5.

Can anyone point me in the right direction?

Many thanks.

P.S. Forgot to mention this important item. If the node does finally save properly, then at the top of the page, within admin, I see the following message: "The Product kit has been updated." I see this repeated several hundred times.
permalink #1 Wed, 11/26/2008 - 22:17
thill

Posts: 223
 Joined: 01/25/2008
Bug FinderBrain StormerGetting busy with the Ubercode.

It sounds like you have a error with an endless loop. First thing to do is upgrade to 1.6 and run update.php after you upload the new files.

Let's see if that helps first.

permalink #2 Thu, 11/27/2008 - 02:14
excellira
Posts: 11
 Joined: 09/13/2008

Thanks for your reply. I upgraded to 1.6 and I'm seeing the same issue.

I checked the log and a recurring error is as follows:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: INSERT INTO uc_product_kits (vid, nid, product_id, mutable, qty, discount, ordering) VALUES in /home/accountname/public_html/installdirectory/includes/database.mysql.inc on line 174.

Running PHP 5.25 MySQL 5.0.51a

I'm uncertain as to what this error could be.

Any thoughts?

Thanks again for your help.

permalink #3 Thu, 11/27/2008 - 10:47
excellira
Posts: 11
 Joined: 09/13/2008

I just looked at the content list and in addition to the above mentioned issues, there are countless numbers of "new" blank nodes. Lots of mayhem going on!

permalink #4 Thu, 11/27/2008 - 12:32
torgosPizza

Posts: 1376
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

Well setting the max_execution time back to its default will prevent a lot of those blank nodes from getting added. The weird thing is, it looks like that query isn't getting the form values for some reason? What kinds of custom modules do you have added? My first guess is that there is some non-UC-core code that is hooking into the node insert op and destroying the query.

Beyond that I'm not really sure. Can you give us any more information about the products you're adding to the kit? Is there anything about the products that might not be supported (like an old Contrib module)?

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #5 Fri, 11/28/2008 - 12:22
excellira
Posts: 11
 Joined: 09/13/2008

Thanks for the reply torgos. I reset max_execution - didn't seem to matter what it was set to - always resulted in a loop.

The site does not have any custom modules but there are a number of contributed modules. I am scratching my head though. This issue did not exist 2 days ago and I do not recall making any changes.

I have been going through the process of disabling modules. I've cut the list down to just a bare-bones list - mostly the Uber modules.

After doing so, I then edited and saved a product (it does not matter whether it's a product or a product kit - for simplicity I've chosen to work with just the products) the problem persists but this time I received the following message when the node save timed out:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Lost connection to MySQL server during query\nquery: SELECT sid FROM sessions WHERE sid = '647ae8d34aae4357fd19480f4c199074' in /home/accountname/public_html/installdirectory/includes/database.mysql.inc on line 174.', 2, '', 'https://www.accountnamea.com/installdirectory/node/125/edit?destination=admin%2Fcontent%2Fnode', 'https://www.accountnamea.com/installdirectory/node/125/edit?destination=admin%2Fcontent%2Fnode', 'xx.xx.xxx.xx', 1227845877) in /home/accountname/public_html/installdirectory/includes/database.mysql.inc on line 174

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('647ae8d34aae4357fd19480f4c199074', 1, 0, 'xx.xx.xxx.xx', 'node_overview_filter|a:0:{}form|a:14:{s:32:\\"24317415a4cede3d9c1245d0d50fd0b4\\";a:2:{s:9:\\"timestamp\\";i:1227834253;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"7b4892ffe8b5e8d98170f50bb3c70696\\";a:2:{s:9:\\"timestamp\\";i:1227834274;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"b3075e1468ec5aa7d3b1f3c038f399ed\\";a:2:{s:9:\\"tim in /home/accountname/public_html/installdirectory/includes/database.mysql.inc on line 174

The site is a new site, in development, that has been updated approximately two times (Drupal and Uber). All modules are up-to-date.

Any thoughts? Your help is appreciated.

-Greg

permalink #6 Fri, 11/28/2008 - 12:41
end user
Posts: 110
 Joined: 01/11/2008

I don't have a solution but here's a link

http://drupal.org/node/163145

permalink #7 Fri, 11/28/2008 - 15:08
excellira
Posts: 11
 Joined: 09/13/2008

Thanks end user for the input. I've tried much of the solutions offered in the link you provided (as well as many other timout related links) and the issue persists.

What I'm curious about is why Uber product pages are not saving quickly. Nodes within the main site are functioning properly. There must be something within the Uber modules which is causing this issue.

I'm stumped.

Anyone have other ideas?

Thanks!!

permalink #8 Sun, 11/30/2008 - 10:38
excellira
Posts: 11
 Joined: 09/13/2008

-bump

permalink #9 Wed, 12/17/2008 - 10:18
excellira
Posts: 11
 Joined: 09/13/2008

Couldn't figure it out. Had to abandon install and start over.