Ceon Manual Card Payment Module v3.0.0

[DCDC]

You should restore the backup and start again, this time following the steps outlined in the upgrade documentation.

Hello Conor,

Sorry, it was late when I typed the last message and I was less than clear. Please allow me to try to explain one more time.

I am upgrading my client's site from 1.3.9h to 1.5.1. The 1.3.9h site had been running v 2.2, but my client disabled it due to his site being hacked. I installed the new version of Zencart, moved the database over, patched the database to 1.5.1. Then I copied over the files for CEON 3.0.1. The old version 2.2 files were not on the 1.5.1 build prior to me copying over new CEON 3.0.1 files. When I go into the admin panel>Modules>Payment and click on CEON, I am not receiving the message that should display from your upgrading instructions:

"A notice about the module being upgraded should be displayed. Click the “Reload module” link so it can perform its configuration checks. If no error messages are displayed, everything is fine!"

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.

So my question is, do I need to reinstall the 2.2 files from my client's 1.3.9h build, and then copy over the 3.0.1 files (which would overwrite all the 2.2 files, anyway, correct?). And if I do need the 2.2 files on the server, I'd ideally like a fresh copy of those from you to install to avoid any potential issue with the hacked files on the 1.3.9h, though I don't see the 2.2 download link on your site.

Sorry for my confusion, and hope this is clearer than my last message.

Thank you,

Christopher

[DCDC]

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

[conor]

Hi Christopher,

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

[DCDC]

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

[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.

[conor]

Hi,

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

[DCDC]

Hi Conor,

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

Thank you,

Christopher

[conor]

Hi Christopher,

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