Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SolidAmerica

Members
  • Content count

    6
  • Joined

  • Last visited

About SolidAmerica

  • Birthday January 15

Profile Information

  • Real Name
    Solid America
  • Gender
    Not Telling
  • Location
    United States
  • Interests
    Broadcast Information and Business
  • Website

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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.

     

     

     

    error.png

    1. valquiria23

      valquiria23

      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://forums.oscommerce.com/topic/496261-v10710-questionscommentsconcerns/

      Community members could surely will help you.

      Cheers

      Valqui

       

       

    2. SolidAmerica

      SolidAmerica

      I bade a back up and forget to upgrade.

      Thank You. :smile:

  2. 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.com

      Copyright (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.

    1. Show previous comments  2 more
    2. SolidAmerica

      SolidAmerica

      THANK YOU do much.

      Gino Venegas Costa Rica.

    3. valquiria23

      valquiria23

      de nada y a las ordenes.

    4. SolidAmerica

      SolidAmerica

      Funciona de Marabilla, Fantastico!.

      Muchisimas Gracias.

  3.  

    For anyone who knows about this plugin:
     

    I was installing this module o Google Ads and got this error.

    "    Google Ads

    1146 - Table 'bookoflikes_stores.TABLE_CONFIGURATION' doesn't exist

    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())     "

    How can that be fixed? 

    Thank You.

    1. SolidAmerica

      SolidAmerica

      Oh, I'm Sorry about Your father. So sorry.

    2. valquiria23

      valquiria23

      change insert into TABLE_CONFIGURATION to:

      insert into configuration

×