Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
  • 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
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

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]
 
The knights of nee want a shrubbery. And a tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic