Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19
  1. #11
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,319
    Plugin Contributions
    99

    Default Re: no list of define pages in admin

    Sorry, this assumed you were using a prefix of "zen_". If you don't have a prefix on your table names just say

    SELECT configuration_key, configuration_group_id FROM configuration WHERE configuration_key like 'DEFINE_%_STATUS';
    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.

  2. #12
    Join Date
    Feb 2009
    Location
    UK
    Posts
    775
    Plugin Contributions
    0

    Default Re: no list of define pages in admin

    Quote Originally Posted by Mocca View Post
    Ok google said click SQL, so I typed all that in, wont let you cut n paste I hit go and this came up:

    #1146 - Table 'sonicart_*****.zen_configuration' doesn't exist
    For the future, Ctrl+v will paste into the SQL query box.
    Simon

  3. #13
    Join Date
    Mar 2010
    Posts
    37
    Plugin Contributions
    0

    Default Re: no list of define pages in admin

    Same result, the ***** is replacing the real db tag as I am sure you guessed.
    #1146 - Table 'sonicart_*****.configuration' doesn't exist.


    Ahh ok, you mean zen is in front of all the files, mine has 4 letters in front, auto generated I guess during install and setup.

    So I entered them instead of "zen" in your original string, and what comes up is:

    DEFINE_BREADCRUMB_STATUS
    DEFINE_PAGE_NOT_FOUND_STATUS

    Configuration group ID, 19 & 25 respectively.
    Last edited by Mocca; 17 Jul 2020 at 01:56 PM.

  4. #14
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,319
    Plugin Contributions
    99

    Default Re: no list of define pages in admin

    OK so these values have simply been deleted from your database. You need to add them back in.

    You may want to compare your database to a default fresh 1.5.7 installation to see what else is missing.

    I have commented out page not found because you already have that one.

    Code:
    #Define Page Status
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Main Page Status', 'DEFINE_MAIN_PAGE_STATUS', '1', 'Enable the Defined Main Page Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '60', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Contact Us Status', 'DEFINE_CONTACT_US_STATUS', '1', 'Enable the Defined Contact Us Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '61', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Privacy Status', 'DEFINE_PRIVACY_STATUS', '1', 'Enable the Defined Privacy Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '62', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Shipping & Returns', 'DEFINE_SHIPPINGINFO_STATUS', '1', 'Enable the Defined Shipping & Returns Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '63', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Conditions of Use', 'DEFINE_CONDITIONS_STATUS', '1', 'Enable the Defined Conditions of Use Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '64', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Checkout Success', 'DEFINE_CHECKOUT_SUCCESS_STATUS', '1', 'Enable the Defined Checkout Success Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '65', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Discount Coupon', 'DEFINE_DISCOUNT_COUPON_STATUS', '1', 'Enable the Defined Discount Coupon Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '66', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Site Map Status', 'DEFINE_SITE_MAP_STATUS', '1', 'Enable the Defined Site Map Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '67', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    # INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Page-Not-Found Status', 'DEFINE_PAGE_NOT_FOUND_STATUS', '1', 'Enable the Defined Page-Not-Found Text from define-pages?<br />0= Define Text OFF<br />1= Define Text ON', '25', '67', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Page 2', 'DEFINE_PAGE_2_STATUS', '1', 'Enable the Defined Page 2 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '82', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Page 3', 'DEFINE_PAGE_3_STATUS', '1', 'Enable the Defined Page 3 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '83', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Define Page 4', 'DEFINE_PAGE_4_STATUS', '1', 'Enable the Defined Page 4 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '84', now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');
    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.

  5. #15
    Join Date
    Mar 2010
    Posts
    37
    Plugin Contributions
    0

    Default Re: no list of define pages in admin

    Thank you for your time on this, am learning as I go. So where do I add this in, into the myphp admin area? and which file?

  6. #16
    Join Date
    Mar 2010
    Posts
    37
    Plugin Contributions
    0

    Default Re: no list of define pages in admin

    Its ok I figured it out, go into ADMIN>tools> "install SQL patches."
    Past the entire code you posted in and send, hold your breath, open configuration>"define page status" and bingo the pages are there!

    Much appreciated, I wonder why they were missing in the install, I will go through the 1.5.7 I loaded from a zencart.com download and compare to my current files.

  7. #17
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,319
    Plugin Contributions
    99

    Default Re: no list of define pages in admin

    It's not so much the files as the database content you want to check.
    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.

  8. #18
    Join Date
    Mar 2010
    Posts
    37
    Plugin Contributions
    0

    Default Re: no list of define pages in admin

    I will google how to do this tomorrow, thanks again for the help, hopefully this will come up in a search for someone else in the future.

  9. #19
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,319
    Plugin Contributions
    99

    Default Re: no list of define pages in admin

    Two options:
    1. create a new database by running zc_install, then run a query like

    SELECT configuration_key FROM configuration;

    and export as CSV, then do the same thing on your database, then compare.


    2. Walk through the menus in your admin > configuration screen and compare to
    https://docs.zen-cart.com/user/admin...configuration/
    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.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Add to config define pages admin list
    By gwmbox in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 10 Jun 2009, 05:36 AM
  2. Incomplete Page List in Define Pages Editor
    By krazykev in forum Basic Configuration
    Replies: 5
    Last Post: 22 Feb 2009, 11:49 AM

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