which database are you using?

On Dec 21, 12:57 am, Johann Spies <johann.sp...@gmail.com> wrote:
> On 20 December 2010 19:35, mdipierro <mdipie...@cs.depaul.edu> 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

Reply via email to