Docs

[jasonixr]

Hello,

I’ve just installed the Essential Grid plug via the Xaddons page. However no skins are showing as available when I create a grid. When creating a grid under the skins tab none are shown as options. The same happens when I go into skin editor – there are no skins to edit.

Having used essential grids with other x Theme installs I’m fairly certain I know what I’m doing but perhaps I’m overlooking something in the initial plugin setup?

My troubleshooting steps so far:

Attempt 1
Deactivated the Essential Grid Plugin
Deleted the Essential Grid plugin with the “delete all files” option
Re-installed the plugin via the Xaddons page & reactivated
Tested – skins are still missing

Attempt 2
Deactivated and deleted the plugin with the “delete all files” option
Revoked X Theme validation via the Xaddons page
Re-validated the X Theme install via the xAddons page (pasting in the purchase code associated with the license)
Reinstalled and activated the Essential Grid plugin via the Xaddon page
Tested – skins are still missing

Wordpress version 4.5.2
X version 4.4.2
Cornerstone version 1.2.4

[Lely]

Hello There,

You could try testing for a plugin conflict. You can do this by deactivating all third party plugins, and seeing if the problem remains. If it’s fixed, you’ll know a plugin caused the problem, and you can narrow down which one by reactivating them one at a time. If not a plugin conflict, please would you mind providing us with login credentials so we can take a closer look? To do this, you can make a post with the following info:

– Link to your site
– WordPress Admin username / password
– FTP credentials

Don’t forget to select Set as private reply. This ensures your information is only visible to our staff.

[jasonixr]

This reply has been marked as private.

[Rad]

Hi Jason,

Your database could be corrupted, please download this file https://www.dropbox.com/home/X%20Re-use?preview=ess_grid_tables.sql and import it to your database through PHPMyAdmin. It should be accessible on your hosting panel if not, then you should contact your hosting provider.

Now, that SQL file is for database tables that have wp_ prefix ( eg. wp_eg_grids, wp_eg_item_elements, wp_eg_item_skins ). Now, if your database tables have different prefixes than wp_, then you’ll have to edit the SQL file before the import and change all instances of wp_ to your preferred prefix.

Your FTP login credential is pointing to the wrong folder, I can’t verify the prefix that your site uses ( wp-config.php’s $table_prefix ).

Thanks!

[jasonixr]

This reply has been marked as private.

[jasonixr]

This reply has been marked as private.

[Rad]

Hi there,

Thanks, I checked and there is no need to edit the SQL file. You’ll just need to import it using PHPMyadmin.

Sorry about the link, I just re-uploaded it here https://www.dropbox.com/s/ba3a3ozna5iy98j/ess_grid_tables.sql?dl=0

Let me know. Thanks!

[jasonixr]

This reply has been marked as private.

[jasonixr]

OK, I imported the SQL and that solved the issue. However every time I create a new xTheme until I run this the skins are missing – it didn’t used to be this way on these same servers.

I’m worried that something bigger is wrong.

[Nico]

Hi There,

Glad to hear that the SQL works and we know already what is the problem. The problem is when activating the essential grid, the table for essential grid is not correct that is why you need to re-import it. Please try installing a new setup without changing the database prefix.

Let us know how it goes.

Thanks.

[Stephen C]

I just updated Essential Grid and have the exact same issue. WordPress, X and Essential Grid are all updated as of today. I’ve attempted to follow the link above to Dropbox but this was unsuccessful so I assume it’s gone or a private link.

https://www.dropbox.com/home/X%20Re-use?preview=ess_grid_tables.sql

I have 6 sub-domains running so I can test themes/solutions and demo sites to clients prior to final launch. Because of this each database is named something like wpsa_ or wpun_ instead of just wp_ . I have a screenshot of my database for reference.

I wonder if Jason also has more than one instance of WP running maybe on a sub domain?

Regardless, since I cannot have all of them have the same exact database name:

1) How can I get a copy of the tables you referenced above?

2) Would I be able to just modify those tables to get them to work?

Thanks!

Stephen

**UPDATE: I went back and when activating through Softaculous I am able to manually enter the database prefix. If that is the root cause I should be able to correct it.

[Rad]

Hi there,

The table names for Essential Grid are always the same and will not change (unless the plugin’s developer does so). It’s nothing to do with the database name. Though, you’ll have to import it to the database that matches your WordPress’s wp-config.php database.

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'awesome_database');

The only thing you need to change is the table prefix used for tables, table prefixes are added once you install WordPress. If you didn’t change the prefixes during installation of WordPress, then it’s of course default to wp_ (unless hosting provider auto install it with their own prefix).

You’ll have to check your table prefixes and edit the given SQL file to match them. From your screen shot, your table prefix is wpsa_. It should also available from WordPress’s wp-config.php

/**
 * WordPress Database Table prefix.
 *
 * You can have multiple installations in one database if you give each
 * a unique prefix. Only numbers, letters, and underscores please!
 */
$table_prefix  = 'wp_';

The rule is just to match prefixes before importing, or change it after the import if allowed.

Cheers!

[Stephen C]

Hi Rad!

I think I am following you and I updated my initial post when you were adding yours.

Evidently for sub-domains (but not main domain installations), Softaculous does change the table prefixes. I talked to my hosting service and they said I shouldn’t have an issue if I change it to wp_ . I have a screenshot of the section in Softaculous I found prior to editing the prefix to wp_ . Once I installed WP I looked at the tables again and they look good (screenshot attached). I think this should work now. I may migrate my current test site to this new installation for this client.

Thank you!

[Lely]

Hello Stephen,

Thank you for updating us. Glad it is working now.

Cheers!

[jasonixr]

Unfortunately the fresh install still creates the problem, even with wp_ as the table prefix.

Please reference the screencast of me recreating the issue, I included the youtube link and all applicable login info in one of my private replies above. In it you’ll see I set the table prefix as wp_ yet the issue still occurs.

Once it’s occurring I’m able to fix it with your provided SQL, but why the issue is happening in the first place is not clear.

[Author]

Posts