ZeLonewolf

Ok, I had the button meanings backwards. So, given that:

1. I recreated the table layout by copy/pasting your create statement and then re-filled it from a backup table.

2. I set the 4 fields as you described in the form builder, and disabled Ajax. I also made name unique and sortable. I also removed a passback field that I noticed was there.

When I hit that darned submit button, it still lands on /wp-admin/admin-ajax.php, even with the Ajax button unchecked.

To research deeper, I looked into my server logs (I use nginx for performance reasons), and found this:

PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0" while reading upstream, client: **IP ADDRESS**, server: **HOST NAME**, request: "POST /wp-admin/admin-ajax.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "**HOST NAME**", referrer: "https://**HOST NAME**/wp-admin/admin.php?page=Database_Toolkit&renderinterface=dt_intfc4cf13e14ab82d"

Doing some digging, I realized it was a server-side permissions issue in that my php session directory was not writable by my web server. Once I fixed that, all of a sudden the insert started working. I bet it will fix other strangeness as well. So now I can keep playing with this!

I am not clear on the button meaning for the unique/required/sortable toggle buttons. Specifically, does the red ring around it mean it’s enabled or disabled?

I have the form constructed, it has 3 fields: name, lat, lon. Also got the Ajax box checked. When I try to input a new record, I get that -1 page.

Also, for reference, my table structure is:

CREATE TABLE fields (
name varchar(80) NOT NULL,
lat float default NULL,
lon float default NULL,
PRIMARY KEY (name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Hi,

I’m using version 0.1.14 (is that not the latest?). I’m building a web site for a soccer organization, and I’m trying to use it to provide a list of soccer field directions. I have pre-filled a table with soccer field name, latitude, and longitude. I also made a view, which has just 2 fields, a soccer field name and a URL to Google Maps to get directions (which I construct from name, lat, lon).

The goal is to have an admin-side form that we can use to edit the list of fields, as well as have public-side functionality to browse the list and search for fields.

I’ve been struggling to get this plugin to work. It seems to have a lot of promise, but I keep running into spots where it doesn’t work in non-obvious ways.

So at the moment, I have an interface set up for a very simple 3-field table. When I try to use it to add a new record, it redirects to /wp-admin/admin-ajax.php and just shows “-1”, and the record is NOT added. Is there some kind of trick to making that work?

Also, the “auto” field type didn’t work at all, they just showed up blank in the add new form, I had to change it to the single text field type.