I did some scaffolding on the paypalpayement extension… and it returns nothing untill i comment out this table
$criteria->compare(‘quantity’,$this->quantity);
quantity
int(11) NOT NULL default ‘0’,
Entire table looks like this:
CREATE TABLE IF NOT EXISTS `paypal_payments` (
`id` int(11) NOT NULL auto_increment,
`payer_id` varchar(60) default NULL,
`payment_date` varchar(50) default NULL,
`txn_id` varchar(50) default NULL,
`first_name` varchar(50) default NULL,
`last_name` varchar(50) default NULL,
`payer_email` varchar(75) default NULL,
`payer_status` varchar(50) default NULL,
`payment_type` varchar(50) default NULL,
`memo` tinytext,
`item_name` varchar(127) default NULL,
`item_number` varchar(127) default NULL,
`quantity` int(11) NOT NULL default '0',
`mc_gross` decimal(9,2) default NULL,
`mc_currency` char(3) default NULL,
`address_name` varchar(255) NOT NULL default '',
`address_street` varchar(255) NOT NULL default '',
`address_city` varchar(255) NOT NULL default '',
`address_state` varchar(255) NOT NULL default '',
`address_zip` varchar(255) NOT NULL default '',
`address_country` varchar(255) NOT NULL default '',
`address_status` varchar(255) NOT NULL default '',
`payer_business_name` varchar(255) NOT NULL default '',
`payment_status` varchar(255) NOT NULL default '',
`pending_reason` varchar(255) NOT NULL default '',
`reason_code` varchar(255) NOT NULL default '',
`txn_type` varchar(255) NOT NULL default '',
`custom` int(11) default NULL,
`paypal_response` varchar(125) NOT NULL,
`correct_price` int(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `txn_id` (`txn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
Is it a bug or is there something wrong with the table 0_o