タイトルが採番されていないバグを修正
plugins/listmanageplugin/branches/0.3.x/ListManagePlugin/src/listmanage/listtitle.py (diff)| @@ -37,7 +37,7 @@ | ||
| 37 | 37 | try: |
| 38 | 38 | sql = '' |
| 39 | 39 | if mode == 'add': |
| 40 | - sql = (("""insert into list_title values('%s','%s','%s',(select max(order_no)+1 from list_title),'%s','%s',null)""") | |
| 40 | + sql = (("""insert into list_title values('%s','%s','%s',ifnull((select max(order_no)+1 from list_title),1),'%s','%s',null)""") | |
| 41 | 41 | % (list_id, title, description, parent_list_id, wiki_name)) |
| 42 | 42 | else: |
| 43 | 43 | sql = (("""update list_title set title='%s',description='%s',parent_list_id='%s',wiki_name='%s' where list_id='%s'""") |
| @@ -88,6 +88,7 @@ | ||
| 88 | 88 | |
| 89 | 89 | data = {"list_id":list_id,"title":title,'description':description,'order_no':order_no,'parent_list_id':parent_list_id,'wiki_name':wiki_name,'error':error,'mode':mode} |
| 90 | 90 | |
| 91 | + db.close() | |
| 91 | 92 | return 'listtitle.html', data, None |
| 92 | 93 | |
| 93 | 94 |