Howto update antclick-1.1pre1 to antclick-1.1pre2?
hi, the search-bug in pre1 forces me to upgade to antclick-1.1pre2.
Is there a howto update for antCLICK? or do I have to wait for the next real release (not pre)?
Searching The Antville-user Archives and help.antville.org, I could not find anything related. Reading adele.helma.org, I failed at "shutdown helma if it's running and execute the sql script 11pre1_to_pre2.sql". SQL is not running after I quit antclick, right? How do I execute the script 11pre1_to_pre2.sql?
thank you.
hns
want to try sqlShell to issue the sql update commands manually.
http://adele.helma.org/download/helma/contrib/hannes/sqlShell/
Be sure to make a backup copy of the database before you start!
InterfaceDesigner
With the help of ‘Howto update antclick-1.1pre1 to antclick-1.1pre2’ http://help.antville.org/stories/709673/ I try to update from antclick-1.1pre1 to antclick-1.1 on a Windows XP pro PC.
1. Backup C:\antclick-1.1pre1
2. Install and start sqlShell-0.8.zip http://adele.helma.org/download/helma/contrib/hannes/sqlShell/
C:\antclick-1.1pre1\apps\antville\sqlShell-0.8.zip
add sqlShellPassword = ***** to C:\antclick-1.1pre1\apps\antville\app.properties
http://192.168.204.169/sqlShell
Please enter a valid data source name: antville
3. At http://192.168.204.169/sqlShell/ and the options Data Source: antville and Schema: - I entered without success:
a) the text from http://adele.helma.org/download/antville/update/1.1pre1_to_pre2/11pre1_to_pre2.sql
b) the same text without the first line "use antville;" (because I thought I had chosen a valid data source name in the step before)
c) the first part of the text without comments
create table AV_LAYOUT (
LAYOUT_ID mediumint(10) not null,
LAYOUT_ALIAS varchar(128),
LAYOUT_TITLE varchar(128),
LAYOUT_F_SITE mediumint(10),
LAYOUT_F_LAYOUT_PARENT mediumint(10),
LAYOUT_PREFERENCES mediumtext,
LAYOUT_DESCRIPTION mediumtext,
LAYOUT_CREATETIME datetime,
LAYOUT_MODIFYTIME datetime,
LAYOUT_F_USER_CREATOR mediumint(10),
LAYOUT_F_USER_MODIFIER mediumint(10),
LAYOUT_SHAREABLE tinyint(1),
LAYOUT_ISIMPORT tinyint(1),
primary key (LAYOUT_ID)
);
d) and the first part of the text without comments and linebrakes:
create table AV_LAYOUT (LAYOUT_ID mediumint(10) not null, LAYOUT_ALIAS varchar(128), LAYOUT_TITLE varchar(128), LAYOUT_F_SITE mediumint(10), LAYOUT_F_LAYOUT_PARENT mediumint(10), LAYOUT_PREFERENCES mediumtext, LAYOUT_DESCRIPTION mediumtext, LAYOUT_CREATETIME datetime, LAYOUT_MODIFYTIME datetime, LAYOUT_F_USER_CREATOR mediumint(10), LAYOUT_F_USER_MODIFIER mediumint(10), LAYOUT_SHAREABLE tinyint(1), LAYOUT_ISIMPORT tinyint(1), primary key (LAYOUT_ID));
The message for a) is Error: Encountered "use" at line 1, column 1. Was expecting one of: "drop" ... "show" ... "alter" ... "select" ... "update" ... "create" ... "delete" ... "insert" ... "commit" ... "compact" ... "rollback" ... "describe" ... "shutdown" ... "set" ... "call" ... "grant" ... "revoke" ...
The message for b) is Error: Lexical error at line 1, column 1. Encountered: "#" (35), after : ""
The message for c) is Error: Encountered "mediumint" at line 2, column 14. Was expecting one of: "long" ... "bit" ... "int" ... "real" ... "blob" ... "date" ... "time" ... "float" ... "bigint" ... "double" ... "binary" ... "numeric" ... "decimal" ... "boolean" ... "tinyint" ... "integer" ... "smallint" ... "varbinary" ... "timestamp" ... "java_object" ... "longvarbinary" ... "character" ... "text" ... "string" ... "longvarchar" ... "char" ... "varchar" ... "clob" ...
The message for d) is the same as in c)
Any help appreciated.
Thank you,
id
ps.: hier wird ein alternativer weg beschrieben, der mir aber auch nicht weiter hilft: http://help.antville.org/stories/926004/ bzw antville update 1.0.x nach 1.1.0 http://axelk.blogger.de/stories/154000/