Home » Forums » Ubercart » Bug Reports
12 replies [Last post]
Thu, 02/28/2008 - 18:35
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28

my apologies if this has already been posted, but I have a tight deadline,

so THANK YOU in advance

here is the error message

user warning: Unknown table 'node_data_field_image_cache' in field list query: SELECT node.nid, uc_products.ordering AS uc_products_ordering, node.title AS node_title, node_data_field_image_cache.field_image_cache_fid AS node_data_field_image_cache_field_image_cache_fid, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = '1') AND (node.type IN ('product')) AND (term_node.tid IN ('1')) ORDER BY uc_products_ordering ASC, node_title ASC LIMIT 0, 14 in /mnt/gs01/herd04/36893/domains/positivelyfundraising.com/html/includes/database.mysql.inc on line 172.

thankyou again

Paul Fasel

www.doreydesigngroup.com

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Thu, 02/28/2008 - 20:37
#1 View page
torgosPizza
torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Cart error message after latest update

I saw this error after migrating our site to a dev server. Try going into your Image Cache settings (/admin/settings/imagecache) and re-submitting your presets. This worked for me but I'm not sure if that was a coincidence or not. Let me know if it helps!

--
Help directly fund development: Donate via PayPal!

Top
Fri, 02/29/2008 - 01:27
#2 View page
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28
Re: Re: Cart error message after latest update

That was the first thing I tried and it didn't do anything. I tried pretty much everything in the imagecache module, I tried countless other things, none of which seemed to help. I then took a look at a known good backup SQL dump and noticed that there were more fields in the node_data_field_image_cache table in the running version than on the backup. When I removed the duplicate fields in in the table using phpMyAdmin the error went away, but my view now had no thumbnails and I couldn't readd them.

I ultimately couldn't find the problem so I just restored the backup and continued, checking carefully each time I made any change to see that it was still working. It popped up the error again when I clicked the update script once, and my best guess what that clicking on the update script was duplicating the table. However, despite restoring from SQL dump again and not using the update script, it happened yet again. I can't continue developing my site if this keeps happening. Any help would be appreciated.

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Fri, 02/29/2008 - 02:35
#3 View page
torgosPizza
torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Re: Cart error message after latest update

Best thing to do is to start disabling, one at a time, modules until you find the culprit. Like I said, to me it looks like an image cache issue, like a table hasn't been created that it's looking for.

I did some looking and I found it in uc_product.module:

<?php
$view->field = array (
    array (
      'tablename' => 'node_data_field_image_cache',
      'field' => 'field_image_cache_fid',
      'label' => 'Image(s)',
      'handler' => 'content_views_field_handler_group',
      'options' => 'product_list_linked',
    ),
?>
<?php
$view->requires = array('node_data_field_image_cache', 'node', 'uc_products');
?>

I'm not quite sure why these tables aren't being created, they're not in the .install file anywhere... hopefully the Uberdudes can shed some light on it.

--
Help directly fund development: Donate via PayPal!

Top
Fri, 02/29/2008 - 12:28
#4 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Re: Re: Cart error message after latest update

Try changing node_data to content and see if that fixes it...

Top
Wed, 05/28/2008 - 17:43
#5 View page
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28
I'm getting this error

I'm getting this error again! I never fixed it the last time, I eventually just restored from an old backup. I can't keep doing this though every time I get this error, particularly for the client I'm dealing with calling me up and having to explain why all their recent work has to be redone.

I did move the site to their new dedicated server, as I was hosting it myself before. The move went fine otherwise, and the error happened about a week and a half after when they tried to add a new product to the database.

user warning: Unknown column 'node_data_field_image_cache.field_image_cache_fid' in 'field list' query: SELECT node.nid, uc_products.ordering AS uc_products_ordering, node.title AS node_title, node_data_field_image_cache.field_image_cache_fid AS node_data_field_image_cache_field_image_cache_fid, node.changed AS node_changed, uc_products.sell_price AS uc_products_sell_price FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = '1') AND (node.type IN ('product')) AND (term_node.tid IN ('1')) ORDER BY uc_products_ordering ASC, node_title ASC LIMIT 0, 14 in /var/www/vhosts/positivelyfundraising.com/httpdocs/includes/database.mysql.inc on line 172.

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Wed, 05/28/2008 - 17:56
#6 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: I'm getting this error

It's weird that it would say a column is missing... what version of ImageCache is the site running?

Top
Thu, 05/29/2008 - 18:31
#7 View page
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28
Re: Re: I'm getting this error

$Id: imagecache.module,v 1.19.2.28 2007/06/16 17:22:41 dopry Exp $

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Fri, 05/30/2008 - 02:48
#8 View page
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28
Re: Re: I'm getting this error

I think I may have figured out what the problem is. I got a call that the shipping module wasn't generating the shipping labels, so I did a test order and sure enough I got an error that said it couldn't find the ups_labels directory. The directory was there, but had permissions of 755, when I changed it to 777 it worked. I also noticed the imagecache directory also had permissions of 755 and I changed that to 777. However, now when I try to upload pictures with a new product it gives me a broken image link.

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Mon, 06/09/2008 - 17:02
#9 View page
spinfresh
spinfresh's picture
Offline
Joined: 02/28/2008
Juice: 28
Re: Re: Re: I'm getting this error

Any news on this? Do the developers need any more from me? Error logs? Site access? It seems this isn't a unique issue so probably worth taking a look at.

Paul Fasel
www.doreydesigngroup.com
we are your web department

Top
Tue, 06/10/2008 - 23:46
#10 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15422
Re: Re: Re: Re: I'm getting this error

Not really sure we could do much to debug... with the proper permissions set now, have you tried flushing the presets and maybe Drupal's cache tables and refreshing the pages?

Top
Wed, 01/28/2009 - 08:51
#11 View page
sseeger
sseeger's picture
Offline
Joined: 01/28/2009
Juice: 3
Disable modules

Start disabling modules, one at a time. For me, disabling "Secure Pages" restored it. I can't for the life of me figure out how Secure Pages is interfering with it, though.

Top
Thu, 03/18/2010 - 04:35
#12 View page
hendrinx
hendrinx's picture
Offline
Joined: 03/18/2010
Juice: 32
Possible solution

I know its really late, but hopefully it might help others.

Have a read through http://drupal.org/node/383330

It covers a variety of error messages similar to this one (the one I experienced read something like "user warning: Unknown column 'delta'")... anyway, reseting the field_image_cache (read the posted link) sorted it out for me.

Top