PhpMyAdmin ALTER TABLE command gets ignored when table definition is imported

I am running PhpMyAdmin v4.8.0.1. I exported a table and thus, have the following structure:

CREATE TABLE `wp_site_settings` (   `settings_id` bigint(20) UNSIGNED NOT NULL,       `usage_limit_per_user` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;  -- -- Indexes for dumped tables -- ALTER TABLE `wp_site_settings`   ADD PRIMARY KEY (`settings_id`); 

As we can see from the above code, the ALTER TABLE part is present after the CREATE TABLE. I want this ADD PRIMARY KEY to be a part of the CREATE TABLE itself, so that it can be exported as:

CREATE TABLE `wp_site_settings` (   `settings_id` bigint(20) UNSIGNED NOT NULL,       `usage_limit_per_user` varchar(255) NOT NULL,    PRIMARY KEY (`settings_id`), ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

I need it in the above way because I am trying to use the above in a custom WordPress plugin. If the ADD PRIMARY KEY is performed using the ALTER TABLE command, the whole command gets ignored and the resultant table does not contain the PRIMARY KEY.

This is just an example of one table. I need the solution to work for other 20+ custom tables as well, so any workaround/fix is appreciated.

NOTE: I am aware that the ALTER TABLE was separated intentionally as per + rfe #1004 Create indexes at the end in SQL export

user gets access denied when adding new document in folder

In my SharePoint 2013 environment I have a site where the admin user group has design rights + security management rights. A readers permission group has read access on the site. I have a document library with one folder. On the folder I break the inheritance and give the readers group contribute access.

When the user from the readers groups wants to add a new document (Ribbon –> new document –> document) he gets a pop-up with an access denied message.

Why can’t the user add a new document with contribute access?

Sharepoint Internal names of Person or group column gets changed on taking list template

I have created a person or group column in list. When I take list template and use it in other site the internal name of the person or group column gets changed. I have used the internal names of this column in my code. Now due to this mismatch of internal names the code is failing.

my Ubuntu 18.04 gets stuck on splash screen

My computer gets stuck on the splash screen unless I immediately press esc and then ctrl+alt+F2 if I don’t press the second keyboard command I will get stuck in the text mode until I press it. I have no idea how to troubleshoot this my profile seems to load if I let the splash run as I have autologin enabled and my keyboard lights up meaning it ran the corsair icue software and loaded my profile, as it only does that after login into my user

SharePoint 2013 workflow task gets canceled when sending email

I have a custom list in a SharePoint 2013 site with just one column. Then I implemented a workflow using SharePoint Designer 2013. The workflow only send an email to myself with the title of the new item. I have three groups in the website:

  • Members- Contribute
  • Owners – Full Control
  • Visitors – Read

When a user belonging to the Owners group creates a new item in that list the workflow finishes and the email is sent perfectly. When a user belonging to the Members group creates a new item, the workflow gets cancelled and the email is never sent.

I tried modifying the list permissions, giving access to Members group to Workflow Task List and Workflow History but nothing seems to work. I got this error:

RequestorId: 170d2919-dd32-0503-0057-1a030da463d7. Details: System.ApplicationException: HTTP 401 {“Transfer-Encoding”:[“chunked”],”X-SharePointHealthScore”:[“0″],”SPClientServiceRequestDuration”:[“7″],”SPRequestGuid”:[“a6c775de-ca84-441a-b978-ee53e06ed509″],”request-id”:[“a6c775de-ca84-441a-b978-ee53e06ed509″],”X-FRAME-OPTIONS”:[“SAMEORIGIN”],”MicrosoftSharePointTeamServices”:[“″],”X-Content-Type-Options”:[“nosniff”],”X-MS-InvokeApp”:[“1; RequireReadOnly”],”Cache-Control”:[“max-age=0, private”],”Date”:[“Tue, 09 Jun 2015 01:56:36 GMT”],”Server”:[“Microsoft-IIS/8.5″],”WWW-Authenticate”:[“NTLM”],”X-AspNet-Version”:[“4.0.30319″],”X-Powered-By”:[“ASP.NET”]} at Microsoft.Activities.Hosting.Runtime.Subroutine.SubroutineChild.Execute(CodeActivityContext context) at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem

Am I missing something???

Are there official mechanics for how a climbing kit gets used in play, or is it DM discretion?

Our sorcerer is not an athlete, so she bought a climbers kit to explore the steep slopes of the tundras & snow caps of the sword mountains. This entails some 30, 40, 50 feet climbs on rock and ice. I don’t think the kit should make her a master climber, anymore than owning a stove should make someone a master chef.

I made a mini game involving climbing with climbing kit gear. Such as Piton AC, “special” piton AC, Athletics bonuses to cletes and gloves, etc. It seems to be fun and challenging Terrain puzzle for the PC, but it can be tedious and bring the session to a crawl.

Is there an official way to use piton and harness gear when climbing, or are kits like that made for such mini-game tomfoolery at the DM’s discretion? With the thieves tools kit, you have to be proficient with tools to gain a bonus. I thought maybe every kit was this way. I am looking for clarity regarding using the kit proficiently, as opposed to using it generally.

Is there some theoretical verification or explanation of why KDTree gets slower when the dimensionality gets higher?

This post and this post indicate that when the dimensionality gets higher, KDTree gets slower.

Per scikit-learn doc, the KDTree becomes inefficient as D(dimensions) grows very large (say, $ D>20$ ): this is one manifestation of the so-called “curse of dimensionality”.

Is there some theoretical verification or explanation of why KDTree gets slower when the dimensionality gets higher?

External user gets ‘Access Required’ could it be down to these two factors?

I have an external user who’s trying to access a SharePoint online site but keeps getting the Access Request page.

I’ve been doing some rooting around and found that when I checked their permissions I get this:

enter image description here

There’s a lot of Deny in that list! I read in another post that I should go to Application Management in Site Collections and select Configure quotas but can’t find Application Management in Online

Also when I was in Active Sites and clicked on the site in question I saw a message on the right hand side saying ‘We couldn’t find the Office 365 group connected to this site’.

Could either or both be causing the access issue and how would I resolve?

Thanks in advance

Securing Code Secrets – What is the relevance if the host gets compromised?

I’ve been researching and testing different approaches when it comes to securing code secrets, and am unsure what the best options are, and if they even have any relevance once a host gets compromised.

Some standard approaches I’ve read about storing variables are:

  • Compiled code
  • Environment variables on machine or through Docker
  • Files
  • Encrypted/decrypted through keys to a vault API/DB

If a host gets compromised (admin access), secrets can be exposed via:

  • Decompiling code
  • Viewing env variables / files
  • Memory dumps
  • Viewing SSL traffic using private keys on host
  • Decompiling and modifying code to expose possible encryption/decryption keys and output secrets once fetched from a vault

Are there methods that will protect secrets once a host is compromised, or is it just making the ability to fetch secrets more complex, so an intruder will find it more difficult to reach them?
If a host is secured and firewalled and admin access is tightly controlled, is there really any benefit to the added complexity of storing secrets elsewhere rather than on the host itself?