Author Topic: Problem with iDEAL  (Read 5359 times)

W1SE4ALL

  • Beginner
  • *
  • Posts: 2
Problem with iDEAL
« on: May 08, 2008, 08:35:08 am »
Hi,

I have a problem with the iDEAL module for VirtueMart (iDEAL-VirtueMart v0.7).
When I need to import the file "joomla_virtuemart.sql" I get the following:


Fout
SQL-query:

INSERT INTO `jos_vm_payment_method`
VALUES (

'', 1, 'Ideal', 'ps_ideal', 5, 00.00, 0, 'ID', 'D', 0, 'Y', '', '<form name=\\"idealform\\" action=\\"<?=$mosConfig_live_site?>/index.php?option=com_virtuemart&page=checkideal.send\\" method=\\"post\\" target=\\"_self\\">\r\n<input type=\\"hidden\\" name=\\"grandtotal\\" value=\\"<?php printf(\\"%.2f\\", $db->f(\\"order_total\\"))?>\\" />\r\n<input type=\\"hidden\\" name=\\"ordernumber\\" value=\\"<?php $db->p(\\"order_id\\") ?>\\">\r\n<input type=\\"hidden\\" name=\\"issuerID\\" value=\\"<?=$_SESSION[\\''issuerID\\'']?>\\">\r\n<input type=\\"hidden\\" name=\\"ec\\" value=\\"<?php $db->p(\\"order_number\\") ?>\\">\r\n<?\r\nif (empty( $_SESSION[\\"issuerID\\"]) )\r\n{\r\nrequire_once( CLASSPATH. \\''/payment/ideal/DirReqIdeal.php\\'' );\r\n}\r\n?>\r\n<table border=\\"0\\" width=\\"100%\\" id=\\"table1\\" cellspacing=\\"0\\" cellpadding=\\"0\\">\r\n <tr>\r\n  <td width=\\"60\\"><input type=\\"image\\" name=\\"Submit\\" src=\\"<?=$mosConfig_live_site?>/administrator/components/com_virtuemart/classes/payment/ideal/icons/logo_ideal.gif\\" width=\\"57\\" height=\\"50\\"></td>\r\n  <td><a href=\\"#\\" onclick=\\"document.idealform.submit();\\">Klik hier om direct te betalen met Ideal.</a></td>\r\n </tr>\r\n</table>\r\n</form>', ''
);



MySQL retourneerde: 

#1136 - Column count doesn't match value count at row 1


Does someone know this problem and have an idea how to solve this?

With kind regards,
W1SE4ALL

W1SE4ALL

  • Beginner
  • *
  • Posts: 2
Re: Problem with iDEAL
« Reply #1 on: May 13, 2008, 16:31:31 pm »
Are there any dutch users of VirtueMart??