[SOLVED] mysqldump: Can't get CREATE TABLE for table

Jul
02

Have you tried to make a backup of a MySQL database, and run into a problem with errors?

Posted By admin read more

[SOLVED] Zen Cart incorrect time zone

Jun
24

Our Zen Cart installation has incorrect time zone. On the orders page, the orders are placed +5 hours from current date/time. This is very annoying problem as the server is showing correct time, and PHP is configured with correct time zone in /etc/php.ini file. Also, the correct time zone is set in the includes/application_top.php file.

Posted By admin read more

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

May
23

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.

Posted By admin read more

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

May
23

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.

Posted By admin read more

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

Apr
23

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.

Posted By admin read more

How to fix blank screen or White Screen of Death?

Apr
17

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.

Posted By admin read more

Microsoft Office is FREE on smartphones

Apr
07

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.

Posted By admin read more

Can a tablet replace a computer?

Mar
19

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.

Posted By admin read more

IE9 certificate error blocks navigation and can't continue

Mar
05

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

Posted By admin read more

PC Charge Payment Server Client Installation

Mar
03

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.

Posted By admin read more

Pages

Subscribe to Web Traffic Exchange RSS