Thread: Template help

Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2021
    Posts
    3
    Plugin Contributions
    0

    Default Template help

    I've installed 1.5.6c zencart, Server php version 7.3.23, everything is fine. Then upon install my theme I'm unable to view login page.

    I'm receiving Error log)
    Code:
    PHP Fatal error: 1292:Incorrect datetime value: 'NOW()' for column 'last_modified' at row 1 :: INSERT INTO zc_configuration SET  configuration_key="ZEN_LIGHTBOX_STATUS", configuration_title="<b>Zen Lightbox</b>", configuration_value="true", configuration_description="<br />If true, all product images on the following pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- page (EZ-Pages)<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br /><b>Default: true</b>", sort_order="100", use_function="NULL", set_function="zen_cfg_select_option(array(\'true\', \'false\'), ", last_modified="NOW()", date_added="NOW()", configuration_group_id="37" ==> (as called by) /public_html/my_admin/includes/installers/zen_lightbox/1_7_0.php on line 295 <== in /public_html/includes/classes/db/mysql/query_factory.php on line 171.
    is it fixable? How can I recorrect this if any help please?

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,271
    Plugin Contributions
    78

    Default Re: Template help

    Change line 295 of /my_admin/includes/installers/zen_lightbox/1_7_0.php, modifying those uppercase NOW() characters to be lowercase now().

    Then change the name of your admin directory, since you've posted it publicly.

  3. #3
    Join Date
    Feb 2021
    Posts
    3
    Plugin Contributions
    0

    Default Re: Template help

    Quote Originally Posted by lat9 View Post
    Change line 295 of /my_admin/includes/installers/zen_lightbox/1_7_0.php, modifying those uppercase NOW() characters to be lowercase now(). Then change the name of your admin directory.
    Thank you, I've changed it but still no improve

    Admin page displaying below error message
    Code:
    1292 Incorrect datetime value: 'now()' for column 'last_modified' at row 1
    in:
    [INSERT INTO configuration SET configuration_key="ZEN_LIGHTBOX_STATUS", configuration_title="Zen Lightbox", configuration_value="true", configuration_description="
    If true, all product images on the following pages will be displayed within a lightbox:
    
    - document_general_info
    - document_product_info
    - page (EZ-Pages)
    - product_free_shipping_info
    - product_info
    - product_music_info
    - product_reviews
    - product_reviews_info
    - product_reviews_write
    
    Default: true", sort_order="100", use_function="null", set_function="zen_cfg_select_option(array(\'true\', \'false\'), ", last_modified="now()", date_added="now()", configuration_group_id="40"]
    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.
    log file have some
    Code:
    PHP Warning: Use of undefined constant IH_VERSION - assumed 'IH_VERSION' (this will throw an Error in a future version of PHP)
    and
    Code:
    require(/home//public_html/my_admin/includes/application_top.php) called at [/home//public_html/my_admin/login.php:9]
    --> PHP Fatal error: 1292:Incorrect datetime value: 'now()' for column 'last_modified' at row 1 :: INSERT INTO configuration SET  configuration_key="ZEN_LIGHTBOX_STATUS", configuration_title="<b>Zen Lightbox</b>", configuration_value="true", configuration_description="<br />If true, all product images on the following pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- page (EZ-Pages)<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br /><b>Default: true</b>", sort_order="100", use_function="null", set_function="zen_cfg_select_option(array(\'true\', \'false\'), ", last_modified="now()", date_added="now()", configuration_group_id="40" ==> (as called by) /home//public_html/my_admin/includes/installers/zen_lightbox/1_7_0.php on line 295 <== in /home//public_html/includes/classes/db/mysql/query_factory.php on line 171.
    I guess lightbox failing all these and it's combined within template

  4. #4
    Join Date
    Feb 2021
    Posts
    3
    Plugin Contributions
    0

    Default Re: Template help

    There was long IH Version issue, this one I've solved. I found IMAGE HANDLER file and uploaded files to regarding folders and IH version issue removed.

    I don't have any issue on catalog-MAIN page.
    But I cannot display admin login page to key in admin details. Below error displayed instead of login

    Code:
    1292 Incorrect datetime value: 'now()' for column 'last_modified' at row 1
    in:
    [INSERT INTO configuration SET configuration_key="ZEN_LIGHTBOX_STATUS", configuration_title="Zen Lightbox", configuration_value="true", configuration_description="
    If true, all product images on the following pages will be displayed within a lightbox:
    
    - document_general_info
    - document_product_info
    - page (EZ-Pages)
    - product_free_shipping_info
    - product_info
    - product_music_info
    - product_reviews
    - product_reviews_info
    - product_reviews_write
    
    Default: true", sort_order="100", use_function="null", set_function="zen_cfg_select_option(array(\'true\', \'false\'), ", last_modified="now()", date_added="now()", configuration_group_id="40"]
    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.

  5. #5
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,889
    Plugin Contributions
    6

    Default Re: Template help

    Quote Originally Posted by lat9 View Post
    Change line 295 of /wj00txrbplmrdywo/includes/installers/zen_lightbox/1_7_0.php, modifying those uppercase NOW() characters to be lowercase now(). Then change the name of your admin directory.
    i think the problem is with the quotes around the now(), not the uppercase.

    i can not find that file, so hard to recommend the solution.
    #getAJabWhenYouCan
    if you feel so inclined, feel free to send some cake....

  6. #6
    Join Date
    Jan 2004
    Posts
    66,263
    Blog Entries
    7
    Plugin Contributions
    270

    Default Re: Template help

    Quote Originally Posted by carlwhat View Post
    i think the problem is with the quotes around the now(), not the uppercase.
    That is correct.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Jul 2012
    Posts
    15,653
    Plugin Contributions
    17

    Default Re: Template help

    Quote Originally Posted by carlwhat View Post
    i think the problem is with the quotes around the now(), not the uppercase.

    i can not find that file, so hard to recommend the solution.
    FYI and likely will become obvious, but the "same problem" will occur after modifying that for the reported instance of 'last_modified' when it then tries to process 'date_added'. Meaning make the same change (quote removal) to 'date_added' as is done/suggested for 'last_modified'.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. Replies: 8
    Last Post: 29 Apr 2011, 07:53 PM
  2. Purchased template from Template Monster ... need help.
    By dragonimpact in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 16 Nov 2010, 04:07 PM
  3. Template Coding / CSS template location help please?
    By ttac in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 16 Jun 2010, 06:37 AM
  4. Need help modifying a Template Monster template
    By liquidpictures in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 5 Oct 2007, 05:59 PM
  5. Help About New Template Install Please Help
    By mboley370 in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 25 Jun 2007, 06:52 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