No category pages

**slater555** · 31 Jan 2018, 08:38 AM

found a place to turn off the uri mapping. all seems to be working now. thanks for the advice.

**mc12345678** · 31 Jan 2018, 03:51 PM

Originally Posted by slater555

close enough. have read my debug files and the problem is the ceon uri mapping. if I just delete all the files from that my whole site disappears. So how do I disable it or 'turn it off'?
here is a debug file: (sorry was trying to get it in quotes
here it is:

Code:

[31-Jan-2018 00:59:29 America/Chicago] Request URI: /airtight-next/, IP address: 75.82.198.67
#1  in_array() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingHREFLinkBuilder.php:230]
#2  CeonURIMappingHREFLinkBuilder->buildHREFLink() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/functions/html_output.php:49]
#3  zen_href_link() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php:558]
#4  include_once(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php:60]
#5  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php:48]
#6  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php:170]
#7  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/index.php:26]

[31-Jan-2018 00:59:29 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingHREFLinkBuilder.php on line 230
[31-Jan-2018 00:59:29 America/Chicago] Request URI: /airtight-next/, IP address: 75.82.198.67
#1  in_array() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingHREFLinkBuilder.php:231]
#2  CeonURIMappingHREFLinkBuilder->buildHREFLink() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/functions/html_output.php:49]
#3  zen_href_link() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php:558]
#4  include_once(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php:60]
#5  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php:48]
#6  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php:170]
#7  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/index.php:26]

[31-Jan-2018 00:59:29 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingHREFLinkBuilder.php on line 231
[31-Jan-2018 00:59:29 America/Chicago] Request URI: /airtight-next/, IP address: 75.82.198.67
#1  trigger_error() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingDBLookup.php:166]
#5  CeonURIMappingDBLookup->getURIMappingsResultset() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingHREFLinkBuilder.php:326]
#6  CeonURIMappingHREFLinkBuilder->buildHREFLink() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/functions/html_output.php:49]
#7  zen_href_link() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php:558]
#8  include_once(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/languages/responsive_classic/english.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php:60]
#9  require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/init_includes/init_templates.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php:48]
#10 require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/autoload_func.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php:170]
#11 require(/home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/application_top.php) called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/index.php:26]

[31-Jan-2018 00:59:29 America/Chicago] PHP Fatal error:  1146:Table 'slater_155_database.TABLE_CEON_URI_MAPPINGS' doesn't exist :: 
            SELECT
                uri
            FROM
                TABLE_CEON_URI_MAPPINGS
            WHERE
                    main_page = 'login'
AND
    associated_db_id IS NULL
AND
    query_string_parameters = ''
AND
    language_id = '1'
AND
    current_uri = '1'

LIMIT 1; ==> (as called by) /home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/class.CeonURIMappingDBLookup.php on line 166 <== in /home3/slater/public_html/airtightsecurityplus.com/airtight-next/includes/classes/db/mysql/query_factory.php on line 171

Primarily this is at least from an incomplete install (missing define for TABLE_CEON_URI_MAPPINGS) that will need to be corrected to support the final upgrade.

As to the link mapping issue(s) that carlwhat identified/pointed out, the database table contains the full path to be appended to HTTP_SERVER/HTTPS_SERVER. Because of the overall configuration of the airtight-next version, the URIs will "resolve" to the sub-directory of the old store unless the configure.php files are modified to consider the sub-directory as part of the domain name.

It is suggested that after other portions of the store have been upgraded/developed that prior to using the software of this store for your live store that Ceon URI Mapping be properly installed and tested. For your situation now that the live site database is present, I would suggest the test to be the following:
With Ceon URI Mapping active/enabled, create a new category and allow the URI to be auto-generated.
Create a new product in that new category, and allow the URI to be auto-generated.
From the catalog side of the store, attempt to access that new category (only as the other categories may/will direct elsewhere).
From the catalog side of the store, attempt to access the new product.
Again in the admin, create a new ez-page and a new manufacturer.
Add a product to the manufacturer option.
Access the catalog to access the new ez-page
Access the catalog to access the new manufacturer.

Check the logs directory along the route to see what if any errors are generated.

Again, the error(s) above stem from an incomplete installation as the file:
includes/extra_datafiles/ceon_uri_mapping_database_tables.php
appears to be missing and/or
YOUR_ADMIN/includes/extra_datafiles/ceon_uri_mapping_database_tables.php

The first few errors appear to be because either or both of the following files also were not loaded:
includes/extra_datafiles/ceon_uri_mapping_product_pages.php
YOUR_ADMIN/includes/extra_datafiles/ceon_uri_mapping_product_pages.php

**slater555** · 31 Jan 2018, 06:13 PM

What (if any) would be the most effective way to completely remove the ceon uri mapping mod. I of course know where every file that was loaded from the installation

**slater555** · 31 Jan 2018, 07:13 PM

what exactly is this telling me to do?

require_once() called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/555admin555/includes/classes/class.CeonURIMappingAdminCategoryPages.php:25]

I know where the page and line number is and when I go there (555admin555/includes/classes/class.CeonURIMappingAdminCategoryPages.php) this is line 25 (counting blank lines)

require_once(DIR_FS_CATALOG . DIR_WS_CLASSES . 'class.CeonURIMappingAdminCategories.php');

**mc12345678** · 31 Jan 2018, 08:01 PM

I don't understand the frame of reference (perspective). From what has been provided, the line isn't telling you personally to do anything. What the line is saying is that at line 25 of that file is a requirement (use of require instead of include) that the file referenced exists. If it does not then execution will stop at that line and an error will be reported.

What to be done with that information depends on what you are trying to do and ultimately (remember to think big picture) about what you plan to do.

Remember that generally those offering assistance are doing so from a perspective of previous experience either directly with the specific topic or an understanding of potential effects. If you're final goal is to not use Ceon URI Mapping or any uri rewriter, then it would be in the best interest of the active site to operate the site so that it properly responds to existing rewritten uris, but converts back to the ZC generated uris. Ceon URI Mapping can do that if so desired.

The problems seen though are related to the installation (method of most likely) or what seems to be not restoring the site back to a condition of pre-installation of the software.

**slater555** · 31 Jan 2018, 08:58 PM

Actually I would like to keep the ceon uli mapping. but I seem to have problems

you did notice that when
it called at [/home3/slater/public_html/airtightsecurityplus.com/airtight-next/555admin555/includes/classes/class.CeonURIMappingAdminCategoryPages.php:25]
when you go to that file and go to line 25 the file name is different than the one it calls for.
on line 25 the file name is <class.CeonURIMappingAdminCategories.php>
File ends one with categoryPages.php and the other is categories.php

where should that file be?

**mc12345678** · 31 Jan 2018, 10:11 PM

Forgive me, I didn't realize that the name discrepancy was a part of the issue/understanding.

So two concepts to consider here.
1) following the errors (that are discovered).
2) installing the files as originally provided and the instructions as written.

Right now, looks like chasing down the errors.

So: what was presented was the file and line number where an error was identified. Then the contents of the file and line were reviewed to identify this:

Code:

require_once(DIR_FS_CATALOG . DIR_WS_CLASSES . 'class.CeonURIMappingAdminCategories.php');

Since the error occurred from within the admin, the above defines (DIR_FS_CATALOG and DIR_WS_CATALOG) are associated to the initial load process of the admin side of the store. In ZC 1.5.5 that means to use any define that is in admin/includes/local/configure.php (if it exists), followed by the defines of admin/includes/configure.php (assigned if not previously defined), and then admin/includes/defined_paths.php to finish off the core defines that have not yet been defined.

In this situation of a typical (correctly setup) install, the system is expecting to find the file ending with categories in the store side includes/classes directory.