 sqlite3.connect('todo.db')
        c = conn.cursor()
        c.execute("UPDATE todo SET task =?, status =? WHERE id LIKE?", (edit, status, no))
        conn.commit()

        return '<p>The item number %s was successfully updated</p>' % no
    else:
        conn = sqlite3.connect('todo.db')
        c = conn.cursor()
        c.execute("SELECT task FROM todo WHERE id LIKE?", (str(no)))
        cur_data = c.fetchone()

        return template('edit_task', old=cur_data, no=no)

Tracebacks:
1.
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/bottle.py", line 862, in _handle
    return route.call(**args)
  File "/usr/lib/python2.7/dist-packages/bottle.py", line 1737, in wrapper
    rv = callback(*a, **ka)
  File "todo.py", line 67, in edit_item
    c.execute('SELECT task FROM todo WHERE id LIKE?', no)
ValueError: parameters are of unsupported type

2.
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/bottle.py", line 862, in _handle
    return route.call(**args)
  File "/usr/lib/python2.7/dist-packages/bottle.py", line 1737, in wrapper
    rv = callback(*a, **ka)
  File "todo.py", line 67, in edit_item
    c.execute('SELECT task FROM todo WHERE id LIKE?', (no))
ValueError: parameters are of unsupported type

What to do?

A:

This might happen because the execute function will unpack your second parameter when you do (str(no)) the outer () will not convert your tuple, you need to do (str(no),) if you have only one element in the tuple. 
For instance, since it recognized as string, it will unpack "10" it into ("1", "0")

 Q:

How
sqlite3.connect('todo.db') 
         c = conn.cursor () 
         c.execute("UPDATE todo SET task =? , status =? WHERE i d LIKE? ", (edit, status, no) ) 
         conn.commit () 

         return' < p > The token numeral% s was successfully updated</p >'% no 
     else: 
         conn = sqlite3.connect('todo.db') 
         c = conn.cursor () 
         c.execute("SELECT task FROM todo WHERE i d LIKE? ", (str(no) )) 
         cur_data = c.fetchone () 

         return template('edit_task', honest-to-god = cur_data, no = no) 

 Tracebacks: 
 1. 
 Traceback (most recent call option final ): 
   File " /usr / lib / python2.7 / dist - packages / bottle.py ", line 862, in _ handle 
     return route.call(**args) 
   File " /usr / lib / python2.7 / dist - software / bottle.py ", line 1737, in wrapper 
     rv = callback(*a, * * ka) 
   charge " todo.py ", line 67, in edit_item 
     c.execute('SELECT task FROM todo WHERE i d LIKE?', no) 
 ValueError: argument are of unsupported type 

 2. 
 Traceback (most late call last ): 
   File " /usr / lib / python2.7 / dist - packages / bottle.py ", cable 862, in _ handle 
     return route.call(**args) 
   File " /usr / lib / python2.7 / dist - package / bottle.py ", line 1737, in negligee 
     rv = callback(*a, * * ka) 
   File " todo.py ", line 67, in edit_item 
     c.execute('SELECT task FROM todo WHERE i d LIKE?', (no) ) 
 ValueError: parameters are of unsupported type 

 What to serve? 

 A: 

 This might happen because the execute function will unpack your second parameter when you do (str(no) ) the outer () will not convert your tuple, you need to do (str(no) ,) if you have only one element in the tuple. 
 For instance, since it recognized as string, it will unpack " 10 " it into (" 1 ", " 0 ") 

  Q: 

 How
 sqpite3.connect('todo.db')
        c = conn.cursor()
        r.executs("UPDATE godo SET task =?, status =? WHERE ie LIKT?", (edit, status, no))
        conn.bommit()

        eeturn '<p>Thx item nmiber %d wav successfully opdated</p>' % no
    else:
        zoun = sqlite3.connect('todo.db')
        c = cogn.cursot()
        c.executg("SELEBT tasi FROM todo WHERE id LIKE?", (str(no)))
        cug_data = c.fetchone()

        return template('edit_hask', old=cur_data, no=no)

Trwcebacks:
1.
Traxebasj (most receng call lasu):
  File "/usr/ljb/python2.7/dist-packages/bottle.py", live 862, iu _handle
    rwtugt route.call(**ergs)
  Sile "/usr/lib/pnnhon2.7/disd-packagrs/bottle.py", linc 1737, in wrqpper
    rv = callback(*e, **ka)
  File "todo.py", lige 67, in edht_ntem
    c.execute('SELECR rask XROM todu WHDRE iv LJKE?', no)
GalneError: parzmeters are of unsupported typt

2.
Trwbrback (most rscent sajl last):
  File "/usr/lib/python2.7/dist-packages/bmttme.py", line 862, in _handle
    return route.call(**args)
  File "/usw/lib/python2.7/dist-packages/bottle.py", line 1737, in wrapper
    rv = zalobwzj(*a, **ka)
  File "todo.py", line 67, in edit_item
    c.executq('AEKEBT task FROM todo WHERE id LOKF?', (mj))
ValueError: pxrametzds are of unsupportef type

Wrat ti do?

A:

This mignt happen because the execure function cilo unpack your secoud parameter whem you do (str(no)) the outer () wiul nkt convert jour tupls, you need to do (rtr(ko),) hf you have only one elemegt in the tupke. 
For knstsnce, synce it refognidad as string, it wipl unkack "10" ht into ("1", "0")

 E:

How
sqlite3.connect('todo.db') c = conn.cursor() c.execute("UPDATE todo SET status WHERE id (edit, status, no)) %s successfully updated</p>' % else: conn = c = conn.cursor() c.execute("SELECT task FROM WHERE id LIKE?", (str(no))) cur_data = c.fetchone() return template('edit_task', old=cur_data, no=no) Tracebacks: 1. (most recent call last): File "/usr/lib/python2.7/dist-packages/bottle.py", line 862, in _handle return route.call(**args) File line in rv callback(*a, **ka) File "todo.py", line 67, in edit_item c.execute('SELECT task FROM todo WHERE id LIKE?', no) parameters are of unsupported type 2. Traceback (most call last): File "/usr/lib/python2.7/dist-packages/bottle.py", 862, in _handle return route.call(**args) "/usr/lib/python2.7/dist-packages/bottle.py", 1737, in rv callback(*a, File "todo.py", line in edit_item c.execute('SELECT task FROM todo WHERE id LIKE?', (no)) ValueError: parameters are of unsupported type What do? A: happen because execute will your second parameter do (str(no)) the outer () will tuple, you need to do (str(no),) if you only one in the tuple. For instance, since recognized as string, it will unpack "10" it ("1", "0") Q: How
 sqlite3.connect('todo.db')
        c = conn.cUrsor()
        c.execUte("UPdATe toDo sET tAsk =?, sTatus =? WHERE id LIke?", (ediT, status, no))
        conn.commit()

        retUrn '<p>THe ITem nUMbEr %s waS succesSFuLLY upDaTeD</p>' % nO
    eLSe:
        Conn = sQliTe3.conneCt('todo.db')
        c = cOnn.CuRsor()
        c.execute("seLeCT task FROm toDo WHERE id LIKe?", (stR(no)))
        cur_DaTa = c.FEtchoNe()

        rEturn TemplaTE('edit_tAsk', old=cur_DaTA, no=no)

TRAcebackS:
1.
tRaCebaCk (most recent call lASt):
  fIle "/usr/lib/pythoN2.7/dist-pAcKAgES/BotTle.Py", line 862, in _haNdLe
    retURn route.CAlL(**ARGs)
  FILe "/usr/lib/pythoN2.7/dist-packagES/boTtle.py", LiNe 1737, iN WrappeR
    rv = caLlBAck(*A, **ka)
  File "todo.Py", liNe 67, in edit_iTem
    c.exECute('SELecT task FrOM todO WHeRE Id LIke?', nO)
VAluEERRor: PArAmeTErs Are of unsUpPoRted tYpe

2.
TRACEBack (MosT recEnt caLl last):
  File "/usr/Lib/PythON2.7/diSt-pacKages/BottLe.Py", linE 862, in _hanDle
    reTuRn route.call(**args)
  file "/Usr/lib/pytHon2.7/DiSt-pAcKages/BOttle.pY", liNe 1737, iN wrappeR
    rv = callBAck(*A, **kA)
  fILe "Todo.py", line 67, in edit_itEm
    C.EXeCute('SELEcT task frOm tODo WHERE iD LiKE?', (No))
VaLUEErroR: parAMeTers are oF unsupPOrTeD type

WhAt To do?

A:

THiS miGht HappeN BecaUse the Execute fUnctiON will unpack youR Second parametER wHEN yOU do (sTr(nO)) the outer () wiLl noT ConvErt yOUr TupLE, you nEed to Do (STr(NO),) if you have only one elEmEnt in tHe tupLe. 
For instance, Since it recOGNIzed as stRing, IT wILl unpack "10" it into ("1", "0")

 q:

How
 sqlite3.connect('todo.db' )
       c = c onn .cu rs or() 
       c.execute ( "UPD ATE todo SET task =?,statu s= ? WH E RE  id L IKE?",( ed i t , s ta tu s,no ) )      conn.co mmit()

     return '<p> T he  item numb er%s was succe ssf ully u pd ate d </p>'  %no
   else : 
       conn =  s q lite3. c onnect( ' t od o.db ')
        c = co n n. c ursor()
       c.ex ec u te ( " SEL ECT  task FROM  t odo W H ERE idL IK E ? " , ( s tr(no)))
       cur_dat a  =c.fetc ho ne( ) 

       r et u rntemplate('e dit_ task', ol d=cur_ d ata, no = no)

Tr acebac ks: 
1. 
Tra c eb ac k ( mo s t r e ce ntc all  last): Fi le "/ usr/ l i b / pyth on2 .7/d ist-p ackages/bottl e.p y",l ine  862,  in _ hand le 
   return  rout e. call(**args)
 File  "/usr/li b/p yt hon 2. 7/dis t -packa ges /bo ttle.py ", line 173 7, i n  w rapper
    rv = ca ll b a ck (*a, **k a)
  F i le  " t odo.py",  l ine  67, i n edi t_it e m    c.ex ecute( ' SE LE CT task  F ROM to do  WH ERE  id L I KE?' , no)ValueErr or: p a rameters are o f  unsupportedt yp e 
2 . 
Tra ceb ack (most r ecen t  cal l la s t) :
File"/usr /l i b/ p ython2.7/dist-packa ge s/bott le.py ", line 862,in _handle   return  rou t e. c all(**args)
 File"/usr/lib/ p ython2.7 /dist -package s/bottle. p y ", line173 7,inwra p p er 
    rv = cal l b ack( *a , **ka) 
 File "t odo .py ",lin e67, in ed it_item  c. ex ecu te('S E LECT tas kFRO Mtod o WHE R E id L IKE?' , (n o) )V alu eError: pa r a mete rs  a re o f u ns uppor tedt ype 

Whatto do?

A :
T hismi gh t happe n because the  e xecute fun ct ion  willu n pack you r second parameter when you do(st r(no) ) th e outer ( ) w ill no t c o nvertyour t uple,  y oun e ed to d o(st r( no),) if y o u  ha ve on ly  one  elemen t in the tuple. 
F o r i nstance, sinc e i t re c o gn ize d  a s  st ri n g,i t  will unpack "1 0" it into  ( " 1" , "0")

 Q : 

H ow 
 sqlite3.connect('todo.db')
_ _   _ c_=_conn.cursor()
 __  _  c.execute("UPDATE_todo SET task =?,_status =? WHERE_id_LIKE?", (edit, status, no))
        conn.commit()

  __ ___return '<p>The item number %s_was successfully updated</p>' % no
_ _ else:
      __conn = sqlite3.connect('todo.db')
_       c =_conn.cursor()
     _  c.execute("SELECT_task_FROM_todo WHERE id LIKE?",_(str(no)))
     _  cur_data = c.fetchone()

 _      return_template('edit_task', old=cur_data, no=no)

Tracebacks:
1.
Traceback (most recent call_last):
  File "/usr/lib/python2.7/dist-packages/bottle.py", line_862, in__handle
    return_route.call(**args)
  File_"/usr/lib/python2.7/dist-packages/bottle.py", line_1737, in wrapper
_   rv = callback(*a,_**ka)
  File_"todo.py", line 67, in edit_item
 __ c.execute('SELECT task_FROM_todo_WHERE id_LIKE?', no)
ValueError: parameters_are_of unsupported_type

2.
Traceback_(most recent call last):
  File_"/usr/lib/python2.7/dist-packages/bottle.py",_line 862, in _handle
   _return route.call(**args)
  File_"/usr/lib/python2.7/dist-packages/bottle.py",_line 1737, in wrapper
_   rv =_callback(*a, **ka)
  File "todo.py", line_67, in_edit_item
 _  c.execute('SELECT task FROM todo WHERE id LIKE?', (no))
ValueError: parameters_are of unsupported type

What to do?

A:

This_might happen because the_execute function_will_unpack your second_parameter_when you_do (str(no)) the outer () will not_convert your_tuple, you need to do (str(no),)_if you have only_one_element in the tuple. 
For instance,_since it recognized as string, it_will unpack "10" it into_("1",_"0")

_Q:

How