payment module instalation problem [solved]

[comzemadrid]

hi all

 

i just bought some payment module of payment by visa card. im using 1.5.3 .im trying to install it but it give me this error.

 

[PrestaShopDatabaseException]

Duplicate column name 'payment_fee'

ALTER TABLE `ps_orders` ADD `payment_fee` decimal(20,6) NOT NULL default '0',ADD `payment_fee_type` int(2) NOT NULL default '0';

at line 607 in file classes/db/Db.php

601. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. 		}603. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))604. 		{605. 			if ($sql)606. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');607. 			throw new PrestaShopDatabaseException($this->getMsgError());608. 		}609. 	}610. 611. 	/**

• DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 447 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 39 - modules/redsys/redsys.php] - [1 Arguments]
• Redsys->install - [line 675 - controllers/admin/AdminModulesController.php] - [0 Argument]
• AdminModulesControllerCore->postProcessCallback - [line 795 - controllers/admin/AdminModulesController.php] - [0 Argument]
• AdminModulesControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 50 - secure/index.php] - [0 Argument]

 

 

 

pleas anyone can help me? well be very thankfull

Edited November 30, 2013 by comzemadrid (see edit history)

[comzemadrid]

[El Patron]

please provide more information, i.e. where did you buy the module, the module name etc...

 

from the error you received I would be very afraid of proceeding with module installation as it's modifying core files

[vekia]

it looks like payment_fee column already exists in the table mentioned in error code

can you verify it please? (in database manager like phpmyadmin)

[comzemadrid]

yeah you are right. i just fixed it by deleting payment fee table from db. then i reinstall the module and works fine thank to everyone.