Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

ideal not working
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.

TOPIC: ideal not working

ideal not working 10 years, 7 months ago #42946

There is an problem with the iDeal payment.

This database is not there? i get this problem.....


ERROR: Table 'waarbeek_memedia.jos_transactions' doesn't exist

FILE: /home/waarbeek/domains/waarbeek.nl/public_html/plugins/eticketspayment/ideal/framework/gateways/gateway.core.cls.5.php

LINE: 230
The topic has been locked.

Re: ideal not working 10 years, 7 months ago #42997

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
Hello, please, create the table via PHPMyAdmin with this command:
 
CREATE TABLE IF NOT EXISTS `jos_transactions` (
`id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` VARCHAR(64) DEFAULT NULL,
`order_code` VARCHAR(64) DEFAULT NULL,
`order_params` TEXT DEFAULT NULL,
`store_code` VARCHAR(64) DEFAULT NULL,
`gateway_code` VARCHAR(64) DEFAULT NULL,
`language_code` VARCHAR(2) DEFAULT NULL,
`country_code` VARCHAR(2) DEFAULT NULL,
`currency_code` VARCHAR(3) DEFAULT NULL,
`transaction_id` VARCHAR(64) DEFAULT NULL,
`transaction_code` VARCHAR(64) DEFAULT NULL,
`transaction_params` TEXT DEFAULT NULL,
`transaction_date` INT(11) UNSIGNED DEFAULT NULL,
`transaction_amount` DECIMAL(10, 2) UNSIGNED DEFAULT NULL,
`transaction_description` VARCHAR(100) DEFAULT NULL,
`transaction_status` VARCHAR(16) DEFAULT NULL,
`transaction_url` VARCHAR(255) DEFAULT NULL,
`transaction_payment_url` VARCHAR(255) DEFAULT NULL,
`transaction_success_url` VARCHAR(255) DEFAULT NULL,
`transaction_pending_url` VARCHAR(255) DEFAULT NULL,
`transaction_failure_url` VARCHAR(255) DEFAULT NULL,
`transaction_log` TEXT DEFAULT NULL,
PRIMARY KEY (`id`));
 
ARTIO Support Team
Last Edit: 10 years, 7 months ago by jitr.
The topic has been locked.

Re: ideal not working 10 years, 7 months ago #43013

Seems not be right.

ERROR: Unknown column 'user_id' in 'field list'

FILE: /home/waarbeek/domains/waarbeek.nl/public_html/plugins/eticketspayment/ideal/framework/gateways/gateway.core.cls.5.php

LINE: 230
The topic has been locked.

Re: ideal not working 10 years, 7 months ago #43062

Hi there,

Programmer from MEMedia here. I looked at the error-report and the database structure, both the one you provided in your previous response and the tables already present in our database. I of course do not know exactly what is going wrong here since it seems to be a database-design problem, but I think there are different version of this plugin around and you are mixing them up.

The command that returns with an error is trying to update jos_transactions but most of the fieldnames it specifies are fields that jos_etickets_order has, not jos_transactions. The last few fields in the sql UPDATE-statement are however fields that the (new) jos_transactions holds and that jos_etickets_order doesn't have. So these two tables seem some how mixed up or the database UPDATE-query is mixed up. Either way, something seems really wrong here and it looks to me like different versions are getting mixed up here.
The topic has been locked.

Re: ideal not working 10 years, 7 months ago #43071

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
Hello, please try again with this
 
CREATE TABLE IF NOT EXISTS `#__transactions` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`order_id` varchar(64) DEFAULT NULL,
`order_code` varchar(64) DEFAULT NULL,
`order_params` text,
`store_code` varchar(64) DEFAULT NULL,
`gateway_code` varchar(64) DEFAULT NULL,
`language_code` varchar(2) DEFAULT NULL,
`country_code` varchar(2) DEFAULT NULL,
`currency_code` varchar(3) DEFAULT NULL,
`transaction_id` varchar(64) DEFAULT NULL,
`transaction_code` varchar(64) DEFAULT NULL,
`transaction_params` text,
`transaction_date` int(11) unsigned DEFAULT NULL,
`transaction_amount` decimal(10,2) unsigned DEFAULT NULL,
`transaction_description` varchar(100) DEFAULT NULL,
`transaction_status` varchar(16) DEFAULT NULL,
`transaction_url` varchar(255) DEFAULT NULL,
`transaction_payment_url` varchar(255) DEFAULT NULL,
`transaction_success_url` varchar(255) DEFAULT NULL,
`transaction_pending_url` varchar(255) DEFAULT NULL,
`transaction_failure_url` varchar(255) DEFAULT NULL,
`transaction_log` text,
`user_id` int(11) DEFAULT NULL,
`adr_i_degree` varchar(255) DEFAULT NULL,
`adr_i_name` varchar(255) DEFAULT NULL,
`adr_i_surname` varchar(255) DEFAULT NULL,
`adr_i_email` varchar(255) DEFAULT NULL,
`adr_i_street` varchar(255) DEFAULT NULL,
`adr_i_zip` varchar(255) DEFAULT NULL,
`adr_i_city` varchar(255) DEFAULT NULL,
`adr_i_country` int(11) DEFAULT NULL,
`adr_i_phone` varchar(50) DEFAULT NULL,
`adr_i_fax` varchar(50) DEFAULT NULL,
`adr_i_company` varchar(255) DEFAULT NULL,
`adr_i_vat_number` varchar(255) DEFAULT NULL,
`adr_d_degree` varchar(255) DEFAULT NULL,
`adr_d_name` varchar(255) DEFAULT NULL,
`adr_d_surname` varchar(255) DEFAULT NULL,
`adr_d_email` varchar(255) DEFAULT NULL,
`adr_d_street` varchar(255) DEFAULT NULL,
`adr_d_zip` varchar(255) DEFAULT NULL,
`adr_d_city` varchar(255) DEFAULT NULL,
`adr_d_country` int(11) DEFAULT NULL,
`adr_d_phone` varchar(50) DEFAULT NULL,
`adr_d_fax` varchar(50) DEFAULT NULL,
`shipping_method` int(11) DEFAULT NULL,
`shipping_method_name` varchar(255) DEFAULT NULL,
`shipping_method_price` float DEFAULT NULL,
`shipping_method_vat_rate` float DEFAULT NULL,
`payment_method` int(11) DEFAULT NULL,
`payment_method_name` varchar(255) DEFAULT NULL,
`payment_method_price` float DEFAULT NULL,
`payment_method_vat_rate` float DEFAULT NULL,
`note` varchar(255) DEFAULT NULL,
`ctime` int(11) DEFAULT NULL,
`mtime` int(11) DEFAULT NULL,
`order_status` tinyint(1) DEFAULT NULL,
`payment_status` tinyint(1) DEFAULT NULL,
`payed_amount` float DEFAULT NULL,
`voucher_code` varchar(255) DEFAULT NULL,
`user_language` varchar(5) DEFAULT NULL,
`items` varchar(255) DEFAULT NULL,
`country_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
ARTIO Support Team
Last Edit: 10 years, 7 months ago by jitr.
The topic has been locked.

Re: ideal not working 10 years, 7 months ago #43112

This problem is solved, buth after the bankchoice the transaction is not going on. You can try ideal at www.waarbeek.nl/events
The topic has been locked.
Moderators: pedu
User Login Empty