Zen Cart Logo
Forums / Customization from the Admin / Admin Customer Details - No Edit Button

Admin Customer Details - No Edit Button

Views: 6,609

Results 1 to 20 of 22
28 Nov 2022, 04:22
#1
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Admin Customer Details - No Edit Button

I am in the process of upgrading to version 1.5.8.

Configuration, Customer Details page does not have an edit button. Confguration, MY Store does have an edit button.

Can anybody tell me why the edit button is missing and how I can get it back please.

I have attached a screen shot of the Customer Details page with no edit button.

28 Nov 2022, 07:45
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Admin Customer Details - No Edit Button

Need to provide more accurate details to minimize unnecessary research. Say that "in the middle" of an upgrade. How much in the middle is the store at which this condition is observed?

Further, when say MY store has this feature or another, what version is the store from which upgrading?

These are things requested to be provided when making the first post about an issue. They make the problem solving that much easier which means you get an answer that much faster and your business can make that much more money.

There are other things to look into even with a little information as had been provided, but issues with a new version should get well documented before skipping to other things.

28 Nov 2022, 08:58
#3
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

[QUOTE=mc12345678;1391781]Need to provide more accurate details to minimize unnecessary research. Say that "in the middle" of an upgrade. How much in the middle is the store at which this condition is observed?

By in the middle I mean I am slowly adding my custom folders and updating settings in Admin.

Further, when say MY store has this feature or another, what version is the store from which upgrading?

The My Store is still the new version 1.5.8. In Admin if I go Configuration, My Store, I have an edit button. If I then go to Customer Details there is no edit button. So 1.5.8 has an edit button on some pages but not other pages.

My actual store is still running version 1.5.7d The new version 1.5.8 is in a subfolder and it will remain there until I am sure it is all ready to go live as my new store.

I have no issues with version 1.5.7d. As far as I know the only issue I have with 1.5.8 is the edit button missing on one page in Admin. I don't understand why the edit button is showing on other admin pages but not on the Customer Detail pages..

I hope I have explained myself clearly enough. I am not good at working out this kind of problem. I try but I find a lot of it very difficult, so I came here to ask for help.

Thanks for your time.

28 Nov 2022, 09:14
#4
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,760
Plugin Contributions:
9

Re: Admin Customer Details - No Edit Button

First of all, go to Admin >> Modules >> Plugin Manager and make sure your Display Logs is Installed.

If it is already installed, you should have gotten an indication of the problem.

Something on the Customers' Details page is failing which causes a partial blank page. That's why you do not see the edit.

28 Nov 2022, 09:39
#5
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

Thank you! I have downloaded my logs and I will slowing try to work out what is wrong.

I appreciate your help.

28 Nov 2022, 11:44
#6
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

You're experiencing a "partial whitescreen", the the "Display Logs" plugin will definitely have some stuff to tell you because there's a PHP and/or MySQL issue going on.

28 Nov 2022, 11:54
#7
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

lat9:

You're experiencing a "partial whitescreen", the the "Display Logs" plugin will definitely have some stuff to tell you because there's a PHP and/or MySQL issue going on.

in Admin version 1.5.8 all of the listings in Configuration have an edit box except for Customers Details page

I have downloaded the log files and the errors I am looking at are not files I have touched. I haven't customized these files ever.

[28-Nov-2022 11:15:26 UTC] PHP Fatal error: Uncaught TypeError:
Argument 1 passed to zen_get_countries() must be of the type int, string given, called in
/includes/functions/functions_addresses.php on line 100 and
defined in /includes/functions/functions_addresses.php:50

Stack trace:
#0 /includes/functions/functions_addresses.php(100): zen_get_countries('', false, true)
#1 /admin/includes/functions/general.php(439): zen_get_country_name('')
#2 //admin/configuration.php(145): zen_call_function('zen_get_country...', '')
#3 /admin/index.php(11): require('/home/www/ksp-x...')
#4 {main}
thrown in /includes/functions/functions_addresses.php on line 50

I've look at these files but I don't understand the error even though it gives me the line numbers.

Maybe I should delete everything and do another fresh install because I'm lost.

Time to close up for the night. Thanks again for your help.

28 Nov 2022, 17:34
#8
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

What's the Zen Cart history of the site, specifically from which version of Zen Cart is the site being upgraded?

If you include the top portion of that log (where the specific page on which the error occurred), that would help immensely. Just be sure to xxx-out the site's URL and especially your admin sub-directory name. It's just the portion of the URL starting with **cmd= **that will help us help you.

29 Nov 2022, 08:43
#9
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

lat9:

What's the Zen Cart history of the site, specifically from which version of Zen Cart is the site being upgraded?

I started with Zen Cart version 3 something. I have upgraded each time my Admin home page told me there was a new version.

If you include the top portion of that log (where the specific page on which the error occurred), that would help immensely. Just be sure to xxx-out the site's URL and especially your admin sub-directory name. It's just the portion of the URL starting with **cmd= **that will help us help you.

I hope this is the part of the log you requested.
[28-Nov-2022 11:15:26 UTC] Request URI: /zc_Test/admin/index.php?cmd=configuration&gID=5, IP address: 58.6.171.68

I have a friend trying to help me and she has found if we put the new empty database back, the edit button appears in the Customer Details in the Configuration in Admin. Then if we import my current database to the new version of Zen Cart, the edit button vanishes from the Customers Details in Admin. The strange thing is all the other pages in Configuration have edit buttons. So I'd guess something in my database is breaking that edit button.

My friend is now trying to work out why my imported database is causing this issue. I've never had this database problem upgrading before.

Again, thanks for your help.

29 Nov 2022, 09:12
#10
brittainmark avatar

brittainmark

Totally Zenned

Join Date:
Apr 2009
Posts:
507
Plugin Contributions:
1

Re: Admin Customer Details - No Edit Button

Did you load the database, then run zc_install to update the database? If not, that could be the issue.

29 Nov 2022, 09:20
#11
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

Spinach:

I hope this is the part of the log you requested.
[28-Nov-2022 11:15:26 UTC] Request URI: /zc_Test/admin/index.php?cmd=configuration&gID=5, IP address: 58.6.171.68

I have a friend trying to help me and she has found if we put the new empty database back, the edit button appears in the Customer Details in the Configuration in Admin. Then if we import my current database to the new version of Zen Cart, the edit button vanishes from the Customers Details in Admin. The strange thing is all the other pages in Configuration have edit buttons. So I'd guess something in my database is breaking that edit button.

My friend is now trying to work out why my imported database is causing this issue. I've never had this database problem upgrading before.

Again, thanks for your help.
Yes, that helps. From the log you posted above, it appeared that (for whatever reason) your database's "Create Account Default Country" was an empty string instead of a numeric value and I reproduced the error you posted by changing my test site's value to an empty string!

You can correct your issue by going to the admin's Tools :: Install SQL Patches and entering the following to set that country default to Australia:

UPDATE configuration SET configuration_value = '13' WHERE configuration_key = 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY' LIMIT 1;

P.S. I have no idea how that empty value has worked for so long!

29 Nov 2022, 19:09
#12
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

I can't remember the exact version of Zen Cart we started with. Our shop has been online 19 years and I guess we started using Zen Cart for about 17 years now.

On the live store, I am running Zen Cart Version 1.5.7d.

On what I'm calling the 'Test store', I am upgrading to version 1.5.8.

After importing the live store database into the 'test store' database, I ran Zen Cart install to upgrade the database. I have the following error log:

cmd=configuration&gID=5, IP address: 58.6.171.68
--> PHP Fatal error: Uncaught TypeError: Argument 1 passed to zen_get_countries() must be of the type int, string given, called in /home/www/xxx.com/xxxx/includes/functions/functions_addresses.php on line 100 and defined in /home/www/xxxx.com/xxxx/includes/functions/functions_addresses.php:50

As already stated, the edit button is missing in 'customer details' on the 'test store' after importing the live site database, but all other edit buttons are there in admin.

On the live site in 'customer details' the edit button is there, and there are no errors on the 'live store'.

Thank you again for any help.

29 Nov 2022, 19:39
#13
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,760
Plugin Contributions:
9

Re: Admin Customer Details - No Edit Button

Ran into the same problem on a current upgrade from 1.5.1 to 1.5.8.

The solution for the countries problem is:

***BACKUP

***Dump a sql of the countries table created by the zc_install for 1.5.8 ( you can pull it out of the mysql_zencart.sql starting at line 408 thru 419 for the table design.)

Delete the countries table brought in from the old database

Insert the table and data created by the 1.5.8

run zc_install to update.

OR.... If your database has a prefix

  1. Using phpMyAdmin, open the 1.5.8 created table in phpMyAdmin
  2. click on Export in the top Menu Bar
  3. Choose the Custom Export Method
  4. Select Structure and Data for the countries table
  5. Choose your desired Output (It should be set for Save)
  6. Scroll down and Click on the go button
  7. Make sure the Old database has been imported to your site
  8. Open your admin >> Tools >> Install SQL Patches
  9. Choose File gto bring in your saved countries table
  10. Click on Upload
  11. Run zc_install and the database should upgrade.

did I mention....

BACKUP

29 Nov 2022, 19:44
#14
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

Spinach:

I can't remember the exact version of Zen Cart we started with. Our shop has been online 19 years and I guess we started using Zen Cart for about 17 years now.

On the live store, I am running Zen Cart Version 1.5.7d.

On what I'm calling the 'Test store', I am upgrading to version 1.5.8.

After importing the live store database into the 'test store' database, I ran Zen Cart install to upgrade the database. I have the following error log:

cmd=configuration&gID=5, IP address: 58.6.171.68
--> PHP Fatal error: Uncaught TypeError: Argument 1 passed to zen_get_countries() must be of the type int, string given, called in /home/www/xxx.com/xxxx/includes/functions/functions_addresses.php on line 100 and defined in /home/www/xxxx.com/xxxx/includes/functions/functions_addresses.php:50

As already stated, the edit button is missing in 'customer details' on the 'test store' after importing the live site database, but all other edit buttons are there in admin.

On the live site in 'customer details' the edit button is there, and there are no errors on the 'live store'.

Thank you again for any help.
You're not "listening"; did you try performing that "Install SQL Patches" suggestion that I posted above?

29 Nov 2022, 19:45
#15
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,760
Plugin Contributions:
9

Re: Admin Customer Details - No Edit Button

Not finding where the actual 1.5.8 countries table data is inserted but you probably have a copy somewhere of what the 1.5.8 install created.

30 Nov 2022, 10:11
#16
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

brittainmark:

Did you load the database, then run zc_install to update the database? If not, that could be the issue.

She did that but it didn't fix anything.

30 Nov 2022, 10:17
#17
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

dbltoe:

Not finding where the actual 1.5.8 countries table data is inserted but you probably have a copy somewhere of what the 1.5.8 install created.

We are just about ready to give up on it. I know absolutely nothing about databases. It is all beyond me. I'm 64 years young but this is testing my patience. Thank you all, for your help.

30 Nov 2022, 11:31
#18
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,682
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

Upgrading is difficult; you might need to hire a pro to take care of this for you.

30 Nov 2022, 12:32
#19
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Admin Customer Details - No Edit Button

lat9:

Yes, that helps. From the log you posted above, it appeared that (for whatever reason) your database's "Create Account Default Country" was an empty string instead of a numeric value and I reproduced the error you posted by changing my test site's value to an empty string!

You can correct your issue by going to the admin's Tools :: Install SQL Patches and entering the following to set that country default to Australia:

UPDATE configuration SET configuration_value = '13' WHERE configuration_key = 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY' LIMIT 1;

> P.S. I have no idea how that empty value has worked for so long!

> **Spinach:**
>
> We are just about ready to give up on it.  I know absolutely nothing about databases.  It is all beyond me.  I'm 64 years young but this is testing my patience.  Thank you all, for your help.
**Again**, did you apply the SQL patch that I'd previously suggested?
30 Nov 2022, 12:34
#20
spinach avatar

spinach

New Zenner

Join Date:
Jun 2018
Location:
Canberra Australia
Posts:
21
Plugin Contributions:
0

Re: Admin Customer Details - No Edit Button

You can correct your issue by going to the admin's Tools :: Install SQL Patches and entering the following to set that country default to Australia:
Code:
UPDATE configuration SET configuration_value = '13' WHERE configuration_key = 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY' LIMIT 1;

My friend just tried the above code and it worked!

We want to thank you all for your help it really was appreciated.