Pesapal.com
  • Noton
  • PCI/DSS Compliant
Home / Forum

Forum

Welcome, Guest
Username
Password:
 
Forgot your password? Forgot your username? Create an account
Forum
Main Forum
Pesapal Integration

Magento Integration
(1 viewing) (1) Guest
Welcome to the Pesapal integration forum!

This forum discusses everything about Pesapal integration on your web site. Having any problems? This is the right place to post a question and we are sure you will get an answer
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Magento Integration

Magento Integration 11 years, 3 months ago #960

  • jmusyoka
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
I have integrated my website (which uses magento) with pesapal using the plugin. All looks ok until payment where the payment goes through but I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pesapal_transaction_tracking_id' in 'field list'

Trace:
php 5.1.12
Apache 2.4.4
MAgento 1.7.0.0

#5 C:\wamp\www\magento\app\code\local\Pesapal\Pesapalexpress\controllers\PaymentController.php(33): Varien_Db_Adapter_Pdo_Mysql->query('UPDATE sales_fl...')

I am on:
Windows 8.

Kindly assist. Will appreciate
Reply Quote

Re: Magento Integration 11 years, 3 months ago #962

  • jmusyoka
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
I managed to sort out my own problems.

Just manually add field with name pesapal_transaction_tracking_id to table sales_flat_order i.e

ADD COLUMN pesapal_transaction_tracking_id VARCHAR(50) NULL
Reply Quote

Re: Magento Integration 10 years, 2 months ago #1465

This will help you:

ALTER TABLE  `sales_flat_order` ADD  `pesapal_transaction_tracking_id` VARCHAR( 100 ) NOT NULL AFTER  `shipping_address_id` ;
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
Forum
Main Forum
Pesapal Integration