Was uninstall 1.3.3 and install 1.3.4 for production service and bus, bugs, bugs!
And those bugs would be…?
please use more descriptive thread’s titles!
a “1.3.4” is a bit a too generic… thanks!
I have none of those errors. Have you reinstalled CS-Cart properly? Do you have any restrictions on database size at your webhost?
[quote name=‘Zyles’]I have none of those errors. Have you reinstalled CS-Cart properly? Do you have any restrictions on database size at your webhost?[/QUOTE]
Try add product to home page from admin side and got this error:
Database error: 1109 : Unknown table ‘prices’ in order clause
Invalid query: SELECT products.product_id, descr1.product as product, products.tracking, products.feature_comparison, products.zero_price_action, products.product_type FROM avail_products INNER JOIN cscart_products as products ON products.product_id=avail_products.product_id LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id=products.product_id AND descr1.lang_code=‘EN’ WHERE 1 GROUP BY avail_products.product_id ORDER BY prices.price asc LIMIT 0, 10
--------------------------------------------------------------------------------
Backtrace: File: /home/indy2go/public_html/lucky2go.php
Line: 79
Function: include
File: /home/indy2go/public_html/targets/index_page.php
Line: 36
Function: include
File: /home/indy2go/public_html/include/admin/index_page.php
Line: 94
Function: include
File: /home/indy2go/public_html/core/include_addons.php
Line: 47
Function: include
File: /home/indy2go/public_html/addons/featured_products/include/admin/index_page.php
Line: 85
Function: include
File: /home/indy2go/public_html/include/common/search_products.php
Line: 264
Function: include
File: /home/indy2go/public_html/include/common/search_products_improved.php
Line: 94
Function: db_get_array
File: /home/indy2go/public_html/core/fn_database.php
Line: 42
Function: db_query
File: /home/indy2go/public_html/core/db_mysql.php
Line: 89
Function: db_debug_error
Senior Memberdominos_2004
Today 03:50 PM
When click on search button to add product to home page
Senior Memberdominos_2004
Today 03:51 PM
Same problem when try add product to any category page from admin side and got this error:
Database error: 1109 : Unknown table ‘prices’ in order clause
Invalid query: SELECT products.product_id, descr1.product as product, products.tracking, products.feature_comparison, products.zero_price_action, products.product_type FROM avail_products INNER JOIN cscart_products as products ON products.product_id=avail_products.product_id LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id=products.product_id AND descr1.lang_code=‘EN’ WHERE 1 GROUP BY avail_products.product_id ORDER BY prices.price asc LIMIT 0, 10
--------------------------------------------------------------------------------
Backtrace: File: /home/indy2go/public_html/lucky2go.php
Line: 79
Function: include
File: /home/indy2go/public_html/targets/categories.php
Line: 40
Function: include
File: /home/indy2go/public_html/include/admin/categories.php
Line: 472
Function: include
File: /home/indy2go/public_html/core/include_addons.php
Line: 47
Function: include
File: /home/indy2go/public_html/addons/featured_products/include/admin/categories.php
Line: 90
Function: include
File: /home/indy2go/public_html/include/common/search_products.php
Line: 264
Function: include
File: /home/indy2go/public_html/include/common/search_products_improved.php
Line: 94
Function: db_get_array
File: /home/indy2go/public_html/core/fn_database.php
Line: 42
Function: db_query
File: /home/indy2go/public_html/core/db_mysql.php
Line: 89
Function: db_debug_error
I’m using cs-cart about year and install and reinstall 1000 times and when was use 1.3.3 never got errors like this.
So exactly what is “lucky2go.php” ?
Does your db havecscart_product_prices
and in your config.php
$db_tables = array(
‘product_prices’ => ‘cscart_product_prices’,
looks to me like you modified your tables and/or config.php.
The table “prices” is NOT default in any version of CS Cart that i reviewed.
[quote name=‘ETInteractive’]Does your db havecscart_product_prices
and in your config.php
$db_tables = array(
‘product_prices’ => ‘cscart_product_prices’,
looks to me like you modified your tables and/or config.php.
The table “prices” is NOT default in any version of CS Cart that i reviewed.[/QUOTE]
i did not modified tables and/or config.php just install Newest Products module
but before installing this module was same problem
[quote name=‘Zyles’]So exactly what is “lucky2go.php” ?[/QUOTE]
admin.php was renamed
Never got this problem in version 1.3.3
You didnt answer the question. does cscart_pricing_product table exist in your db?
[quote name=‘ETInteractive’]You didnt answer the question. does cscart_pricing_product table exist in your db?[/QUOTE]
Server: localhost Database: bla Table: cscart_product_prices
price_id product_id price lower_limit membership_id combination_id
2438 899 119.50 1 0 0
2437 1066 115.59 1 0 0
2436 1553 94.44 1 0 0
But i did not change anything.
fresh install today 3 times and every time problem!
The error is looking for a table called “prices” not “cscart_product_prices”. Could it be the prefix is missing?
[quote name=‘sculptingstudio’]The error is looking for a table called “prices” not “cscart_product_prices”. Could it be the prefix is missing?[/QUOTE]
But i did not change anything.
fresh install today 3 times and every time problem!
* *
* Copyright (c) 2004-2006 CS-Cart.com. All rights reserved. *
* *
*******************************************************************************
* *
* CS-Cart is commercial software, only users who have purchased a valid *
* license through [url]https://www.cs-cart.com/[/url] and accept to the terms of this *
* License Agreement can install this product. *
* *
*******************************************************************************
* THIS CS-CART SHOP END-USER LICENSE AGREEMENT IS A LEGAL AGREEMENT BETWEEN *
* YOU AND YOUR COMPANY (COLLECTIVELY, "YOU") AND CS-CART.COM (HEREINAFTER *
* REFERRED TO AS "THE AUTHOR") FOR THE SOFTWARE PRODUCT IDENTIFIED ABOVE, *
* WHICH INCLUDES COMPUTER SOFTWARE AND MAY INCLUDE ASSOCIATED MEDIA, PRINTED *
* MATERIALS, AND "ONLINE" OR ELECTRONIC DOCUMENTATION (COLLECTIVELY, THE *
* "SOFTWARE"). BY USING THE SOFTWARE, YOU SIGNIFY YOUR AGREEMENT TO ALL *
* TERMS, CONDITIONS, AND NOTICES CONTAINED OR REFERENCED HEREIN. IF YOU ARE *
* NOT WILLING TO BE BOUND BY THIS AGREEMENT, DO NOT INSTALL OR USE THE *
* SOFTWARE. *
* *
* PLEASE READ THE FULL TEXT OF SOFTWARE LICENSE AGREEMENT IN THE "COPYRIGHT" *
* FILE PROVIDED WITH THIS DISTRIBUTION. THE AGREEMENT TEXT IS ALSO AVAILABLE *
* AT THE FOLLOWING URL: [url]https://www.cs-cart.com/license.html[/url] *
******************************************************************************/
//
// $Id: config.php 2480 2006-11-06 11:51:46Z zeke $
//
if ( !defined('IN_CSCART') ) { die('Access denied'); }
$db_host = 'localhost';
$db_name = 'xxxxx';
$db_user = 'xxxxx';
$db_password = 'xxxxx';
// Example:
// Your url is [url]http://www.yourcompany.com/store/cscart[/url]
// cscart_http_host = 'www.yourcompany.com';
// cscart_http_dir = '/store/cscart';
//
// Your secure url is [url]https://secure.yourcompany.com/secure_dir/cscart[/url]
// cscart_https_host = 'secure.yourcompany.com';
// cscart_https_dir = '/secure_dir/cscart';
// Host and directory where cs-cart is installed on usual server
$cscart_http_host = 'www.indymart.net';
$cscart_http_dir = '';
// Host and directory where cs-cart is installed on secure server
$cscart_https_host = 'www.indymart.net';
$cscart_https_dir = '';
$admin_index = 'xxxxxxx';
$customer_index = 'index.php';
$partner_index = 'partner.php';
$image_index = 'image.php';
$target_name = 'target';
$mode_name = 'mode';
$action_name = 'action';
// DEMO mode
$demo_mode_enabled = false;
// Trial mode
$trial_mode = false;
error_reporting(E_ALL ^ E_NOTICE);
ini_set("display_errors", "on");
//
// Load local config data
//
@include_once($cscart_dir . DS . 'local_conf.php');
//
// Directory definitions
//
// Filesystem paths
$core_dir = $cscart_dir . DS . 'core' . DS;
$classes_dir = $cscart_dir . DS . 'classes' . DS;
$addons_dir = $cscart_dir . DS . 'addons' . DS;
$skins_dir = $cscart_dir . DS . 'skins' . DS;
$common_dir = $cscart_dir . DS . 'include' . DS . 'common' . DS;
$admin_dir = $cscart_dir . DS . 'include' . DS . 'admin' . DS;
$targets_dir = $cscart_dir . DS . 'targets'.DS;
$customer_dir = $cscart_dir . DS . 'include' . DS . 'customer' . DS;
$partner_dir = $cscart_dir . DS . 'include' . DS . 'partner' . DS;
$payment_files_dir = $cscart_dir . DS . 'payments' . DS;
$shipping_files_dir = $cscart_dir . DS . 'shippings' . DS;
$var_dir = array();
$var_dir['log'] = $cscart_dir . DS .'var' . DS . 'log' . DS;
$var_dir['compiled'] = $cscart_dir . DS .'var' . DS . 'compiled' . DS;
$var_dir['database'] = $cscart_dir . DS .'var' . DS . 'database' . DS;
$var_dir['downloads'] = $cscart_dir . DS .'var' . DS . 'downloads' . DS;
$var_dir['upgrade'] = $cscart_dir . DS .'var' . DS . 'upgrade' . DS;
require $core_dir . 'https_detect.php';
// Define host directory depending on the current connection
$cscart_host_dir = (defined('HTTPS')) ? $cscart_https_dir : $cscart_http_dir;
// Directory for store images on file system
$images_storage_dir = $cscart_dir . DS .'images' . DS;
$images_storage_web_dir = $cscart_host_dir.'/images/';
// Web paths
$skins_rel_dir = 'skins/'; // Used for web path
//
// Database tables aliases...
//
$db_tables = array(
'categories' => 'cscart_categories',
'category_descriptions' => 'cscart_category_descriptions',
'category_images' => 'cscart_category_images',
'category_images_links' => 'cscart_category_images_links',
'currencies' => 'cscart_currencies',
'currency_descriptions' => 'cscart_currency_descriptions',
'common_images' => 'cscart_common_images',
'common_images_links' => 'cscart_common_images_links',
'detailed_images' => 'cscart_detailed_images',
'products' => 'cscart_products',
'product_descriptions' => 'cscart_product_descriptions',
'products_categories' => 'cscart_products_categories',
'product_prices' => 'cscart_product_prices',
'products_taxes' => 'cscart_products_taxes',
'users' => 'cscart_users',
'user_profiles' => 'cscart_user_profiles',
'sessions' => 'cscart_sessions',
'product_images' => 'cscart_product_images',
'product_images_links' => 'cscart_product_images_links',
'languages' => 'cscart_languages',
'language_values' => 'cscart_language_values',
'memberships' => 'cscart_memberships',
'membership_descriptions' => 'cscart_membership_descriptions',
'states' => 'cscart_states',
'state_descriptions' => 'cscart_state_descriptions',
'orders' => 'cscart_orders',
'order_details' => 'cscart_order_details',
'taxes' => 'cscart_taxes',
'tax_descriptions' => 'cscart_tax_descriptions',
'tax_rates' => 'cscart_tax_rates',
'shippings' => 'cscart_shippings',
'shipping_descriptions' => 'cscart_shipping_descriptions',
'shipping_rates' => 'cscart_shipping_rates',
'discounts' => 'cscart_discounts',
'discount_descriptions' => 'cscart_discount_descriptions',
'discounts_categories' => 'cscart_discounts_categories',
'discounts_users' => 'cscart_discounts_users',
'discounts_products' => 'cscart_discounts_products',
'destination_descriptions' => 'cscart_destination_descriptions',
'destinations' => 'cscart_destinations',
'destination_elements' => 'cscart_destination_elements',
'countries' => 'cscart_countries',
'country_descriptions' => 'cscart_country_descriptions',
'payments' => 'cscart_payments',
'payment_descriptions' => 'cscart_payment_descriptions',
'payment_processors' => 'cscart_payment_processors',
'common_descriptions' => 'cscart_common_descriptions',
'settings' => 'cscart_settings',
'settings_sections' => 'cscart_settings_sections',
'settings_subsections' => 'cscart_settings_subsections',
'settings_routines' => 'cscart_settings_routines',
'settings_elements' => 'cscart_settings_elements',
'settings_descriptions' => 'cscart_settings_descriptions',
'settings_variants' => 'cscart_settings_variants',
'topics' => 'cscart_topics',
'topic_descriptions' => 'cscart_topic_descriptions',
'pages' => 'cscart_pages',
'page_descriptions' => 'cscart_page_descriptions',
'pages_topics' => 'cscart_pages_topics',
'ekeys' => 'cscart_ekeys',
'sitemap_links' => 'cscart_sitemap_links',
'sitemap_sections' => 'cscart_sitemap_sections',
'static_data' => 'cscart_static_data',
'static_data_descriptions' => 'cscart_static_data_descriptions',
'statistics_element_descriptions' => 'cscart_statistics_element_descriptions',
'statistics_elements' => 'cscart_statistics_elements',
'statistics_interval_descriptions' => 'cscart_statistics_interval_descriptions',
'statistics_intervals' => 'cscart_statistics_intervals',
'statistics_reports' => 'cscart_statistics_reports',
'statistics_report_descriptions' => 'cscart_statistics_report_descriptions',
'statistics_tables' => 'cscart_statistics_tables',
'statistics_table_descriptions' => 'cscart_statistics_table_descriptions',
'statistics_table_conditions' => 'cscart_statistics_table_conditions',
'statistics_table_elements' => 'cscart_statistics_table_elements',
'statistics_table_element_conditions' => 'cscart_statistics_table_element_conditions',
'product_options' => 'cscart_product_options',
'product_options_descriptions' => 'cscart_product_options_descriptions',
'product_options_exceptions' => 'cscart_product_options_exceptions',
'product_option_variants' => 'cscart_product_option_variants',
'product_option_variants_descriptions' => 'cscart_product_option_variants_descriptions',
'product_options_inventory' => 'cscart_product_options_inventory',
'product_global_option_links' => 'cscart_product_global_option_links',
'new_orders' => 'cscart_new_orders',
'product_features' => 'cscart_product_features',
'product_features_values' => 'cscart_product_features_values',
'product_features_variants_descriptions' => 'cscart_product_features_variants_descriptions',
'product_features_descriptions' => 'cscart_product_features_descriptions',
'forms' => 'cscart_forms',
'form_elements' => 'cscart_form_elements',
'form_element_variants' => 'cscart_form_element_variants',
'form_descriptions' => 'cscart_form_descriptions',
'shipping_services' => 'cscart_shipping_services',
'shipping_service_descriptions' => 'cscart_shipping_service_descriptions',
'membership_privileges' => 'cscart_membership_privileges',
'privileges' => 'cscart_privileges',
'privilege_descriptions' => 'cscart_privilege_descriptions',
'shippings_taxes' => 'cscart_shippings_taxes',
'order_data' => 'cscart_order_data',
'order_statuses' => 'cscart_order_statuses',
'order_status_descriptions' => 'cscart_order_status_descriptions',
'profile_fields' => 'cscart_profile_fields',
'profile_field_values' => 'cscart_profile_field_values',
'profile_field_descriptions' => 'cscart_profile_field_descriptions',
'profile_fields_data' => 'cscart_profile_fields_data',
'banners' => 'cscart_aff_banners',
'banner_descriptions' => 'cscart_aff_banner_descriptions',
'groups' => 'cscart_aff_groups',
'group_descriptions' => 'cscart_aff_group_descriptions',
'affiliate_plans' => 'cscart_affiliate_plans',
'partner_profiles' => 'cscart_aff_partner_profiles',
'partner_actions' => 'cscart_aff_partner_actions',
'affiliate_payouts' => 'cscart_affiliate_payouts',
'action_links' => 'cscart_aff_action_links',
);
//
// Default targets
//
$script_targets = array (
'categories' => $targets_dir.'categories.php',
'products' => $targets_dir.'products.php',
'cart' => $targets_dir.'cart.php',
'help' => $targets_dir.'help.php',
'index' => $targets_dir.'index.php',
'auth' => $targets_dir.'auth.php',
'profiles' => $targets_dir.'profiles.php',
'languages' => $targets_dir.'languages.php',
'settings' => $targets_dir.'settings.php',
'settings_dev' => $targets_dir.'settings_dev.php',
'states' => $targets_dir.'states.php',
'shippings' => $targets_dir.'shippings.php',
'discounts' => $targets_dir.'discounts.php',
'checkout' => $targets_dir.'checkout.php',
'orders' => $targets_dir.'orders.php',
'taxes' => $targets_dir.'taxes.php',
'memberships' => $targets_dir.'memberships.php',
'destinations' => $targets_dir.'destinations.php',
'countries' => $targets_dir.'countries.php',
'payments' => $targets_dir.'payments.php',
'tools' => $targets_dir.'tools.php',
'html_catalog' => $targets_dir.'html_catalog.php',
'topics' => $targets_dir.'topics.php',
'pages' => $targets_dir.'pages.php',
'sitemap' => $targets_dir.'sitemap.php',
'exceptions' => $targets_dir.'exceptions.php',
'search' => $targets_dir.'search.php',
'statistics' => $targets_dir.'statistics.php',
'static_data' => $targets_dir.'static_data.php',
'product_options' => $targets_dir.'product_options.php',
'file_browser' => $targets_dir.'file_browser.php',
'client_env' => $targets_dir.'client_env.php',
'payment_notification' => $targets_dir.'payment_notification.php',
'template_editor' => $targets_dir.'template_editor.php',
'product_features' => $targets_dir.'product_features.php',
'index_page' => $targets_dir.'index_page.php',
'upgrade_center' => $targets_dir.'upgrade_center.php',
'skin_selector' => $targets_dir.'skin_selector.php',
'forms' => $targets_dir.'forms.php',
'my_account' => $targets_dir.'my_account.php',
'currencies' => $targets_dir.'currencies.php',
'order_management' => $targets_dir.'order_management.php',
'logs' => $targets_dir.'logs.php',
'order_statuses' => $targets_dir.'order_statuses.php',
'profile_fields' => $targets_dir.'profile_fields.php',
'license' => $targets_dir.'license.php',
'product_groups' => $targets_dir.'product_groups.php',
'affiliate_plans' => $targets_dir.'affiliate_plans.php',
'product_banners' => $targets_dir.'product_banners.php',
'banner' => $targets_dir.'banner.php',
'banners' => $targets_dir.'banners.php',
'banners_manager' => $targets_dir.'banners_manager.php',
'partners' => $targets_dir.'partners.php',
'aff_statistics' => $targets_dir.'aff_statistics.php',
'payouts' => $targets_dir.'payouts.php',
'database' => $targets_dir.'database.php',
'import_export' => $targets_dir.'import_export.php',
);
//
// Check if logging is enabled
//
if (file_exists($var_dir['log'].'settings.php')) {
include $var_dir['log'].'settings.php';
}
if (defined('LOG_PHP_EVENTS')) {
ini_set("log_errors", 1);
if (!file_exists($var_dir['log'].'php_events_'.date("Y-m-d").'.log.php')) {
$fd = @fopen($var_dir['log'].'php_events_'.date("Y-m-d").'.log.php', 'w');
@fwrite($fd, "\n");
@fclose($fd);
}
ini_set("error_log", $var_dir['log'].'php_events_'.date("Y-m-d").'.log.php');
ini_set("ignore_repeated_errors", 1);
}
$http_location = “http://$cscart_http_host”.$cscart_http_dir;
$https_location = “https://$cscart_https_host”.$cscart_https_dir;
$current_location = (defined(‘HTTPS’)) ? $https_location : $http_location;
// BlowFish key
$crypt_key = ‘xxxxxxx’;
// Database layer
$db_type = ‘mysql’;
// Set the session name
// C - for customer area
// A - for admin area
// The different session names for areas allows you to
// log in as customer and admin in one browser instance
$CSCART_SESSION_NAMES = array(‘C’ => ‘csid’, ‘A’ => ‘acsid’, ‘P’ => ‘psid’);
// List of file extensions which the uploaded or renamed via admin area
// file can not has.
$forbidden_file_extensions = array (
‘php’,
‘php3’,
‘pl’,
‘com’,
‘exe’,
‘bat’,
‘cgi’
);
// Uncomment this line if you experience problems with mysql5 server
//define(‘MYSQL5’, true);
// Delimiter for SEF urls
define(‘CS_SEO_DELIMITER’, ‘-’);
//define(‘LICENSE_USED’, true);
// Authentication code to access the installer
$AUTH_CODE = ‘xxxxxxx’;
define(‘CSCART_VERSION’, ‘1.3.4’);
?>
Thank you guys, it was a bug. I was right.
Pretend like this post has been deleted. Since I can't delete it for some reason.