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

migration from MySql 4.1 to MySql 5.0

 
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 migrate database from:
mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3
to
mysql Ver 14.12 Distrib 5.0.37, for redhat-linux-gnu (i686) using readline 5.0

sql script migrate success.. encoding is correct..
but Jforum shows this:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'forum_id' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)


[originally posted on jforum.net by sae]
 
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
This can't be simple due a database version migration. There are problems with your JForum installation. It looks like you did't run some upgrade script when upgrading from an older version of JForum (or, when converting the table from one version of mysql to another, something happened that corrupted a table... hard to say)

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
it's funny but i install under FC7 MySQL 4.1 the same version as FC4 has.
I copy database files directly! from FC4, and copy tomcat with working copy of Jforum from FC4.
AND! I have the same exception

16:04:28,803 ERROR [ForumStartup ] Unable to bootstrap JForum repository.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'forum_id' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.jav
a:92)
[originally posted on jforum.net by sae]
 
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
Hey Sae,

I am having the same problem... Have to migrate data from Mysql 4.1 to 5.0, and I'm getting an 'Unknown Column' Error, even though the column is defined in the table, and getMetadata also prints it. Plus, when I decided to not update this column, i.e. removed it from the query string, I still get an Error, saying this field not found.

Please let me know how you solved your problem

-inno
[originally posted on jforum.net by inno]
 
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
No idea I'm migrate to PhpBB, and lost all data from jforum...
[originally posted on jforum.net by sae]
reply
    Bookmark Topic Watch Topic
  • New Topic