• 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
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

2.1.4 to 2.1.5 CVS database upgrade tips?

 
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 trying to upgrade an existing 2.1.4 forum to the current CVS code. I'm having a few problems. I see that all of my categories and forums are loaded into the DB but I'm unable to see pretty much anything.

I'm running against a PostgreSQL 8.1 DB and Tomcat 5.5.12. Restarting Tomcat does not seem to change anything. I notice that there are a few DB changes, for example in jforum_roles (there is no longer a user_id column).

My sequence of events is:

1) Create empty DB.
2) Create DB struct from the db_struct.sql file.
3) Load the sample data from the data_dump file.
4) Load the database dump from 2.1.4. I expect to see some duplicate key violations.

I've tried it with skipping step three above. Any thoughts as to where I may have gone wrong? I feel that this is a permissions issue but am not positive about that.

Thanks in advance for any information.
[originally posted on jforum.net by stdunbar]
 
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
Yes, it is. After you migrate from one version to another, you should set again all permissions.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
You learn how to close your eyes and tell yourself "this just isn't really happening to me." Tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic