Nochex problems

[Andy c]

Hi can anyone help with my new problem
I had a cust buy an item today it didn't show up any details of what they bought ...I have managed to fix this by finding the update
it is now showing what was purchased but doesn't give any pricing just a big fat Zero
the only think I can think of is that when I ran the sql file I got error messages
1 being   
Note: 2 statements ignored. See "upgrade_exceptions" table for additional details.

is there a way to to the sql manually and what would need doing
thanks

sql file
CREATE TABLE `nochex_apc_transactions` (
  `nochex_apc_id` int(11) unsigned NOT NULL auto_increment,
  `order_id` int(11) unsigned NOT NULL default '0',
  `nc_transaction_id` varchar(30) NOT NULL,
  `nc_transaction_date` varchar(100) NOT NULL,
  `nc_to_email` varchar(255) NOT NULL,
  `nc_from_email` varchar(255) NOT NULL,
  `nc_order_id` varchar(255) NOT NULL,
  `nc_custom` varchar(255) NOT NULL,
  `nc_amount` decimal(9,2) NOT NULL,
  `nc_security_key` varchar(255) NOT NULL,
  `nc_status` varchar(15) NOT NULL,
  `nochex_response` varchar(255) NOT NULL,
  `last_modified` datetime NOT NULL default '0001-01-01 00:00:00',
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  `memo` text,
  PRIMARY KEY  (`nochex_apc_id`),
  KEY `idx_zen_order_id_zen` (`order_id`)
);

CREATE TABLE `nochex_sessions` (
  `unique_id` int(11) NOT NULL auto_increment,
  `session_id` text NOT NULL,
  `saved_session` blob NOT NULL,
  `expiry` int(17) NOT NULL default '0',
  PRIMARY KEY  (`unique_id`),
  KEY `idx_session_id_zen` (`session_id`(36))
);

[seamus]

where did you get the update from?

I noticed that the nochex mod on the zen cart site doesnt work properly, there are three files that have problems, I downloaded the mod from the nochex site, that version works alright.

The sql gave you the error because the two tables are already there
thats why the statements were ignored.

[Andy c]

can't remember the original (might have been zencart d/l) but got the 2nd from nochex help files with a few updated files & sql

[seamus]

to check the database tables, go into Cpanel then into phpmyadmin and then click on your store database on the left hand side, it'll show you all the tables that are in that database, then just look for two tables called

nochex_apc_transactions

and

nochex_sessions

they should be there, you can browse those tables just to make sure there are fields in them.

If there are fields in those tables, then the database is fine, I dont think thats where the problem will be, if you updated the mod then those tables would've already been there, hence the error when adding the sql patch

there might be a missing updated file, go through the updated files and check they are all where they should be

[Andy c]

found them they do have stuff in them from when installed and updated today's date

[Andy c]

another question ..I don't have paypal business option loaded ..I have paypal express ,would this make a difference.
Have also rechecked files and they are in the right places
if you want access I can pm you ..if it is easier

[Andy c]

Still have an issue with this addon ... getting the products to show but still getting a big fat ZERO for a total ..
I would get rid of it but people are using it
any help please