Multiple-table-error #37


  • New
  • Defect
Open
Assigned to _ForgeUser3386019
  • Kostronor created this issue Jan 16, 2012

    What steps will reproduce the problem?
    1. Use a phpbb-board
    2. Add a new custom-profile-field
    3. try to use that field as your minecraft-name
    4. Profit: Exception
    modes:
      normal:
        user-table: phpbb_users
        minecraft-login-name-field: pf_mc_username
        rank-id-field: user_rank
        multitable:
          enable-multiple-tables: 'true'
          second-table: phpbb_profile_fields_data
          user-id-field-in-user-table: user_id
          user-id-field-in-second-table: user_id

    What is the expected output? What do you see instead?
    It should work, but it throws this exeption:
    2012-01-16 14:57:05 [WARNING] [OKB3] [MySQL] Error in SQL query: Unknown column 'pf_mc_username' in 'where clause'
    2012-01-16 14:57:05 [SEVERE] java.sql.SQLException: Operation not allowed after ResultSet closed
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
    2012-01-16 14:57:05 [SEVERE]     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145)
    2012-01-16 14:57:05 [SEVERE]     at me.kalmanolah.okb3.OKFunctions.GetMySQLPosts(OKFunctions.java:453)
    2012-01-16 14:57:05 [SEVERE]     at me.kalmanolah.okb3.OKFunctions.updatePosts(OKFunctions.java:468)
    2012-01-16 14:57:05 [SEVERE]     at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:127)
    2012-01-16 14:57:05 [SEVERE]     at java.lang.Thread.run(Unknown Source)

    What version of the product are you using?
    the newest: v3.4.0

    Do you have an error log of what happened?
    sure, see above

    Please provide any additional information below.

  • Kostronor added the tags New Defect Jan 16, 2012
  • Kostronor posted a comment Jan 16, 2012

    This only fails when rank-change is enabled!


To post a comment, please login or register a new account.