When and why does this happen?—

"NetworkError: 404 Not Found - http://example.org/wp-jsontabulate/tables"

I'm trying to make a CRUD form using tabulate.

In the list of records can we implement a link or button which takes us to the edit/delete page of the record.

In the usual WP manner, I mean.

Any chance you could add the ability to set a default on a field that's kind of a critical piece that's missing. Great plugin otherwise but would be hard to use without defaults. Though I can probably go over into mysqladmin and set those for now.

Thanks,

Eric

To comply with Bootstrap.

Version 2.7.13 In Overview the up-down arrows will move a given column but when I hit the save button the moved row returns to its original position. The row was added to the table and originated at the bottom. It consists of a phone number as a short-text 255 and is not a key or auto-incrementing.

Unable to alter 'books.id' — Cannot change column 'id': used in a foreign key constraint 'book_fk_to_books' of table 'wordpress.book_quotations' — ALTER TABLE books CHANGE COLUMN id id INT(10) NOT NULL AUTO_INCREMENT COMMENT ''

also:

WordPress\Tabulate\DB\Exception: Unable to alter 'types.id' — ALGORITHM=COPY is not supported. Reason: Columns participating in a foreign key are renamed. Try ALGORITHM=INPLACE. — ALTER TABLE types CHANGE COLUMN id ident INT(10) NOT NULL AUTO_INCREMENT COMMENT ''

Everything looks good, but after updating a row the data is not updated in the database and the row reverts to its original value.

If this is to do with 'secure_file_priv' then I don't think it is possible for me to use the product because my hosting company does not allow access to the MySQL ini file.

Please advise.
Thanks

Now that the table name is recorded in the change-tracker, renaming a table also requires that the change history be updated.

Could anyone please assist me in modifying the code in such a way that instead of selecting a record based on the primary identifier (which is passed as 'ident' in the shortcode) it can be used to select a record using a different identifier also passed using a short code.
Example:
[tabulate format=record table=bookings ident=2]
Would return one value from the table bookings where the primary identifier is 2.
Goal:
[tabulate format=record table=bookings ref=ref-142536]
And the goal would be for this to return the record that has the reference 'ref-142536'
Any contributions would be greatly appreciated :)
(Also first issues ever)

Fatal error: Uncaught Error: Call to a member function get_record() on boolean in /home/execut61/public_html/charterfishingnow.com/wp-content/plugins/tabulate/src/DB/Reports.php:70 Stack trace: #0 /home/execut61/public_html/charterfishingnow.com/wp-content/plugins/tabulate/src/Controllers/ReportsController.php(30): WordPress\Tabulate\DB\Reports->get_template(1) #1 /home/execut61/public_html/charterfishingnow.com/wp-content/plugins/tabulate/src/Menus.php(140): WordPress\Tabulate\Controllers\ReportsController->index(Array) #2 /home/execut61/public_html/charterfishingnow.com/wp-includes/plugin.php(525): WordPress\Tabulate\Menus->dispatch('') #3 /home/execut61/public_html/charterfishingnow.com/wp-settings.php(393): do_action('init') #4 /home/execut61/public_html/charterfishingnow.com/wp-config.php(99): require_once('/home/execut61/...') #5 /home/execut61/public_html/charterfishingnow.com/wp-load.php(37): require_once('/home/execut61/...') #6 /home/execut61/public_html/charterfishingnow.com/wp-admin/admin.php(31): require_once in /home/execut61/public_html/charterfishingnow.com/wp-content/plugins/tabulate/src/DB/Reports.php on line 70

On version 4.5.2 went to Reports but I don't see any Views or Reports on the previous screen so perhaps it doesn't handle if someone doesn't have reports.

The following WordPress\Tabulate\DB\Column method works contradictionary to how it is documented:

    /**
     * Only NOT NULL text fields are allowed to have empty strings.
     * @return boolean
     */
    public function allows_empty_string() {
            $textTypes = array( 'text', 'varchar', 'char' );
            return $this->nullable() && in_array( $this->get_type(), $textTypes );
    }

Supposedly, it should be return !$this->nullable() ...

Hi,

I want to make a page like the screenshot of tabulate.
I want to see the table of database and modify it.

Could you tell me about it?

Thank you.

We need a more user-friendly way to enter the shortcode when in visual editing mode (because pasting text from the documentation often brings the HTML along with it and breaks the shortcode; see #44).

Steps to reproduce

1. Create two database tables as follows:

   CREATE TABLE wp_test_category (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255));
   CREATE TABLE wp_test_item (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), category_id INT, FOREIGN KEY (category_id) REFERENCES wp_test_category(id) ON DELETE SET NULL);
   INSERT INTO wp_test_category (name) VALUES ('foo');
   INSERT INTO wp_test_item (name, category_id) VALUES ('bar', 1);

2. Open Tabulate at http://localhost/wp-admin/admin.php?page=tabulate&controller=record&action=save&table=wp_test_item&ident=1

3. Change Category ID field from "foo" to (empty), click Save.

Expected result

The Category ID is reset to empty value (NULL is stored to the database).

Actual result

The Category ID remains pointing to "Foo".

Notes

I traced the problem to $wpdb->update not supporting NULLs, however I believe until this is fixed upstream this shouldn't prevent Tabulate from handling this situation properly.

Fatal error: Call to undefined method WordPress\Tabulate\Controllers\RecordController::delete() in /var/lib/openshift/account/app-root/data/plugins/tabulate/src/Menus.php on line 94

Is there an include I need to add to the template to get the delete to work properly? I am new to wordpress and openshift.

Thanks!

Unable to navigate to subsequent pages if filters are applied. The filters are dropped.

Only “Grants” page is working for me.. “Overview” and “Reports” are not working, just white pages… I have tried to

• disable all other plugins, still no luck.
• Also after a Google quest i did not find my answer

Can somebody please help to find my answer to get Tabulate 2.5.1. to work?

Thnx up front!

Chad

Following on from #4 (and with thanks to @IlyaSemenov), this feature is to allow the user to explicitely choose between a (nullable) text field being saved as null or as the empty string.

New to Tabulate - and not very experienced. I am confused by the shortcode attributes and their proper formats.

If I could just get an example shortcode to do this one thing I think it will sink in!

I have a table called
Xwp Participants Database

I just want to give the user a form where he can create a new record in that table.

Could someone just please tell me what that shortcode should be?

Very much appreciate your help!

Hello, when I pressed Report menu, gives an error like that:
Fatal error: Call to undefined method Twig_Environment::createTemplate() in /home/content/

I can see Grants and Overview menu. I use Php 5.4.

I just want to shown html tables for my query, it is not to be hard :(

One should be able to do is 'yes' as well as is '1'.

I get - The page isn’t working

[server] is currently unable to handle this request.
HTTP ERROR 500

on
/wp-admin/admin.php?page=tabulate

The grants page works. The overview and reports one doesnt.

I'm running WordPress 4.6

thank you

After update to 2.9.1 I get the following error:
Parse error: syntax error, unexpected 'class' (T_CLASS), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' in /home/wshstreasurer/public_html/wp-content/plugins/tabulate/src/Menus.php on line 54

Please fix!
I will be removing until fixed.

Fatal error: Class 'WordPress\Tabulate\Controllers\Controller' not found in /home/u6692146/public_html/wp-content/plugins/tabulate/src/Menus.php on line 136
i am gettting this error. What should i do ?

My table have image field(both binary and path are ok), does it support?
if field is used to store link, if possible to support directly click the link.

Needs investigation.

From https://wordpress.org/support/topic/user-frontend-filter

It looks like it does everything we do now, but better.
http://harvesthq.github.io/chosen/

Good Afternoon,

I have installed Tabulate and WP Rest API and when I click on overview from the menu it give me this error:
Parse error: syntax error, unexpected '[' in /home/dimo/public_html/wp-content/plugins/tabulate/src/DB/Column.php on line 554

I also get this error on the reports link, but not on the grants link.

I have made a test page to use the shortcode:
http://dimo.com/test-2/

and same error, any help would be appreciated. THank you.
-SGF

Received following error

Argument 2 passed to WordPress\Tabulate\DB\ChangeTracker::after_save() must be an instance of WordPress\Tabulate\DB\Record, boolean given, called in ... /plugins/tabulate/src/DB/Table.php on line 966 and defined, .../plugins/tabulate/src/DB/ChangeTracker.php, 69,

help me!
I use tabulate (version 0.11.1) from WordPress.

• Wordpress: Version 4.2.2.
• phpMyAdmin : Version 2.11.5.1
• PHP: Version 5.5.17p1.

I export the data to a csv an error occurs, such as the image below.

Hello Team,
Thanks for the great job with the plugin.

I'm new to using it. I have few queries

1. Please let me know how I can get data from two tables using foreign key.
2. Is it possible to decide which all columns to be displayed in the list and form
3. Can we customize the style (CSS)

Not sure how yet, but perhaps with a sort of 'tagging' interface....

When Create a new row for a table, in the very INSERT of it. It works, the record is inserted, but not all the values are inserted.

The pk and all the string type are fine, but the numeric staff, that is some NUMERIC (x,y) and so on, also an ENUM('0','1') do not get inserted.

No big problem because the UPDATE goes smooth on the other side, but it is a bug, Sam.

I'd like to ask if how come I use cross reference type and select the table, after saving changes, it goes to integer type.

Suppose a dropdown from the table it is referenced to? or is it something in my data? My database is just from the regular wordpress installation and added tables via my sql, and the rest from Create Table from Tabulate itself.

I have access to myphpadmin and mysql.

Hope you can answer dilemma. Thanks!

If a table has an enum column, its structure can't be edited at the moment.

When I use the shortcode like this:
[tabulate table=wp_csw_mbracct_personuser]
I get the following error:
Tabulate shortcode error:
The 'table' attribute must be set. Attributes found: [ 0 = "" 1 = "" 2 = "" 3 = "style="font-family:" 4 = "Courier" 5 = "" 6 = "class="pre">" ]
For more information, please read the docs.

The documentation does not mention anything about table attributes.

It's pretty frustrating to try to edit a table that contains an unsupported field. It doesn't work, but there's no indication of why or what could be done to fix it — just a blank 'type' dropdown.

The map works when clicking on the map, to place the pin; but not when subsequently viewing the same record.

Permit access to the data in Tabulate tables via the Rest API.

(Requested at https://wordpress.org/support/topic/using-tabulate-with-rest-api/ )

We have a mysql table and would like to CRUD where to add / config the table . Should we bring it in wordpress DB ? As after installation of tabulate by default it displays the wordpress DB info could not find to change the DB option.

I always encounter this error every updates

Fatal error: Call to undefined function WordPress\Tabulate\is_plugin_active() in .../wp-content/plugins/tabulate/src/Menus.php on line 118

I'm running a stable, completely up to date multisite. I installed Tabulate but am unable to network active it. I receive the message, "Fatal error: Class 'WP_Filesystem_Base' not found in /var/www/html/<mysite./wp-admin/includes/class-wp-filesystem-direct.php on line 17. The plugin also fails to activate on a subsite, with the same error.

Shortcode feature is great but use many not always use it. It would be good idea to enque the assets only when the shortcode is used

Where a table contains spatial data, provide an option to display on a map.

Is there some issue?

I had to place in a default size, had no idea what size to us, used 8 and it created. Saying Schema Updated.