Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8989E182C0 for ; Wed, 26 Aug 2015 18:30:20 +0000 (UTC) Received: (qmail 60510 invoked by uid 500); 26 Aug 2015 18:30:19 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 60480 invoked by uid 500); 26 Aug 2015 18:30:19 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 60469 invoked by uid 99); 26 Aug 2015 18:30:19 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2015 18:30:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id E6F72C028F for ; Wed, 26 Aug 2015 18:30:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.999 X-Spam-Level: *** X-Spam-Status: No, score=3.999 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id PHhH3EpAS-_r for ; Wed, 26 Aug 2015 18:30:18 +0000 (UTC) Received: from mail-ig0-f171.google.com (mail-ig0-f171.google.com [209.85.213.171]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id E87D1508AF for ; Wed, 26 Aug 2015 18:30:17 +0000 (UTC) Received: by igfj19 with SMTP id j19so18843404igf.1 for ; Wed, 26 Aug 2015 11:30:17 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:reply-to:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=FOrVHMy6nejZLf/RGPJk7x/6kQN1noF6gnFAdU4V3wk=; b=i0/9o7IXe/3C7tNSEV3o40v5ZWJMemXKl1QLLKgM0k1Jog6OjaqJ61He1UwxnYthkr /1JEhZCdzlV5MEF+4FzGTA+DelAb7Esmcr2mMDB1wXR4j7M6cPmw/l8/Zgjxk32/myk7 SgS1U6h7hAbM/75CJGFEOmqNgue99GhrLiAI4A6nQaR0UKvbBv6xJgd7Zl34D0cjHJAr xxweaDQskq2n7Uf9dTJolPjuxxgQPJxWWh40NAtmAnuKDfTkCQ+sFSG9WOJ02DzXjtFT /GQxIM3rwYQyKCK+oqyxxhbOxPb6xA2WGtwd2Zo43oRUvQkGbasd1/5XXTCpp6ivjadM 0OmQ== X-Gm-Message-State: ALoCoQkJMSh6Yetb3SkA4a/y0wxL2+NsWmkmJ2DimoL+1IyOLAUD/wwAADpCsYEE0pFm7AfKemwX MIME-Version: 1.0 X-Received: by 10.50.3.37 with SMTP id 5mr5921427igz.96.1440613811569; Wed, 26 Aug 2015 11:30:11 -0700 (PDT) Received: by 10.107.164.164 with HTTP; Wed, 26 Aug 2015 11:30:11 -0700 (PDT) Reply-To: morten@citizenme.com In-Reply-To: References: Date: Wed, 26 Aug 2015 19:30:11 +0100 Message-ID: Subject: Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION' From: Morten Jensen To: user@ofbiz.apache.org Content-Type: multipart/alternative; boundary=089e013c6e9a87200e051e3b0acc --089e013c6e9a87200e051e3b0acc Content-Type: text/plain; charset=UTF-8 @Vyom very good point - I tested 5.1.36 and after repopulating the database there have been no issues - thanks! I automatically assumed that 5.1.6 was a "certified" driver release but on closer inspection that release turns out to be from March 2008 according to maven repo ;-) I have updated the JIRA issue and requested that a newer driver is downloaded via ANT - and I see a patch has been forthcoming already using 5.1.36, which is pretty quick ;-) Morten --089e013c6e9a87200e051e3b0acc--