-
Some issues when upgrading
Version 1.57C
Apologies in advance if the answer was posted elsewhere. I'm unable to find it.
Gotta say, i dread the upgrades but so far, this one is way better than the old one! But having a few issues and i'll post them separately so others can benefit.
When on the admin home, if i click tools--who is online I get this message in a new blank page with these words on top:
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Then, I the admin home page itself, under the new customers table i get this warning which is the same:
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Few more minor things but will post it in another question. Thank you.
-
Re: Some issues when upgrading
So any time those messages are generated, a mydebug like file is expected to be generated in the logs folder.
Now, something else of importance here is to also identify the version from which upgrading as that may lead to an understanding of what problem(s) exist and potential causes.
For example, it is not yet known if the zc_install process has been used to upgrade the old database (if even at that point yet or just testing out the demo data and having this issue) or even how the current version being used was provided to the server (one-click install?) all these things are covered by addressing the posting tips upon first posting and as soon as possible after making that first post...
-
Re: Some issues when upgrading
Quote:
Originally Posted by
mc12345678
So any time those messages are generated, a mydebug like file is expected to be generated in the logs folder.
Now, something else of importance here is to also identify the version from which upgrading as that may lead to an understanding of what problem(s) exist and potential causes.
For example, it is not yet known if the zc_install process has been used to upgrade the old database (if even at that point yet or just testing out the demo data and having this issue) or even how the current version being used was provided to the server (one-click install?) all these things are covered by addressing the posting tips upon first posting and as soon as possible after making that first post...
Mydebug is a plugin? it's not for 1.57c This is an upgrade from v1.5.1 i used the zc_install to upgrade an old database. I did not see this issue when i tested. I did not see it. I did test in a separate folder before going live.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
Mydebug is a plugin? it's not for 1.57c This is an upgrade from v1.5.1 i used the zc_install to upgrade an old database. I did not see this issue when i tested. I did not see it. I did test in a separate folder before going live.
No.. myDEBUG-XXXXXXXX is the prefix/basic name of the file(s) that contain... well debug information... The file(s) are generated in the folder that is called logs. It is off of the root of your store.
So then, when making the new files part of the live store, what was done with the old files?
-
Re: Some issues when upgrading
Quote:
Originally Posted by
mc12345678
No.. myDEBUG-XXXXXXXX is the prefix/basic name of the file(s) that contain... well debug information... The file(s) are generated in the folder that is called logs. It is off of the root of your store.
So then, when making the new files part of the live store, what was done with the old files?
According to the directions given by Zen Cart, i uploaded the new files to the old store allowing overwrite...then adjusted the permissions...then ran zc_install. After that, removed zc install and everything seemingly works then i found those errors. Looking at the logs folder I see the following and i removed personal info so i don't worry about it:
[27-May-2021 17:02:05 America/Boise] Request URI: /shop/admin/, IP address: i remove this info
#1 trigger_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:132]
#5 WhosOnline->retrieve() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:218]
#6 WhosOnline->getStats() called at [/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php:15]
#7 include(/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php) called at [/home2/myprivatename/public_html/shop/admin/index_dashboard.php:62]
#8 require(/home2/myprivatename/public_html/shop/admin/index_dashboard.php) called at [/home2/myprivatename/public_html/shop/admin/home.php:25]
#9 require(/home2/myprivatename/public_html/shop/admin/home.php) called at [/home2/myprivatename/public_html/shop/admin/index.php:11]
--> PHP Fatal error: 1267:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' :: SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, s.value as session_data
FROM whos_online w
LEFT OUTER JOIN sessions s ON (s.sesskey = w.session_id)
WHERE ip_address != '' AND ip_address NOT IN (' i remove this as it may be sensitive')
ORDER BY time_entry, LPAD(ip_address,11,'0') ==> (as called by) /home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php on line 132 <== in /home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php on line 170.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
According to the directions given by Zen Cart, i uploaded the new files to the old store allowing overwrite...then adjusted the permissions...then ran zc_install. After that, removed zc install and everything seemingly works then i found those errors. Looking at the logs folder I see the following and i removed personal info so i don't worry about it:
[27-May-2021 17:02:05 America/Boise] Request URI: /shop/admin/, IP address: i remove this info
#1 trigger_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:132]
#5 WhosOnline->retrieve() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:218]
#6 WhosOnline->getStats() called at [/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php:15]
#7 include(/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php) called at [/home2/myprivatename/public_html/shop/admin/index_dashboard.php:62]
#8 require(/home2/myprivatename/public_html/shop/admin/index_dashboard.php) called at [/home2/myprivatename/public_html/shop/admin/home.php:25]
#9 require(/home2/myprivatename/public_html/shop/admin/home.php) called at [/home2/myprivatename/public_html/shop/admin/index.php:11]
--> PHP Fatal error: 1267:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' :: SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, s.value as session_data
FROM whos_online w
LEFT OUTER JOIN sessions s ON (s.sesskey = w.session_id)
WHERE ip_address != '' AND ip_address NOT IN (' i remove this as it may be sensitive')
ORDER BY time_entry, LPAD(ip_address,11,'0') ==> (as called by) /home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php on line 132 <== in /home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php on line 170.
That debug-log says it all ... you need to grab a copy of Convert DB to UTF8 (https://www.zen-cart.com/downloads.php?do=file&id=1318) and follow the instructions in that plugin. You've got a mixture (utf8_general_ci and utf8_unicode_ci) of character-encodings in use in your database.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
lat9
That debug-log says it all ... you need to grab a copy of
Convert DB to UTF8 (
https://www.zen-cart.com/downloads.php?do=file&id=1318) and follow the instructions in that plugin. You've got a mixture (utf8_general_ci and utf8_unicode_ci) of character-encodings in use in your database.
Great. Thanks. Question... instructions say "configure.php (both) need a line which says: define('DB_CHARSET', 'utf8mb4');"
Configure already has a line that says define('DB_CHARSET', 'utf8'); // 'utf8mb4' or older 'utf8' / 'latin1' are most common
do i alter that line or add an entirely new line?
Also, you're right, i did it and everything now works! Thank you. The php gave me these warning in red:
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'free' at line 1
ALTER TABLE `plugin_control` MODIFY `type` VARBINARY(11) NOT NULL DEFAULT free
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'free' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TEXT' at line 1
ALTER TABLE `customers` MODIFY `customers_email_format` VARBINARY(4) NOT NULL DEFAULT TEXT
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TEXT' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'F' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y' at line 1
ALTER TABLE `coupons` MODIFY `coupon_active` BINARY(1) NOT NULL DEFAULT Y
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y' at line 1
And there are probably a dozen more...
Am i now having to fix this too?
-
Re: Some issues when upgrading
Yikes! Looks like we forgot to update that plugin with a patch fix regarding those defaults.
Do you have a backup from before running that script? If not, there's a "fix" utility in the updated version of the plugin at https://github.com/zencart/utf8mb4-converter
-
Re: Some issues when upgrading
help me understand... i ran the converter. i backed up the database before. now I have to restore the previous database or go to git hub?
-
Re: Some issues when upgrading
i did a winmerge comparison of the latest file located at plugins and the git hub file you pointed to... they are identical.
-
Re: Some issues when upgrading
i downloaded and ran the git hub files both the optional fix and then the utf8mb4 file... after having done all of this, the red letter warnings persist. here is a sum of all the red letter warnings as a result of using the zc_install in 1.5.7c to update the site and the data base.
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'info' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'info' at line 1
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
MySQL Error: Duplicate key name 'id'
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'F' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'F' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TEXT' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TEXT' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'free' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'free' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y' at line 1
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y' at line 1
-
Re: Some issues when upgrading
Hmmm. I can't replicate it. Maybe it's a different MySQL version.
Does making the changes added here help get rid of most of those errors? https://github.com/zencart/utf8mb4-c...r/pull/5/files
-
Re: Some issues when upgrading
Yes Dr Byte, it does Now there are only two errors in Red:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
MySQL Error: Duplicate key name 'id'
Do i need to be concerned? Should I fix it? Can i let it go? If fix, how? Thank you. I have three sites to upgrade. Sending you a token of appreciation now.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
Yes Dr Byte, it does Now there are only two errors in Red:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
MySQL Error: Duplicate key name 'id'
Those would appear to be related to tables added by something other than original Zen Cart.
Does the output show the table names too? Or clues to what table it was operating on before/after the errors appeared?
I'm puzzled how an existing table could have double auto-increment fields already, so that's odd.
As far as duplicate key name, that's also a bit odd since normally that wouldn't ever have been allowed. I suspect it got created by phpMyAdmin in times past when you attempted to manually add an extra index to a table.
If there's no other output on-screen that can help identify which table, then you could look at your backup file for all the CREATE TABLE commands, and see which tables have more than one auto column, and which ones have any indexes named "id". Then with that information we can come up with whatever manual fixes are required for tidying up these inconsistencies inherited in your old database.
-
Re: Some issues when upgrading
Hello. I updated an older zen using the upgrade button during zc_install. The previous version worked fine with no warnings or loss of functionality. That being said, i never ran the php program on the previous zen verions to know if these problems existed. I never added a table or toyed with the phpadmin. I did start out, years ago, by hiring a person who may have started me out on a bad premise?
Anyway, as soon as i find the time I'll attempt to provide the info. I'm upgrading a second store now. we'll see if the problem repeats itself. old store is fine. no problems at all. I'm being warned by the host that i need to update the php so, now i'm doing the upgrade to the 1.5.7c.
-
Re: Some issues when upgrading
Dr Byte, I'm having a heck of a time trying to provide you what you've asked for. I brought it up with bluehost and they told me to import into a new database. they then dropped the tables and imported it again and said, it's fixed...said the database was not able to overwrite itself. they did all this on test databases and i have no way to confirm as i cannot run the php program without setting up a new cart, right? If that's true... what would cause a database to stop overwriting itself? eh... in your estimation, can i live with this? It's a business i need to put food on the table. so, there's that. should i fix it? will it cause problems later on? is there a risk? Time is the problem. But will make the time if you think it's important enough. It is a database after all. thank you
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
said the database was not able to overwrite itself
If those were their exact words then they're probably talking geek-speak without getting into specifics.
It's "possible" that they mean "server permissions don't let you-the-non-server-owner import a database of the same name as one that already exists (ie: 'overwrite itself')". Which would be true. To overcome that one needs to drop the database and re-create it re-import things. Almost identical to dropping all the tables and importing them again. Sounds like they did that for you.
Quote:
Originally Posted by
muah
they then dropped the tables and imported it again and said, it's fixed
Maybe it's fine then?
I'm not sure what exactly they mean by "it's fixed" ... ie: what exactly did they "test" to confirm that it's "fixed" ... ie: what are they asserting is no longer broken?
Maybe it's moot.
Quote:
in your estimation, can i live with this? It's a business i need to put food on the table. so, there's that. should i fix it? will it cause problems later on? is there a risk?
You could re-run the utf8-convert scripts again to see if any issues are reported.
My only concerns are related to the last errors you quoted:
- duplicate auto_increment on one table
- duplicate index named 'id' on one table
The potential downsides to this are:
- the duplicate auto_increment shouldn't ever have existed, so it's puzzling why it's there; uncertain whether there's been a data risk/problem all along. Too unknown to assess possible impact.
- if the duplicate index isn't being recreated then it's possible that whatever index is being skipped might cause some slowness in whatever table it's referring to. It shouldn't be coming from core Zen Cart tables so maybe it's unlikely to be a problem. But too unknown to understand possible impact very well.
-
Re: Some issues when upgrading
Okay, I have another site, separate from the former. The exact same result. After an upgrade, Admin warning, had to run the UTF8 converter then your added lines to fix. After running everything i have these errors:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
MySQL Error: Duplicate key name 'id'
-
Re: Some issues when upgrading
Hello again. So, I've upgraded 3 sites. Two were upgrades and the two upgrades produced the identical errors after running the UTF8MB4 converter. Using your updated file that you posted, corrected most but left the following identical residual errors on both databases. Here they are back to back in full. I did not post the errors in full, only the red. Here they are in full. Any further advice how to fix this? Many thanks.
site one:
Processing table [admin_files]:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE `admin_files` DROP INDEX `id`
Temporarily dropped unique index id.
Skipping page because it is already using utf8mb4.
Processing indexes...
MySQL Error: Duplicate key name 'id'
CREATE UNIQUE INDEX id ON admin_files (id)
Recreated unique index id on admin_files (id).
Table collation updated.
site 2:
Processing table [admin_files]:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE `admin_files` DROP INDEX `id`
Temporarily dropped unique index id.
Skipping page because it is already using utf8mb4.
Processing indexes...
MySQL Error: Duplicate key name 'id'
CREATE UNIQUE INDEX id ON admin_files (id)
Recreated unique index id on admin_files (id).
Table collation updated.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
Hello again. So, I've upgraded 3 sites. Two were upgrades and the two upgrades produced the identical errors after running the UTF8MB4 converter. Using your updated file that you posted, corrected most but left the following identical residual errors on both databases. Here they are back to back in full. I did not post the errors in full, only the red. Here they are in full. Any further advice how to fix this? Many thanks.
site one:
Processing table [admin_files]:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE `admin_files` DROP INDEX `id`
Temporarily dropped unique index id.
Skipping page because it is already using utf8mb4.
Processing indexes...
MySQL Error: Duplicate key name 'id'
CREATE UNIQUE INDEX id ON admin_files (id)
Recreated unique index id on admin_files (id).
Table collation updated.
site 2:
Processing table [admin_files]:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE `admin_files` DROP INDEX `id`
Temporarily dropped unique index id.
Skipping page because it is already using utf8mb4.
Processing indexes...
MySQL Error: Duplicate key name 'id'
CREATE UNIQUE INDEX id ON admin_files (id)
Recreated unique index id on admin_files (id).
Table collation updated.
The highlighted table comes from some add-on, not a Zen Cart core table. Perhaps if you could determine the source of that table, someone would be better able to help.
-
Re: Some issues when upgrading
The only addons i use on these two sites were obtained from the zen plugin area (shipping, payment, backup mysql, easy update, etc). In fact, if there are plugins outside of zen's area, i'm not even aware of it. the only other code i introduced was google html code and live chat html code and shipping clones. I added shipping flat rate clones but that's it. Okay... well, tried searching from the tool kit, nothing. I tried a local search on the old site, nothing. Looks like it's my problem to solve... did not go to school for this so, here comes the learning curve. Appreciate the feedback nonetheless.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
The only addons i use on these two sites were obtained from the zen plugin area (shipping, payment, backup mysql, easy update, etc). In fact, if there are plugins outside of zen's area, i'm not even aware of it. the only other code i introduced was google html code and live chat html code and shipping clones. I added shipping flat rate clones but that's it. Okay... well, tried searching from the tool kit, nothing. I tried a local search on the old site, nothing. Looks like it's my problem to solve... did not go to school for this so, here comes the learning curve. Appreciate the feedback nonetheless.
While I know DrByte would like to be able to help determine how this situation occurred, if for no other reason than to prevent anything similar occurring to anyone else, there is a need for you to also still continue to operate at the highest level with what already is available to you as a store operator/installer.
So, to support being able to move forwards assuming that this issue has existed for a long period of time but only now in a new environment was discovered, I'd like to ask a few questions to validate the above statement about having done the search.
When you go/have gone to the admin of your site with this database, go to the tools dropdown. Then select developers toolkit.
Now scroll to the bottom. In the lower left text box enter:
admin_files
Now go to the right and select the search button. What are the results?
-
Re: Some issues when upgrading
Quote:
Originally Posted by
mc12345678
While I know DrByte would like to be able to help determine how this situation occurred, if for no other reason than to prevent anything similar occurring to anyone else, there is a need for you to also still continue to operate at the highest level with what already is available to you as a store operator/installer.
So, to support being able to move forwards assuming that this issue has existed for a long period of time but only now in a new environment was discovered, I'd like to ask a few questions to validate the above statement about having done the search.
When you go/have gone to the admin of your site with this database, go to the tools dropdown. Then select developers toolkit.
Now scroll to the bottom. In the lower left text box enter:
admin_files
Now go to the right and select the search button. What are the results?
Hello, thank you for taking an interest. Had I not run the utft8 updater you suggested, I never would have found these errors. Dr Byte's contribution fixed everything the original updater did not...minus this one issue. Granted, if this error has any negative effect on the store... I'm not seeing it. Here are the results:
Searching 1962 files ... for: admin_files
Match Lines found: 0 --- Searching 1962 files ... for: admin_files
Error: No matching Configuration Keys were found ... admin_files
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
Hello, thank you for taking an interest. Had I not run the utft8 updater you suggested, I never would have found these errors. Dr Byte's contribution fixed everything the original updater did not...minus this one issue. Granted, if this error has any negative effect on the store... I'm not seeing it. Here are the results:
Searching 1962 files ... for: admin_files
Match Lines found: 0 --- Searching 1962 files ... for: admin_files
Error: No matching Configuration Keys were found ... admin_files
So, what that means is that within the standard search fileset of the admin tools->developers tool kit, that the database table: admin_files, is not referenced by a file used in the routine processing of Zen Cart.
What that generally means is that the table could be dropped from the database, though as the site owner/operator, perhaps something else is known like there is a sub-directory outside of the Zen Cart store that specifically uses this database and that table.
But, if the software was designed as suggested by the Zen Cart team, then it would appear that the admin_files table could be dropped.
-
2 Attachment(s)
Re: Some issues when upgrading
Quote:
Originally Posted by
mc12345678
So, what that means is that within the standard search fileset of the admin tools->developers tool kit, that the database table: admin_files, is not referenced by a file used in the routine processing of Zen Cart.
What that generally means is that the table could be dropped from the database, though as the site owner/operator, perhaps something else is known like there is a sub-directory outside of the Zen Cart store that specifically uses this database and that table.
But, if the software was designed as suggested by the Zen Cart team, then it would appear that the admin_files table could be dropped.
When you say "dropped" you mean, gone? I went into myphp admin and took a snap shot of this area and expanded it. there are two images included here of what i'm talking about. See images. Dropped means these should Not be there? Attachment 19626Attachment 19627
-
1 Attachment(s)
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
When you say "dropped" you mean, gone? I went into myphp admin and took a snap shot of this area and expanded it. there are two images included here of what i'm talking about. See images. Dropped means these should Not be there?
Attachment 19626Attachment 19627
I wonder if in the past you installed the Admin Profiles add-on (https://www.zen-cart.com/downloads.php?do=file&id=12), a quick look shows that it creates the admin_files table with the same columns as in your image. Given that (as the link shows) this functionality was subsequently built-in to ZCv1.5.x, then as @mc says it would appear that the table can be dropped/deleted. Within phpmyadmin you can see there's a 'drop' link next to the relevant table, here's a shot of part of mine:
Attachment 19628
Of course, backup your database first.
-
Re: Some issues when upgrading
To the question asked of me, now based on simon1066's review, I would agree that the table can be removed (dropped) without issue. Always with the words of backup before destroy. :)
Again, that also is if this particular table is causing any issues moving forwards with the upgrade.
Do please keep a copy though so that perhaps something can be figured out to maybe help more in the future.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
simon1066
I wonder if in the past you installed the Admin Profiles add-on (
https://www.zen-cart.com/downloads.php?do=file&id=12), a quick look shows that it creates the admin_files table with the same columns as in your image. Given that (as the link shows) this functionality was subsequently built-in to ZCv1.5.x, then as @mc says it would appear that the table can be dropped/deleted. Within phpmyadmin you can see there's a 'drop' link next to the relevant table, here's a shot of part of mine:
Attachment 19628
Of course, backup your database first.
I have a faint recollection of such an install. Not sure. I deleted the table and ran the utf8 converter again and this time without errors. Thank you.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
mc12345678
To the question asked of me, now based on simon1066's review, I would agree that the table can be removed (dropped) without issue. Always with the words of backup before destroy. :)
Again, that also is if this particular table is causing any issues moving forwards with the upgrade.
Do please keep a copy though so that perhaps something can be figured out to maybe help more in the future.
Thank you. I'll message you shortly. How likely do you think this drop will affect future installations?
-
Re: Some issues when upgrading
Quote:
Originally Posted by
muah
Thank you. I'll message you shortly. How likely do you think this drop will affect future installations?
One thing that does occur to me is that the previously installed Admin Profiles plugin should ideally be fully removed from your site. Looking at the last image you posted it seems that there are other tables present that are part of this plugin.
I don't know how easy this will be, especially as it was installed many years ago and that parts of the plugin might have been incorporated in to ZC core. Tread carefully, especially if you are working on a live site, and make sure you keep a copy of your files and database. There are uninstall instructions in the plugin's fileset.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
simon1066
One thing that does occur to me is that the previously installed Admin Profiles plugin should ideally be fully removed from your site. Looking at the last image you posted it seems that there are other tables present that are part of this plugin.
I don't know how easy this will be, especially as it was installed many years ago and that parts of the plugin might have been incorporated in to ZC core. Tread carefully, especially if you are working on a live site, and make sure you keep a copy of your files and database. There are uninstall instructions in the plugin's fileset.
I should say that I'm not familiar with this plugin, so don't know whether leaving it partially installed will have any adverse effects. If it was me I would want it gone.
-
Re: Some issues when upgrading
Quote:
Originally Posted by
simon1066
One thing that does occur to me is that the previously installed Admin Profiles plugin should ideally be fully removed from your site. Looking at the last image you posted it seems that there are other tables present that are part of this plugin.
I don't know how easy this will be, especially as it was installed many years ago and that parts of the plugin might have been incorporated in to ZC core. Tread carefully, especially if you are working on a live site, and make sure you keep a copy of your files and database. There are uninstall instructions in the plugin's fileset.
I dropped the table shortly after you posted... well, we'll see what happens. I'll forego doing so on the second site. My two cents is... it was not hurting anything leave it and keep making money. now i'm concerned about the ramifications.
