Skip to main content
28
results
Andrew Fletcher
The user parameters provides details about a specific user based on the following parameters: User uid; The output of this query will return user profile data only of the fields containing data.  An example of the data returned includes, but is not limited to the following: Name {name} - in the system this is their username; Created {created} Firstname {field_firstname} Lastname {field_lastname} Gender {field_gender} Calling a query To call a user query the details are...
Andrew Fletcher
On your local OSX environment using Terminal or iTerm you can create a MySQL...
Andrew Fletcher
This article assumes that you are running Docker and Lando already.  Don't...
Andrew Fletcher
Running Docker and attempting to install a web proxy environment where I'm...
Andrew Fletcher
You would have come across a URL string that appears...
Andrew Fletcher
Working on an Azure server I ran a mysqldump command to generate a copy of the db.  No issues, the file downloaded on to the serve without cause.   The Problem On my local environment, using Sequel Ace I imported the file, but it suddenly it stopped with a red message “Unknown collation: ‘utf8mb4_0900_ai_ci‘” [ERROR in query 14] Unknown collation: 'utf8mb4_0900_ai_ci'“Collation is the assembly of written information into a standard order. Many systems of collation are based on...
Andrew Fletcher
When attempting to backup mysql using the mysqldump command mysqldump -u root...
Andrew Fletcher
How to Create New MySQL User Before you can create a new MySQL user, you need to...
Andrew Fletcher
The generally accepted answer to a mysqldump is: mysqldump -h [host] -u...
Andrew Fletcher
To add ejabberd and run MYSQL to the server I needed to update the server...
Andrew Fletcher
I had an instance where I needed to move content from a plist to the server database.  To achieve this step, I added a few lines of code where the plist was called and added a call to the API so the data would be on the server. The original code appeared as: class ContactsSource { static var contacts: [Contact] { let data = try! PlistLoader.array(fromFile: "ContactsDB", ofType: "plist") return data.compactMap { Contact(dictionary: $0) } } }I needed to access...
Andrew Fletcher
The starting point is to read through and follow the notes outlined on the...
Andrew Fletcher
A list of languages for the iOS app in speech mode: Arabic (Saudi Arabia) -...