Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,666
    Plugin Contributions
    123

    Default Show Customer Time [support thread]

    Show Customer Time displays the current time at your customer's primary address on the customers screen and the order details screen. This way you can be sure not to call them when it's too late or too early.

    It is available in the plugins area at
    https://www.zen-cart.com/downloads.php?do=file&id=2205
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  2. #2
    Join Date
    Jul 2013
    Location
    Brisbane, Australia
    Posts
    39
    Plugin Contributions
    0

    Default Re: Show Customer Time support thread

    Hi swguy. Thanks very much for working on this plugin. It would be a very useful tool in this truly global marketplace. I hit a snag at step 1 in your instructions while uploading the SQL file and unfortunately don't know enough about SQL to resolve the problem. 1st attempt (upload the file) resulted in an error message: Error: Nothing to do - no query or query-file specified. I then tried various other combinations of uploading the code itself into the Admin SQL window (e.g. full code and parts thereof). The only success I had was by loading lines 22-38 of the file which successfully created the new DB table - but I couldn't get any further to populate it.

    Not sure if I broke some fundamental SQL rules by splitting up the code between the commented out SQL lines - but thought I'd give it a go since I took a backup. Can you help please?

    My system: WAMP (local - not live yet); ZC1.5.5e, Responsive Sheffield Blue template upgraded to be compatible with 1.5.5e - and a wide range of other plugins.

    Thanks again for this and your other Zen contributions. You've been a fantastic help for me - and many others, I'm sure!

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,666
    Plugin Contributions
    123

    Default Re: Show Customer Time support thread

    When you got "Error: Nothing to do - no query or query-file specified. " you probably just cancelled the file selection popup instead of selecting the file. You really want to do it that way instead of chopping up the file - try this again. Admin-Tools-Install SQL Patches, select the file, click Open in the file selection Dialog, then click Upload in your Zen Admin.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  4. #4
    Join Date
    Jul 2013
    Location
    Brisbane, Australia
    Posts
    39
    Plugin Contributions
    0

    Default Re: Show Customer Time support thread

    Thanks for replying. I tried it again without success (and several times yesterday). The following message was displayed before I pressed the upload button: Attachment 17933Same message resulted: "Error: Nothing to do - no query or query-file specified." The WAMP version I'm using has MySQL v5.7.14, Apache v2.4.23 and PHP v5.6.25.

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,666
    Plugin Contributions
    123

    Default Re: Show Customer Time support thread

    No idea. Maybe you can get this to work if load it in phpMyAdmin. I use MAMP and it works fine.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  6. #6
    Join Date
    Jul 2013
    Location
    Brisbane, Australia
    Posts
    39
    Plugin Contributions
    0

    Default Re: Show Customer Time support thread

    OK. I gave that a try. I uploaded the file's full content into phpMyAdmin (via cut & paste from Notepad++). There was a warning beside line 1:"Linting is disabled for this query because it exceeds the maximum length."
    Attachment 17934
    And when I pressed go, it shows the "loading" bar but doesn't do anything else. Waited 20min to be sure. Had to close down the browser to get out of the loop.

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. Login as Customer module [Support Thread]
    By vmmeup in forum Addon Admin Tools
    Replies: 240
    Last Post: 29 Apr 2021, 04:47 PM
  3. v150 Admin New Customer [Support Thread]
    By lhungil in forum All Other Contributions/Addons
    Replies: 34
    Last Post: 4 Nov 2016, 06:20 AM
  4. Time Zone Fix Support Thread
    By gilby in forum All Other Contributions/Addons
    Replies: 82
    Last Post: 9 Jan 2016, 12:25 AM
  5. v150 Minimum Customer Account Information - Support Thread
    By lat9 in forum All Other Contributions/Addons
    Replies: 87
    Last Post: 30 Nov 2015, 04:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR