Error processing request

Parameters

Body

Error

Unknow state transition: LINE -> END

-code

1

-level

0

-errorstack

INNER {returnImm {Unknow state transition: LINE -> END} {}} CALL {my render_wikit sqlite_master The\ \[SQLite\]\ database\ holds\ metadata\ in\ the\ table\ sqlite_master.\n----\n**Table\ definition**\n\nThe\ table\ definition\ is\ as\ follows:\n\ \ \ *\ Type\ :\ Type\ is\ Index\ or\ Table.\n\ \ \ *\ name\ :\ Index\ or\ table\ name\n\ \ \ *\ tbl_name\ :\ Name\ of\ the\ table\n\ \ \ *\ rootpage\ :\ rootpage,\ internal\ to\ SQLite\n\ \ \ *\ sql\ :\ The\ \[SQL\]\ statement,\ which\ would\ create\ this\ table.\ Example:\n\ \ \ \ \ CREATE\ TABLE\ \[table2\]\ (\[t2c1\]\ VARCHAR,\ \[t2c2\]\ VARCHAR,\ CONSTRAINT\ \"p_key\"\ PRIMARY\ KEY\ (\[t2c1\],\ \[t2c2\])\ ON\ CONFLICT\ ABORT)\n----\n\[Harald\ Oehlmann\]:\ Got\ the\ following\ by\ E-Mail\ from\ \[Kevin\ Kenny\],\ which\ guides\ how\ to\ implement\ the\ functions\ below\ much\ easier:\n\n\ Yup,\ that's\ in\ tdbc::sqlite\ already.\ \ SQLite\ gives\ you\ some\ help\n\ with\ it:\ http://www.sqlite.org/pragma.html\ shows\ a\ lot.\ \ Look\ for\n\ PRAGMA\ table_info('myTable')\ to\ get\ the\ list\ of\ columns\ in\ a\ table,\n\ and\ PRAGMA\ index_list('myTable')\ to\ get\ the\ list\ of\ indices.\n\ (And\ PRAGMA\ index_info('myIndex')\ to\ get\ the\ list\ of\ columns\n\ that\ determine\ an\ index's\ ordering...)\ \n\n----\n**find\ defined\ tables**\n\nThe\ following\ procedure\ returns\ a\ list\ of\ defined\ tables.\nIts\ functionality\ is\ similar\ to\ the\ \[tclODBC\]\ command\ ''db\ tables''.\n\n\ \ \ proc\ GetTables\ \{\{NameStart\ \"\"\}\}\ \{\n\ \ \ \treturn\ \[db\ eval\ \"select\ tbl_name\ from\ sqlite_master\\\n\ \ \ \t\twhere\ (type\ =\ \\\"table\\\")\ and\ (tbl_name\ like\ \\\"\$\{NameStart\}%\\\")\"\]\n\ \ \ \}\n\n----\n**find\ defined\ columns\ of\ a\ table**\n\nThe\ functionality\ is\ similar\ to\ the\ \[tclODBC\]\ command\ ''db\ columns''.\n\n\ \ \ proc\ GetColumns\ Table\ \{\n\ \ \ \tset\ lRes\ \{\}\n\ \ \ \tset\ SQL\ \[lindex\ \[db\ eval\ \"select\ sql\ from\ sqlite_master\\\n\ \ \ \t\twhere\ type\ =\ \\\"table\\\"\ and\ tbl_name\ =\ \\\"\$\{Table\}\\\"\"\]\ 0\]\n\ \ \ \t#\ >\ Get\ outer\ paranthesis\n\ \ \ \tif\ \{\[regexp\ \{\\((.*)\\)\}\ \$SQL\ match\ SQL\]\}\ \{\n\ \ \ \t\t#\ Keys\ might\ be\ added\ at\ the\ end:\ CONSTRAINT\ ...\n\ \ \ \t\t#\ >\ Replace\ any\ (.,.,.)\ by\ *\ to\ get\ spurious\ \",\"\ away.\n\ \ \ \t\tregsub\ -all\ \{\\(\[^)\]*\\)\}\ \$SQL\ *\ SQL\n\ \ \ \t\t#\ >\ now\ split\ at\ ,\ and\ get\ all\ data\ at\ the\ start\ within\ \\\[...\\\]\n\ \ \ \t\tforeach\ VarSpec\ \[split\ \$SQL\ ,\]\ \{\n\ \ \ \t\t\tif\ \{\[regexp\\\n\ \ \ \t\t\t\t\{^\[\ \\t\]*\\\[(\[^\\\]\]*)\\\]\}\ \$VarSpec\ match\ VarName\]\}\\\n\ \ \ \t\t\t\{\n\ \ \ \t\t\t\tlappend\ lRes\ \$VarName\n\ \ \ \t\t\t\}\n\ \ \ \t\t\}\n\ \ \ \t\}\n\ \ \ \treturn\ \$lRes\n\ \ \ \}\n\n\[KBK\]\ Far\ easier\ would\ be:\n\n======\nproc\ cols\ \{db\ table\}\ \{\n\ \ \ \ set\ result\ \{\}\n\ \ \ \ \$db\ eval\ \"PRAGMA\ TABLE_INFO(\$table)\"\ row\ \{\ lappend\ result\ \$row(name)\ \}\n\ \ \ \ return\ \$result\n\}\n\n----\nSee\ also:\n\n\ \ \ *\ \[SQLite\]\n\n----\n!!!!!!\n%|\[Category\ Database\]|%\n!!!!!! regexp2} CALL {my render sqlite_master The\ \[SQLite\]\ database\ holds\ metadata\ in\ the\ table\ sqlite_master.\n----\n**Table\ definition**\n\nThe\ table\ definition\ is\ as\ follows:\n\ \ \ *\ Type\ :\ Type\ is\ Index\ or\ Table.\n\ \ \ *\ name\ :\ Index\ or\ table\ name\n\ \ \ *\ tbl_name\ :\ Name\ of\ the\ table\n\ \ \ *\ rootpage\ :\ rootpage,\ internal\ to\ SQLite\n\ \ \ *\ sql\ :\ The\ \[SQL\]\ statement,\ which\ would\ create\ this\ table.\ Example:\n\ \ \ \ \ CREATE\ TABLE\ \[table2\]\ (\[t2c1\]\ VARCHAR,\ \[t2c2\]\ VARCHAR,\ CONSTRAINT\ \"p_key\"\ PRIMARY\ KEY\ (\[t2c1\],\ \[t2c2\])\ ON\ CONFLICT\ ABORT)\n----\n\[Harald\ Oehlmann\]:\ Got\ the\ following\ by\ E-Mail\ from\ \[Kevin\ Kenny\],\ which\ guides\ how\ to\ implement\ the\ functions\ below\ much\ easier:\n\n\ Yup,\ that's\ in\ tdbc::sqlite\ already.\ \ SQLite\ gives\ you\ some\ help\n\ with\ it:\ http://www.sqlite.org/pragma.html\ shows\ a\ lot.\ \ Look\ for\n\ PRAGMA\ table_info('myTable')\ to\ get\ the\ list\ of\ columns\ in\ a\ table,\n\ and\ PRAGMA\ index_list('myTable')\ to\ get\ the\ list\ of\ indices.\n\ (And\ PRAGMA\ index_info('myIndex')\ to\ get\ the\ list\ of\ columns\n\ that\ determine\ an\ index's\ ordering...)\ \n\n----\n**find\ defined\ tables**\n\nThe\ following\ procedure\ returns\ a\ list\ of\ defined\ tables.\nIts\ functionality\ is\ similar\ to\ the\ \[tclODBC\]\ command\ ''db\ tables''.\n\n\ \ \ proc\ GetTables\ \{\{NameStart\ \"\"\}\}\ \{\n\ \ \ \treturn\ \[db\ eval\ \"select\ tbl_name\ from\ sqlite_master\\\n\ \ \ \t\twhere\ (type\ =\ \\\"table\\\")\ and\ (tbl_name\ like\ \\\"\$\{NameStart\}%\\\")\"\]\n\ \ \ \}\n\n----\n**find\ defined\ columns\ of\ a\ table**\n\nThe\ functionality\ is\ similar\ to\ the\ \[tclODBC\]\ command\ ''db\ columns''.\n\n\ \ \ proc\ GetColumns\ Table\ \{\n\ \ \ \tset\ lRes\ \{\}\n\ \ \ \tset\ SQL\ \[lindex\ \[db\ eval\ \"select\ sql\ from\ sqlite_master\\\n\ \ \ \t\twhere\ type\ =\ \\\"table\\\"\ and\ tbl_name\ =\ \\\"\$\{Table\}\\\"\"\]\ 0\]\n\ \ \ \t#\ >\ Get\ outer\ paranthesis\n\ \ \ \tif\ \{\[regexp\ \{\\((.*)\\)\}\ \$SQL\ match\ SQL\]\}\ \{\n\ \ \ \t\t#\ Keys\ might\ be\ added\ at\ the\ end:\ CONSTRAINT\ ...\n\ \ \ \t\t#\ >\ Replace\ any\ (.,.,.)\ by\ *\ to\ get\ spurious\ \",\"\ away.\n\ \ \ \t\tregsub\ -all\ \{\\(\[^)\]*\\)\}\ \$SQL\ *\ SQL\n\ \ \ \t\t#\ >\ now\ split\ at\ ,\ and\ get\ all\ data\ at\ the\ start\ within\ \\\[...\\\]\n\ \ \ \t\tforeach\ VarSpec\ \[split\ \$SQL\ ,\]\ \{\n\ \ \ \t\t\tif\ \{\[regexp\\\n\ \ \ \t\t\t\t\{^\[\ \\t\]*\\\[(\[^\\\]\]*)\\\]\}\ \$VarSpec\ match\ VarName\]\}\\\n\ \ \ \t\t\t\{\n\ \ \ \t\t\t\tlappend\ lRes\ \$VarName\n\ \ \ \t\t\t\}\n\ \ \ \t\t\}\n\ \ \ \t\}\n\ \ \ \treturn\ \$lRes\n\ \ \ \}\n\n\[KBK\]\ Far\ easier\ would\ be:\n\n======\nproc\ cols\ \{db\ table\}\ \{\n\ \ \ \ set\ result\ \{\}\n\ \ \ \ \$db\ eval\ \"PRAGMA\ TABLE_INFO(\$table)\"\ row\ \{\ lappend\ result\ \$row(name)\ \}\n\ \ \ \ return\ \$result\n\}\n\n----\nSee\ also:\n\n\ \ \ *\ \[SQLite\]\n\n----\n!!!!!!\n%|\[Category\ Database\]|%\n!!!!!!} CALL {my revision sqlite_master} CALL {::oo::Obj294730 process revision/sqlite%5Fmaster} CALL {::oo::Obj294728 process}

-errorcode

NONE

-errorinfo

Unknow state transition: LINE -> END
    while executing
"error $msg"
    (class "::Wiki" method "render_wikit" line 6)
    invoked from within
"my render_$default_markup $N $C $mkup_rendering_engine"
    (class "::Wiki" method "render" line 8)
    invoked from within
"my render $name $C"
    (class "::Wiki" method "revision" line 31)
    invoked from within
"my revision $page"
    (class "::Wiki" method "process" line 56)
    invoked from within
"$server process [string trim $uri /]"

-errorline

4