Issue after updating CCK field using sql update query
Hi, I have updated a field in a cck table (content_type_resource) using sql. The update executed successfully. However, upon accessing the node via a web browser, the updated values seem to get replaced by NULL. Anyone notice this behavior in Drupal 6 before? -v
Im also curious for the answer why. We got a similar issue. Seems like those values are cached somehow so clear cache all made the values visible that are in the database. Cck seems to turn 0 into null even for integers. We did not search to much further on it because clearing the cache solved the issue. Hans www.koba.be 2010/1/3, VJ <vijaiprao@gmail.com>:
Hi, I have updated a field in a cck table (content_type_resource) using sql. The update executed successfully. However, upon accessing the node via a web browser, the updated values seem to get replaced by NULL. Anyone notice this behavior in Drupal 6 before?
-v
-- Hans Rossel KOBA Webdesign bvba Beukenlaan 56 9051 Gent (Sint-Denijs-Westrem) Belgium BTW 0817.931.516 +32.9.334.52.60 +32.472.79.32.16 www.koba.be info@koba.be
Is there a module that lets me type in the username or last name of a user in the admin so I can find someone without scrolling through hundreds of pages of users? Thanks
There are many options for this. I generally solve this using views with an exposed filter to search for things like user name or other profile fields. Often searching by a real name or an email is more valuable to me or my clients. When you create the view you want to make it a view of users rather than nodes. Using this method you can create filters for anything having to do with your users and the way they use your site that is exposed to views. You can also use Drupal search. You could modify the output files for your theme to add an edit button for the appropriate users when someone is found using search. These are two easy methods. Hope they help. Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 Sign up for the Denver DataMan Free eNewsletter -----Original Message----- From: Stephen Wills [mailto:swills@beyond-print.com] Sent: Sunday, January 03, 2010 10:46 AM To: support@drupal.org Subject: [support] user lookup module Is there a module that lets me type in the username or last name of a user in the admin so I can find someone without scrolling through hundreds of pages of users? Thanks -- [ Drupal support list | http://lists.drupal.org/ ]
Hello Stephen, You can do this using Advanced User (http://drupal.org/project/advuser) or, another option is to make a views (http://drupal.org/project/views) with an exposed filter, which would also let you search for users according to the parameters you allow (for example, username contains, or beggins with, or ends with etc). Best, Dani On Sun, Jan 3, 2010 at 6:46 PM, Stephen Wills <swills@beyond-print.com>wrote:
Is there a module that lets me type in the username or last name of a user in the admin so I can find someone without scrolling through hundreds of pages of users?
Thanks -- [ Drupal support list | http://lists.drupal.org/ ]
-- Daniela de Carvalho Matielo dacamat.com.br | weblab.tk | lixoeletronico.org twitter: @danimatielo "The only people for me are the mad ones, the ones who are mad to live, mad to talk, mad to be saved, desirous of everything at the same time, the ones who never yawn or say an uncommon-place thing, but burn, burn, burn like fabulous yellow roman candles." ~ Jack Kerouac
Thanks. Truncating cache seems to have fixed the issue for me as well. On Sun, Jan 3, 2010 at 10:35 AM, KOBA | Hans Rossel <hans.rossel@koba.be>wrote:
Im also curious for the answer why. We got a similar issue. Seems like those values are cached somehow so clear cache all made the values visible that are in the database. Cck seems to turn 0 into null even for integers. We did not search to much further on it because clearing the cache solved the issue.
Hans www.koba.be
2010/1/3, VJ <vijaiprao@gmail.com>:
Hi, I have updated a field in a cck table (content_type_resource) using sql. The update executed successfully. However, upon accessing the node via a web browser, the updated values seem to get replaced by NULL. Anyone notice this behavior in Drupal 6 before?
-v
-- Hans Rossel KOBA Webdesign bvba Beukenlaan 56 9051 Gent (Sint-Denijs-Westrem) Belgium BTW 0817.931.516 +32.9.334.52.60 +32.472.79.32.16 www.koba.be info@koba.be -- [ Drupal support list | http://lists.drupal.org/ ]
participants (5)
-
Dani Matielo -
KOBA | Hans Rossel -
Stephen Wills -
Steve Kessler -
VJ