Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    11
    Plugin Contributions
    0

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

  2. #2
    Join Date
    May 2006
    Posts
    11
    Plugin Contributions
    0

    Idea or Suggestion 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?

 

 

Similar Threads

  1. Super Orders and Reward Points?
    By DigitalShadow in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 3 Jan 2012, 11:08 PM
  2. Super and Sub Customer Module?
    By hungoveragain in forum Addon Payment Modules
    Replies: 0
    Last Post: 28 Sep 2010, 03:12 PM
  3. Super orders VAT and Footers?
    By MikeyG in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 31 Jul 2010, 07:26 PM
  4. Quickpay Payment Module (Denmark)
    By magicpants in forum Addon Payment Modules
    Replies: 4
    Last Post: 6 Jan 2009, 02:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg