DataApp mysql script doesn't work with latest mysql

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: P4
    • 8
    • Affects Version/s: 7u6
    • Component/s: javafx
    • None

      install mysql-5.1.65-osx10.6-x86_64
      run dataapp server, next error will be shown:

      Invalid Query: Column Count Doesn't Match Value count.


      To fix this: in DataAppLoader/build.xml next lines:


                  INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL);
                  INSERT INTO db VALUES ('localhost','APP','dataapp','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y');


      should be changed to:

      GRANT ALL PRIVILEGES ON APP TO dataapp@localhost IDENTIFIED BY PASSWORD '*B974A83D18BB105D0C9186756F485406E6E6039B';

            Assignee:
            Debra Masada (Inactive)
            Reporter:
            Sergey Grinev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported: