[SOLVED] ERROR 1206 (HY000): The total number of locks exceeds the lock table size


We have a customized Openbravo POS v2.2 running with a dozen workstations operating 24x7 a year around. The size of the database has grown to 10GB, and the performance started to degrade so we decided to archive old data and start fresh. According to Openbravo POS administrative guide, we performed a DELETE operation on transaction data.

[SOLVED] MySQL Crash with Fatal error: cannot allocate memory for the buffer pool


We have a dozen websites mostly running Wordpress, and one Drupal website on Digital Ocean with a 1GB instance. The server was running flawlessly for 6 months, and then the MySQL starts to crash every few days unexpectly with the following error in the mysql error log.

How to install UTM tracking code? (Uses ga.js)


The UTM (Urchin Traffic Monitor) tracking code is used to track traffic source, medium and campaign; and allows a businesses to track conversion funnel from referral site. With an introduction of Google Tag Manager, some folks are unclear how to implement UTM tracking codes into their HTML pages. The following two simple steps will guide you through installing the UTM javascript snippets into your web pages.

1. Add the classic Google Analytics library, ga.js from Google CDN.

How to fix blank screen or White Screen of Death?


One of the common symptom being seen during PHP development is White Screen of Death, a blank screen instead of expected page. If you "View Source" on white page, it will often contains no title, no header or body and there are no errors - a simple blank page.

Microsoft Office is FREE on smartphones


Microsoft CEO, Satya Nadella made Microsoft Office Mobile available free on iPhones and Android Phones on 3/27/2014. You may create, view and edit Microsoft Office documents on smartphone devices running iOS (iOS 7 or later) and Android operating systems completely free. At the same time, Microsoft also made a full version of Office Suite (Word, Excel and Power Point) available on iPads with Office 365 Service, a subscription service required to create and edit MS Office documents. You may view MS Office documents on iPads, but cannot edit them without a paid Office 365 service.

Can a tablet replace a computer?


I have been thinking about replacing my notebook with a tablet for some time, and finally decided to give it a try. Before I chose a tablet to replace my notebook, I thought about the things I do with my computer. I browse web, send and receive emails, manage my websites, watch movies and YouTube videos, and work on the Office Suite. I also spend a lot of time on Linux servers and remote Windows machines so an ability to connect via VNC and RDP is a must feature. All those things I've identified can be done on a tablet, so it may actually work.

IE9 certificate error blocks navigation and can't continue


As a developer, we often require proceeding with IE browser despite with the certificate error. Microsoft decided to block this completely "trying" to fool-proof phishing and other hacking attempts. But, this is a nuisance to developers. This is how you allow it.

1) Run cmd as administrator

2) Execute the following command as an administrator:

certutil -setreg chain\EnableWeakSignatureFlags 8

3) Restart the computer

PC Charge Payment Server Client Installation


Ok, you already have at least 1 PC Charge (Server + Client) installed and trying to add additional licenses to your setup. To begin accepting credit card with the PC Charge, you'll need a PC Charge server.

[SOLVED] JumpLoader Bad Server Response error


We have been using a code-signed JumpLoader with PHP upload handler for several years without any issues. For those users with Java 7 update 21 and above, JumpLoader is now throwing Security Exception, Missing required Permissions manifest attribute in main jar: due to additional security mechanism built into Java.

Stock Investments


If you have extra cash on hand, one of the easiest way to generate passive income is investing your money. There are many investment options to choose from, but one of the preferred option is investing in stocks. Depending on your risk tolerance level, you may invest in low-risk dividend paying stocks, value stocks or even invest in high-growth high-risk stocks. Inflation averaged over 3.05% yearly since 1926, and keeping your money in Bank savings account would have earned you less than the inflation.


Subscribe to Web Traffic Exchange RSS