Error [MySQL]:Error 1054 : Unknown column 'ecommerce_item.title' in 'where clause'
SQL = [SELECT category.* FROM (category) WHERE category.ecommerce_active=1 AND category.in_disabled_category=0 AND ((ecommerce_item.title LIKE '%pitchfork%' AND ecommerce_item.title LIKE '%26%') OR (category.name LIKE '%pitchfork%' AND category.name LIKE '%26%')) ORDER BY category.left_node ASC]
[Backtrace] 0: file:/web/shop/includes/database/database.inc.php line:490 function:include -args: 2: file:/web/shop/includes/database/bs_table.class.php line:241 function:db_query -args: 0 = [SELECT category.* FROM (category) WHERE category.ecommerce_active=1 AND category.in_disabled_category=0 AND ((ecommerce_item.title LIKE '%pitchfork%' AND ecommerce_item.title LIKE '%26%') OR (category.name LIKE '%pitchfork%' AND category.name LIKE '%26%')) ORDER BY category.left_node ASC] 1 = [user] 3: file:/web/www/wordpress/wp-content/plugins/merchantos/merchantos.php line:192 function:loadSQL -args: 0 = [category] 1 = [SELECT category.* FROM (category) WHERE category.ecommerce_active=1 AND category.in_disabled_category=0 AND ((ecommerce_item.title LIKE '%pitchfork%' AND ecommerce_item.title LIKE '%26%') OR (category.name LIKE '%pitchfork%' AND category.name LIKE '%26%')) ORDER BY category.left_node ASC] 4: file:/web/www/wordpress/wp-content/plugins/merchantos/merchantos.php line:202 function:getCategories -args: 0 = [] 1 = [-1] 2 = [pitchfork 26] 3 = [] 5: file:/web/www/wordpress/wp-content/plugins/merchantos/pages/product_search.php line:12 function:getCategoriesFromSearch -args: 0 = [pitchfork 26] 6: file:/web/www/wordpress/wp-content/themes/mstore_modern/search.php line:9 function:require -args: 0 = [/web/www/wordpress/wp-content/plugins/merchantos/pages/product_search.php] 7: file:/web/www/wordpress/wp-includes/template-loader.php line:21 function:include -args: 0 = [/web/www/wordpress/wp-content/themes/mstore_modern/search.php] 8: file:/web/www/wordpress/wp-blog-header.php line:16 function:require_once -args: 0 = [/web/www/wordpress/wp-includes/template-loader.php] 9: file:/web/www/wordpress/index.php line:17 function:require -args: 0 = [/web/www/wordpress/wp-blog-header.php] [Session] modules = [] location_num = [] user_db = [cust25475] user_dbhost = [mylocaldb1] user_type = [0] authorized = [1] cust_user_id = [37920] owner = [1] cust_customer_id = [25475] full_catalog = [1] open_user_slots = [17] mantis_project_id = [] mantis_category = [] service_agree = [1] employee_id = [18] rights = [18] wordpress_url = [http://www.ghybikes.com/] wordpress_upload_url = [http://www.ghybikes.com/wp-content/uploads/25475/] employee_name = [Public Website] login_name = [sw1213_192] messages_off = [0] shop_id = [1] tax_rate = [0.000000000] shop_name = [G.H.Y. Bikes] service_rate = [60.00] tax_category_id = [1] tax_labor = [1] time_zone = [US/Pacific] default_payment_type_id = [1] industry_ids = ['1'] catalog_ids = ['1','3','4','5','10','13','14','15','16','20','21','22','28','29','31','38','42','58','61','1007','1010','1020','1023','1025','1034','1046','1093','1151','1180','1188','1194','1228','1230','1232','1240','1245','1247','1251','1255','1259','1267','1272','1300'] auto_needpin_delay = [0] auto_logout_delay = [60] smarty_assigned = [60] limit_to_shop_id = [0] multi_shop = [] num_shops = [1] transaction_id = [0] [Included Files] 0 = [/web/www/wordpress/index.php] 1 = [/web/www/wordpress/wp-blog-header.php] 2 = [/web/www/wordpress/wp-load.php] 3 = [/web/www/wordpress/wp-config.php] 4 = [/web/www/wordpress/wp-settings.php] 5 = [/web/www/wordpress/wp-includes/compat.php] 6 = [/web/www/wordpress/wp-includes/functions.php] 7 = [/web/www/wordpress/wp-includes/classes.php] 8 = [/web/www/wordpress/wp-includes/wp-db.php] 9 = [/web/www/wordpress/wp-includes/cache.php] 10 = [/web/www/wordpress/wp-includes/plugin.php] 11 = [/web/www/wordpress/wp-includes/default-filters.php] 12 = [/web/www/wordpress/wp-includes/pomo/mo.php] 13 = [/web/www/wordpress/wp-includes/pomo/translations.php] 14 = [/web/www/wordpress/wp-includes/pomo/entry.php] 15 = [/web/www/wordpress/wp-includes/pomo/streams.php] 16 = [/web/www/wordpress/wp-includes/l10n.php] 17 = [/web/www/wordpress/wp-includes/formatting.php] 18 = [/web/www/wordpress/wp-includes/capabilities.php] 19 = [/web/www/wordpress/wp-includes/query.php] 20 = [/web/www/wordpress/wp-includes/theme.php] 21 = [/web/www/wordpress/wp-includes/user.php] 22 = [/web/www/wordpress/wp-includes/meta.php] 23 = [/web/www/wordpress/wp-includes/general-template.php] 24 = [/web/www/wordpress/wp-includes/link-template.php] 25 = [/web/www/wordpress/wp-includes/author-template.php] 26 = [/web/www/wordpress/wp-includes/post.php] 27 = [/web/www/wordpress/wp-includes/post-template.php] 28 = [/web/www/wordpress/wp-includes/category.php] 29 = [/web/www/wordpress/wp-includes/category-template.php] 30 = [/web/www/wordpress/wp-includes/comment.php] 31 = [/web/www/wordpress/wp-includes/comment-template.php] 32 = [/web/www/wordpress/wp-includes/rewrite.php] 33 = [/web/www/wordpress/wp-includes/feed.php] 34 = [/web/www/wordpress/wp-includes/bookmark.php] 35 = [/web/www/wordpress/wp-includes/bookmark-template.php] 36 = [/web/www/wordpress/wp-includes/kses.php] 37 = [/web/www/wordpress/wp-includes/cron.php] 38 = [/web/www/wordpress/wp-includes/version.php] 39 = [/web/www/wordpress/wp-includes/deprecated.php] 40 = [/web/www/wordpress/wp-includes/script-loader.php] 41 = [/web/www/wordpress/wp-includes/class.wp-dependencies.php] 42 = [/web/www/wordpress/wp-includes/class.wp-scripts.php] 43 = [/web/www/wordpress/wp-includes/functions.wp-scripts.php] 44 = [/web/www/wordpress/wp-includes/class.wp-styles.php] 45 = [/web/www/wordpress/wp-includes/functions.wp-styles.php] 46 = [/web/www/wordpress/wp-includes/taxonomy.php] 47 = [/web/www/wordpress/wp-includes/update.php] 48 = [/web/www/wordpress/wp-includes/canonical.php] 49 = [/web/www/wordpress/wp-includes/shortcodes.php] 50 = [/web/www/wordpress/wp-includes/media.php] 51 = [/web/www/wordpress/wp-includes/http.php] 52 = [/web/www/wordpress/wp-includes/widgets.php] 53 = [/web/www/wordpress/wp-includes/vars.php] 54 = [/web/www/wordpress/wp-content/plugins/akismet/akismet.php] 55 = [/web/www/wordpress/wp-content/plugins/all-in-one-seo-pack/all_in_one_seo_pack.php] 56 = [/web/www/wordpress/wp-content/plugins/all-in-one-seo-pack/aioseop.class.php] 57 = [/web/www/wordpress/wp-content/plugins/merchantos/merchantos.php] 58 = [/web/www/wordpress/wp-content/plugins/uploadhack/uploadhack.php] 59 = [/web/www/wordpress/wp-content/plugins/urlhack/urlhack.php] 60 = [/web/www/wordpress/wp-includes/pluggable.php] 61 = [/web/www/wordpress/wp-includes/default-widgets.php] 62 = [/web/www/wordpress/wp-includes/default-embeds.php] 63 = [/web/www/wordpress/wp-includes/locale.php] 64 = [/web/www/wordpress/wp-content/themes/mstore_modern/functions.php] 65 = [/web/www/wordpress/wp-content/plugins/merchantos/widgets/navigation.php] 66 = [/web/www/wordpress/wp-content/plugins/merchantos/widgets/shopping_cart.php] 67 = [/web/www/wordpress/wp-content/plugins/merchantos/widgets/checkout.php] 68 = [/web/www/wordpress/wp-content/plugins/merchantos/widgets/account.php] 69 = [/web/includes/startup_public.php] 70 = [/web/includes/include_dirs.php] 71 = [/web/shop/includes/startup_public.php] 72 = [/web/shop/includes/bs_datetime.class.php] 73 = [/web/shop/includes/bs_date_range.class.php] 74 = [/web/shop/includes/utils.inc.php] 75 = [/web/shop/includes/bikesoft_ids.php] 76 = [/web/shop/includes/database/bs_table.class.php] 77 = [/web/shop/includes/database/database.inc.php] 78 = [/web/shop/includes/database/db_shard_connection.class.php] 79 = [/web/shop/includes/login_state.class.php] 80 = [/web/shop/includes/database/bs_employee.class.php] 81 = [/web/shop/includes/database/bs_shopping_cart.class.php] 82 = [/web/www/wordpress/wp-includes/template-loader.php] 83 = [/web/www/wordpress/wp-content/themes/mstore_modern/search.php] 84 = [/web/www/wordpress/wp-content/themes/mstore_modern/header.php] 85 = [/web/www/wordpress/wp-content/themes/mstore_modern/header_sidebar.php] 86 = [/web/shop/includes/database/bs_merchantos_options.class.php] 87 = [/web/www/wordpress/wp-content/themes/mstore_modern/top_sidebar.php] 88 = [/web/www/wordpress/wp-content/themes/mstore_modern/left_sidebar.php] 89 = [/web/www/wordpress/wp-content/plugins/merchantos/helpers.php] 90 = [/web/shop/includes/database/bs_category.class.php] 91 = [/web/shop/includes/database/bs_tree_base.class.php] 92 = [/web/shop/includes/database/bs_ecommerce_item.class.php] 93 = [/web/shop/includes/database/bs_manufacturer.class.php] 94 = [/web/www/wordpress/wp-content/plugins/merchantos/pages/product_search.php] 95 = [/web/shop/includes/error_helper_functions.php] 96 = [/web/shop/includes/forms/public/report_error.php] [Get Vars] s = [pitchfork 26] [Post Vars] [Server Vars] REDIRECT_STATUS = [200] HTTP_X_CC_ID = [ccc03-02] HTTP_HOST = [www.ghybikes.com] HTTP_USER_AGENT = [CCBot/1.0 (+http://www.commoncrawl.org/bot.html)] HTTP_ACCEPT = [text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5] HTTP_ACCEPT_LANGUAGE = [en-us,en;q=0.5] HTTP_ACCEPT_ENCODING = [gzip] HTTP_ACCEPT_CHARSET = [ISO-8859-1,utf-8;q=0.7,*;q=0.7] HTTP_CONNECTION = [close] HTTP_CACHE_CONTROL = [no-cache] HTTP_PRAGMA = [no-cache] HTTP_COOKIE = [merchantos_shopping_cart=93c5bf016b74065529a46a72c8b8ed97] PATH = [/sbin:/usr/sbin:/bin:/usr/bin] SERVER_SIGNATURE = [Apache/2.2.9 (Fedora) Server at www.ghybikes.com Port 80 ] SERVER_SOFTWARE = [Apache/2.2.9 (Fedora)] SERVER_NAME = [www.ghybikes.com] SERVER_ADDR = [192.168.11.102] SERVER_PORT = [80] REMOTE_ADDR = [38.107.191.108] DOCUMENT_ROOT = [/web/www/] SERVER_ADMIN = [ivan@merchantos.com] SCRIPT_FILENAME = [/web/www/wordpress/index.php] REMOTE_PORT = [23865] REDIRECT_QUERY_STRING = [s=pitchfork+26] REDIRECT_URL = [/] GATEWAY_INTERFACE = [CGI/1.1] SERVER_PROTOCOL = [HTTP/1.1] REQUEST_METHOD = [GET] QUERY_STRING = [s=pitchfork+26] REQUEST_URI = [/?s=pitchfork+26] SCRIPT_NAME = [/wordpress/index.php] PHP_SELF = [/wordpress/index.php] REQUEST_TIME = [1280478154]
Welcome to Our Store!
We're your one stop shop for bikes, accessories, apparel and more! Everything is available here or in our retail location, so drop in today!