ideal not working

Welcome, Guest

TOPIC: ideal not working

ideal not working 10 years, 9 months ago #42946

waarbeek OFFLINE Posts: 7	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, 9 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, 9 months ago by jitr.

The topic has been locked.

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

waarbeek OFFLINE Posts: 7	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, 8 months ago #43062

waarbeek
OFFLINE
Posts: 7

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, 8 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, 8 months ago by jitr.

The topic has been locked.

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

waarbeek OFFLINE Posts: 7	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.

Page:
1
2
3

ARTIO Forums

Support

TOPIC: ideal not working