Ask your Symfony questions! Pay money and get answers fast! (more info)

Error: Duplicate table named Symfony

  • SOLVED

What would cause this error?

Execution of target "om-template" failed for the following reason: /usr/share/php/symfony/vendor/propel-generator/build-propel.xml:470:1: Duplicate table found: propel.

I am working on a site that runs Symfony 1.0. I run "symfony propel-build-model" and I get an error:

~/dev/mercer$ symfony propel-build-model
>> schema converting "/home/mercer/dev/mercer/config/schema.yml" to XML
>> schema putting /home/mercer/dev/mercer/config/generated-schema.xml
>> schema converting "/home/mercer/dev/...lugin/config/schema.yml" to XML
>> schema putting /home/mercer/dev/mercer...erated-sfGuardPlugin-schema.xml
>> file+ config/generated-sfGuardPlugin-schema.xml
>> file- /home/mercer/dev/mercer/plugins...erated-sfGuardPlugin-schema.xml
Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml
[resolvepath] Resolved /home/mercer/dev/mercer/config to /home/mercer/dev/mercer/config

propel-project-builder > check-project-or-dir-set:

propel-project-builder > check-project-set:

propel-project-builder > set-project-dir:

propel-project-builder > check-buildprops-exists:

propel-project-builder > check-buildprops-for-propel-gen:

propel-project-builder > check-buildprops:

propel-project-builder > configure:
[echo] Loading project-specific props from /home/mercer/dev/mercer/config/propel.ini
[property] Loading /home/mercer/dev/mercer/config/propel.ini

propel-project-builder > om:
[phing] Calling Buildfile '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with target 'om'
[property] Loading /usr/share/php/symfony/vendor/propel-generator/./default.properties

propel > check-run-only-on-schema-change:

propel > om-check:

propel > om:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Peer-based Object Model for |
[echo] | YOUR Propel project! (NEW OM BUILDERS)! |
[echo] | |
[echo] +------------------------------------------+
[phingcall] Calling Buildfile '/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with target 'om-template'
[property] Loading /usr/share/php/symfony/vendor/propel-generator/./default.properties

propel > om-template:
[propel-om] Target database type: mysql
[propel-om] Target package: lib.model
[propel-om] Using template path: /usr/share/php/symfony/vendor/propel-generator/templates
[propel-om] Output directory: /home/mercer/dev/mercer
[propel-om] Processing: generated-schema.xml
[propel-om] Could not perform XLST transformation. Make sure PHP has been compiled/configured to support XSLT.
[propel-om] Processing: generated-sfGuardPlugin-schema.xml
[propel-om] Could not perform XLST transformation. Make sure PHP has been compiled/configured to support XSLT.
Execution of target "om-template" failed for the following reason: /usr/share/php/symfony/vendor/propel-generator/build-propel.xml:470:1: Duplicate table found: propel.
[phingcall] /usr/share/php/symfony/vendor/propel-generator/build-propel.xml:470:1: Duplicate table found: propel.

BUILD FINISHED

Total time: 0.3346 seconds
>> file- /home/mercer/dev/mercer/config/...erated-sfGuardPlugin-schema.xml
>> file- /home/mercer/dev/mercer/config/generated-schema.xml










In our top level config/schema.yml file we have 2 different formats for tables, one simple and on verbose:

contracts_question:
question_id: { type: integer, required: true, primaryKey: true, autoIncrement: true }
question_type: { type: varchar(1) }
answer: { type: varchar(1) }
question_text: { type: longvarchar }
created_by_user: { type: varchar(30) }
modify_by_user: { type: varchar(30) }


and also:

contracts_blogs:
_attributes:
idMethod: native
blog_id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
blog_type:
type: CHAR
size: 1
required: true
default: I
blog_name:
type: VARCHAR
size: 200
blog_short_name:
type: VARCHAR
size: 200
blog_sort_name:
type: VARCHAR
size: 50
blog_primary_author:
type: INTEGER
blog_priority:
type: FLOAT
required: true
default: 0
blog_is_active:
type: CHAR
size: 1
required: true
default: Y
blog_promo:
type: VARCHAR
size: 1000
blog_intro:
type: LONGVARCHAR
blog_description:
type: LONGVARCHAR
blog_imgpath1:
type: VARCHAR
size: 200
blog_imgcaption1:
type: VARCHAR
size: 500
blog_imgcredit1:
type: VARCHAR
size: 200
blog_imgpath2:
type: VARCHAR
size: 200
blog_imgcaption2:
type: VARCHAR
size: 500
blog_imgcredit2:
type: VARCHAR
size: 200
_indexes:
Archive:
- blog_is_active
- blog_short_name


We have 100 tables so I won't post them all here. The schema.yml file starts off:

propel:


I have searched for the word "propel" but it only occurs once in the file.

Inside of the config directory, I also have a file called schema.yml.contracts. It should not be called, right? It is an old version.

We had a lot of trouble earlier in the week when the wrong number of spaces were used for indenting in the schema.yml file, but right now, I've looked, and I can not see an error regarding indenting.

Any thoughts about what would cause this error?


UPDATE:

I deleted this following section from schema.yml, changed the top line back to "propel" and re-ran the propel-build-model command. Everything worked. So I think the problem must be in this section:

mercer_author_xref:
state:
type: CHAR
size: 1
required: true
content_id:
type: INTEGER
required: true
content_type:
type: INTEGER
required: true
author_id:
type: INTEGER
required: true
_indexes:
ByID:
- content_id
- state
ByAuthor:
- author_id
- content_type
mercer_blogs:
_attributes:
idMethod: native
blog_id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
blog_type:
type: CHAR
size: 1
required: true
default: I
blog_name:
type: VARCHAR
size: 200
blog_short_name:
type: VARCHAR
size: 200
blog_sort_name:
type: VARCHAR
size: 50
blog_primary_author:
type: INTEGER
blog_priority:
type: FLOAT
required: true
default: 0
blog_is_active:
type: CHAR
size: 1
required: true
default: Y
blog_promo:
type: VARCHAR
size: 1000
blog_intro:
type: LONGVARCHAR
blog_description:
type: LONGVARCHAR
blog_imgpath1:
type: VARCHAR
size: 200
blog_imgcaption1:
type: VARCHAR
size: 500
blog_imgcredit1:
type: VARCHAR
size: 200
blog_imgpath2:
type: VARCHAR
size: 200
blog_imgcaption2:
type: VARCHAR
size: 500
blog_imgcredit2:
type: VARCHAR
size: 200
_indexes:
Archive:
- blog_is_active
- blog_short_name
mercer_channel:
code:
type: VARCHAR
size: 50
required: true
primaryKey: true
literal:
type: VARCHAR
size: 100
required: true
mercer_cms_users:
userid:
type: VARCHAR
size: 30
required: true
primaryKey: true
isvalid:
type: CHAR
size: 1
required: true
default: Y
passwd:
type: VARCHAR
size: 60
required: true
fullname:
type: VARCHAR
size: 80
required: true
role:
type: VARCHAR
size: 60
required: true
default: USR
isadmin:
type: CHAR
size: 1
required: true
default: N
cdate:
type: TIMESTAMP
required: true
mercer_comment_ratings:
_attributes:
idMethod: native
cmt_id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
cmt_key:
type: VARCHAR
size: 20
required: true
cmt_content_id:
type: INTEGER
required: true
cmt_status:
type: CHAR
size: 1
required: true
cmt_submit_date:
type: TIMESTAMP
required: true
cmt_post_date:
type: TIMESTAMP
required: true
cmt_userid:
type: VARCHAR
size: 50
cmt_username:
type: VARCHAR
size: 200
cmt_userlocation:
type: VARCHAR
size: 200
cmt_rating:
type: CHAR
size: 1
cmt_original_comment:
type: LONGVARCHAR
cmt_comment:
type: LONGVARCHAR
cmt_link:
type: VARCHAR
size: 500
_indexes:
ByContent:
- cmt_key
- cmt_content_id
- cmt_status
ByKey:
- cmt_key
- cmt_status
- cmt_post_date
- cmt_submit_date
mercer_content:
id:
type: BIGINT
required: true
primaryKey: true
state:
type: CHAR
size: 1
required: true
primaryKey: true
default: W
legacyid:
type: VARCHAR
size: 50
textid:
type: VARCHAR
size: 200
content_hint:
type: CHAR
size: 1
aliastext:
type: VARCHAR
size: 20
package_tags:
type: VARCHAR
size: 200
priority:
type: FLOAT
default: 0
reference_link_1:
type: INTEGER
alt_info_1:
type: VARCHAR
size: 200
required: true
alt_info_2:
type: LONGVARCHAR
required: true
parent_content_id:
type: INTEGER
created_at:
type: TIMESTAMP
required: true
created_by:
type: VARCHAR
size: 30
required: true
updated_at:
type: TIMESTAMP
required: true
updated_by:
type: VARCHAR
size: 30
required: true
published_at:
type: TIMESTAMP
published_by:
type: VARCHAR
size: 30
content_type:
type: INTEGER
required: true
protected:
peerName: mercer_protected
phpName: mercer_protected
type: CHAR
size: 1
required: true
default: D
override_channel:
type: VARCHAR
size: 50
override_adsite:
type: VARCHAR
size: 50
override_adzone:
type: VARCHAR
size: 50
override_mlc:
type: VARCHAR
size: 200
required: true
direct_url:
type: VARCHAR
size: 250
pvar1:
type: VARCHAR
size: 100
required: true
pvar2:
type: LONGVARCHAR
required: true
content_date:
type: TIMESTAMP
live_date:
type: TIMESTAMP
issue_date:
type: DATE
issue_toc_id:
type: INTEGER
issue_page:
type: INTEGER
toc_title:
type: VARCHAR
size: 500
toc_subtitle:
type: LONGVARCHAR
title:
type: VARCHAR
size: 200
required: true
title_link:
type: VARCHAR
size: 150
subtitle:
type: VARCHAR
size: 300
required: true
author1:
type: INTEGER
required: true
default: 0
author2:
type: INTEGER
required: true
default: 0
author3:
type: INTEGER
required: true
default: 0
author4:
type: INTEGER
required: true
default: 0
author_ids:
type: VARCHAR
size: 100
required: true
author_str:
type: VARCHAR
size: 500
required: true
topic_ids:
type: VARCHAR
size: 100
required: true
topic_str:
type: LONGVARCHAR
required: true
assoc1_ids:
type: VARCHAR
size: 200
required: true
assoc1_str:
type: LONGVARCHAR
required: true
assoc2_ids:
type: VARCHAR
size: 200
required: true
assoc2_str:
type: LONGVARCHAR
required: true
assoc3_ids:
type: VARCHAR
size: 200
required: true
assoc3_str:
type: LONGVARCHAR
required: true
hp_include:
type: CHAR
size: 1
required: true
default: N
hp_seq:
type: INTEGER
required: true
default: 0
hp_title:
type: CHAR
size: 200
hp_text:
type: LONGVARCHAR
hp_include_image:
type: CHAR
size: 1
required: true
default: N
hp_image:
type: VARCHAR
size: 200
promo_text_1:
type: VARCHAR
size: 1000
required: true
promo_text_2:
type: VARCHAR
size: 1000
required: true
meta_desc:
type: LONGVARCHAR
required: true
meta_keywords:
type: LONGVARCHAR
required: true
meta_title:
type: VARCHAR
size: 300
required: true
tags:
type: LONGVARCHAR
required: true
abstract:
peerName: mercer_abstract
phpName: mercer_abstract
type: LONGVARCHAR
required: true
pcontent:
type: LONGVARCHAR
required: true
scontent:
type: LONGVARCHAR
altcontent:
type: LONGVARCHAR
orig_content:
type: LONGVARCHAR
suppress_standard_sidebars:
type: CHAR
size: 1
required: true
default: N
use_sidebar:
type: CHAR
size: 1
required: true
default: N
sidebar_title:
type: VARCHAR
size: 1000
sidebar_html:
type: LONGVARCHAR
sidebar_object_1:
type: VARCHAR
size: 50
sidebar_value_1:
type: VARCHAR
size: 200
sidebar_title_1:
type: VARCHAR
size: 150
sidebar_object_2:
type: VARCHAR
size: 50
sidebar_value_2:
type: VARCHAR
size: 200
sidebar_title_2:
type: VARCHAR
size: 150
sidebar_object_3:
type: VARCHAR
size: 50
sidebar_value_3:
type: VARCHAR
size: 200
sidebar_title_3:
type: VARCHAR
size: 150
imgpath1:
type: VARCHAR
size: 150
imgcaption1:
type: VARCHAR
size: 1000
imgcredit1:
type: VARCHAR
size: 500
imglink1:
type: VARCHAR
size: 150
imgpath2:
type: VARCHAR
size: 150
imgcaption2:
type: VARCHAR
size: 1000
imgcredit2:
type: VARCHAR
size: 500
imglink2:
type: VARCHAR
size: 150
imgpath3:
type: VARCHAR
size: 150
imgcaption3:
type: VARCHAR
size: 1000
imgcredit3:
type: VARCHAR
size: 500
imglink3:
type: VARCHAR
size: 150
imgpath4:
type: VARCHAR
size: 150
imgcaption4:
type: VARCHAR
size: 1000
imgcredit4:
type: VARCHAR
size: 500
imglink4:
type: VARCHAR
size: 150
imgpath5:
type: VARCHAR
size: 150
imgcaption5:
type: VARCHAR
size: 1000
imgcredit5:
type: VARCHAR
size: 500
imglink5:
type: VARCHAR
size: 150
aobject1:
type: VARCHAR
size: 50
aparams1:
type: LONGVARCHAR
aobject2:
type: VARCHAR
size: 50
aparams2:
type: LONGVARCHAR
aobject3:
type: VARCHAR
size: 50
aparams3:
type: LONGVARCHAR
allow_comments:
type: CHAR
size: 1
required: true
default: D
show_comments:
type: CHAR
size: 1
required: true
default: D
stripped_search_1:
type: LONGVARCHAR
stripped_search_2:
type: LONGVARCHAR
rel_type_1:
type: VARCHAR
size: 50
rel_data_1:
type: LONGVARCHAR
rel_type_2:
type: VARCHAR
size: 50
rel_data_2:
type: LONGVARCHAR
rel_type_3:
type: VARCHAR
size: 50
rel_data_3:
type: LONGVARCHAR
rel_type_4:
type: VARCHAR
size: 50
rel_data_4:
type: LONGVARCHAR
rel_type_5:
type: VARCHAR
size: 50
rel_data_5:
type: LONGVARCHAR
_indexes:
ByTextID:
- textid
- state
ByContentType:
- content_type
- content_date
ByLegacy:
- legacyid
Issue1:
- issue_date
- issue_toc_id
- issue_page
Retr01:
- state
- content_type
- content_date
- live_date
Retr02:
- state
- content_type
- reference_link_1
- content_date
- live_date
Ref03:
- state
- reference_link_1
- content_date
ByAlias:
- aliastext
- state
ByPackage:
- package_tags
- state
mercer_content_header:
_attributes:
idMethod: native
id:
type: BIGINT
required: true
autoIncrement: true
primaryKey: true
textid:
type: VARCHAR
size: 200
required: true
content_type:
type: INTEGER
required: true
created_at:
type: TIMESTAMP
required: true
created_by:
type: VARCHAR
size: 30
required: true
updated_at:
type: TIMESTAMP
required: true
updated_by:
type: VARCHAR
size: 30
required: true
title:
type: VARCHAR
size: 250
required: true
author_str:
type: VARCHAR
size: 250
content_date:
type: TIMESTAMP
live_date:
type: TIMESTAMP
published_at:
type: TIMESTAMP
published_by:
type: VARCHAR
size: 30
locked_by:
type: VARCHAR
size: 30
locked_at:
type: TIMESTAMP
_indexes:
textid:
- textid
mercer_content_history:
id:
type: BIGINT
required: true
state:
type: CHAR
size: 1
required: true
default: W
legacyid:
type: VARCHAR
size: 50
textid:
type: VARCHAR
size: 50
content_hint:
type: CHAR
size: 1
aliastext:
type: VARCHAR
size: 20
package_tags:
type: VARCHAR
size: 200
priority:
type: FLOAT
default: 0
reference_link_1:
type: INTEGER
alt_info_1:
type: VARCHAR
size: 200
required: true
alt_info_2:
type: LONGVARCHAR
required: true
parent_content_id:
type: INTEGER
created_at:
type: TIMESTAMP
required: true
created_by:
type: VARCHAR
size: 30
required: true
updated_at:
type: TIMESTAMP
required: true
updated_by:
type: VARCHAR
size: 30
required: true
published_at:
type: TIMESTAMP
published_by:
type: VARCHAR
size: 30
content_type:
type: INTEGER
required: true
protect:
type: CHAR
size: 1
required: true
default: Y
override_channel:
type: VARCHAR
size: 50
override_adsite:
type: VARCHAR
size: 50
override_adzone:
type: VARCHAR
size: 50
override_mlc:
type: VARCHAR
size: 200
required: true
direct_url:
type: VARCHAR
size: 250
pvar1:
type: VARCHAR
size: 100
required: true
pvar2:
type: LONGVARCHAR
required: true
content_date:
type: TIMESTAMP
live_date:
type: TIMESTAMP
issue_date:
type: DATE
required: true
issue_toc_id:
type: INTEGER
issue_page:
type: INTEGER
toc_title:
type: VARCHAR
size: 500
toc_subtitle:
type: LONGVARCHAR
title:
type: VARCHAR
size: 200
required: true
title_link:
type: VARCHAR
size: 150
subtitle:
type: VARCHAR
size: 300
required: true
author1:
type: INTEGER
required: true
default: 0
author2:
type: INTEGER
required: true
default: 0
author3:
type: INTEGER
required: true
default: 0
author4:
type: INTEGER
required: true
default: 0
author_ids:
type: VARCHAR
size: 100
required: true
author_str:
type: VARCHAR
size: 500
required: true
topic_ids:
type: VARCHAR
size: 100
required: true
topic_str:
type: LONGVARCHAR
required: true
assoc1_ids:
type: VARCHAR
size: 200
required: true
assoc1_str:
type: LONGVARCHAR
required: true
assoc2_ids:
type: VARCHAR
size: 200
required: true
assoc2_str:
type: LONGVARCHAR
required: true
assoc3_ids:
type: VARCHAR
size: 200
required: true
assoc3_str:
type: LONGVARCHAR
required: true
hp_include:
type: CHAR
size: 1
required: true
default: N
hp_seq:
type: INTEGER
required: true
default: 0
hp_title:
type: CHAR
size: 200
hp_text:
type: LONGVARCHAR
hp_include_image:
type: CHAR
size: 1
required: true
default: N
hp_image:
type: VARCHAR
size: 200
promo_text_1:
type: VARCHAR
size: 1000
required: true
promo_text_2:
type: VARCHAR
size: 1000
required: true
meta_desc:
type: LONGVARCHAR
required: true
meta_keywords:
type: LONGVARCHAR
required: true
meta_title:
type: VARCHAR
size: 300
required: true
tags:
type: LONGVARCHAR
required: true
mercer_abstract:
type: LONGVARCHAR
required: true
pcontent:
type: LONGVARCHAR
required: true
scontent:
type: LONGVARCHAR
altcontent:
type: LONGVARCHAR
orig_content:
type: LONGVARCHAR
suppress_standard_sidebars:
type: CHAR
size: 1
required: true
default: N
use_sidebar:
type: CHAR
size: 1
required: true
default: N
sidebar_title:
type: VARCHAR
size: 1000
sidebar_html:
type: LONGVARCHAR
sidebar_object_1:
type: VARCHAR
size: 50
sidebar_value_1:
type: VARCHAR
size: 200
sidebar_title_1:
type: VARCHAR
size: 150
sidebar_object_2:
type: VARCHAR
size: 50
sidebar_value_2:
type: VARCHAR
size: 200
sidebar_title_2:
type: VARCHAR
size: 150
sidebar_object_3:
type: VARCHAR
size: 50
sidebar_value_3:
type: VARCHAR
size: 200
sidebar_title_3:
type: VARCHAR
size: 150
imgpath1:
type: VARCHAR
size: 150
imgcaption1:
type: VARCHAR
size: 1000
imgcredit1:
type: VARCHAR
size: 500
imglink1:
type: VARCHAR
size: 150
imgpath2:
type: VARCHAR
size: 150
imgcaption2:
type: VARCHAR
size: 1000
imgcredit2:
type: VARCHAR
size: 500
imglink2:
type: VARCHAR
size: 150
imgpath3:
type: VARCHAR
size: 150
imgcaption3:
type: VARCHAR
size: 1000
imgcredit3:
type: VARCHAR
size: 500
imglink3:
type: VARCHAR
size: 150
imgpath4:
type: VARCHAR
size: 150
imgcaption4:
type: VARCHAR
size: 1000
imgcredit4:
type: VARCHAR
size: 500
imglink4:
type: VARCHAR
size: 150
imgpath5:
type: VARCHAR
size: 150
imgcaption5:
type: VARCHAR
size: 1000
imgcredit5:
type: VARCHAR
size: 500
imglink5:
type: VARCHAR
size: 150
aobject1:
type: VARCHAR
size: 50
aparams1:
type: LONGVARCHAR
aobject2:
type: VARCHAR
size: 50
aparams2:
type: LONGVARCHAR
aobject3:
type: VARCHAR
size: 50
aparams3:
type: LONGVARCHAR
allow_comments:
type: CHAR
size: 1
required: true
default: N
show_comments:
type: CHAR
size: 1
required: true
default: N
stripped_search_1:
type: LONGVARCHAR
stripped_search_2:
type: LONGVARCHAR
rel_type_1:
type: VARCHAR
size: 50
rel_data_1:
type: LONGVARCHAR
rel_type_2:
type: VARCHAR
size: 50
rel_data_2:
type: LONGVARCHAR
rel_type_3:
type: VARCHAR
size: 50
rel_data_3:
type: LONGVARCHAR
rel_type_4:
type: VARCHAR
size: 50
rel_data_4:
type: LONGVARCHAR
rel_type_5:
type: VARCHAR
size: 50
rel_data_5:
type: LONGVARCHAR
mercer_content_type:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
parent:
type: INTEGER
required: true
lft:
type: INTEGER
required: true
rgt:
type: INTEGER
required: true
literal:
type: VARCHAR
size: 50
required: true
alias:
type: VARCHAR
size: 50
required: true
seq:
type: INTEGER
required: true
default: 50
assignable:
type: CHAR
size: 1
required: true
default: N
searchable:
type: CHAR
size: 1
required: true
default_protected:
type: CHAR
size: 1
required: true
indexable:
type: CHAR
size: 1
required: true
default: Y
default_show_comments:
type: CHAR
size: 1
required: true
default: N
default_allow_comments:
type: CHAR
size: 1
required: true
default: N
cmaobject:
type: VARCHAR
size: 50
required: true
cdaobject:
type: VARCHAR
size: 50
required: true
cdaaction:
type: VARCHAR
size: 50
required: true
channel:
type: VARCHAR
size: 50
required: true
adsite:
type: VARCHAR
size: 50
adzone:
type: VARCHAR
size: 50
mlc:
type: VARCHAR
size: 500
bc_link:
type: VARCHAR
size: 200
required: true
bc_text:
type: VARCHAR
size: 100
required: true
srch_heading:
type: VARCHAR
size: 200
required: true
_indexes:
byparent:
- parent
- seq
- literal
ct_textid:
- alias
mercer_insider_issue:
id:
type: INTEGER
required: true
primaryKey: true
issue_date:
type: DATE
required: true
issue_text_date:
type: VARCHAR
size: 100
required: true
issue_title:
type: VARCHAR
size: 300
required: true
issue_intro:
type: LONGVARCHAR
content_block_1:
type: LONGVARCHAR
content_block_2:
type: LONGVARCHAR
issue_live_date:
type: TIMESTAMP
required: true
bg_live_date:
type: TIMESTAMP
required: true
link_live_date:
type: TIMESTAMP
required: true
_indexes:
issue_date:
- issue_date
mercer_issue:
id:
type: INTEGER
required: true
primaryKey: true
issue_date:
type: DATE
required: true
issue_text_date:
type: VARCHAR
size: 100
required: true
issue_title:
type: VARCHAR
size: 300
required: true
issue_intro:
type: LONGVARCHAR
content_block_1:
type: LONGVARCHAR
content_block_2:
type: LONGVARCHAR
issue_live_date:
type: TIMESTAMP
required: true
bg_live_date:
type: TIMESTAMP
required: true
link_live_date:
type: TIMESTAMP
required: true
_indexes:
issue_date:
- issue_date
mercer_issue_toc:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
parent:
type: INTEGER
required: true
literal:
type: VARCHAR
size: 100
required: true
seq:
type: INTEGER
required: true
default: 50
assignable:
type: CHAR
size: 1
required: true
default: Y
stylecode:
type: VARCHAR
size: 10
required: true
_indexes:
byparent:
- parent
- seq
- literal
mercer_module_driver:
mod_key:
type: VARCHAR
size: 50
required: true
primaryKey: true
mod_state:
type: CHAR
size: 1
required: true
primaryKey: true
default: W
mod_title:
type: VARCHAR
size: 500
mod_value:
type: LONGVARCHAR
mercer_old_authors:
ID:
type: INTEGER
required: true
primaryKey: true
default: 0
PICTURE:
type: VARCHAR
size: 80
TITLE:
type: VARCHAR
size: 80
LNAME:
type: VARCHAR
size: 80
MNAME:
type: VARCHAR
size: 80
FNAME:
type: VARCHAR
size: 80
testing_BEAT_SHORT:
type: VARCHAR
size: 120
WS_TASTER:
type: VARCHAR
size: 1
AUTHOR_DISPLAY:
type: VARCHAR
size: 600
AUTHOR_DISPLAY_TEXT:
type: CHAR
size: 200
testing_BEAT:
type: LONGVARCHAR
HOT_WINES:
type: VARCHAR
size: 1
VGN_USERNAME:
type: VARCHAR
size: 15
BLOG_PHOTO:
type: VARCHAR
size: 50
BLOG_BIO:
type: VARCHAR
size: 4000
AUTHOR_EMAIL:
type: VARCHAR
size: 100
BLOGGER_TITLE:
type: VARCHAR
size: 100
BLOG_ACTIVE:
type: CHAR
size: 1
BLOGGER_INTRO:
type: VARCHAR
size: 500
GUEST_BLOGGER:
type: CHAR
size: 1
BLOGGER_INTRO_PHOTO:
type: VARCHAR
size: 50
WWDN_FLAG:
type: VARCHAR
size: 1
WWDN_CAPTION:
type: VARCHAR
size: 4000
WWDN_PHOTO:
type: VARCHAR
size: 200
AUTHOR_IDMATCHER:
type: VARCHAR
size: 30
HOT_rivet:
type: VARCHAR
size: 100
required: true
AUTHOR_TEMP:
type: VARCHAR
size: 200
required: true
BLOGGER_HP_PHOTO:
type: VARCHAR
size: 200
required: true
BLOGGER_JOB_TITLE:
type: VARCHAR
size: 200
required: true
BLOGGER_ORDER:
type: VARCHAR
size: 20
required: true
_indexes:
AUTHOR_DISPLAY:
- AUTHOR_DISPLAY
AUTHOR_DISPLAY_TEXT:
- AUTHOR_DISPLAY_TEXT
mercer_old_blog_posts:
ID:
type: INTEGER
AUTHOR_FID:
type: INTEGER
TITLE:
type: VARCHAR
size: 1000
POST_DATE:
type: TIMESTAMP
KEYWORD_ID_1:
type: INTEGER
KEYWORD_ID_2:
type: INTEGER
KEYWORD_ID_3:
type: INTEGER
CREATE_DATE:
type: TIMESTAMP
LAST_UPDATED:
type: TIMESTAMP
UPDATED_BY:
type: VARCHAR
size: 20
POST_STATUS:
type: VARCHAR
size: 20
CONTENT:
type: LONGVARCHAR
PHOTO:
type: VARCHAR
size: 50
CAPTION:
type: VARCHAR
size: 200
_indexes:
ID:
- ID
mercer_old_ca_profiles:
ID:
type: INTEGER
required: true
primaryKey: true
NAME:
type: VARCHAR
size: 200
DESIGNATION:
type: VARCHAR
size: 300
TITLE:
type: VARCHAR
size: 1000
SUBTITLE:
type: VARCHAR
size: 1000
PROFILE_TYPE:
type: VARCHAR
size: 120
AUTHOR:
type: VARCHAR
size: 200
AUTHOR_FID:
type: INTEGER
WEBCONTENT:
type: LONGVARCHAR
ISSUE_FID:
type: INTEGER
ISSUE_DATE:
type: DATE
LAST_MODIFIED:
type: DATE
POST_DATE:
type: DATE
TITLE_FORMAT:
type: VARCHAR
size: 200
SUBTITLE_FORMAT:
type: VARCHAR
size: 200
PHOTO:
type: VARCHAR
size: 50
SORT_BY:
type: VARCHAR
size: 50
OLD_URL:
type: VARCHAR
size: 100
mercer_old_feature_types:
ID:
type: INTEGER
required: true
primaryKey: true
FEATURE_CATEGORY:
type: VARCHAR
size: 80
FEATURE_SUBCATEGORY:
type: VARCHAR
size: 80
FEATURE_TYPE:
type: VARCHAR
size: 200
FEATURE_SUBTYPE:
type: VARCHAR
size: 200
DISPLAY_GRAPHIC:
type: VARCHAR
size: 80
mercer_old_features:
ID:
type: INTEGER
required: true
primaryKey: true
default: 0
TITLE:
type: VARCHAR
size: 1000
SUBTITLE:
type: VARCHAR
size: 1000
AUTHOR_FID:
type: INTEGER
WEBCONTENT:
type: LONGVARCHAR
ISSUE_FID:
type: INTEGER
LAST_MODIFIED:
type: DATE
ISSUE_DATE:
type: DATE
FEATURE_TYPE2:
type: VARCHAR
size: 120
FEATURE_TYPE3:
type: VARCHAR
size: 120
AUTHOR_TEMP:
type: VARCHAR
size: 120
FEATURE_TYPE:
type: VARCHAR
size: 120
OLD_URL:
type: VARCHAR
size: 120
LIVE_DATE:
type: DATE
TITLE_FORMAT:
type: VARCHAR
size: 200
SUBTITLE_FORMAT:
type: VARCHAR
size: 200
SHOW_PHOTO:
type: VARCHAR
size: 50
OLD_FLAG:
type: VARCHAR
size: 1
AUTHOR:
type: VARCHAR
size: 600
POST_DATE:
type: DATE
FEATURE_TYPE_FID:
type: INTEGER
FEATURE_TYPE_FID2:
type: INTEGER
FEATURE_TYPE_FID3:
type: INTEGER
WHATS_NEW:
type: VARCHAR
size: 1
INDEX_DESCRIPTION:
type: VARCHAR
size: 1000
FEATURE_TYPE_HOLDER:
type: VARCHAR
size: 200
EMAIL_BLURB:
type: VARCHAR
size: 300
HOMEPAGE_BLURB:
type: VARCHAR
size: 400
PHOTO_LARGE:
type: VARCHAR
size: 40
CAPTION:
type: VARCHAR
size: 1000
SIDEBAR_HTML:
type: VARCHAR
size: 4000
SHOW_SIDEBAR:
type: CHAR
size: 1
LIVE_TIME:
type: VARCHAR
size: 20
WHATS_NEW_PHOTO:
type: VARCHAR
size: 30
PHOTO_EXPIRES:
type: DATE
SHORT_CAPTION:
type: VARCHAR
size: 30
_indexes:
ID:
- ID
mercer_old_issue_list:
ID:
type: INTEGER
required: true
primaryKey: true
default: 0
ISSUE_DATE:
type: DATE
ISSUE_TAG:
type: VARCHAR
size: 80
COVER_IMG_SM:
type: VARCHAR
size: 80
COVER_IMG_MID:
type: VARCHAR
size: 80
COVER_IMG_LRG:
type: VARCHAR
size: 80
COVER_STORY:
type: VARCHAR
size: 80
SHORT_DESCRIPTION:
type: VARCHAR
size: 1000
LONG_DESCRIPTION:
type: VARCHAR
size: 3000
DISPLAY_FLAG:
type: CHAR
size: 1
TABLE_OF_CONTENTS:
type: LONGVARCHAR
POST_DATE:
type: DATE
_indexes:
ISSUE_DATE:
- ISSUE_DATE
mercer_old_issues_archive:
ID:
type: INTEGER
required: true
default: 0
TITLE:
type: VARCHAR
size: 500
AUTHOR_FID:
type: INTEGER
CONTENT:
type: LONGVARCHAR
ISSUE_DATE:
type: DATE
FEATURE_TYPE:
type: VARCHAR
size: 120
ISSUE_FID:
type: INTEGER
OLD_URL:
type: VARCHAR
size: 200
AUTHOR_TEMP:
type: VARCHAR
size: 600
ARTICLE_TYPE:
type: VARCHAR
size: 80
SUBTITLE:
type: VARCHAR
size: 500
FEATURE_TYPE_FID:
type: INTEGER
_indexes:
AUTHOR_FID:
- AUTHOR_FID
ID:
- ID
mercer_people:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
textid:
type: VARCHAR
size: 20
legacyid:
type: VARCHAR
size: 50
lastn:
type: VARCHAR
size: 50
required: true
firstn:
type: VARCHAR
size: 50
required: true
fulln:
type: VARCHAR
size: 100
required: true
title:
type: VARCHAR
size: 75
email:
type: VARCHAR
size: 200
meta_description:
type: LONGVARCHAR
is_linkable:
type: CHAR
size: 1
required: true
default: N
is_active:
type: CHAR
size: 1
required: true
default: N
is_editor:
type: CHAR
size: 1
required: true
default: N
is_taster:
type: CHAR
size: 1
required: true
default: N
bio_formal:
type: LONGVARCHAR
bio_short:
type: LONGVARCHAR
bio_informal:
type: LONGVARCHAR
testingbeat:
type: LONGVARCHAR
imgid1:
type: INTEGER
default: 0
imgpath1:
type: VARCHAR
size: 200
imgcap1:
type: VARCHAR
size: 1000
imgcred1:
type: VARCHAR
size: 200
imgid2:
type: INTEGER
default: 0
imgpath2:
type: VARCHAR
size: 200
imgcap2:
type: VARCHAR
size: 1000
imgcred2:
type: VARCHAR
size: 200
imgid3:
type: INTEGER
imgpath3:
type: VARCHAR
size: 200
imgcap3:
type: VARCHAR
size: 1000
imgcred3:
type: VARCHAR
size: 200
imgid4:
type: INTEGER
imgpath4:
type: VARCHAR
size: 200
imgcap4:
type: VARCHAR
size: 1000
imgcred4:
type: VARCHAR
size: 200
_indexes:
lastn:
- lastn
textid:
- textid
ByTextId:
- textid
mercer_redirects:
_attributes:
idMethod: native
id:
type: BIGINT
required: true
autoIncrement: true
primaryKey: true
startdate:
type: DATE
default: 2009-01-01
enddate:
type: DATE
incoming:
type: VARCHAR
size: 250
required: true
target:
type: VARCHAR
size: 250
required: true
_indexes:
ByLink:
- incoming
- startdate
- enddate
mercer_save_groups:
savegroup_type:
type: VARCHAR
size: 50
required: true
primaryKey: true
savegroup_long:
type: VARCHAR
size: 500
required: true
savegroup_short:
type: VARCHAR
size: 50
required: true
mercer_saved:
_attributes:
idMethod: native
save_id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
save_userid:
type: VARCHAR
size: 50
required: true
save_type:
type: VARCHAR
size: 10
required: true
save_date_create:
type: TIMESTAMP
required: true
save_title_1:
type: VARCHAR
size: 200
required: true
save_title_2:
type: VARCHAR
size: 500
save_link:
type: VARCHAR
size: 1000
required: true
save_group:
type: VARCHAR
size: 50
_indexes:
User:
- save_userid
- save_type
- save_group
- save_title_1
UserGroup:
- save_userid
- save_group
mercer_topic:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
parent:
type: INTEGER
required: true
literal:
type: VARCHAR
size: 50
required: true
seq:
type: INTEGER
required: true
default: 50
_indexes:
byparent:
- parent
- seq
- literal
mercer_topic_index:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
textid:
type: VARCHAR
size: 50
title:
type: VARCHAR
size: 100
required: true
description:
type: VARCHAR
size: 255
channel:
type: VARCHAR
size: 100
required: true
topic_list:
type: VARCHAR
size: 200
required: true
content_type_list:
type: VARCHAR
size: 200
required: true
_indexes:
textid:
- textid
mercer_topic_xref:
state:
type: CHAR
size: 1
required: true
content_id:
type: INTEGER
required: true
content_type:
type: INTEGER
required: true
topic_id:
type: INTEGER
required: true
_indexes:
ByID:
- content_id
- state
ByTopic:
- topic_id
- content_type
mercer_user_list:
_attributes:
idMethod: native
id:
type: BIGINT
required: true
autoIncrement: true
primaryKey: true
valid:
type: CHAR
size: 1
required: true
default: N
email:
type: VARCHAR
size: 200
required: true
lastn:
type: VARCHAR
size: 80
required: true
firstn:
type: VARCHAR
size: 80
required: true
passwd:
type: VARCHAR
size: 50
required: true
created_at:
type: TIMESTAMP
required: true
validated_at:
type: TIMESTAMP
required: true
validated_ip:
type: VARCHAR
size: 40
required: true
lastaccess_at:
type: TIMESTAMP
required: true
user_class:
type: VARCHAR
size: 10
required: true
attr1:
type: VARCHAR
size: 100
required: true
attr2:
type: VARCHAR
size: 100
required: true
attr3:
type: VARCHAR
size: 100
required: true
attr4:
type: VARCHAR
size: 100
required: true
_indexes:
ByValid:
- valid
- email
email:
- email
mercer_user_registry:
USER_ID:
type: VARCHAR
size: 50
required: true
primaryKey: true
KEY_NAME:
type: VARCHAR
size: 100
required: true
primaryKey: true
KEY_VALUE:
type: LONGVARCHAR
_indexes:
KeyVal:
- KEY_VALUE
- KEY_NAME
USER_ID:
- USER_ID
KEY_NAME:
- KEY_NAME
- KEY_VALUE
mercer_wcp:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
rivet_id:
type: INTEGER
country:
type: VARCHAR
size: 100
rivet_name:
type: VARCHAR
size: 120
home_page_blurb:
type: VARCHAR
size: 250
rivet_size:
type: VARCHAR
size: 100
length:
type: VARCHAR
size: 10
ring_gauge:
type: INTEGER
filler:
type: VARCHAR
size: 100
binder:
type: VARCHAR
size: 100
wrapper:
type: VARCHAR
size: 100
score:
type: INTEGER
price:
type: VARCHAR
size: 100
testing_report:
type: VARCHAR
size: 3000
live_date:
type: DATE
taster_id:
type: INTEGER
small_image:
type: VARCHAR
size: 100
large_image:
type: VARCHAR
size: 100
matched:
type: VARCHAR
size: 1
required: true
default: N
_indexes:
country:
- country
- rivet_name
- filler
- binder
- wrapper
- testing_report
files:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
user_id:
type: INTEGER
foreignTable: sf_guard_user
foreignReference: id
onDelete: RESTRICT
onUpdate: RESTRICT
file_name:
type: VARCHAR
size: 255
required: true
default:
description:
type: LONGVARCHAR
required: true
category:
type: VARCHAR
size: 255
required: true
default:
created_at:
type: TIMESTAMP
updated_at:
type: TIMESTAMP
_indexes:
files_FI_1:
- user_id
_uniques:
id:
- id
sf_guard_group:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
name:
type: VARCHAR
size: 255
required: true
description:
type: LONGVARCHAR
_uniques:
sf_guard_group_name_unique:
- name
sf_guard_group_permission:
group_id:
type: INTEGER
required: true
primaryKey: true
permission_id:
type: INTEGER
required: true
primaryKey: true
_indexes:
sf_guard_group_permission_FI_2:
- permission_id
sf_guard_permission:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
name:
type: VARCHAR
size: 255
required: true
description:
type: LONGVARCHAR
_uniques:
sf_guard_permission_name_unique:
- name
sf_guard_remember_key:
user_id:
type: INTEGER
required: true
primaryKey: true
remember_key:
type: VARCHAR
size: 32
ip_address:
type: VARCHAR
size: 50
required: true
primaryKey: true
created_at:
type: TIMESTAMP
sf_guard_user:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
username:
type: VARCHAR
size: 128
required: true
algorithm:
type: VARCHAR
size: 128
required: true
default: sha1
salt:
type: VARCHAR
size: 128
required: true
password:
type: VARCHAR
size: 128
required: true
created_at:
type: TIMESTAMP
last_login:
type: TIMESTAMP
is_active:
type: INTEGER
required: true
default: 1
is_super_admin:
type: INTEGER
required: true
default: 0
_uniques:
sf_guard_user_username_unique:
- username
sf_guard_user_group:
user_id:
type: INTEGER
required: true
primaryKey: true
group_id:
type: INTEGER
required: true
primaryKey: true
_indexes:
sf_guard_user_group_FI_2:
- group_id
sf_guard_user_permission:
user_id:
type: INTEGER
required: true
primaryKey: true
permission_id:
type: INTEGER
required: true
primaryKey: true
_indexes:
sf_guard_user_permission_FI_2:
- permission_id
temp_ct:
_attributes:
idMethod: native
id:
type: INTEGER
required: true
autoIncrement: true
primaryKey: true
parent:
type: INTEGER
required: true
literal:
type: VARCHAR
size: 50
required: true
_indexes:
byparent:
- parent
- literal
temp_edredirs:
src:
type: VARCHAR
size: 500
required: true
dst:
type: VARCHAR
size: 500
required: true
temp_subredirs:
src:
type: VARCHAR
size: 500
required: true
dst:
type: VARCHAR
size: 500
required: true



Could the change for format, from minimal style to a more verbose style, cause problems?

What about the inclusion of the sf_guard_user tables?

Or would this just be a problem of white space gone wrong?

Answers (4)

2010-04-30

casivaagustin answers:

Check if your schema.yml does not have the definition for sf_guard_* table, if you do a build-schema this probably happens and when try to build the table of the plugin throw the error because is duplicate in config/schema.yml and plugin/sfGuardPlugin/config/schema.yml


marshall comments:

Ah, I see. That must be it then.


marshall comments:

Yes, just checked. That is the problem. Thanks.

2010-04-30

Eduardo Raffoul answers:

Please, check the indentation on your schema.yml

It should go like this
propel:
table1:
attribute: ....
table2:



and so on.

It would help if you copy the entire schema.yml, or at least the head of your schema.yml cause' it's not clear for me what's the structure you have.

----------------------------

Marshall,

Don't copy your entire schema.yml, please paste the first 25 lines please. And also you propel.ini file. And as sais Marcos Ibañez, check that you have the XSLT module enabled (look for it in your server php.ini file)


marshall comments:

Like I said, I searched for "propel" but it only appears once in the file.

One problem is the file is so long, w, with a 100 tables. I can not send the whole table.

But this is interesting: I changed "propel" to "default" and one error went away. The command "symfony propel-build-model" worked. But now in my web pages I am getting a different error:


Warning: include_once(p.php) [function.include-once]: failed to open stream: No such file or directory in /usr/share/php/symfony/vendor/creole/Creole.php on line 366

Warning: include_once() [function.include]: Failed opening 'p.php' for inclusion (include_path='/home/mercer/dev/mercer/lib:/home/mercer/dev/mercer:/home/mercer/dev/mercer/apps/wso/lib:/usr/share/php/symfony/vendor:.:/usr/share/php:/usr/share/pear') in /usr/share/php/symfony/vendor/creole/Creole.php on line 366

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/php/symfony/vendor/creole/Creole.php:366) in /usr/share/php/symfony/exception/sfException.class.php on line 101

[PropelException]
[wrapped: Unable to load driver class: p [User Info: Array]]

stack trace
at ()
in SF_SYMFONY_LIB_DIR/vendor/propel/Propel.php line 489 ...
try {

$con = Creole::getConnection($dsn);

} catch (SQLException $e) {

throw new PropelException($e);

}

self::$connectionMap[$name] = $con;

}
at Propel::getConnection('default')
in ...

2010-04-30

Nirav Ranpara answers:

Hi Marshall,

Can you please send us your schema file ?

2010-04-30

Marcos Ibañez answers:

Maybe the problema has something to do with the fact that your php doesn't seems to have XSLT enabled. You shoud enable it and try again.