So, I installed this module and added a serial number filed to a content type of mine and then went through and began checking nodes... and I found a BUNCH that had the value 0 for the field. Why would this happen?

I also got this warning message and wasn't really sure what was going on, which is why i went to check my content and see how screwed up my nodes where. It is attached.

CommentFileSizeAuthor
#4 Screen shot 2010-02-25 at 10.40.15 AM.png81 KBbeckyjohnson
Screen shot 2010-02-24 at 11.09.18 AM.png100.55 KBbeckyjohnson

Comments

kirsh’s picture

kirsh commented
Status: Active » Postponed (maintainer needs more info)

I don't know when and why this happens. More info is needed.

beckyjohnson’s picture

beckyjohnson commented

what kind of info do you need? I already deleted the field...so if I re-enable it and get another error message, what should I look for?

kirsh’s picture

kirsh commented

This is probably some sort of edge case. I will need step by step instructions that will enable me reproducing the problem.

beckyjohnson’s picture

beckyjohnson commented
StatusFileSize
new Screen shot 2010-02-25 at 10.40.15 AM.png81 KB

Ok.
1. I imported nodes onto a clean install using node export. This worked like a charm. Unfortunetly, some of the nodes have the same title. These are products and for example, sadly, there are 4 products called "thinkpad".
2. After the nodes were in, I started making changes to my content type. I re-arranged fields and such.
3. I added some modules. Here is a list of all CCK Modules I have installed:
CCK Required by Role
Conditional Fields
Content
Content Copy
Content Multigroup
Content Permissions
Email
Fieldgroup
FileField
ImageField
Link
Multistep
Node Reference
Node reference views
Node Relationships
Number
Option Widgets
Serial
Text
User Reference

4. I went to my content type and added a serial field and moved it to the top of my page, above the node title.
After I created the field I got an error about duplicate entries. Actually first I got a white screen and then I tried to go back a page and got the error attached below.

Rebecca

beckyjohnson’s picture

beckyjohnson commented

Ok! I took care of the screen warnings as shown in my screenshot. Path alias was causing issues. However, I have a ton of nodes that still have 0 for a value. I'm not getting any other database errors. Is it possible that I could just go into the database and manually assign numbers? I really really need to get this working for me.

Becky

beckyjohnson’s picture

beckyjohnson commented

Ok, so I went in and tried editing a node entry and editing the table for the serial number module but that resulted in nothing. The values still stayed at 0.

kirsh’s picture

kirsh commented

You have to edit the ordinary CCK tables, not the serial module table, which is used temporarily only for allocation. If the serial field is dedicated to one type it will be in the CCK node type table (e.g. content_type_mytype). If the serial field is shared by multiple node types - the field will have its own table (e.g. content_field_serial).

beckyjohnson’s picture

beckyjohnson commented

I'm only using it for one content type and I did edit the ordinary cck tables....and even after clearing the cache and running update.php, the changes did not take effect.

The nodes I am using were imported using the module node export. Do you think this could be creating a problem? If so, how can I investigate further?
Becky

kirsh’s picture

kirsh commented

Maybe the field has been updated but for the title to be updated you also need to resave the nodes? Try saving one of these nodes.
In addition, you may try deleting all the cache tables in addition to cache clear.

beckyjohnson’s picture

beckyjohnson commented

UPDATE: [ I went though and cleared cache tables after doing some research and realizing that this would not hurt anything and nothing changed. The values are still 0].

So, I edited the data base and then cleared my cache and ran update.php and I re saved the node and nothing...
I went back to my database to try emptying cache tables but I'm unclear about whether I should empty all the tables or just a couple.
The only cache tables I can browse though are Cache, Cache Form, Cache Menu, and cache update.....

Becky

beckyjohnson’s picture

beckyjohnson commented

I upped my memory limit from 120 MB to 200 MB to see if this was a memory issue and then I deleted the serial number filed and then re-created it. When the field saved, I got a white screen....I've been getting these white screens when I make the serial field but for some reason I didn't think of upping the php memory at first. Anyway...so upped the memory limit, still got a white screen, ran a view to see what Nid's matched up with what serial number. On my last attempt I got 102 serial numbers generated. This time around I got 95. The problem actually got worse....

Any other ideas?
Becky

beckyjohnson’s picture

beckyjohnson commented

I figured out the problem! Ok, I deleted all my path aliases because I was getting weird errors about duplicate paths every time I enabled this module and then I noticed just now, that after I save the serial number field, I am still getting these errors even though, I had cleared them. Then I thought maybe when the nodes re-save or whatever after the field is enabled, the system is trying to generate paths for everything; 200 nodes in my case. So I disabled the path auto module and then enabled the serial field again and it worked! All my nodes have a unique number.

The version of path auto that I'm using is 6.x-1.x-dev because the regular release has a conflict with Path Redirect...

Becky

kirsh’s picture

kirsh commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Thanks for the update. Adding a serial field to a type with many existing nodes is known as problematic. If node save is slower because of additional modules (e.g. pathauto) the problem is bigger.

Jonasvh’s picture

Jonasvh commented
Status: Closed (fixed) » Fixed

SOLUTION
Increase the PHP Execution time

Add to the .htacces file :

php_value max_execution_time 200

200 is the time in seconds

I just remove the serial field in my contenttype -> save the contenttype -> added the serial field again -> save the contenttype -> just wait, so that the module can execute -> done

check some example: www.geografica.be

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.