0.6.0 - Does not create SQL Tables

[Psinergy]

Steps to reproduce

What did you do?
Deleted tables and uninstalled plugin. Reinstalled plugin, activated, but does not create tables.

Expected behavior

Tell us what should happen
When activating plugin, should be creating tables.

Actual behavior

Tell us what happens instead

Frameworks tested

Which module / plugin were you using?

• Drupal 8
• Drupal 7
• [x ] WordPress 4.8.1
• Using lcache/lcache directly
• Other (specify)

[danielbachhuber]

@Psinergy I can't reproduce this issue. When I activate the plugin, database tables are created correctly.

Could you share your MySQL version and other debugging steps you've performed?

[RBrang]

$table_prefix in object_cache.php is wrong in multisite (and/or network?) environments. That's why lcache thinks that the tables have not been created on activation. The tables are there, but with a name like wp_5_lcache(whatever)

[davidstrauss]

LCache (this library, specifically) generally doesn't create its own tables. It's handled by whatever system is handling DB schema, which would be the WordPress plug-in in this case.

[danielbachhuber]

@RBrang Great catch — I know exactly what the issue is. I'll work out a fix and tag a patch release for the plugin.

This issue can be closed in favor of lcache/wp-lcache#147

[danielbachhuber]

$table_prefix in object_cache.php is wrong in multisite (and/or network?) environments. That's why lcache thinks that the tables have not been created on activation. The tables are there, but with a name like wp_5_lcache(whatever)

@RBrang Actually, this is incorrect. The lcache_events table is used for the entire WordPress install, even on multisite. On multisite, keys are prefixed with the blog id.

@Psinergy Could you share more environment details? If possible, can you debug the activation process itself, to make sure wp_lcache_initialize_database_schema() is being called and to see if any MySQL errors are thrown?

[Psinergy]

That is totally out of the scope of what I know how to do any longer (haven't been into that kind of stuff for about 8 years at this point... :/ ) ...sorry. I use FastComet Speedup for hosting? Does that help? Make it a GREAT Day, SchaOn Blodgett, CCP, BTAT Holistic Health Professional *Psinergy Natural Health & Holistic Wellness | Helping you access your Awesomeness... Naturally.* *...a branch of Psinergy LLC* 1553 Como Ave St Paul, Minnesota 55108 Office: (612) 217-4325 Fax: (612) 217-4325 schaon@psinergyhealth.com https://www.psinergyhealth.com This e-mail, including any attachments, is intended solely for the person or entity to which it is addressed and may contain confidential, proprietary and/or non-public material. Except as stated above, any review, re-transmission dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than an intended recipient is prohibited. If you receive this in error, please notify the sender and delete the material from any media and destroy any printouts or copies. Additionally, this e-mail does not create a practitioner-client relationship unless a Client Bill of Rights, as mandated by MN State Law Statute 146A, has been signed by both the client and responsible practitioner.

…

-------------------- ‎"A man too busy to take care of his health is like a mechanic too busy to take care of his tools." Spanish Proverb

On Thu, Sep 28, 2017 at 7:12 AM, Daniel Bachhuber ***@***.***> wrote: $table_prefix in object_cache.php is wrong in multisite (and/or network?) environments. That's why lcache thinks that the tables have not been created on activation. The tables are there, but with a name like wp_5_lcache(whatever) @RBrang <https://github.com/rbrang> Actually, this is incorrect. The lcache_events table is used for the entire WordPress install, even on multisite. On multisite, keys are prefixed with the blog id. @Psinergy <https://github.com/psinergy> Could you share more environment details? If possible, can you debug the activation process itself, to make sure wp_lcache_initialize_database_schema() is being called and to see if any MySQL errors are thrown? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#85 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AXjr_xGgjAIWFNtw6PQxhxcrErsNDZeoks5sm40XgaJpZM4PE66d> .

[danielbachhuber]

No worries, @Psinergy.

There's a similar report in the WordPress.org support forums that's yielded this MySQL error: lcache/wp-lcache#148