upgrading 1.3.x to 1.3.9h; using zc_install, and it says a table is missing, hangs up

[gaildok]

Upgrading 1.3.x to 1.3.9h. Using zc_install, and at the index page, after the license screen (before prerequisite screen), it says:

1146 Table 'XXXzencart.authorizenet' doesn't exist
in:
[show fields from authorizenet]

What do I do next?

[kobra]

What procedure are you attempting??

You should not be trying to upgrade your live.current site directly

Install clean into a folder first with a new database, then using phpmyadmin make a proper DB backup of your live site and then import that backup into your new upgrade site's database

https://www.zen-cart.com/tutorials/i...hp?article=103

Upgrade
https://www.zen-cart.com/tutorials/i...hp?article=108

[DrByte]

Evidently you've deleted the authorizenet table from your database.
Put it back and zc_install should work without that error.

[gaildok]

Thanks for the replies.

1) No, this isn't an upgrade to a direct/live DB. We are working in a "dev" environment, so this is a recently-built "dev" MySQL database, and we're installing the 1.3.9h ZC release before going live. (We have complete backups and can restore if needed.)

Thanks for links, these are what I was using as a guide already. Again, I am making my way through the 3-step upgrade tutorial. I admit that I'm doing something wrong, but I don't know what.

2) Honestly, I don't work on the DB at all (it's built by another team member), so I haven't made any changes to it yet (such as deleting an authorizenet table).

Perhaps I need to "add" a reference to a DB table in one of the ZC files so that it knows to call that table? Or maybe I shouldn't have turned off the payment modules, including authorizenet, before starting the upgrade, although that's within the instructions?

Step by step, this is basically what I've tried 2-3 times now:

1) I turned off all payment modules first, before starting the upgrade.

2) Downloaded the newest release.

3) I conducted the comparison of old and new files using BBEdit. We used the "template override" system, so there were few customizations to the site. They're limited to 4 separate "override" directories in: ZC/includes/languages/english/CUSTOM and ZC/includes/languages/english/html_includes/CUSTOM and ZC/includes/languages/english/modules/shipping/CUSTOM and ZC/includes/templates/CUSTOM.

4) After line by line comparison of these files with the ZC counterparts, these "override" directories have been deemed ready for use, and placed into the new folder called "ZC-139h" which holds the newly-downloaded v1.3.9h release of ZC. Thus the new release has been customized to our site, using the "override" system. No other modifications were made to our site in the past, as far as I can tell, so there's nothing else to alter. As far as I can tell.

5) I've also copied the relevant configure.php files into both the ZC/includes and ZC/admin/includes directories into the new folder called "ZC-139h."

6) Again, we're already in a "DEV" env't on a test server, so we're running a test DB as it is.

7) I uploaded the "ZC_v139h" directory to the server, and pointed it at the "dev" DB via the configure files.

8) Then I launched the ZC_Install/admin.php page from inside the new directory. IT DOES NOT GIVE AN OPTION TO UPGRADE, at least at the point before it hangs up...I may not have gotten far enough to see that choice yet.

9) On the index.php page, it hangs up with the message posted earlier, between screens (license and prerequisite). I'm pasting it back in here, for reference:

1146 Table 'XXXzencart.authorizenet' doesn't exist
in:
[show fields from authorizenet]


10) Same question. Any other thoughts? Totally out of my depth here.

[gaildok]

Dr Byte -- Although i didnt delete the table, its certainly missing, so how do i put it back in? I'm using mysql workbench to access DB.

[gaildok]

In case 'quick reply' is extra-effective, I used MySQL Workbench to verify that there's not authorizenet table in the DB (no surprise). Although I didn't work directly on the database, and didn't delete the table, it's not there. I tested whether turning on/off payment modules might have affected the table structure in the DB (it didn't). Please advise...how do I put that table back into place (if it was ever there, and I suppose it must have been, if ZC is looking for it)? Your help is appreciated.

[DrByte]

Rebuild it from the original table structure found in the mysql_zencart.sql file in the zc_install directory of the master Zen Cart distribution files for the version you're currently using on your site.