pawelsalawa / sqlitestudio Goto Github PK

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 184
Originally created at: Thu Jul 28 13:29:23 2011
Originally last updated at: Thu Jul 28 13:29:23 2011

DESCRIPTION:

Stack trace:
can't rename to "::.convertDb": command already exists
(object "::DBTree::.convertDb" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::DBTree::.convertDb" in ::itk::Archetype::constructor (body line 2)
while constructing object "::DBTree::.convertDb" in ::Window::constructor (body line 2)
while constructing object "::DBTree::.convertDb" in ::Modal::constructor (body line 2)
invoked from within
"Modal::constructor -db ::sqlite22"
("eval" body line 1)
invoked from within
"eval Modal::constructor $args"
while constructing object "::DBTree::.convertDb" in ::DbConvertDialog::constructor (body line 2)
invoked from within
"DbConvertDialog .convertDb -db $db"
(object "::.mainWin.d.l.sb" method "::DBTree::convertDb" body line 8)
invoked from within
"DBTREE convertDb"
(menu invoke)

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 167
Originally created at: Thu Jul 28 02:12:11 2011
Originally last updated at: Thu Jul 28 02:12:11 2011

DESCRIPTION:

Stack trace:
invalid command name ""
while executing
"$\_db errorcode"
(object "::sqlite31" method "::DB::onecolumn" body line 8)
invoked from within
"$\_db onecolumn $sql"
(object "::tableWin1" method "::TableWin::refreshTotalNumberOfRows" body line 20)
invoked from within
"$\_tableWin refreshTotalNumberOfRows"
(object "::.mainWin.d.r.win3.main.tabs.data.tabs.grid.grid" method "::DataGrid::renumberRows" body line 17)
invoked from within
"$this renumberRows"
(object "::.mainWin.d.r.win3.main.tabs.data.tabs.grid.grid" method "::DBGrid::commitAll" body line 139)
invoked from within
"::.mainWin.d.r.win3.main.tabs.data.tabs.grid.grid commitAll {{8 4}}"
(menu invoke)

OPERATING SYSTEM:
Windows NT (6.0), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 190
Originally created at: Thu Jul 28 13:34:27 2011
Originally last updated at: Thu Jul 28 13:34:27 2011

What annoys me a little is that the column types are sorted alphabetically, but the important types are at the bottom. I always need to scroll to get INTEGER or TEXT which are the common types as SQLite or SQLite3 uses.\n\nOperating system:\nLinux 32-bit\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 169
Originally created at: Thu Jul 28 02:29:40 2011
Originally last updated at: Thu Jul 28 02:29:40 2011

DESCRIPTION:

Stack trace:
can't rename to "::.blobEdit": command already exists
(object "::DataGrid::.blobEdit" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::DataGrid::.blobEdit" in ::itk::Archetype::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Window::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Modal::constructor (body line 2)
invoked from within
"Modal::constructor -message {Edit BLOB entry:} -value ���

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 198
Originally created at: Thu Jul 28 13:47:51 2011
Originally last updated at: Thu Jul 28 13:47:51 2011

DESCRIPTION:

Stack trace:
unknown option "-foreignKey"
(object "::statement2ColumnConstraint29" method "::Statement::cget" )
invoked from within
"$this cget -$varName"
(object "::statement2ColumnConstraint29" method "::Statement::getValue" body line 2)
invoked from within
"$constrDef getValue foreignKey"
(object "::tableWin0" method "::TableWin::refreshColumns" body line 132)
invoked from within
"refreshColumns $doFocus $refreshDataGridColumns"
(object "::tableWin0" method "::TableWin::refreshWindowContents" body line 69)
invoked from within
"refreshWindowContents -data false"
while constructing object "::tableWin0" in ::TableWin::constructor (body line 214)
invoked from within
"$class ::#auto {\*}$args"
(object "::TASKBAR" method "::TaskBar::createTask" body line 4)
invoked from within
"TASKBAR createTask TableWin $title $db $table"
(object "::.mainWin.d.l.sb" method "::DBTree::openTableWindow" body line 25)
invoked from within
"openTableWindow $db [lindex $data 2]"
("TABLE" arm line 2)
invoked from within
"switch -- [lindex $data 0] {
"DATABASE" {
if {[$db isOpen]} {
if {[$\_tree item isopen $it]} {
$\_tree item collapse $it
} else {
..."
(object "::.mainWin.d.l.sb" method "::DBTree::openClickedItem" body line 9)
invoked from within
"openClickedItem $x $y"
(object "::.mainWin.d.l.sb" method "::DBTree::doubleClicked" body line 4)
invoked from within
"::.mainWin.d.l.sb doubleClicked 70 49"
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 176
Originally created at: Thu Jul 28 13:18:58 2011
Originally last updated at: Thu Jul 28 13:18:58 2011

HOW TO REPRODUCE:
in addition to previous post:
trying to enter table and dot for showing field from table
Maybe this helps to identify the problem

DESCRIPTION:

Stack trace:
can't rename to "::.hint0": command already exists
(object "::HintWin::.hint0" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::HintWin::.hint0" in ::itk::Archetype::constructor (body line 2)
while constructing object "::HintWin::.hint0" in ::Window::constructor (body line 2)
while constructing object "::HintWin::.hint0" in ::HintWin::constructor (body line 2)
invoked from within
"HintWin .hint$i $parent $sqlEditor $completionList $x $y"
(procedure "::HintWin::create" body line 6)
invoked from within
"HintWin::create $\_edit.t $this $completionList $x $y"
(object "::.mainWin.d.r.win7.main.paned.tabs.query\_tab.query" method "::SQLEditor::runDelayedParser" body line 17)
invoked from within
"::.mainWin.d.r.win7.main.paned.tabs.query\_tab.query runDelayedParser"
("after" script)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 179
Originally created at: Thu Jul 28 13:21:48 2011
Originally last updated at: Thu Jul 28 13:21:48 2011

DESCRIPTION:

Stack trace:
invalid command name ""
while executing
"$stmt info class"
(procedure "::FormatStatement::createGenericFormatStatement" body line 2)
invoked from within
"createGenericFormatStatement $stmt"
(object "::formatStatementPragma0" method "::FormatStatement::createFormatStatement" body line 2)
invoked from within
"createFormatStatement $pragmaVal"
(object "::formatStatementPragma0" method "::FormatStatementPragma::formatSql" body line 12)
invoked from within
"$subStatement formatSql"
(object "::formatStatementSql9" method "::FormatStatementSql::formatSql" body line 23)
invoked from within
"$fmtStmt formatSql"
(procedure "::EnterpriseSqlFormattingPlugin::formatSqlInternal" body line 42)
invoked from within
"formatSqlInternal $originalQuery $db"
(object "::enterpriseSqlFormattingPlugin0" method "::EnterpriseSqlFormattingPlugin::formatSql" body line 2)
invoked from within
"$formatter formatSql $tokenizedQuery $txt $db"
(procedure "::Formatter::format" body line 22)
invoked from within
"Formatter::format $query [getDB true]"
(object "::editorWin0" method "::EditorWin::formatSQL" body line 3)
invoked from within
"::editorWin0 formatSQL"
invoked from within
".mainWin.d.r.win1.main.tb.tb.tbframe.grp\_default.w4 invoke "
invoked from within
".mainWin.d.r.win1.main.tb.tb.tbframe.grp\_default.w4 instate {pressed !disabled} { .mainWin.d.r.win1.main.tb.tb.tbframe.grp\_default.w4 state !pressed; ..."
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 168
Originally created at: Thu Jul 28 02:29:24 2011
Originally last updated at: Thu Jul 28 02:29:24 2011

DESCRIPTION:

Stack trace:
can't rename to "::.blobEdit": command already exists
(object "::DataGrid::.blobEdit" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::DataGrid::.blobEdit" in ::itk::Archetype::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Window::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Modal::constructor (body line 2)
invoked from within
"Modal::constructor -message {Edit BLOB entry:} -value ���

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 186
Originally created at: Thu Jul 28 13:30:47 2011
Originally last updated at: Thu Jul 28 13:30:47 2011

HOW TO REPRODUCE:
Using the 'Export Database' function produces SQL code that cannot be imported ("Execute SQL from file') later.

DESCRIPTION:
SQLiteStudio mauls the quotes around variables - it forgets to add ' before and after variables.

SQLiteStudio should simply use the standard SQLite code:

sqlite3 db.sqlite .dump > db.sql

OPERATING SYSTEM:
Linux (2.6.32-5-686), i686

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.2
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.9
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::tilegtk........... 0.2
uuencode...................... 1.1.5
yencode....................... 1.1.3\n\nOperating system:\nLinux 32-bit\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 174
Originally created at: Thu Jul 28 13:17:22 2011
Originally last updated at: Thu Jul 28 13:17:22 2011

HOW TO REPRODUCE:
Insert a new column in table that have a blob column

DESCRIPTION:

Stack trace:
near "<": syntax error
while executing
"::database0 eval {PRAGMA foreign\_key\list(LFF\)} fkRow {
if {$fkRow(table) == $oldTableName} {
Info [mc {Table '%s' references table ..."
("uplevel" body line 1)
invoked from within
"uplevel [list $\_db eval {\*}$args]"
while executing
"error $::errorInfo"
(object "::sqlite30" method "::DB::eval" body line 16)
invoked from within
"$\_db eval "PRAGMA foreign\_key\_list([wrapObjIfNeeded $dbTable $dialect])" fkRow {
if {$fkRow(table) == $oldTableName} {
Info [mc {Table '%s' r..."
(object "::.editTable" method "::TableDialog::okClicked" body line 16)
invoked from within
"okClicked"
("default" arm line 3)
invoked from within
"switch -- $bt {
"cancel" {
set retval [cancelClicked]
}
default {
set okBtn 1
set retval [okClicked]
}
}"
(object "::.editTable" method "::Modal::clicked" body line 3)
invoked from within
"::.editTable clicked ok"
invoked from within
".editTable.f.bottom.ok invoke "
invoked from within
".editTable.f.bottom.ok instate {pressed !disabled} { .editTable.f.bottom.ok state !pressed; .editTable.f.bottom.ok invoke } "
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 189
Originally created at: Thu Jul 28 13:33:39 2011
Originally last updated at: Thu Jul 28 13:33:39 2011

DESCRIPTION:

Stack trace:
can't read "v2null": no such variable
while executing
"if {$v2null} {
set v2 ""
}"
(object "::tableWin0" method "::DataEditor::transferFormToGrid" body line 41)
invoked from within
"transferFormToGrid"
(object "::tableWin0" method "::DataEditor::canDestroy" body line 5)
invoked from within
"DataEditor::canDestroy"
(object "::tableWin0" method "::TableWin::canDestroy" body line 2)
invoked from within
"$\_winObj canDestroy"
(object "::item0" method "::TaskBar::Item::canDestroy" body line 2)
invoked from within
"$it canDestroy"
(object "::TASKBAR" method "::TaskBar::delTask" body line 2)
invoked from within
"delTask $it"
(object "::TASKBAR" method "::TaskBar::delTaskByTitle" body line 5)
invoked from within
"TASKBAR delTaskByTitle $\_title"
("CLOSE\_BY\_DB" arm line 3)
invoked from within
"switch -- [lindex $data 0] {
"REFRESH" {
if {$matchTable} {
if {[lindex $data 2] != ""} {
changeTable [lindex $data 2]
changeT..."
(object "::tableWin0" method "::TableWin::signal" body line 7)
invoked from within
"[$it getWinObj] signal $receiver $data"
(object "::TASKBAR" method "::TaskBar::signal" body line 3)
invoked from within
"TASKBAR signal TableWin [list CLOSE\_BY\_DB $this]"
(object "::sqlite30" method "::DB::close" body line 3)
invoked from within
"$db close"
(object "::.mainWin.d.l.sb" method "::DBTree::disconnectFromSelected" body line 8)
invoked from within
"DBTREE disconnectFromSelected"
invoked from within
".mainWin.db.tb.tbframe.grp\_db.w2 invoke "
invoked from within
".mainWin.db.tb.tbframe.grp\_db.w2 instate {pressed !disabled} { .mainWin.db.tb.tbframe.grp\_db.w2 state !pressed; .mainWin.db.tb.tbframe.grp\_db.w2 invok..."
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 195
Originally created at: Thu Jul 28 13:40:02 2011
Originally last updated at: Thu Jul 28 13:40:02 2011

DESCRIPTION:

Stack trace:
can't read "uiVar(uniqNamed)": no such element in array
while executing
"if {$uiVar(uniqNamed) && $uiVar(uniqName) == ""} {
if {!$skipWarnings} {
Error [mc {Constraint is marked as being named, but there's no name fill..."
(object "::.newTable" method "::TableDialog::validateUniq" body line 4)
invoked from within
"validateUniq true"
(object "::.newTable" method "::TableDialog::validate" body line 10)
invoked from within
"validate"
(object "::.newTable" method "::TableDialog::okClicked" body line 4)
invoked from within
"okClicked"
("default" arm line 3)
invoked from within
"switch -- $bt {
"cancel" {
set retval [cancelClicked]
}
default {
set okBtn 1
set retval [okClicked]
}
}"
(object "::.newTable" method "::Modal::clicked" body line 3)
invoked from within
"::.newTable clicked ok"
invoked from within
".newTable.f.bottom.ok invoke "
invoked from within
".newTable.f.bottom.ok instate {pressed !disabled} { .newTable.f.bottom.ok state !pressed; .newTable.f.bottom.ok invoke } "
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.0), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 183
Originally created at: Thu Jul 28 13:27:46 2011
Originally last updated at: Thu Jul 28 13:27:46 2011

HOW TO REPRODUCE:
Using php sqlite

DESCRIPTION:

Stack trace:
database disk image is malformed
while executing
"$\_db onecolumn $sql"
(object "::sqlite20" method "::Sqlite2::onecolumn" body line 15)
invoked from within
"$\_db onecolumn $sql"
(object "::tableWin1" method "::TableWin::refreshTotalNumberOfRows" body line 20)
invoked from within
"refreshTotalNumberOfRows"
(object "::tableWin1" method "::TableWin::refreshData" body line 39)
invoked from within
"refreshData"
("\data\" arm line 3)
invoked from within
"switch -glob -- [$\_tabs select] {
"\cols\" {
$\_colsGrid setSelection
}
"\data\" {
if {!$\_dataRead} {
refreshData
}

update idlet..."
(object "::tableWin1" method "::TableWin::focusTab" body line 14)
invoked from within
"::tableWin1 focusTab"
(command bound to event)

OPERATING SYSTEM:
Windows 7

APPLICATION VERSION:
2.0.9

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.2.10
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 193
Originally created at: Thu Jul 28 13:38:17 2011
Originally last updated at: Thu Jul 28 13:38:17 2011

DESCRIPTION:

Stack trace:
Cannot parse objects DDL.
SQLite version is 3.7.4.
The DDL is:
CREATE VIEW [p\_newBudget] AS SELECT tab1 . username , round ( max ( CASE WHEN tab1 . last\_profit IS NULL THEN tab1 . profit ELSE ( ( tab1 . profit + tab1 . last\_profit ) / 2 ) END / 1000000.0 , 0 ) + max ( r . budget - tab1 . I , 0 ) , 1 ) AS newBudget\_Meuro
FROM room r ,
( SELECT p . \* , lp . last\_profit
FROM (
( SELECT tp . game\_code , tp . room\_name , tp . username , tp . profit ,
CASE WHEN ti . I IS NULL THEN 0 ELSE ti . I END AS I
FROM (
SELECT username , period\_gc AS game\_code , room\_name , CASE WHEN sum ( profit ) IS NULL THEN 0 ELSE sum ( profit ) END AS profit
FROM
( SELECT pr . player\_username AS username ,
pr . room\_game\_code AS period\_gc ,
pr . room\_name ,
CASE WHEN tp . profit IS NULL THEN 0 ELSE tp . profit END AS profit
FROM ( SELECT \*
FROM player\_room pr
WHERE pr . player\_game\_code = ( SELECT value FROM view\_parameters WHERE name = 'game\_code' )
AND pr . room\_name = ( SELECT value FROM view\_parameters WHERE name = 'room\_name' )
) pr LEFT OUTER JOIN p\_pool\_tech\_player tp
ON pr . player\_username = tp . username
AND pr . player\_game\_code = tp . period\_gc
AND pr . room\_name = tp . room\_name
)
GROUP BY username
) tp LEFT OUTER JOIN p\_total\_investments\_all ti ON tp . username = ti . username ) AS tab1
) p LEFT OUTER JOIN ( SELECT game\_code , room\_name , username , sum ( profit ) AS last\_profit
FROM aux\_last\_profit lp
WHERE lp . game\_code = ( SELECT value FROM view\_parameters WHERE name = 'game\_code' )
AND lp . room\_name = ( SELECT value FROM view\_parameters WHERE name = 'room\_name' )
AND lp . period = ( SELECT value - 1 FROM view\_parameters WHERE name = 'period' )
GROUP BY lp . username
) lp
ON p . username = lp . username
AND p . game\_code = lp . game\_code
AND p . room\_name = lp . room\_name
) tab1
WHERE r . game\_code = tab1 . game\_code
AND r . name = tab1 . room\_name

Error stack:
while executing
"error $err"
(object "::.mainWin.d.l.sb" method "::DBTree::editView" body line 12)
invoked from within
"editView"
("VIEW" arm line 2)
invoked from within
"switch -- [lindex $data 0] {
"DATABASE" {
if {[$db isOpen]} {
if {[$\_tree item isopen $it]} {
$\_tree item collapse $it
} else {
..."
(object "::.mainWin.d.l.sb" method "::DBTree::openClickedItem" body line 9)
invoked from within
"openClickedItem $x $y"
(object "::.mainWin.d.l.sb" method "::DBTree::doubleClicked" body line 4)
invoked from within
"::.mainWin.d.l.sb doubleClicked 111 375"
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 182
Originally created at: Thu Jul 28 13:25:06 2011
Originally last updated at: Thu Jul 28 13:25:06 2011

I want to delete and a column value in a table and press delete and always remove the whole row. For me it's not intuitive that it works this way. The back button is okay to, but pressing delete and only get the column removed seems more suitable for me.

I could change the delete row function to another key, but then delete has no function anymore. I'm missing the option to assign a key to empty a column.\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 170
Originally created at: Thu Jul 28 02:30:23 2011
Originally last updated at: Thu Jul 28 02:30:23 2011

HOW TO REPRODUCE:
try to edit an sqlite database with blob info...
you can't edit the blobs without errors

DESCRIPTION:

Stack trace:
can't rename to "::.blobEdit": command already exists
(object "::DataGrid::.blobEdit" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::DataGrid::.blobEdit" in ::itk::Archetype::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Window::constructor (body line 2)
while constructing object "::DataGrid::.blobEdit" in ::Modal::constructor (body line 2)
invoked from within
"Modal::constructor -message {Edit BLOB entry:} -value ���

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 188
Originally created at: Thu Jul 28 13:32:47 2011
Originally last updated at: Thu Jul 28 13:32:47 2011

DESCRIPTION:

Stack trace:
can't read "sqls": no such variable
while executing
"join $sqls "[spaceBeforeComma],[spaceAfterComma]""
(object "::formatStatementExprSuffix20" method "::FormatStatement::handleSubStmtList" body line 24)
invoked from within
"handleSubStmtList sql $exprFmts defFlat"
(object "::formatStatementExprSuffix20" method "::FormatStatementExprSuffix::formatSql" body line 149)
invoked from within
"$suffixFmt formatSql"
(object "::formatStatementExpr175" method "::FormatStatementExpr::formatSql" body line 15)
invoked from within
"$subStmtFmt formatSql"
(object "::formatStatementExprOnly174" method "::FormatStatement::handleSubStmt" body line 22)
invoked from within
"handleSubStmt sql $exprFmt expr"
(object "::formatStatementExprOnly174" method "::FormatStatementExprOnly::formatSql" body line 88)
invoked from within
"$exprOnlyFmt formatSql"
(object "::formatStatementExpr174" method "::FormatStatementExpr::formatSql" body line 11)
invoked from within
"$whereFmt formatSql"
(object "::formatStatementSelectCore10" method "::FormatStatementSelectCore::formatSql" body line 40)
invoked from within
"$firstCore formatSql"
(object "::formatStatementSelect10" method "::FormatStatementSelect::formatSql" body line 7)
invoked from within
"$subStatement formatSql"
(object "::formatStatementSql65" method "::FormatStatementSql::formatSql" body line 23)
invoked from within
"$fmtStmt formatSql"
(procedure "::EnterpriseSqlFormattingPlugin::formatSqlInternal" body line 42)
invoked from within
"formatSqlInternal $originalQuery $db"
(object "::enterpriseSqlFormattingPlugin0" method "::EnterpriseSqlFormattingPlugin::formatSql" body line 2)
invoked from within
"$formatter formatSql $tokenizedQuery $txt $db"
(procedure "::Formatter::format" body line 22)
invoked from within
"Formatter::format $query [getDB true]"
(object "::editorWin11" method "::EditorWin::formatSQL" body line 3)
invoked from within
"::editorWin11 formatSQL"
invoked from within
".mainWin.d.r.win18.main.tb.tb.tbframe.grp\_default.w4 invoke "
invoked from within
".mainWin.d.r.win18.main.tb.tb.tbframe.grp\_default.w4 instate {pressed !disabled} { .mainWin.d.r.win18.main.tb.tb.tbframe.grp\_default.w4 state !pressed..."
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.0), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows Vista\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 194
Originally created at: Thu Jul 28 13:38:43 2011
Originally last updated at: Thu Jul 28 13:38:43 2011

DESCRIPTION:

Stack trace:
invalid command name "::sqlite33"
while executing
"$\_db getHandler"
(object "::.mainWin.d.r.win5.main.paned.tabs.query\_tab.query" method "::SQLEditor::getCurrentParser" body line 4)
invoked from within
"getCurrentParser"
(object "::.mainWin.d.r.win5.main.paned.tabs.query\_tab.query" method "::SQLEditor::parseContents" body line 3)
invoked from within
"parseContents $idx"
(object "::.mainWin.d.r.win5.main.paned.tabs.query\_tab.query" method "::SQLEditor::runDelayedParser" body line 7)
invoked from within
"::.mainWin.d.r.win5.main.paned.tabs.query\_tab.query runDelayedParser"
("after" script)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 197
Originally created at: Thu Jul 28 13:46:09 2011
Originally last updated at: Thu Jul 28 13:46:09 2011

DESCRIPTION:

Stack trace:
bad window path name ".newView.f.tabs.main.middle.edit.top.text.t"
while executing
"focus $\_parent"
while deleting object "::.hint0" in ::HintWin::destructor (body line 2)
invoked from within
"itcl::delete object ::.hint0"
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 172
Originally created at: Thu Jul 28 13:13:25 2011
Originally last updated at: Thu Jul 28 13:13:25 2011

DESCRIPTION:
tengo una sentencia sql, y al darle click al boton explain, este no realiza ninguna accion. Nose si es que estoy haciendo algo mal, o es que no esta funcionando.
Gracias por la ayuda!

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 185
Originally created at: Thu Jul 28 13:30:11 2011
Originally last updated at: Thu Jul 28 13:30:11 2011

DESCRIPTION:
Please allow user to highlight and copy (CTRL C) plain text view results from a View, so that data can be pasted (CTRL V) into another application, e.g. a word processor

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.2
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.9
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::tilegtk........... 0.2
uuencode...................... 1.1.5
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 191
Originally created at: Thu Jul 28 13:35:14 2011
Originally last updated at: Thu Jul 28 13:35:14 2011

DESCRIPTION:

Stack trace:
can't rename to "::.populateTable": command already exists
(object "::DBTree::.populateTable" method "::itk::Archetype::\_initOptionInfo" )
invoked from within
"\_initOptionInfo"
while constructing object "::DBTree::.populateTable" in ::itk::Archetype::constructor (body line 2)
while constructing object "::DBTree::.populateTable" in ::Window::constructor (body line 2)
while constructing object "::DBTree::.populateTable" in ::Modal::constructor (body line 2)
invoked from within
"Modal::constructor {\*}$args"
while constructing object "::DBTree::.populateTable" in ::PopulateTableDialog::constructor (body line 2)
invoked from within
"PopulateTableDialog .populateTable -db $db -table $table -title [mc {Populate table}]"
(object "::.mainWin.d.l.sb" method "::DBTree::populateTable" body line 4)
invoked from within
"::.mainWin.d.l.sb populateTable"
(menu invoke)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 180
Originally created at: Thu Jul 28 13:23:06 2011
Originally last updated at: Thu Jul 28 13:23:06 2011

DESCRIPTION:

Stack trace:
no such column: OCCUR\TIME
while executing
"::database2 eval {SELECT [REQUEST], [OCCUR\TIME], ROWID as \\\rowid\\\ FROM [INSIGHT\REQUEST] LIMIT 1000 OFFSET 0} R {
set col 1
set data [list]..."
("uplevel" body line 1)
invoked from within
"uplevel [list $\db eval {\*}$args]"
while executing
"error $::errorInfo"
(object "::sqlite30" method "::DB::eval" body line 16)
invoked from within
"$\db eval "SELECT $cols, ROWID as \\\rowid\\\_ FROM [wrapObjName $\_table [$\_db getDialect]] $filter $orderBy LIMIT $resultsPerPage OFFSET [expr {$resul..."
(object "::tableWin3" method "::TableWin::refreshData" body line 51)
invoked from within
"refreshData"
("\data\" arm line 3)
invoked from within
"switch -glob -- [$\_tabs select] {
"\cols\" {
$\_colsGrid setSelection
}
"\data\" {
if {!$\_dataRead} {
refreshData
}

update idlet..."
(object "::tableWin3" method "::TableWin::focusTab" body line 14)
invoked from within
"focusTab"
(object "::tableWin3" method "::TableWin::activated" body line 2)
invoked from within
"$\_winObj activated"
(object "::item13" method "::TaskBar::Item::setActive" body line 11)
invoked from within
"::item13 setActive"
(command bound to event)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 175
Originally created at: Thu Jul 28 13:17:57 2011
Originally last updated at: Thu Jul 28 13:17:57 2011

DESCRIPTION:

Stack trace:
No such column 'key\' while getting it's model for edition.
while executing
"error "No such column '$colName' while getting it's model for edition.""
(object "::.editTable" method "::TableDialog::getColumnModelByName" body line 12)
invoked from within
"getColumnModelByName $columnName"
(object "::.editTable" method "::TableDialog::editColumn" body line 4)
invoked from within
"::.editTable editColumn key\ true"
("uplevel" body line 1)
invoked from within
"uplevel #0 $\_initScript"
(object "::.editTable" method "::Modal::exec" body line 25)
invoked from within
"$dialog exec"
(object "::tableWin4" method "::TableWin::editSelectedColumn" body line 12)
invoked from within
"editSelectedColumn"
(object "::tableWin4" method "::TableWin::editDoubleClickedColumn" body line 3)
invoked from within
"::tableWin4 editDoubleClickedColumn $x $y"
("eval" body line 1)
invoked from within
"eval $itk\_option(-doubleclicked)"
(object "::.mainWin.d.r.win7.main.tabs.cols.grid" method "::Grid::handleDoubleClick" body line 10)
invoked from within
"::.mainWin.d.r.win7.main.tabs.cols.grid handleDoubleClick 340 83"
(command bound to event)

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 178
Originally created at: Thu Jul 28 13:20:29 2011
Originally last updated at: Thu Jul 28 13:20:29 2011

HOW TO REPRODUCE:
Create a query that uses a Natural Join, ex:
"SELECT \* FROM TableA NATURAL JOIN TableB"

DESCRIPTION:
When attempting to use a query that contains Natural Join, the following error is displayed:
"Error while executing query: no such column: NATURAL.ROWID"

Interestingly, Views that contain a Natural Join still display properly.

This SQL query still works in v2.0.5, but doesn't in v2.0.8 (I don't have 2.0.6 and couldn't open .7)

OPERATING SYSTEM:
Windows NT (6.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 187
Originally created at: Thu Jul 28 13:32:00 2011
Originally last updated at: Thu Jul 28 13:32:00 2011

HOW TO REPRODUCE:
Under Debian SID
Edit data into a table and try to close the small window without clicking on "commit"

DESCRIPTION:
The entire system freezes

OPERATING SYSTEM:
Linux (2.6.38-2-686), i686

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.2
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.9
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::tilegtk........... 0.2
uuencode...................... 1.1.5
yencode....................... 1.1.3\n\nOperating system:\nLinux 32-bit\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 181
Originally created at: Thu Jul 28 13:23:54 2011
Originally last updated at: Thu Jul 28 13:23:54 2011

Hi,Googie

I wish add to Helpmenu following links:

SQLiteStudio Site (http://sqlitestudio.one.pl/index.rvt)
SQLiteStudio manual online (HTML page) (http://sqlitestudio.one.pl/docs/html/manual.html)
\n\nOperating system:\nLinux 32-bit

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 196
Originally created at: Thu Jul 28 13:45:19 2011
Originally last updated at: Thu Jul 28 13:45:19 2011

DESCRIPTION:

Stack trace:
invalid command name ".bindParamDialog.f.top.f.scrolled.f.1.1.e"
while executing
"$fr.1.1.e setTextFocus"
while constructing object "::.bindParamDialog" in ::BindParamDialog::constructor (body line 67)
invoked from within
"BindParamDialog .bindParamDialog -tokens $tokenizedStatements -title $title"
(object "::editorWin1" method "::EditorWin::handleBindParams" body line 20)
invoked from within
"handleBindParams $query"
(object "::editorWin1" method "::EditorWin::execQuery" body line 11)
invoked from within
"::editorWin1 execQuery"
(command bound to event)

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3
\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 173
Originally created at: Thu Jul 28 13:16:25 2011
Originally last updated at: Thu Jul 28 13:16:25 2011

HOW TO REPRODUCE:
Open query editor and write
PRAGMA table\_info('')
Execute
The results window should show one row for each colum in the table (with the columns cid, name, type, notnull, dflt\_value and pk), instead the results window shows one row with all the columns info.

DESCRIPTION:
The results window should show one row for each colum in the table (with the columns cid, name, type, notnull, dflt\_value and pk).

OPERATING SYSTEM:
Windows 7

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::vista............. 1.0
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows 7\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 177
Originally created at: Thu Jul 28 13:19:38 2011
Originally last updated at: Thu Jul 28 13:19:38 2011

A bug report

Repeatable: yes

Description:
when editing the table name after adding some columns, deleting a character using key triggers column deletion.

when copying DDL using insertion of new column was trigered
\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 171
Originally created at: Thu Jul 28 07:22:03 2011
Originally last updated at: Thu Jul 28 07:22:03 2011

HOW TO REPRODUCE:
general winchester

DESCRIPTION:

Stack trace:
invalid command name ""
Stack 2:
invalid command name ""
while executing
"$\_db begin"
(also error on rollback: invalid command name "")
Stack 1:
invalid command name ""
Stack 2:
invalid command name ""
while executing
"$\_db begin"
(also error on rollback: invalid command name "")
while executing
"error "$err\n(also error on rollback: $rbErr)""
(object "::.mainWin.d.r.win2.main.paned.tabs.results\_tab.tabs.t1.grid" method "::DBGrid::commitAll" body line 89)
invoked from within
"$dataGrid commitAll $itColList"
while executing
"error $err"
(object "::editorWin0" method "::DataEditor::commitGrid" body line 13)
invoked from within
"::editorWin0 commitGrid"
invoked from within
".mainWin.d.r.win2.main.paned.tabs.results\_tab.tabs.t1.toolbar.tb.tbframe.grp\_default.w3 invoke "
invoked from within
".mainWin.d.r.win2.main.paned.tabs.results\_tab.tabs.t1.toolbar.tb.tbframe.grp\_default.w3 instate {pressed !disabled} { .mainWin.d.r.win2.main.paned.tab..."
(command bound to event)

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 192
Originally created at: Thu Jul 28 13:36:25 2011
Originally last updated at: Thu Jul 28 13:36:25 2011

HOW TO REPRODUCE:
alter table[Student]ADD[Scome]datetime;

DESCRIPTION:

Stack trace:
invalid command name ".mainWin.d.r.win5.main.paned.tabs.results\_tab.tabs.t3.text.bottom.hscroll"
while executing
".mainWin.d.r.win5.main.paned.tabs.results\_tab.tabs.t3.text.bottom.hscroll set 0.0 1.0"
(horizontal scrolling command executed by text)

OPERATING SYSTEM:
Windows NT (5.1), intel

APPLICATION VERSION:
2.0.12

TCL PACKAGES:
autoscroll.................... 1.1
crc16......................... 1.1.1
crc32......................... 1.3.1
http.......................... 2.7.5
Itcl.......................... 3.4
Itk........................... 3.4
md4........................... 1.0.5
md5........................... 1.4.4
msgcat........................ 1.4.3
sha1.......................... 2.0.3
sha256........................ 1.0.2
sqlite........................ 2.0
sqlite3....................... 3.7.4
Tcl........................... 8.5.9
Thread........................ 2.6.6
Tk............................ 8.5.9
tkpng......................... 0.7
treectrl...................... 2.3.1
ttk::dialog................... 0.8
ttk::theme::alt............... 8.5
ttk::theme::clam.............. 8.5
ttk::theme::classic........... 8.5
ttk::theme::default........... 8.5
ttk::theme::keramik........... 0.6.1
ttk::theme::keramik\_alt....... 0.6.1
ttk::theme::plastik........... 0.6.1
ttk::theme::winnative......... 8.5
ttk::theme::xpnative.......... 8.5
uuencode...................... 1.1.5
winappendfile................. 1.0
yencode....................... 1.1.3\n\nOperating system:\nWindows XP/2003/2000\n\nVersion:\n2.0.12