The problem is this field:
Field("publishers_details","string", length=1024) ,
The new dal thinks (incorrecly) this is too much. I have now fixed it
in trunk and soon post a new stable version with the fix.
Massimo
On Dec 21, 12:57 am, Johann Spies <[email protected]> wrote:
> On 20 December 2010 19:35, mdipierro <[email protected]> wrote:
>
> > web2py 1.90.6 is OUT
>
> > please check it out
>
> Upgrading from 1.90.4 broke something:
>
> Traceback (most recent call last):
> File "/home/js/web2py/gluon/restricted.py", line 188, in restricted
> exec ccode in environment
> File "/home/js/web2py/applications/kb/models/kb4.py"
> <http://127.0.0.1:8000/admin/default/edit/kb/models/kb4.py>, line 112,
> in <module>
> format=lambda r: r.source_title or 'not in database'
> File "/home/js/web2py/gluon/dal.py", line 3318, in define_table
> polymodel=polymodel)
> File "/home/js/web2py/gluon/dal.py", line 550, in create_table
> fake_migrate=fake_migrate)
> File "/home/js/web2py/gluon/dal.py", line 626, in migrate_table
> self.execute(sub_query)
> File "/home/js/web2py/gluon/dal.py", line 1058, in execute
> return self.log_execute(*a, **b)
> File "/home/js/web2py/gluon/dal.py", line 1055, in log_execute
> return self.cursor.execute(*a,**b)
> DataError: value too long for type character varying(512)
>
> The specific model:
>
> db.define_table('erkende_joernale_2009',
> Field("source_title") ,
> Field("notes") ,
> Field("print_issn") ,
> Field("frequency") ,
> Field("editors_details") ,
> Field("publishers_details","string", length=1024) ,
> Field("date_of_last_review_or_accreditation") ,
> Field("doe_2010") ,
> Field("doe_list_international_accreditation") ,
> Field("doe_2008") ,
> Field("scopus_coverage") ,
> Field("scopus") ,
> Field("scopus_active_or_inactive") ,
> Field("y2009_sjr") ,
> Field("y2009_snip") ,
> Field("isi_jif") ,
> Field("isi_5_year_impact_factor") ,
> Field("publisher_s_name") ,
> Field("ibss") ,
> Field("e_issn") ,
> Field("isi_notes_as_on_aug_2010") ,
> Field("isi_listed_2009") ,
> Field("isi_scie_2009") ,
> Field("isi_ssc_2009") ,
> Field("isi_ahc") ,
> Field("total_cites") ,
> Field("impact_factor") ,
> Field("five_year_impact_factor") ,
> Field("immediacy_index") ,
> Field("articles") ,
> Field("cited_half_life") ,
> Field("field28") ,
> Field("article_influencetm"),
> format=lambda r: r.source_title or 'not in database'
> )
>
> This works without a problem in 1.90.4
>
> Regards
> Johann
>
> --
> May grace and peace be yours in abundance through the full knowledge of God
> and of Jesus our Lord! His divine power has given us everything we need for
> life and godliness through the full knowledge of the one who called us by
> his own glory and excellence.
> 2 Pet. 1:2b,3a
