Forums / General Questions / Quickpay and Super ordre

Quickpay and Super ordre

Locked

Views: 812

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
11 Sep 2007, 4:39 PM
#1
silo avatar

silo

New Zenner

Join Date:
May 2006
Posts:
11
Plugin Contributions:
0

Quickpay and Super ordre

I cant get quickpay and super odre to work together..

In Quickpay zip file i downloaded. Are there not any sql i can set into my database.

Im getting this fail..

1146 Table 'web5884.shop_quickpay_transactions' doesn't exist
in:
[select count(*) as total FROM ((shop_quickpay_transactions qt LEFT JOIN shop_quickpay_transactions_history qth ON (qt.transaction_id = qth.transaction_id)) LEFT JOIN . shop_quickpay_transactions_history qth2 ON ((qth.transaction_id = qth2.transaction_id) AND (qth.datetimestamp < qth2.datetimestamp))) WHERE (qth2.transaction_id IS NULL) AND NOT (qth.transaction_status IN ('3', '5', '7'))]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

13 Sep 2007, 7:26 AM
#2
silo avatar

silo

New Zenner

Join Date:
May 2006
Posts:
11
Plugin Contributions:
0

Re: Quickpay and Super ordre

I found a solution
I did following to get quickpay to work:

i added these in my database


DROP TABLE IF EXISTS quickpay_transactions;
CREATE TABLE IF NOT EXISTS quickpay_transactions (
qt_entry_id int(15) NOT NULL auto_increment,
transaction_id varchar(64) collate latin1_danish_ci default NULL,
order_id int(11) default NULL,
customer_id int(11) default NULL,
currency char(3) collate latin1_danish_ci default NULL,
code text collate latin1_danish_ci,
PRIMARY KEY (qt_entry_id),
UNIQUE KEY transaction_id (transaction_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=280 ;


DROP TABLE IF EXISTS quickpay_transactions_history;
CREATE TABLE IF NOT EXISTS quickpay_transactions_history (
qth_entry_id int(15) NOT NULL auto_increment,
transaction_id varchar(64) collate latin1_danish_ci default 'NULL',
amount decimal(15,4) default NULL,
transaction_status tinyint(2) default '0',
datetimestamp datetime default NULL,
qpstatmsg text collate latin1_danish_ci,
PRIMARY KEY (qth_entry_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=598 ;

But now i have this problem in my admin panel.

Its the super order
Admin->Customer->Super order.
Then i get this fail :
Fatal error: Call to undefined function so_close_status() in \admin\super_orders.php on line 1172

i looked in that line in the file:
$close_status = so_close_status($orders->fields['orders_id']);

Couldt it be quickpay disturbing it?