Upgrade woe!

[Fred]

Oh what have I done wrong?

I downloaded the zip file, and dropped the contents on top of the previous version. I did not use the installer because, for various reasons, I do not have the database on the same partition as the program.

Then I started the program using my previous batch file. Everything went very well, and I admired some of the changes in version. But I determined to get the British English spell check working. So I closed it all down, found the necessary files and put them in the correct place.

Full of confidence, I went to re-start TAMB. But it tells me that it cannot find the database! During the previous run it had made the change from \database\ to \data\ with some minor changes to the file sizes.

Does anyone have any ideas on what to do next?

[I am running Java 1.6_07 on Win98SE, the last Java version that Sun will allow to run on Win98.]

This is the full error message:

net.sf.thingamablog.blog.BackendException: java.lang.Exception: Unable to connect to database
   at net.thingamablog.TAMBProfile.open(TAMBProfile.java:118)
   at net.thingamablog.OpenProfileTask.doInBackground(OpenProfileTask.java:37)
   at org.jdesktop.swingworker.SwingWorker$1.call(Unknown Source)
   at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at org.jdesktop.swingworker.SwingWorker.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Exception: Unable to connect to database
   at net.sf.thingamablog.backend.HSQLDatabaseBackend.connectToDB(HSQLDatabaseBackend.java:165)
   at net.thingamablog.TAMBProfile.open(TAMBProfile.java:116)
   ... 8 more
 

[Fred]

PS Didn't say it, but of course I have tried File | Open Profile and pointed TAMB to the appropriate user.xml. At that point I get the error message all over again.

[Bob]

Fred,

 can you please post the contents of the files "database.properties" and "database.script" (In the data folder) here?

[Fred]

Bob,

Many thanks for your very swift response.

database.properties:

#HSQL Database Engine 1.8.0.9
#Sun Dec 06 21:55:24 GMT 2009
hsqldb.cache_file_scale=1
runtime.gc_interval=0
version=1.8.0
modified=no
hsqldb.script_format=0
hsqldb.cache_size_scale=8
hsqldb.cache_scale=14
hsqldb.log_size=200
sql.enforce_strict_size=false
readonly=false
hsqldb.compatible_version=1.8.0
hsqldb.original_version=1.7.1
hsqldb.nio_data_file=true
hsqldb.cache_version=1.7.0
hsqldb.default_table_type=memory

database.script:

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE AUTH_TABLE(BLOG LONGVARCHAR,BLOG_AUTHOR LONGVARCHAR)
CREATE CACHED TABLE CAT_TABLE(BLOG LONGVARCHAR,BLOG_CATEGORY LONGVARCHAR)
CREATE CACHED TABLE FEED_ITEMS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,RETRIEVED TIMESTAMP,PUB_DATE LONGVARCHAR,TITLE LONGVARCHAR,DESC LONGVARCHAR,AUTHOR LONGVARCHAR,READ BOOLEAN,HASH_CODE INTEGER,LINK LONGVARCHAR,CHANNEL_TITLE LONGVARCHAR,CHANNEL_LINK LONGVARCHAR,CHANNEL_IMG_LINK LONGVARCHAR)
CREATE CACHED TABLE ENTRY_TABLE_1197660025200(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,TIMESTAMP TIMESTAMP,TITLE LONGVARCHAR,CATEGORIES LONGVARCHAR,ENTRY LONGVARCHAR,DRAFT BOOLEAN,MODIFIED TIMESTAMP,AUTHOR LONGVARCHAR,LABELS LONGVARCHAR,KEYWORDS LONGVARCHAR,ENTRY_DESC LONGVARCHAR,EXTRA1 LONGVARCHAR,EXTRA2 LONGVARCHAR)
CREATE CACHED TABLE LABEL_TABLE(BLOG LONGVARCHAR,BLOG_LABEL LONGVARCHAR)
SET TABLE AUTH_TABLE INDEX'14336 181'
SET TABLE FEED_ITEMS INDEX'13939216 33268'
SET TABLE ENTRY_TABLE_1197660025200 INDEX'2102680 250'
ALTER TABLE FEED_ITEMS ALTER COLUMN ID RESTART WITH 33268
ALTER TABLE ENTRY_TABLE_1197660025200 ALTER COLUMN ID RESTART WITH 250
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10

The number of the numbered folder is indeed 1197660025200

[Bob]

Thanks, Fred.

Do you still have a "database" folder? If so that one should be intact. If you move or rename the data folder, and then restart Thingamablog 1.5, do you still get the error?

Also, I wonder if it would be possible for you to zip up your current data folder and email it to me.

Thanks,
-Bob

[Fred]

Thanks Bob for your effort in trying to resolve this.

I renamed the "data" folder, and the program started as I would expect. It went for a while with just a waiting symbol in bottom right doing anything, then showed me a panel just as I would expect. There were all the details of the blog. I closed it down.

Restarting, using exactly the same shortcut as for the paragraph above, produced the error message noted above (or probably the same, I am rushing to work now, so do not have the time to do a diff on it).

Yes, I can zip the data folder and send it. Can you PM me with the email address that you want me to use, I cannot see any on the site.

[beckett71]

I have exactly the same problem. Moreover. Going to database properties and modifying the line
modified=yes into modified=no does not help anymore.  Immediately after I start the database I get the error message. When I open again database.properties I see modified=yes.

I can send the whole database by email if it can help. Forum allows attaching only below 200kb files.

Thank you in advance for assistance.

Jacek

[Fred]

Jacek,

Bob was able to resolve my database problem. He said that the upgrade process hadn't gone quite right, but it was a relatively simple thing to resolve. Since then, I have been using the latest version of TAMB without any problem.

Fred

[beckett71]

What should I do  to access my database? Did Bob explain what should be done?
I am addicted to Thingamablog and would like to continue using it.

I will be very grateful for help.

Jacek

[Fred]

I had to zip my old database up and send it to him. He did his magic and sent it back, and it has worked without any problem ever since. So I am afraid you need to wait for Bob to send you a direct message (email or PM on this board). I have modified the subject to see if that draws attention.

In passing, my zipped database was larger than could be sent by email, so I used a free file transfer service, such as:
http://www.bigupload.com/ 
or
http://www.sendthisfile.com/

In the meantime, continue to use the old program. The old version database is still there. You did do some backups before you made the change, didn't you?

[sjb]

I also have the same problem, when I copy the database folder I gott he same error. Is there a published solution  ?

Thanks
SJB

[Fred]

To the best of my knowledge there is no published solution. Bob took my database, did something with it and sent it back. I don't understand the way TAMB stores the data, so I can't even offer a guess at what has gone wrong with the update actions.

All I can suggest is that you make direct contact with Bob using the PM on this board.