#188 Non-numeric series numbers error out in Title Update

[Ahasuerus]

When approving a Title Edit submission which includes a non-numeric series number, the Python script ta_update.cgi errors out:

SQL Updates:

* update titles set title_seriesnum='fg' where title_id=1161919 --> -->

<class '_mysql_exceptions.DataError'> Python 2.5.4: C:\usr\bin\python.exe
Sat Nov 27 21:25:29 2010

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
C:\Program Files\Apache Software Foundation\Apache2.2\cgi-bin\mod\ta_update.cgi in ()
69 #UpdateColumn(merge, 'Translator', 'title_xlate', Record)
70 UpdateColumn(merge, 'Year', 'title_copyright', Record)
71 UpdateColumn(merge, 'Seriesnum', 'title_seriesnum', Record)
72 UpdateColumn(merge, 'Storylen', 'title_storylen', Record)
73 UpdateColumn(merge, 'Wikipedia', 'title_wikipedia', Record)
UpdateColumn = <function UpdateColumn at 0x011CF570>, merge = [<DOM Element: TitleUpdate at 0x11a6850>], Record = '1161919'
C:\Program Files\Apache Software Foundation\Apache2.2\cgi-bin\mod\ta_update.cgi in UpdateColumn(doc=[<DOM Element: TitleUpdate at 0x11a6850>], tag='Seriesnum', column='title_seriesnum', id='1161919')
36 print "<li> ", update
37 if debug == 0:
38 db.query(update)
39
40
global db = <_mysql.connection open to 'localhost' at 9d8be0>, db.query = <built-in method query of Connection object at 0x009D8BE0>, update = "update titles set title_seriesnum='fg' where title_id=1161919"

<class '_mysql_exceptions.DataError'>: (1264, "Out of range value adjusted for column 'title_seriesnum' at row 1")
args = (1264, "Out of range value adjusted for column 'title_seriesnum' at row 1")
message = ''

[Ahasuerus]

Fixed in r2010-80 by adding JavaScript and server-side checks to ensure that only 1-9 digits can be entered as in the Series Number field.