Can you check to make sure the GP tables were created in the database? You should see a few, but for projects the wp_gp_projects table is the important one.
Thread Starter
tanter
(@tanter)
no databases at this time (gp ot wp_gp) 😕
I just deinstall and install again. I got them before….
Thread Starter
tanter
(@tanter)
I just install the plugin again and no tables were created. 😕
I tried to create them using sql statement at schema.php and I have problems with some of them.
gp_meta – “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘{$max_objtype_metakey_key_length})),
KEY object_type__object_id__meta_key (ob’ at line 8 ”
gp_originals – “‘{$max_singular_plural_context_key_length}),plural({$max_singular_plural_context_’ at line 14 ”
gp_translations_sets – “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘{$max_pid_slug_locale_key_length}),locale),
KEY locale_slug (locale,slug({$ma’ at line 8 ”
What should I do?
The most likely problem is that whatever SQL account WP is using doesn’t have table create permissions, the easiest solution is to grant it that right and then re-install the plugin.
The schema file is intended to be run as part of the plugin and has several variables that are calculated at run time, so a simple copy/paste won’t work. If you need to generate it by hand you can create a quick script to do the work for you by creating a php file in the root of your WP install with the following content:
include( 'wp-load.php' );
include( 'wp-content\plugins\glotpress\gp-includes\schema.php' );
foreach( gp_schema_get() as $table => $sql ) {
echo $sql . PHP_EOL;
echo PHP_EOL;
}
-
This reply was modified 8 years, 7 months ago by
Greg Ross.