Remove exim queue mail in console
After stopped the spam, I need to clear the spam queue in exim [code lang=”shell”] exim -bp | awk ‘/^ *[0-9]+[mhd]/{print "exim -Mrm " $3}’ | bash [/code]
2015
Optimize MySQL order by RAND()
It is not recommended to use ORDER BY RAND() only, it will slow for query large database like over 50,000 rows. The easiest way to optimize existing code, just add RAND()< (SELECT ((1/COUNT(*))*10) FROM Table_name) after the WHERE before the ORDER, this sub query will speed up the select random from the table. Using this …
ERROR: IITC failed to extract the required parameters from the intel site
I’ve got the error by using IITC for Ingress today IITC failed to extract the required parameters from the intel site This can happen after Niantic update the standard intel site. A fix will be needed from the IITC developers. [code lang=”javascript”] – var reVersion = new RegExp(‘[a-z]=[a-z].getData\\(\\);[a-z].v="([a-f0-9]{40})";’); + var reVersion = new RegExp(‘[a-z].v="([a-f0-9]{40})";’); – …
ERROR: IITC failed to extract the required parameters from the intel site Read More »
How to rename rename *.png.png to *.png in Mac OS terminal
I always use this way to rename *.png.png to *.png [code lang=”shell”] find ./ -name ‘*.png.png’ -type f \ -exec sh -c ‘mv {} ./$(basename -s .png.png {}).png’ \; [/code]
exit code of #128 fatal: unable to connect to github.com
I follow the Quickstart guide from FoundationPress and it display this error [code lang=”bash”] bower install && grunt build bower foundation#* not-cached git://github.com/zurb/bower-foundation.git#* bower foundation#* resolve git://github.com/zurb/bower-foundation.git#* bower fontawesome#~4.3.0 not-cached git://github.com/FortAwesome/Font-Awesome.git#~4.3.0 bower fontawesome#~4.3.0 resolve git://github.com/FortAwesome/Font-Awesome.git#~4.3.0 bower fontawesome#~4.3.0 ECMDERR Failed to execute “git ls-remote –tags –heads git://github.com/FortAwesome/Font-Awesome.git”, exit code of #128 fatal: unable to connect to …
exit code of #128 fatal: unable to connect to github.com Read More »
libpng error: IDAT: CRC error
I receive this error message while using wkhtmltoimage. In Mac, it it not allow you to use Preview to save to other format. It will display cannot write, or enable to save. The fastest way to solve this problem, can be done in Automator, you can use Photo -> Flip Image -> Flip Image then …
Data from SoftBank Ultra Link in Ingress
I’ve pull out the date from the game Ingress, the Mod SoftBank Ultra Link. So confirm that it added 8 out going links, and increate the range multiplier, and do not have stickiness, and increase the link defense boost. If you do not have any link, then the defense boost does not apply. Very Rare …
Data from MUFG Capsule in Ingress
I farm out the MUFG Capsule I’ve trace out the data from the game Ingress by Google, maybe can find out some reference data from here. I’ve put Jarvis, ADA, Very Rare Heat Sink, Very Rare Multi-Hack into the MUFG Capsule. [code lang=”js”] { "result": [ ["72e55d5658db455db78093b6f0682c67.5", 1434910286425, { "moniker": { "differentiator": "D6F55A77" }, "resource": …