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?
Can anyone help with this?
logikal16
Member
Posted 2 years ago #
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?
The wp_pod_tbl_Test was created yes, but theres nothing in it.
My host is siteground.com and yes I've got Firebug.
I've just tested it on the same host in a sub blog I have and it worked straight away.
logikal16
Member
Posted 2 years ago #
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.
Joshua Tree
Member
Posted 2 years ago #
Hi Guys,
I am getting the exact same error, did you get this resolved?
Thanks.
Joshua Tree
Member
Posted 2 years ago #
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
Joshua Tree
Member
Posted 2 years ago #
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.
