Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

after iDEAL intallation - missing payment methods


gewoon09

Recommended Posts

hi,

 

I tried to install iDEAL (ideal-for-oscommerce-2-2).

The problem I encountered is that after installing iDEAL, it is the only available payment method at checkout_payment.php

 

I selected 3 modules in admin: moneyorder, paylater, iDEAL.

The sortorders are set as 1, 2, and 3.

Moneyorder and paylater used to work just fine, before installing iDEAL.

I can't figure out why they don't show up anymore.

 

Can anyone please help me?

 

Perhaps it has anything to do with ideal_install.php, which is as following:

 

<?php

// Load database settings
require_once(dirname(__FILE__) . '/ideal/include.php');

$aQueries = array();

// Add #_transactions table
$aQueries[] = "CREATE TABLE IF NOT EXISTS `" . DATABASE_PREFIX . "transactions` (`id` int(11) unsigned NOT NULL auto_increment, `order_id` varchar(100) default NULL, `order_code` varchar(100) default NULL, `transaction_id` varchar(100) default NULL, `transaction_code` varchar(100) default NULL, `transaction_method` varchar(100) 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_params` text, `transaction_log` text, PRIMARY KEY (`id`));";

// Add default labels for iDEAL status
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('100', '1', 'Payment success (verified)')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('101', '1', 'Payment success')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('102', '1', 'Payment pending')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('103', '1', 'Payment open')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('104', '1', 'Payment canceled')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('105', '1', 'Payment failure')";
$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('106', '1', 'Payment expired')";

// Add dutch labels for iDEAL status
$sql = "SELECT `languages_id` AS `id` FROM `" . DATABASE_PREFIX . "languages` WHERE `code` = 'nl' LIMIT 1;";
$oRecordset = mysql_query($sql) or die('QUERY: ' . $sql . ', ERROR: ' . mysql_error());

if(mysql_num_rows($oRecordset))
{
	$oRecord = mysql_fetch_assoc($oRecordset);

	if(strcmp($oRecord['id'], '1') !== 0)
	{
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('100', '" . $oRecord['id'] . "', 'Betaling ontvangen (gecheckt)')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('101', '" . $oRecord['id'] . "', 'Betaling ontvangen')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('102', '" . $oRecord['id'] . "', 'Betaling in behandeling')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('103', '" . $oRecord['id'] . "', 'Betaling open')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('104', '" . $oRecord['id'] . "', 'Betaling geannuleerd')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('105', '" . $oRecord['id'] . "', 'Betaling mislukte')";
		$aQueries[] = "INSERT INTO `" . DATABASE_PREFIX . "orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES ('106', '" . $oRecord['id'] . "', 'Betaling verlopen')";
	}
}



$query_html = '';

for($i = 0; $i < sizeof($aQueries); $i++)
{
	if(mysql_query($aQueries[$i]))
	{
		// Query success
	}
	else
	{
		$query_html .= '<b>Query:</b> ' . $aQueries[$i] . '<br><b>Error:</b> ' . mysql_error() . '<br><br><br>';
	}
}


// Validate files & directories
$sBasePath = dirname(__FILE__) . '/';

$aPaths = array();

// Gateway files
$aPaths[] = array('path' => $sBasePath . 'ideal', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/certificates', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/gateways', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/gateways/gateway.core.cls.4.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/gateways/gateway.core.cls.5.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/images', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/images/ideal.gif', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/temp', 'write' => true);
$aPaths[] = array('path' => $sBasePath . 'ideal/.htaccess', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/config.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/include.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/index.html', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/report.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/return.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/setup.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/transaction.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'ideal/validate.php', 'write' => false);


// Application files
$aPaths[] = array('path' => $sBasePath . 'includes/languages/dutch/modules/payment/ideal.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'includes/languages/english/modules/payment/ideal.php', 'write' => false);
$aPaths[] = array('path' => $sBasePath . 'includes/modules/payment/ideal.php', 'write' => false);




$files_html = '';

for($i = 0; $i < sizeof($aPaths); $i++)
{
	if(is_file($aPaths[$i]['path']))
	{
		if($aPaths[$i]['write'] && !is_writable($aPaths[$i]['path']))
		{
			$files_html .= 'File <b>' . $aPaths[$i]['path'] . '</b> not writable.<br>';
		}
	}
	elseif(is_dir($aPaths[$i]['path']))
	{
		if($aPaths[$i]['write'] && !is_writable($aPaths[$i]['path']))
		{
			$files_html .= 'Directory <b>' . $aPaths[$i]['path'] . '</b> not writable.<br>';
		}
	}
	else
	{
		$files_html .= 'File <b>' . $aPaths[$i]['path'] . '</b> does not exist.<br>';
	}
}


echo '
<h1>IDEAL INSTALL LOG</h1>
<p style="color: red;">Please remove this file after installation!</p>
<h3>Queries:</h3>
<code>' . ($query_html ? $query_html : 'No warnings found') . '</code>

<h3>Files & Folders:</h3>
<code>' . ($files_html ? $files_html : 'No warnings found') . '</code>

<h3>Configuration</h3>
<p>You can change your gateway settings in <b>/ideal/config.php</b>!</p>
';

?>

 

Thank you in advance

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...