I'm not a webmaster, i am a programmer and writer. I don't like spending hours on end trying to get a webapps up and running. I use my forum for a writing community. ok with that out of the way.
I do not have the average webmaster knowledge of databases and web servers. Without this knowledge I find the upgrade instructions to be unhelpful.
Here is what i'm using
jetty 6, wich makes JForum an easy pop in and run.
JForum default hsqldb.
Step 1. back up.
No problem.
Step 2. have 217 work directory and when done overwrite the original in the webserver directory.
What the? What am I suppose to be doing here? do I take my 216 database and overwrite the 217work version? Well I did that.
Do I manualy copy all the properties and config variables from the two mentioned special files and past them in the new 217 versions. That's what I understand from another posting. Haven't done that yet.
Step 3. update the schema
why use the mysql command when it's the hsqldb as defualt. If someone is already managing to run a mysql db, doesn't it stand to reason then they already know what they are doing.
I've tried using various org.hsqldb.util.* tools. The closest I got was DatabaseManager --script, but even then I couldn't reference the database. Is the db suppose to be running?
I found that so far the upgrading help made the assumption that everyone is somewhat experianced webmaster. What sold me on using JForum was that it was supposed to be easy.
Funny thing is I can program using hsqldb but actualy using it's tools is another matter.
I'm frustrated becuase I love, if I didn't love I would send the database over to a friends and have him host it on his PHP server. I would prefer using JForum becuase I like it. I realy realy want to run 217. Please help an idiot to upgrade. i' going to put back the backup in the meant time.
oh I have/had an account here under the name JaydeRyu, but I forgot the password and I don't get any emails. [originally posted on jforum.net by jasonjarvis]
I'm using mysql, so I'm not sure I can help you precisely.
That's what I would do ...
stop tomcat,
don't overwrite you database, but simply attach to the hsqldb script file, at the end of the file, the update script.
And just restart: it should work.
Ask for any doubt [originally posted on jforum.net by enricod]
Most people will be running there database separately from their forum. I am running the internal default version. So maybe what I need to run the forum as a individual like the others. Then run the tool and script from within 217. I think this is what the instructions miss if your running the default. I'll check to see if i' right later. [originally posted on jforum.net by jasonjarvis]
I was right, I ran the org.hsqldb.Server as independent. Ran org.hsqldb.util.DatabaseManager --script hsqldb_2.1.6_to_2.1.7.sql. Executed the script. I did get errors. I ran it again and it came up with a already done error. Tested it and it worked.
Except my Emoticons/smilies are broken. I can't even add new ones.
Any suggestions what went wrong, and were to look in to fix it. [originally posted on jforum.net by jasonjarvis]
Tried that, doesn't show smilies. All the images have the broken image. When I try to add a new smily it's comes up as a broke image. Do you have another solution. [originally posted on jforum.net by jasonjarvis]
