samwilson

Thanks for reporting this! And thanks for liking the plugin. ??

I’m not able to reproduce this error with pagination (with 4.6, or 4.7/trunk, and PHP 7). Do you have any more info about the error? Could you check your logs for any more specific error message? I’d love to figure out what’s going wrong and fix it!

Thanks!

Thank you for your kind words of encouragement! I have rather let development slide in the last couple of months because I lost my job. I’ll be back into it soon though, I hope.

In answer to your questions:

1. Yes, when you link a ‘cross reference’ to a ‘target table’, a foreign key is created in the local table.
2. No, there’s no other index-creation capabilities at the moment, but I’d like to add some. Want to keep it simple though.

Keep in mind that if you’re comfortable working in PHPmyAdmin or similar, then you can do all the structure-modification stuff there, and Tabulate will work with it just fine.

Let me know what else needs attending to!

I’m sorry for your troubles! Thanks for your nice words about Tabulate.

I think your issue is a common one, and hopefully quite easy to fix; there’s an item in the FAQ about it.

The thing is, your database user needs to have the FILE privilege in order for the temporary CSV file to be written to the server before you can download it.

So something like GRANT FILE ON *.* to db_user@localhost should fix it.

Sorry, scratch that. There is no support for tables without PKs!

Can you explain a bit more about why you can’t add a PK? Do you have any UNIQUE constraints?

Sorry to disappoint. The other issues should be solved though.

Ok, the uninstallation error has been fixed now, and you should be able to import into tables without PKs.

Sorry about the delay with all this. But I’m on to it now; should have a new version out shortly. ??

Sorry for this! And thanks for reporting it.

You’re quite correct, grants don’t work for roles that have the ‘promote_users’ capability — the idea being that anyone with that capability can just modify the grants anyway. Perhaps the solution to this bug is to remove the Administrators role from the Grants table? I’ll investigate.

Your issue with saving cennik_upd should be fixed in the new version (which I’ll get out this afternoon).

Your issue with importing CSV is not clear yet. I’m investigating. Could you please provide more info about the structure of the table you’re importing to. I suspect it’s an issue with the primary key; what data type is your PK column?

+1 I’d use this plugin much more if I could make it available for non-admin users.

Sorry, actually I’m still getting this error (I checked on a different host before, where errors were turned off).

Looks good now! Thanks. ??

Yes, hopefully will get it out soon. ??

Come over to https://github.com/tabulate/tabulate/issues/26 with any ideas you’ve got for this.

Thanks!

I’ll track this here: https://github.com/tabulate/tabulate/issues/26

No, I’m afraid not at the moment. This feature is planned, though. Stay tuned! ??

(Sorry for being so slow in replying!)

The easiest way is probably to create a view:

CREATE OR REPLACE VIEW user_information AS
SELECT u.user_login,m.meta_value
FROM wp_user u JOIN wp_user_meta m ON m.user_id=u.user_id

1. Yes, you can create a view such as this:

SELECT cs.id AS changeset_id, c.id AS change_id, date_and_time,
  user_nicename, table_name, record_ident, column_name, old_value,
  new_value, comment
FROM wp_tabulate_changes c
  JOIN wp_tabulate_changesets cs ON (c.changeset_id=cs.id)
  JOIN wp_users u ON (u.ID=cs.user_id)

Of course, change the database prefix to whatever’s correct.

2. Not at the moment, I’m afraid, and there isn’t a plan to make this happen. Not that it’s not a good idea though. I’ll add it to the future-features list! ??

Thanks,
Sam

PS Sorry for the delay in replying, I only just saw this post.