Winchester Responsive

[videoseconds]

I am using zen cart v1.5.5f I upgraded, many times since long ago. I did it using filezilla sftp.
I am using your great template v1.4
I have only 1 plugin for creating sitemap.
PHP Version: 7.0.32 (Zend: 3.0.0)
PHP File Uploads: On
Upload Max Size: 64M
PHP Memory Limit: 90M
POST Max Size: 65M
Database: MySQL 5.6.34-log
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: /dh/mysql/logs/mysql.oesterle.slow
MySQL Mode: NO_ENGINE_SUBSTITUTION

Something is wrong with doing search.
https://www.videoseconds.com/shop/ is the url for the shop.
When trying a search it gets and error and gives a login/register page instead. I tried this will 3 different themes, including the original theme, and they all do the same thing. Driving me nuts.
Here is the error from log file:

[28-Aug-2018 04:10:33 America/Los_Angeles] Request URI: /shop/index.php?main_page=advanced_search_result&search_in_description=1&keyword=david, IP address: 83.42.74.216
#1  trigger_error() called at [/home/**** domain name ****/shop/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/**** domain name ****/shop/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/**** domain name ****/shop/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/**** domain name ****/shop/includes/classes/split_page_results.php:78]
#5  splitPageResults->__construct() called at [/home/**** domain name ****/shop/includes/modules/winchester_responsive/product_listing.php:35]
#6  include(/home/**** domain name ****/shop/includes/modules/winchester_responsive/product_listing.php) called at [/home/**** domain name ****/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php:14]
#7  require(/home/**** domain name ****/shop/includes/templates/winchester_responsive/templates/tpl_modules_product_listing.php) called at [/home/**** domain name ****/shop/includes/templates/winchester_responsive/templates/tpl_advanced_search_result_default.php:49]
#8  require(/home/**** domain name ****/shop/includes/templates/winchester_responsive/templates/tpl_advanced_search_result_default.php) called at [/home/**** domain name ****/shop/includes/templates/winchester_responsive/common/tpl_main_page.php:252]
#9  require(/home/**** domain name ****/shop/includes/templates/winchester_responsive/common/tpl_main_page.php) called at [/home/**** domain name ****/shop/index.php:97]

[28-Aug-2018 04:10:33 America/Los_Angeles] PHP Fatal error:  1109:Unknown table 'p' in field list :: select count(p.products_id) as total  ==> (as called by) /home/**** domain name ****/shop/includes/classes/split_page_results.php on line 78 <== in /home/**** domain name ****/shop/includes/classes/db/mysql/query_factory.php on line 171

I somehow do not thing this is to do with the theme as trying other themes does not make the search work.
PLEASE HELP???

[drm1963]

Check

Configuration / Customer Details

Look under: Customer Shop Status - View Shop and Prices

We have ours set to 0:

See what you have checked?

Customer must be approved to shop
0= Not required
1= Must login to browse
2= May browse but no prices unless logged in
3= Showroom Only

[videoseconds]

It is set to 0

Thank you, but it is not the fix. I think it will be more difficult.

[drm1963]

So you only have Zen Cart 155f installed, 1 Sitemap plugin and 1 Template Winchester Responsive Version 1.4

Server set ups are almost identical " I also run a test server on a local pc for testing purposes but identical to my Real Shop!

Our Server
PHP Version: 7.0.32 (Zend: 3.0.0)
PHP File Uploads: On
Upload Max Size: 128M
PHP Memory Limit: 768M
POST Max Size: 128M
Database: MySQL 5.6.40-84.0-log
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: /var/lib/mysql/mysql-slow.log
MySQL Mode: NO_ENGINE_SUBSTITUTION

Your server
PHP Version: 7.0.32 (Zend: 3.0.0)
PHP File Uploads: On
Upload Max Size: 64M
PHP Memory Limit: 90M
POST Max Size: 65M
Database: MySQL 5.6.34-log
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: /dh/mysql/logs/mysql.oesterle.slow
MySQL Mode: NO_ENGINE_SUBSTITUTION

When was the last time you did a fresh install of Zen Cart 155f not an update or anything but a full fresh install?

[videoseconds]

So you only have Zen Cart 155f installed, 1 Sitemap plugin and 1 Template Winchester Responsive Version 1.4

When was the last time you did a fresh install of Zen Cart 155f not an update or anything but a full fresh install?

Maybe 2015?

Now you are talking the other extreme. So much work. I have started it making a secondary store and, of course, it is a lot of work and will take at least a day if not more. But, of course, it is worth it if it solves the issue. I wish it was as simple as the first response, but it never is so easy. Over the years of upgrades it just may be a file missed on upgrade. I had that thought but the fear of all the time to recreate a zen installation kept me from trying this. I guess as I wait for any other solution I will create a second store from a fresh copy of zen. I am just confused if I can use the old database and upgrade, make a new one and restore the old into it, or what? I guess I may be beyond the remit of the theme remit at this point.

[drm1963]

I think I sent you a PM. PM me back to let me know you did get it or let me know here if you did not and I will do what i can to assist you with an easy test installation.

[swguy]

...

Something is wrong with doing search.

Check the file includes/modules/pages/advanced_search_result/header_php.php

against a fresh download of 1.5.5f.

[videoseconds]

Check the file includes/modules/pages/advanced_search_result/header_php.php

against a fresh download of 1.5.5f.

You are a genius! Thank you so much! That solved the problem! Search now works. Guess I missed some upgrade file, try as I might to make them all work, long ago. Wonder what else I missed.

Thanks again! Very much!
Rick

[swguy]

You are a genius!

Finally, someone with taste and discernment. :)

[videoseconds]

OK, thanks for the help on the search function to all!
Now the reason I came on to troubleshoot the site is really that google mobile reports that the site has three grave problems with the display. Clickables too close, incompatible plugins, and too wide for screen. Their mobile friendly test page shows the site very ugly and the links are all you see, piled up on one another. This is not what it should be like.
So,
I figure the template is fine and there must be some mobile detect issue or how zen responds to mobile that craps out the theme. ANY HELP PLEASE????