Forum Replies Created

Viewing 15 replies - 31 through 45 (of 87 total)
  • Plugin Author samwilson

    (@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!

    Plugin Author samwilson

    (@samwilson)

    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!

    Forum: Plugins
    In reply to: [Tabulate] CSV export issue
    Plugin Author samwilson

    (@samwilson)

    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.

    Forum: Plugins
    In reply to: [Tabulate] Multiple issues
    Plugin Author samwilson

    (@samwilson)

    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.

    Forum: Plugins
    In reply to: [Tabulate] Multiple issues
    Plugin Author samwilson

    (@samwilson)

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

    Forum: Plugins
    In reply to: [Tabulate] Multiple issues
    Plugin Author samwilson

    (@samwilson)

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

    Forum: Plugins
    In reply to: [Tabulate] Multiple issues
    Plugin Author samwilson

    (@samwilson)

    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?

    samwilson

    (@samwilson)

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

    Thread Starter samwilson

    (@samwilson)

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

    Thread Starter samwilson

    (@samwilson)

    Looks good now! Thanks. ??

    Forum: Plugins
    In reply to: [Tabulate] End Users Search
    Plugin Author samwilson

    (@samwilson)

    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!

    Plugin Author samwilson

    (@samwilson)

    Plugin Author samwilson

    (@samwilson)

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

    Plugin Author samwilson

    (@samwilson)

    (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
    
    Forum: Plugins
    In reply to: [Tabulate] track changes
    Plugin Author samwilson

    (@samwilson)

    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.

Viewing 15 replies - 31 through 45 (of 87 total)