On Tue, 2006-07-18 at 23:26 -0500, Steve Longdo wrote: > At any rate I show 18 tables. Is that right?
[EMAIL PROTECTED]:~/typo/local/db$ grep "CREATE TABLE" schema.mysql.sql CREATE TABLE articles_categories ( CREATE TABLE articles_tags ( CREATE TABLE blacklist_patterns ( CREATE TABLE blogs ( CREATE TABLE categories ( CREATE TABLE contents ( CREATE TABLE notifications ( CREATE TABLE page_caches ( CREATE TABLE pings ( CREATE TABLE redirects ( CREATE TABLE resources ( CREATE TABLE sessions ( CREATE TABLE sidebars ( CREATE TABLE tags ( CREATE TABLE text_filters ( CREATE TABLE triggers ( CREATE TABLE users ( CREATE TABLE schema_info ( Looks right. > mysql> show tables; > +-----------------------+ > | Tables_in_rhesus_typo | > +-----------------------+ > | articles_categories | > | articles_tags | > | blacklist_patterns | > | blogs | > | categories | > | contents | > | notifications | > | page_caches | > | pings | > | redirects | > | resources | > | schema_info | > | sessions | > | sidebars | > | tags | > | text_filters | > | triggers | > | users | > +-----------------------+ > 18 rows in set (0.00 sec) > > mysql> desc > contents;+------------------+--------------+------+-----+---------+----------------+| > Field | Type | Null | Key | Default | Extra > |+------------------+--------------+------+-----+---------+----------------+| > id | int(11) | | PRI | NULL | > auto_increment || title | varchar(255) | YES | | NULL > | || author | varchar(255) | YES | | > NULL | || body | text | YES | > | NULL | || body_html | text | YES > | | NULL | || extended | text | > YES | | NULL | || excerpt | text > | YES | | NULL | || keywords | > varchar(255) | YES | | NULL | || text_filter > | varchar(255) | YES | | NULL | || created_at > | datetime | YES | | NULL | || > updated_at | datetime | YES | | NULL | > || extended_html | text | YES | | NULL | > || user_id | int(11) | YES | | NULL | > || permalink | varchar(255) | YES | | NULL | > || guid | varchar(255) | YES | | NULL > | || text_filter_id | int(11) | YES | | > NULL | | > | whiteboard | text | YES | | NULL | | > | type | varchar(255) | YES | | NULL | | > | article_id | int(11) | YES | MUL | NULL | | > | email | varchar(255) | YES | | NULL | | > | url | varchar(255) | YES | | NULL | | > | ip | varchar(40) | YES | | NULL | | > | blog_name | varchar(255) | YES | | NULL | | > | name | varchar(255) | YES | | NULL | | > | comments_count | int(11) | YES | | NULL | | > | trackbacks_count | int(11) | YES | | NULL | | > | published | tinyint(1) | YES | | 0 | | > | allow_pings | tinyint(1) | YES | | NULL | | > | allow_comments | tinyint(1) | YES | | NULL | | > | blog_id | int(11) | | MUL | 0 | | > | published_at | datetime | YES | | NULL | | > +------------------+--------------+------+-----+---------+----------------+ > 31 rows in set (0.00 sec) > > On 7/18/06, Scott Bronson <[EMAIL PROTECTED]> wrote: > > On Tue, 2006-07-18 at 21:52 -0500, Steve Longdo wrote: > > > I have an update for some reason the @article.text_filter is returning > > > a YAML String instead of a TextFilter object. This is probably the > > > culprit for Trac #1006 as well. I confirmed this in the console > > > loading the saved new post(a) and an older one that still renders > > > correctly(b): > > > > When I encountered symptoms like this, it's because my database schema > > was hosed. Probably happened when I tried to fix the migrations 6 > > months ago. My database had an extra table that wasn't being used but > > had the same name as a variable in the code. AR wasn't very happy about > > that and instantiated YAML strings instead of objects. > > > > In my case, I dropped the table and things started working. > > > > So, you might want to give your schema a close look-see. Especially > > check for extra tables. > > > > I've been meaning to write a Typo database lint tool... It would ensure > > that no extra tables exist, all table references work, no duplicates, > > etc. Ah, if only I had a bit more time... > > > > - Scott > > > > > > > > _______________________________________________ > > Typo-list mailing list > > [email protected] > > http://rubyforge.org/mailman/listinfo/typo-list > > > > _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
