Pga2: 4 errors

From: "Lrat" <lratlrat(at)correo(dot)lrats(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Pga2: 4 errors
Date: 2003-05-20 20:32:38
Message-ID: 000d01c31f0e$f4e4e2b0$0102a8c0@uno
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

<->Pga2:Control array element '4' doesn't exist
full log:
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Log Level",
1, "4")
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II\Log Window",
"Always On Top", 1, "Y")
2003-05-20 22:13:01 - Entering pgSchema:pgServer.Property Let
ShowPassword(False)
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Mask
Password", 1, "Y")
2003-05-20 22:13:01 - Entering pgAdmin II:basPatch.PatchForm(frmMain)
2003-05-20 22:13:01 - Entering pgAdmin
II:basPatch.PatchFormScrollObj(frmMain)
2003-05-20 22:13:01 - Entering pgAdmin II:basPatch.PatchFormFont(frmMain)
2003-05-20 22:13:01 - Entering pgAdmin
II:basPatch.PatchFormToolTip(frmMain)
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Font", 1, "MS
Sans Serif|8|False|False")
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II",
"AutoHighlight", 1,
"ALTER|0|0|16711680;COMMENT|0|0|16711680;CREATE|0|0|16711680;DELETE|0|0|16
711680;DROP|0|0|16711680;EXPLAIN|0|0|16711680;GRANT|0|0|16711680;INSERT|0|
0|16711680;REVOKE|0|0|16711680;SELECT|0|0|16711680;UPDATE|0|0|16711680;VAC
UUM|0|0|16711680;AGGREGATE|0|0|255;CONSTRAINT|0|0|255;DATABASE|0|0|255;FUN
CTION|0|0|255;GROUP|0|0|255;INDEX|0|0|255;LANGUAGE|0|0|255;OPERATOR|0|0|25
5;RULE|0|0|255;SEQUENCE|0|0|255;TABLE|0|0|255;TRIGGER|0|0|255;ABORT|0|0|11
998061;BEGIN|0|0|11998061;CHECKPOINT|0|0|11998061;CLOSE|0|0|11998061;CLUST
ER|0|0|11998061;COMMIT|0|0|11998061;COPY|0|0|11998061;DECLARE|0|0|11998061
;FETCH|0|0|11998061;LISTEN|0|0|11998061;LOAD|0|0|11998061;LOCK|0|0|1199806
1;MOVE|0|0|11998061;NOTIFY|0|0|11998061;REINDEX|0|0|11998061;RESET|0|0|119
98061;ROLLBACK|0|0|11998061;SET|0|0|11998061;SHOW|0|0|11998061;TRUNCATE|0|
0|11998061;UNLISTEN|0|0|11998061;AND|0|0|32768;AS|0|0|32768;ASC|0|0|32768;
ASCENDING|0|0|32768;BY|0|0|32768;CASE|0|0|32768;DESC|0|0|32768;DESCENDING|
0|0|32768;ELSE|0|0|32768;FROM|0|0|32768;END|0|0|32768;HAVING|0|0|32768;INT
O|0|0|32768;ON|0|0|32768;OR|0|0|32768;ORDER|0|0|32768;THEN|0|0|32768;USING
|0|0|32768;WHEN|0|0|32768;WHERE|0|0|32768;")
2003-05-20 22:13:01 - Entering pgSchema:pgServer.Property Get
ConnectionString()
2003-05-20 22:13:01 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Master DB",
1, "template1")
2003-05-20 22:13:01 - Entering pgSchema:pgServer.Property Let
EncryptPasswords(True)
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Encrypt
Passwords", 1, "Y")
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Auto Row
Count", 1, "Y")
2003-05-20 22:13:01 - Entering pgSchema:pgServer.Property Let
DeferConnection("True")
2003-05-20 22:13:01 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Defer
Connection", 1, "Y")
2003-05-20 22:13:03 - Entering pgAdmin
II:frmSQLOutput.lvData_ItemClick("prueba")
2003-05-20 22:13:04 - Entering pgAdmin II:frmSQLOutput.cmdDelete_Click()
2003-05-20 22:13:06 - Counting matching records...
2003-05-20 22:13:06 - Done - 0 Secs.

2003-05-20 22:13:06 -
*******************************************************************
2003-05-20 22:13:06 - Error(s)
2003-05-20 22:13:06 -
*******************************************************************
2003-05-20 22:13:06 - Error in pgAdmin II:frmSQLOutput.cmdDelete_Click:
340 - Control array element '4' doesn't exist

2003-05-20 22:13:06 - Windows Version: Windows XP v5.1 build 2600 Service
Pack 1
2003-05-20 22:13:06 - pgSchema Version: 1.5.60
2003-05-20 22:13:06 - MDAC Version: 2.7
2003-05-20 22:13:06 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.96
2003-05-20 22:13:06 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=psql.lrats.com;P
ORT=5432;UID=postgres;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;
ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100
;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;De
bug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;U
nknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTa
blePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;True
IsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0"

2003-05-20 22:13:22 - Entering pgAdmin II:frmMain.mnuToolsOptions_Click()
2003-05-20 22:13:22 - Entering pgAdmin II:frmOptions.Form_Load()
2003-05-20 22:13:22 - Entering pgAdmin II:basPatch.PatchForm(frmOptions)
2003-05-20 22:13:22 - Entering pgAdmin
II:basPatch.PatchFormScrollObj(frmOptions)
2003-05-20 22:13:22 - Entering pgAdmin
II:basPatch.PatchFormFont(frmOptions)
2003-05-20 22:13:22 - Entering pgAdmin
II:basPatch.PatchFormToolTip(frmOptions)
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Log File")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Log Level")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Always On Top")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Mask Password")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Font")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "AutoHighlight")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Encrypt Passwords")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Auto Row Count")
2003-05-20 22:13:22 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Defer Connection")
2003-05-20 22:13:24 - Entering pgAdmin II:frmOptions.cmdOK_Click()
2003-05-20 22:13:24 - Entering pgSchema:pgServer.Property Let
Logfile("D:\admin\pgAdmin2\log\pgAdmin II_%ID.Log")
2003-05-20 22:13:24 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Log File", 1,
"D:\admin\pgAdmin2\log\pgAdmin II_%ID.Log")
2003-05-20 22:13:24 - Entering pgSchema:pgServer.Property Let
LogLevel("0")

<->Pga2:run-time error '76' path not found -> In options->log, if path not
exist, the app hang

<->Pga2: ole link to msaccess -> filter ilegal chars in file name

<->Pga2: pgexporter error full log + image

2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Log Level",
1, "4")
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II\Log Window",
"Always On Top", 1, "Y")
2003-05-20 22:24:47 - Entering pgSchema:pgServer.Property Let
ShowPassword(False)
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Mask
Password", 1, "Y")
2003-05-20 22:24:47 - Entering pgAdmin II:basPatch.PatchForm(frmMain)
2003-05-20 22:24:47 - Entering pgAdmin
II:basPatch.PatchFormScrollObj(frmMain)
2003-05-20 22:24:47 - Entering pgAdmin II:basPatch.PatchFormFont(frmMain)
2003-05-20 22:24:47 - Entering pgAdmin
II:basPatch.PatchFormToolTip(frmMain)
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Font", 1, "MS
Sans Serif|8|False|False")
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II",
"AutoHighlight", 1,
"ALTER|0|0|16711680;COMMENT|0|0|16711680;CREATE|0|0|16711680;DELETE|0|0|16
711680;DROP|0|0|16711680;EXPLAIN|0|0|16711680;GRANT|0|0|16711680;INSERT|0|
0|16711680;REVOKE|0|0|16711680;SELECT|0|0|16711680;UPDATE|0|0|16711680;VAC
UUM|0|0|16711680;AGGREGATE|0|0|255;CONSTRAINT|0|0|255;DATABASE|0|0|255;FUN
CTION|0|0|255;GROUP|0|0|255;INDEX|0|0|255;LANGUAGE|0|0|255;OPERATOR|0|0|25
5;RULE|0|0|255;SEQUENCE|0|0|255;TABLE|0|0|255;TRIGGER|0|0|255;ABORT|0|0|11
998061;BEGIN|0|0|11998061;CHECKPOINT|0|0|11998061;CLOSE|0|0|11998061;CLUST
ER|0|0|11998061;COMMIT|0|0|11998061;COPY|0|0|11998061;DECLARE|0|0|11998061
;FETCH|0|0|11998061;LISTEN|0|0|11998061;LOAD|0|0|11998061;LOCK|0|0|1199806
1;MOVE|0|0|11998061;NOTIFY|0|0|11998061;REINDEX|0|0|11998061;RESET|0|0|119
98061;ROLLBACK|0|0|11998061;SET|0|0|11998061;SHOW|0|0|11998061;TRUNCATE|0|
0|11998061;UNLISTEN|0|0|11998061;AND|0|0|32768;AS|0|0|32768;ASC|0|0|32768;
ASCENDING|0|0|32768;BY|0|0|32768;CASE|0|0|32768;DESC|0|0|32768;DESCENDING|
0|0|32768;ELSE|0|0|32768;FROM|0|0|32768;END|0|0|32768;HAVING|0|0|32768;INT
O|0|0|32768;ON|0|0|32768;OR|0|0|32768;ORDER|0|0|32768;THEN|0|0|32768;USING
|0|0|32768;WHEN|0|0|32768;WHERE|0|0|32768;")
2003-05-20 22:24:47 - Entering pgSchema:pgServer.Property Get
ConnectionString()
2003-05-20 22:24:47 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Master DB",
1, "template1")
2003-05-20 22:24:47 - Entering pgSchema:pgServer.Property Let
EncryptPasswords(True)
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Encrypt
Passwords", 1, "Y")
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Auto Row
Count", 1, "Y")
2003-05-20 22:24:47 - Entering pgSchema:pgServer.Property Let
DeferConnection("True")
2003-05-20 22:24:47 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Defer
Connection", 1, "Y")
2003-05-20 22:24:50 - Entering pgAdmin II:frmSQLInput.cmdExecute_Click()
2003-05-20 22:24:50 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Recordset
Viewer", 1, "OLE Link to MS Access")
2003-05-20 22:24:50 - Executing SQL Query...
2003-05-20 22:24:50 - Entering pgSchema:pgServer.Property Get Databases()
2003-05-20 22:24:51 - Entering pgSchema:Databases.Property Get
Item("registrointertell")
2003-05-20 22:24:51 - Entering pgSchema:pgDatabase.Execute("select * from
registrogaceta limit 1", 0, -1, 4)
2003-05-20 22:24:51 - Entering pgSchema:pgDatabase.dbConnect()
2003-05-20 22:24:51 - Entering pgSchema:pgServer.ExecSQL("select * from
registrogaceta limit 1", "Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=registrointertell;SERVER=psql.lra
ts.com;PORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;
ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100
;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;De
bug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;U
nknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTa
blePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;True
IsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0"", 0, -1, 4)
2003-05-20 22:24:51 - SQL (registrointertell): select * from
registrogaceta limit 1
2003-05-20 22:24:51 - Done - 0,01 Secs.
2003-05-20 22:24:51 - Entering pgAdmin II:clsExporters.Property Get
Item("OLE Link to MS Access")
2003-05-20 22:24:51 - Entering pgAdmin II:clsExporters.Property Get
Item("OLE Link to MS Access")
2003-05-20 22:24:51 - Running Exporter: OLE Link to MS Access v1.5.60
2003-05-20 22:24:51 - Entering pgAdmin II:clsExporters.Property Get
Item("OLE Link to MS Access")
2003-05-20 22:26:13 - Entering pgAdmin II:frmSQLInput.StoreCmdSql("select
* from registrogaceta limit 1")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL0")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL1")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL2")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL3")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL4")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL5")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL6")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL7")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL8")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL9")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL10")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL11")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL12")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL13")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL14")
2003-05-20 22:26:13 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Command SQL", "CmdSQL15")
2003-05-20 22:26:16 - Entering pgAdmin II:frmMain.mnuToolsOptions_Click()
2003-05-20 22:26:16 - Entering pgAdmin II:frmOptions.Form_Load()
2003-05-20 22:26:16 - Entering pgAdmin II:basPatch.PatchForm(frmOptions)
2003-05-20 22:26:16 - Entering pgAdmin
II:basPatch.PatchFormScrollObj(frmOptions)
2003-05-20 22:26:16 - Entering pgAdmin
II:basPatch.PatchFormFont(frmOptions)
2003-05-20 22:26:16 - Entering pgAdmin
II:basPatch.PatchFormToolTip(frmOptions)
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Log File")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Log Level")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Always On Top")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Mask Password")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Font")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "AutoHighlight")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Encrypt Passwords")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Auto Row Count")
2003-05-20 22:26:16 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Defer Connection")
2003-05-20 22:26:19 - Entering pgAdmin II:frmOptions.cmdOK_Click()
2003-05-20 22:26:19 - Entering pgSchema:pgServer.Property Let
Logfile("D:\admin\pgAdmin2\log\pgAdmin II_%ID.Log")
2003-05-20 22:26:19 - Entering pgAdmin
II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Log File", 1,
"D:\admin\pgAdmin2\log\pgAdmin II_%ID.Log")
2003-05-20 22:26:19 - Entering pgSchema:pgServer.Property Let
LogLevel("0")

Attachment Content-Type Size
image/gif 9.8 KB

Browse pgadmin-support by date

  From Date Subject
Next Message Reshat Sabiq 2003-05-21 07:10:58 Re: ENCODING (Unicode)
Previous Message Dave Page 2003-05-20 19:09:24 Re: Miigration Wizard ignores not nulls & defau