-
Posts
722 -
Joined
-
Last visited
-
Days Won
7
valquiria23's Achievements
-
Hello, Valquiria23
I made an upgrade to the latest CE Phoenix Ocommerce and everything went fine, but now when clicking on the items, I get this error on the screen. Do you have an idea how to fix that?
I had CE Phoenix v1.0.7.9 and upgraded to CE Phoenix v1.0.7.10. I sending a picture of the error.
This is the error:
" 1054 - Unknown column 'po.sort_order' in 'order clause'
SELECT DISTINCT po.products_options_id, po.products_options_name FROM products_options po INNER JOIN products_attributes patrib ON patrib.options_id = po.products_options_id WHERE patrib.products_id = 45 AND po.language_id = 1 ORDER BY po.sort_order, po.products_options_name
[TEP STOP] "
Thank You.
-
Hello SolidAmerica , Hope everything is well on your side and you are all safe and sound
I have not tested version v1.0.7.10 yet, but I think that the best place to do this question is in the following topic:
https://www.oscommerce.com/forums/topic/496261-v10710-questionscommentsconcerns/
Community members could surely will help you.
Cheers
Valqui
-
-
Would you be interested in installing recaptcha on my site? I'm a guitar builder and I can do some things, but some of this escapes my capabilities. I need it on the account create page and the contact page.
-
Hello DivebombInc ,
I hope you are very well.
I like to help users (if I can), but I don't do installation work for other users. For that, it is best to ask for help at Commercial Support. There are several talented developers on the forum.I recommend you to be a PRO user of Phoenix and contact Burt for his Google recaptcha modules.
have a nice day.
Valqui
-
-
Valeria,
How are you?
Listen, i have this file " bm_jcmgoogleads.php " on the Adsense module installation folder. The question is, do i have to insert that in there?
<?php
/*
$Id$osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.comCopyright (c) 2010 osCommerce
Released under the GNU General Public License
*/class bm_jcmgoogleads {
var $code = 'bm_jcmgoogleads';
var $group = 'boxes';
var $title;
var $description;
var $sort_order;
var $enabled = false;function __construct() {
$this->title = MODULE_BOXES_JCMGOOGLEADS_TITLE;
$this->description = MODULE_BOXES_JCMGOOGLEADS_DESCRIPTION;if ( defined('MODULE_BOXES_JCMGOOGLEADS_STATUS') ) {
$this->sort_order = MODULE_BOXES_JCMGOOGLEADS_SORT_ORDER;
$this->enabled = (MODULE_BOXES_JCMGOOGLEADS_STATUS == 'True');
$this->group = ((MODULE_BOXES_JCMGOOGLEADS_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
}
}function execute() {
global $currencies, $oscTemplate;{
ob_start();
include('includes/modules/boxes/templates/jcmgoogleads.php');
$data = ob_get_clean();$oscTemplate->addBlock($data, $this->group);
}
}function isEnabled() {
return $this->enabled;
}function check() {
return defined('MODULE_BOXES_JCMGOOGLEADS_STATUS');
}function install() {
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable jcmgoogleads Module', 'MODULE_BOXES_JCMGOOGLEADS_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_JCMGOOGLEADS_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_JCMGOOGLEADS_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())");
}function remove() {
tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
}function keys() {
return array('MODULE_BOXES_JCMGOOGLEADS_STATUS', 'MODULE_BOXES_JCMGOOGLEADS_CONTENT_PLACEMENT', 'MODULE_BOXES_JCMGOOGLEADS_SORT_ORDER');
}
}Thank You for helping me.