We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 31255
    • 118 Posts
    I have multilanguage site using babel (contexts web and en). Now error log fills with this error:
    [2017-01-03 15:40:19] (ERROR @ /xxxx/xxxxx/xxxxxxx/core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement: 
    Array
    (
        [0] => 42000
        [1] => 1064
        [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (modResource.context_key IN ('web') OR EXISTS(SELECT 1 FROM `xxxx_contex' at line 1
    )


    I have no idea where it come or what is going on.

    Server: Linux 2.6.32-642.4.2.el6.x86_64
    Database type:mysql
    Database version:10.0.28-MariaDB
    PHP Version:5.4.42
    Revolution 2.5.2
    Babel 3.0.0 pl [ed. note: valokammi last edited this post 7 years, 3 months ago.]
      Tassu, webmaster of Valokammi
      • 33238
      • 388 Posts
      I had something similar, check that you are filling all necessary fields on every context, eg:

      Name:
      Key:
      Value:

      Base URL
      base_url
      /

      Culture key
      cultureKey
      en


      Default Media Source
      default_media_source
      2

      http Host
      http_host
      yoursite.com

      Site start
      site_start
      1


      Site URL
      site_url
      http://yoursite.com/
        --
        ysanmiguel.com