Salesforce REST API example


Salesforce REST API call into platform requires OAuth 2.0 authentication. OAuth is an industry-standard authentication mechanism using "tokens" instead of a typical "username" and "password" credentials. OAuth access tokens provide permission to make Salesforce API calls, and do not grant permission to login to Salesforce Web UI.

1. Navigate to Connected App on Salesforce UI.
Setup -> Build -> Create -> Apps -> New Connected Apps.

Salesforce: Retrieve related list with SOQL and Apex


You are working with a Salesforce custom object, and you need to iterate through the related list. How do you retrieve the listed list with SOQL, and iterate through them with Apex? For the illustration purpose, I'm going to use Financial Force object, SCMC__Sales_Order__c. The SCMC__Sales_Order__c has a child relationship, SCMC__Purchase_Orders__r, as shown in the ( IDE) screenshot below.

Redhat / Centos LAMP Setup Guide


If you're setting up a RedHat or Centos server from a VPS server without a control panel, setting up a LAMP (Linux, Apache, MySQL and PHP) can be a nuisance. Here is a basic setup guide for bringing your Linux server for LAMP development environment.

Salesforce Visualforce Overview


Visualforce is a technology used in for building custom user interfaces. It is analogous to Java Server Pages (JSP) with Java Server Faces (JSF) in Java technology. Visualforce uses Apex classes (controllers) containing business logic, and visualforce pages and visualforce components containing the presentation.

Salesforce Apex Developer's Guide


This guide is written per SFv31, so if you're working in a future version -- you may have a slightly different menu structure. If you are new to Salesforce, you may want to create an account at This will allow you to create a developer ORG, which you may use to develop SF applications.

[SOLVED] MySQL Error 1016: Can't open file: 'user_tracking.MYD'. (errno: 145)


We've been running osCommerce website flawlessly for over two years, but recently encountered the following MySQL error.

1016: Can't open file: 'user_tracking.MYD'. (errno: 145)

We're running mysql 3.23.58 version, and recently restarted the mysqld by killing the mysql processes. This may have corrupted the table file named above.

You may use phpMyAdmin to "repair" the corrupted table. Or, use the command line from the mysql client.

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


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

[SOLVED] Zen Cart incorrect time zone


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.

[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.


Subscribe to Web Traffic Exchange RSS