Ceon Manual Card Payment Module v3.0.0

Conor,

Just checking in to see if you have read my update above to my problem. I'd appreciate any help you can provide.

Thanks,

Christopher

Hi Christopher,

DCDC:

Instead, I'm only getting an install link, which bombs out because it already sees the table it wants to create. I did try recopying the 3.0.1 files just before posting this message, with the same result

That can't happen. The software uses any existing table, upgrading any version 1.x table to the new format introduced in 2.x (which is unchanged for 3.x).

What is probably happening is that you have all the old configuration options in the configuration table and "Install" is trying to add them again. Why these old options are conflicting I don't know, but it's something you've done wrong in your upgrade process..

You need to "Remove" the old module, or at least, the bits of it you must have remaining.. again how you could only have copied across bits I don't know but you've messed up somewhere.

If you can't click "Remove", use PHPMyAdmin to search for the CEON_MANUAL_CARD% configuration options and delete them all, then click "Install" and you should no longer have any conflicts.

Hope that helps.

All the best..

Conor
ceon

Hello again Conor,

Thanks for the response. Unfortunately, what you suggested did not work either.

1. I deleted all the 3.01 files from the server and did a fresh install of 3.01
2. I did the search in phpmyadmin and deleted the few possible configuration references that appeared as you suggested
3. Tried to install again. Same error as mentioned above.
4. I dropped the ceon_manual_card table, and deleted all references to ceon (including those in orders - yes, I have a backup) just to see if I could get a completely clean "non upgrade" install.
5. Tried installing CEON again. This message now appears at the top of the screen.

"Database table could not be created! The database user may not have CREATE TABLE privileges?!"

I deleted the database user, recreated, and added user to the table ensuring that ALL permissions are granted to this user. Repeated steps 4 & 5 above, and still getting the "Database table could not be created! The database user may not have CREATE TABLE privileges?!" message.

The only other module on this site is imagehandler4, which is working okay. The client has been testing the rest of the site this past week, and has not noted any errors, nor is there anything in the log file to clue me in on what is happening.

I'm really mystified by this. Any other ideas? I know you keep saying this can't be happening, but beyond what I've I've tried and what you have suggested, I am hitting a brick wall.

Christopher

I wanted to add, that even though the message appears that the table could not be created, the interesting thing is, when looking at phpmyadmin, the database table is there.

Hi,

DCDC:

I wanted to add, that even though the message appears that the table could not be created, the interesting thing is, when looking at phpmyadmin, the database table is there.

I've no idea what's wrong but maybe there is something wrong with your MySQL server. You'll have to send PHPMyAdmin, FTP and admin details for the site, this isn't one I can help with through the forum, I'll have to see what's wrong on your server.

All the best..

Conor
ceon

Hi Conor,

Just sent you an e-mail from the link provided.

Thank you,

Christopher

Hi Christopher,

DCDC:

Just sent you an e-mail from the link provided.

Found and circumvented the problem.. a broken MySQL server, nothing to do with Ceon Manual Card.

All the best...

Conor
ceon

OK, just where is the CC Expiration Date shown? I mean a customer makes an order and the emails are sent, just where in what email do I see the expiration date of the CC? I can't find it anywhere on any of the emails. Did I fail to turn something on/off or what?

Hi,

Beau91324:

OK, just where is the CC Expiration Date shown?

On the order page.

All the best...

Conor
ceon

I have had a look through the thread and cannot see the answer?

For data protection etc. where are the card details held? if in database of the site, are they deleted after the transaction is completed?

Hi,

adb34:

For data protection etc. where are the card details held? if in database of the site, are they deleted after the transaction is completed?

This module should NOT be used if data protection is valued. You should use a Payment Gateway.

The details are stored in the store's database, except for the middle digits of the card number and the CVV number which are sent by e-mail, for some semblance of security.

No details are ever deleted. The next version may allow for that, maybe, I'm not sure.

All the best...

Conor
ceon

conor:

Hi,

On the order page.

All the best...

Conor
ceon

If by "order page" you mean the eMail sent me with the order, I don't see the expiration date for the CC anywhere. I would expect it just under the CC # and it is not there. So where is it?

Hi,

Beau91324:

If by "order page" you mean the eMail sent me with the order,

No, I don't.

I mean the page in the admin that has the details for the order.

All the best..

Conor
ceon

conor:

Hi,

No, I don't.

I mean the page in the admin that has the details for the order.

All the best..

Conor
ceon

Is there anyway to get the Exp Date to show in one of the two emails sent the store. My client doesn't like or use well the admin of the store, he leaves that up to me so I really don't want to have him go into the Admin of the store. I shutter at the thought of the kind of damage he would do.

Hi,

Beau91324:

Is there anyway to get the Exp Date to show in one of the two emails sent the store. My client doesn't like or use well the admin of the store, he leaves that up to me so I really don't want to have him go into the Admin of the store. I shutter at the thought of the kind of damage he would do.

Your client is happy to send their customers' card details across the internet in an e-mail but not happy to use their own store's admin?

An irresponsible client in my opinion.

Sorry, I can't support someone like that.

All the best..

Conor
ceon

conor:

Hi,

This module should NOT be used if data protection is valued. You should use a Payment Gateway.

The details are stored in the store's database, except for the middle digits of the card number and the CVV number which are sent by e-mail, for some semblance of security.

No details are ever deleted. The next version may allow for that, maybe, I'm not sure.

All the best...

Conor
ceon

Ah. Well this may make a big difference to me and most of the e-commerce site in the UK. Have a read of these links UK data protection act 2008 (updated February 2008 ) and Information Commissioner's Office.

I cannot workout the implications to the UK users of this module I really hope there is non, I would love to use this.

AndyB

Hi,

A new version of Ceon Manual Card has been released.

This thread is now officially closed, if you have any support queries please post in the new thread for the new version of the software:

Ceon Manual Card v4 Support Thread

A new mode of operation has been added to this new version, allowing the storage of all card details, making them available in one place. The e-mail mode is still recommended above this though as it is a little bit more secure.

As always, it is highly recommended by Ceon that all Zen Cart stores use a payment gateway instead of a manual card module, for increased safety of customers' card details and for compliance with any relevant laws.

Latest Revision History

4.0.1- 14th November 2012

[ADDED] Card details deletion functionality updated with a JavaScript refresh to try and avoid potential confusion. A refresh of the page is necessary as the standard details will have already been output before this software had a chance to run and carry out the actual deletion. If JavaScript is disabled at the module will output an informative message to the user.

[UPDATED] Admin panel restyled to give it a fresh, modern, Ceon look.

[UPDATED] More translations made in Spanish language file.

[BUGFIX] The new Store Card Details mode didn't work in Zen Cart 1.5.x as Zen Cart 1.5.x automatically masks the card number, so the card number was missing its middle digits! Module updated to store the card number in the Ceon Manual Card database table instead.

[ADDED] FAQ added about the “Back” button on the order page not bringing the user back to the list of orders.

4.0.0 - 8th November 2012

[ADDED] Added new option to store the full card details, instead of e-mailing the card number's middle digits and any CV2 number. Extra fields added to database table. Automatic upgrade for database and configuration functionality updated appropriately.

[ADDED] Button added to admin panel to delete all the card details for the order. Functionality can be enabled/disabled using a new configuration option.

[ADDED] Facility to check the configuration and database added, by using new config-check flag as a query string parameter.

[BUGFIX] The zone status check was running in the admin, whereas it should only run in the catalog, as the data to check against is only available when checking out.

[BUGFIX] Missing defines added to Spanish language file.

[BUGFIX] Some admin messages had typos in them.

Download Now!

The latest version can always be downloaded from the distribution's website and should also be available in the Zen Cart downloads area soon.

Enjoy!

All the best...

Conor
ceon