• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Need a 2.1.6 to 2.1.7 Idiots guide

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well i'm using jetty not Tomcat. though I don't think that makes a big difference realy.

ok so don't use a overridden database.

so I go to the 217 script directory. As per the instructions. I can do that

I can run the script in databasemangerswing, but without reference to the database/s it just errors out on me.


[originally posted on jforum.net by jasonjarvis]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It occurred to me just moments ago.

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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Try Admin Panel -> Smilies

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, I registered that in Jira. We should do it until Release 4 of JForum 2.1.7. The link is http://www.jforum.net/jira/browse/JF-618

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
any suggestion on how I can fix this in the mean time?
[originally posted on jforum.net by jasonjarvis]
 
What kind of corn soldier are you? And don't say "kernel" - that's only for this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic