No link to create new project

By default the account you used to install GlotPress has admin rights and only admins can create new projects.

If your using another account to manage your GlotPress install you can give that account admin rights thorugh the WordPress user manager. Simply edit the user and find the GlotPress section and enable admin rights.

I have only one account on the site. I used that account to install glotpress but admin rights weren’t given to that account.

I went to user manager, hit edit user, then checked the box that says Grant this user administrative privileges in GlotPress.

After saving it, still no admin rights. So I checked the account profile, glotpress box is unchecked. No matter how many times I check the box and save it, the box is unchecked for some reason.

Any ideas or suggestions on how to fix the issue?

Do you have access to phpMyAdmin? If so check to make sure the wp_gp_permissions table exists, if it does, are there any rows in it?

wp_gp_permissions table dose not exists. What do I do?

please help.

Do any of the other wp_gp_ tables exist?

If not, something went wrong during install. The most likely issues is that the WordPress database user does not have access to create tables. The easiest way to resolve that is to grant the user create rights and then uninstall and re-install GlotPress.

Alternatively you can manually create the tables based on the information that is in gp-includes/schema.php.

I have other tables just not the wp_gp_permissions table.

grant the user create rights <— how I do this?

If the other tables were created then they have create rights, do you know what your default database type is (MyISM, InnoDB, etc)?

Try running the following SQL query to create the permissions table:

CREATE TABLE wp_gp_permissions (
		id INT(10) NOT NULL AUTO_INCREMENT,
		user_id INT(10) DEFAULT NULL,
		action VARCHAR(255) DEFAULT NULL,
		object_type VARCHAR(255) DEFAULT NULL,
		object_id VARCHAR(255) DEFAULT NULL,
		PRIMARY KEY  (id),
		KEY user_id_action (user_id,action)
	);

if it throws an error about the index being too long, try this:

CREATE TABLE wp_gp_permissions (
		id INT(10) NOT NULL AUTO_INCREMENT,
		user_id INT(10) DEFAULT NULL,
		action VARCHAR(255) DEFAULT NULL,
		object_type VARCHAR(255) DEFAULT NULL,
		object_id VARCHAR(255) DEFAULT NULL,
		PRIMARY KEY  (id),
		KEY user_id_action (user_id,action(75))
	);

I ran the 1st SQL query and it gave me an error about index being too long. So I tried the second and it went through. I can see that wp_gp_permissions table is created but nothing changed. still no menu to create project. still can’t check the box in the profile that says Grant this user administrative privileges in GlotPress.

Try disabling GlotPress and then re-enable it.

I tried deactivating and re-activating. It didn’t work. I tried deleting the plugin and re-installing. Still no luck.

Any ideas?

[ No bumping please. ]

Sorry, just been a bit busy, I have another suggestion to try but I haven’t written it up yet.

Ok, no problem. I will be waiting!

Ok, so you need to run two SQL queries, the first is to get your user_id:

SELECT id FROM wp_users WHERE user_login = '[your login name]'

This will identify what your user account id is, then run the following SQL:

INSERT INTO wp_gp_permissions (user_id, action) VALUES ([your user id],'admin')

After the first SQL query I got error message

#1146 – Table ‘********.wp_users’ doesn’t exist

I took screen shot of the tables I have.

View post on imgur.com