[Plugin: Pods]

  • I have created a simple pod and template and wanted to just try it out however when I go and add a new pod (named “Test”) I input the name field and then press save. I then get this message:

    Error: Cannot get datatype fields; SQL: SELECT * FROM wp_pod_fields WHERE datatype = ORDER BY weight; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY weight' at line 1

    My server is running…

    * PHP 5.2.9
    * Apache/1.3.41 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.31 OpenSSL/0.9.8b mod_status/0.2mm
    * MySQL 5.0.77-community-log

    Does anyone know the problem here?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter Steven Jones

    (@rainemaida)

    Can anyone help with this?

    Look in your database and see if the “wp_pod_tbl_Test” table was actually created. If you don’t know how, install the wp_phpMyAdmin plugin.

    At this point, it looks like a server issue. Who’s your host, and are you on a shared server? Also, are you familiar with Firebug?

    Thread Starter Steven Jones

    (@rainemaida)

    The wp_pod_tbl_Test was created yes, but theres nothing in it.

    My host is siteground.com and yes I’ve got Firebug.

    Thread Starter Steven Jones

    (@rainemaida)

    I’ve just tested it on the same host in a sub blog I have and it worked straight away.

    Could you email a login to your original blog to pods [at] uproot [dot] us? I’m curious to see why it was breaking on there.

    Hi Guys,

    I am getting the exact same error, did you get this resolved?

    Thanks.

    this is the error I am getting…

    Error: Cannot get datatype fields; SQL: SELECT * FROM wp_pod_fields WHERE datatype = ORDER BY weight; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY weight’ at line 1

    I have also tried using pods on another hosting platform and I am getting the exact same error.

    One server is running…
    * PHP 5.2.11
    * Apache/2
    * MySQL 5.0.88-community

    And the other is on…
    * PHP 5.2.2
    * Apache
    * MySQL 5.0.68-percona-3-log

    Any help would be a life saver.

    The final issue was resolved, as it was found to be a bug when you enter capital letters as a Pod name. Pods will now normalize the case to lowercase automatically to prevent these types of issues.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘[Plugin: Pods]’ is closed to new replies.