Joomla - 1054 Unknown column 'extra_query' - Can not update

1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query

Read More

IIS7 - How do I update the alias after site creation

1. Change Web Application Name in Configuration

You can't actually do this thru the IIS Manager console, but what you can do is edit the C:\Windows\system32\inetsrv\config\applicationHost.config' file. Find the relatednode and update thepath` attribute.

2. Change Web Application Name in IIS

Show a list of application in IIS

C:\Windows\System32\inetsrv>appcmd list app
APP "Default Web Site/" (applicationPool:DefaultAppPool)

APP "Default Web Site/webapps" (applicationPool:DefaultAppPool)

Rename exiting app
C:\Windows\System32\inetsrv>appcmd set app "Default Web Site/webapps" -path:/myapps


Reference:
http://serverfault.com/questions/319556/iis7-how-do-i-update-the-alias-after-site-creation

Read More

MySQL - Import and Unknown collation: 'utf8mb4_unicode_ci

Unknown collation: 'utf8mb4_unicode_ci' and the import fails.

Solution

1) Click the "Export" tab for the database
2) Click the "Custom" radio button
3) Go the section titled "Format-specific options" and change the dropdown for "Database system or older MySQL server to maximize output compatibility with:" from NONE to MYSQL40.
4) Scroll to the bottom and click "GO".

Read More

Joomla - Sharper Xeon - Failed master.less

failed to find .... /templates/shaper_xeon/less/Master.less

Solution

Login in administrator site. Clear Cache

Read More

How to show or change your Git username or email address

Git user FAQ: How do I show or change my Git username (or email address)?

How to show your Git username

There are several ways to show your Git username. One way is with the "git config" command, like this:

git config user.name

which in my case returns:

Alvin Alexander

Another way to show your Git username is with this git config command:

git config --list

which returns this output:

user.name=Alvin Alexander
user.email=[omitted]
merge.tool=vimdiff

"committer email address" "ERROR: does not match your user account"

1. $ git log 

- to check which email address in your last commit.
For example:
commit 0ef1fea4d19145fc3257c688313da102020e3778
Author: yourusername <yourWRONGemail@address>
Date:   ....

2. if your email address is not in the list then $ git config user.email <your email>

3. $ git commit --amend --reset-author

- to reset your email

4. $git log
- to check again for sure
For example:
commit 0ef1fea4d19145fc3257c688313da102020e3778
Author: yourusername <yourRIGHTemail@address>
Date:   ....

"ERROR: missing Change-Id in commit message footer "

remote: ERROR: missing Change-Id in commit message footer
remote:
remote: Hint: To automatically insert Change-Id, install the hook:
remote: curl -Lo `git rev-parse --git-dir`/hooks/commit-msg
https://gerrit-review.googlesource.com/tools/hooks/commit-msg ; chmod +x
`git rev-parse --git-dir`/hooks/commit-msg
remote: And then amend the commit:
remote: git commit --amend

Solution

1. Install Hook
$ gitdir=$(git rev-parse --git-dir); scp -p -P 29418 YOURUSERNAME@gitsrv:hooks/commit-msg ${gitdir}/hooks/

2. Update Change-Id
$ git commit --amend


Source: http://alvinalexander.com/git/git-show-change-username-email-address

Read More