[typo] missing posts after database restore

Bill McGonigle bill at bfccomputing.com
Thu Aug 21 01:55:06 EDT 2008


On Aug 12, 2008, at 01:58, Bill McGonigle wrote:

> hmmm:
>
> >> Article.count(:all)
> => 0

OK, I think I figured out why this result is true.  Restoring  
from .yaml files sets the 'type' field of the Contents table to NULL,  
even when the .yaml file contains Article as the type.

e.g.:

- allow_pings: t
   updated_at: 2008-02-22 15:30:54.125274
   guid: d81ed114-dc11-423b-93da-0c71c771b4c7
   body: |-
     These guys are installing metal pillars so a vehicle can't get  
into an area to park there.

     <img src="http://mcgonigle.us/bill/blog/files/ 
000801c846a0_d5e95710_6501a8c0.jpeg" height="75%" width="75%">

     Thanks, Dad.
   title: Think Through the Project First
   published: t
   author: bill_mcgonigle
   type: Article
   text_filter_id: "2"
   excerpt:
   id: "22"
   blog_id: "1"
   whiteboard:
   extended: ""
   published_at: 2008-02-22 15:25:00
   user_id: "1"
   state: published
   allow_comments: t
   created_at: 2008-02-22 15:27:26.652014
   keywords: ""

results in:

LOG:  statement: INSERT INTO "contents" ("", "", "", "", "", "", "",  
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "") VALUES 
(E'think-through-the-project-first', NULL, 't', '2008-08-21  
00:26:06.357497', E'Think Through the Project First', E'These guys  
are installing metal pillars so a vehicle can''t get into an area to  
park there.

         <img src="http://mcgonigle.us/bill/blog/files/ 
000801c846a0_d5e95710_6501a8c0.jpeg" height="75%" width="75%">

         Thanks, Dad.', E'd81ed114-dc11-423b-93da-0c71c771b4c7', 't',  
NULL, E'bill_mcgonigle', NULL, 2, 22, 1, E'', NULL, 1, '2008-02-22  
15:25:00.000000', E'', '2008-02-22 15:27:26.652014', 't', E'published')


I tried restoring on postgresql and mysql, same result.

I lined up all the fields and only 'type' in this table has this  
discrepancy.

So, I was able to get things running again with:

   UPDATE Contents SET type='Article';

And so far that looks good.

-Bill

-----
Bill McGonigle, Owner           Work: 603.448.4440
BFC Computing, LLC              Home: 603.448.1668
bill at bfccomputing.com		Cell: 603.252.2606
http://www.bfccomputing.com/    Page: 603.442.1833
Blog: http://blog.bfccomputing.com/
VCard: http://bfccomputing.com/vcard/bill.vcf



More information about the Typo-list mailing list