Can't create puzzle on WP multisite

I have to admit I never looked in the direction of multisite. So this might take a bit of time to get me up to speed.

As this plugin was never considered for multisite functionality, please make sure for now

• that you activate the plugin on every site invidually
• that admin pages are in the same (sub)domain as the individual site they are related to
• that you try to access projects only on the individual site you create them on.

(I hope this makes sense?)

I think I found the error in my code. The right for adminitrating projects is linked to the edit_users capability, which for multisite only the network admin has.

Here you state you are using the Advanced Access Manager plugin. Can you give individual site admins the edit_users capability – only as a temporary measure? I know, in a production enviroment this would be a very bad idea, but it may take me a few days to modify the plugin for a permanent solution. Please bear with me until then.

Unfortunately this is not the answer as I am the only user of this test site (thus net admin) and I have additionally tested with AAM disabled and am still not able to crate a puzzle.

I just found a strange reason why things might not work, and that would have nothing to do with multisite.

You said yours was a fresh install – does this include by chance the MySQL server? If it has a version >= 5.5.3, WordPress might be using “utf8mb4” as the default character set. Can you verify that?

In this case the installation of the database tables for the plugin will have failed silently. A fix for that will be up tomorrow.

MySQL 5.5.41
and yes the encoding on the tables are ‘utf8mb4_unicode_ci’.

Fix is up. Please deactivate the plugin, update to v0.4.3 and activate it again.

I’ll leave this nonetheless open, since I still think site administrators will run into problems.

Well I deactivated, deleted, and re-installed the plug, but alas, unfortunately same behavior.

If the installation is still not public, it would be helpfull if you could activate the Debug mode in wp-config.php. The plugin will then display more information about the reasons for errors.

(Please remember to deactivate that for production installations again.)

Here is the error:

The project could not be added.
Table ‘my_Database_Name.rsc_12_crw_projects’ doesn’t exist
SHOW FULL COLUMNS FROM rsc_12_crw_projects

I peaked at the database saw that there were rsc_crw_projects/editors/crosswords tables. But none created specific for each network site. My guess is that the plug doesn’t take into account on multisites, the table creation numbering scheme. In a multisite, tables specific to each site are prefixed with IDs. ?Idea?, On network activation, does the plug take into consideration creation of the tables for existing multisites or only new?

Hm. That is exactly what the fix was for. Are you sure you used version 0.4.3 of the plugin?

Would you be able to look at the error log of the web server? At the time of plugin activation, there should be an entry that looks something like

WordPress database error ...
CREATE TABLE IF NOT EXISTS rsc_12_crw_projects (
    (multiple lines...)
} ENGINE=InnoDB ...

Could you post that in completed form?

oops, seems we cross-posted.

You say “network activation”. Please note what I said above: you must activate the plugin per-site. On my test installation the table names then get prefixed with IDs.

Aaaahhh, OK, missed that one. (b.t.w. ‘networkactivate’ does throw table creation errors)

I can now create a project. However on the post that I have the shortcodes for ‘build’ and ‘solve’ , all 3 angular.js JSs are not referencing correctly.

sample path:
<script type=’text/javascript’ src=’https://mydevserver.com/devsite01/network-site-path/wp-content/plugins/crosswordsearch/js/angular.min.js?ver=4.2.3′></script&gt;

…and what should it be? Do you use subdomains or paths?

My apologies, the paths are correct. I should have dug a little more.

The browser is barking about these 2 missing references, but are not directly referenced on the page. Could they be referenced from within Angular?

plugins/crosswordsearch/js/angular-route.min.js.map
plugins/crosswordsearch/js/angular.min.js.map

I see that

angular-route.min.js
angular.min.js

are there, just not the .map