Can’t create projects

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.

no databases at this time (gp ot wp_gp) ??

I just deinstall and install again. I got them before….

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 7 years, 3 months ago by Greg Ross.