maximnj

https://www.myoperaworld.com/workspace/

The shortcode on this page is
[crosswordsearch mode=”build” project=”INSIDETHEOPERA”]

I do copy-paste to avoid misspelling of the upper/lower cases.
Let see, maybe I do something wrong on the page creating the crossword?
1. make the private page and ad the shortcode with edited name of the project.
2. Publish this page and view it in browser.
I see the fields with triple arrows for dropdown menues and empty crossword.
3. I add my words to the crossword field, mark them by sliding cursor and the words appear below the crossword. The marks sometime kame the words invisible under the color overlay, sometime there is only the rounded frame.
4. I fill the rest of the fields in the crossword using the left button under the crossword and go up to save it.
5. I enter the name of crossword and press button SAVE. in a few seconds I always see “you have no permission”.
Maybe sowhere in between these manipulations I do a mistake?
I can make step-by-step screenshots for this process too.

I have played today with the roles, did open a new account for myself and get the role editor. As an editor I cannot see “options” and “assign” tabs, in “review” tab nothing have
been changed and I have the same message “you do not have permission” when I try to save the crossword.

Dear CCPROG!

I have made the private page with screenshots of tabs and comments. Could you check it?

https://www.myoperaworld.com/?page_id=1458

It is in the wp_editors in “browse” tab… There is the name of the project as I named it, and User ID 1.
I can see my project in wp_projects “browse”tab as well, but I made the levels (default and maximum) 4/4, and in the table I see default and maximum are 3, used level – 0.

My role on the site is Administrator and I do not have any specific plugin to work with the roles, only standard in user settings. I can change the role of administrator to editor or add an account and set it as editor. But I do not see any sense in it because In “options” of crosswordsearch I gave full rights to administrator, editor and author. As I see it, my role of the administrator should work, and I do not understand why I set default and max. levels to 4, and see on MyPHPAdmin levels 3 and 3…

As far as I got it, your plugin has nothing to do with posts, feedbacks and comments, isn’t it? Because on my site these functions are disabled. Only me, as adiministrator, can add, edit and modify all information, texts, etc. on my site.

I hope very much we will find the solution!

I did check my WP. My role is Administrator. Croswordsearch doesn’t show in fields on Assign my user name (whichi is my email address), but only nickname which I see when logged into my administrative account. My nickname is not Administrator…

I am the only administrator and I see the only my name on assign page.. I add the name to the project and set the level, then click SAVE. Atfer that I move my name I’m logged with, from right to the left box with “full rights” above. SAVE. As I see in my case both buttons SAVE on Assign page do not work. I set level 4/4 and save, but in the MyPHPAdmin I see 3/3. I see the name of project and see the user ID 1. But do not see my name. There is also no one line shows the project with its name as I did in wp_projects. Is it possible to make all these manipulations manually directly in MyPHPAdmin tables without damaging the plugin itself? For example to write all I need to work with the first crossword in a proper fields?

I am travelling now and will check WP settings upon arriving.

Thank you for great help!

Ok. Finally I got it not in the wp-crossword/editor/projects tables but in wp table. The type of crossword/editor/projects is InnoDB.

About second line sorry, hope now I have the correct line –
on crossword relation view: ON UPDATE >CASCADE; ON DELETE>RESTRICT.
on editors *-* : both CASCADE
on projects *-*: nothing at all ( no second line exists )

in Home>Variables:
The field ‘enforce_storage_engine’ is empty and unclickable ((((

The field ‘storage_engine’ shows next – MyISAM and information under sign ‘?’

System Variable Name storage_engine
Variable Scope Global, Session
Dynamic Variable Yes

Permitted Values (<= 5.5.4) Type enumeration
Default MyISAM

Permitted Values (>= 5.5.5) Type enumeration
Default InnoDB

Sorry for the long interruption, now I am in.
1. Database –
Server: Localhost via UNIX socket
Software: Percona Server
Software version: 5.5.40-36.1-log – Percona Server (GPL), Release 36.1, Revision 707
Protocol version: 10
User: g*****@localhost
Server charset: UTF-8 Unicode (utf8)

2.WEB –
cpsrvd 11.42.0.23
Database client version: libmysql – 5.0.96
PHP extension: mysqli Documentation

3. In “wp_crw_crosswords”, “wp_crw_editors” and “wp_crw_projects” the type is varchar(255)

4. In the relation view on editors I see the project line with ‘<database name>’.’wp_crw_projects’.’project’ in it, the second line is empty.

5. in the same view of project I do not see the project name and other options (default_level, maximum_level and used_level answered “no index defined!”

6. And this is the copy of the Engines tab-

Storage Engine Description
CSV CSV storage engine
MRG_MYISAM Collection of identical MyISAM tables
MyISAM MyISAM storage engine
BLACKHOLE /dev/null storage engine (anything you write to it disappears)
InnoDB Percona-XtraDB, Supports transactions, row-level locking, and foreign keys
partition Partition Storage Engine Helper
FEDERATED Federated MySQL storage engine
ARCHIVE Archive storage engine
MEMORY Hash based, stored in memory, useful for temporary tables
PERFORMANCE_SCHEMA Performance Schema

Thank you very much! I still waiting reply from my hosting support to restore access to MySQL databases and MyPHPAdmin. It looks strange, but my old passwords do not match to the accounts and reset option doesn’t work. Will be back with results.

Yes, there is the only one NO – I do not see the project only on Review tab where it should appear after saving in Assign tab. Other places show the information correctly.
I have phpMyAdmin tools on my hosting and I can access it from my cPanel easy. What exactly have I search for?

I think that problem is somewhere in the settings pages… After I save the Options and Projects/full rights no one project appears at the Review Riddles in Projects tab. And they have to be there even if they are empty. So, it looks like saving doesn’t work already on Assign Projects and rights tab.

I am so sorry…
– I am logged in to work on the site as Administrator. This is the only way to build the site in online mode.
– I request the saving from the same page I build the crossword.
– I have enabled Full Rights for Administrator, Editor and Author ( I am Administrator and logged in)
– I am registered full rights editor…

I can copy the site to my virtual MAMP server or I can put the site on Maintenance Mode for debugging, but I am not an IT person, sorry. Hope my XCode6 has these debugging tools, but I never use them.

Oh, I’ll try.
So, after installing and activating the plugin, being logged into my administration account, I do the next step-by-step:
1. on the Settings>CrosswordSearch Administration>Options – I take full rights for Administrator, Editor, Author and save it. All contributors/subscribers are set to none.
2. on Assign projects and editors I create a new project, give the name and level and save it. Then ad the editors with full rights – from right box move my name (it’s already there to the left box and save it.
3. Create a new page which is not assigned to any menu of my site and nobody but only me can see it. In the visual mode I ad the shortcode [crosswordsearch mode=”build” project=”Name of the project” name=””] , publish it and go to the page in browser.
4. In the first dropbox (is it OK if I see the dancing arrows instead one pointed down?) I take “New” but still see “Riddle”
5. in the text box below input the words separated with comma.
6. Set the difficulty level 4.
7. Place the words into the field and mark them. I can see the words appear lower the game field and can choose the color or send it the the trash.
8. After it I fill the empty squares using the left button at the bottom. So, it’s done and need to be saved.
9. I go up to the first drop-box and take “save” or “save as” it doesn’t matter in my case.
10. Add the riddle’s name in the first space and author name (or leave it empty – equal result).
11. The System do not ask me to log-in because I am already working in my account. But after I click “Save” I see every time the same “You do not have permission.
I did try different shortcodes to build the puzzle and each time the same result.
What do I miss in this sequence?
Thank you very much for your help and sorry for the trouble.

{{globalError.error}}

{{msg}}

this I see on the Assign porjects and editors for 1-2 seconds. Then the page is fully loaded and looks pretty correct. But I am not sure everything is OK.

And once again about private page to build the puzzle.

before it’s fully loaded it looks like that –

{{loadError.error}}

{{msg}}

{{crosswordData.name}}
Describe which words should be found:

Dont’t try to be clever!

Select a difficulty level:
Word directions: only to the right and down, any, including the diagonals and backwards,
List of words that should be found: visible before found hidden before found
Fill in the the letters and mark the words:

{{field.letter}}
{{word.fields | joinWord}} (from line {{word.start.y + 1}}, column {{word.start.x + 1}} {{localize(word.direction)}})

Does anyone else see this during the load process?