Jump to content

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

  4. SolidAmerica

    Error With Checkout Paypal

    I uninstalled regular Paypal and taken the Paypal express payment, now it is kind of working. Thank You.
  5. SolidAmerica

    Paypal Module Express Checkout Error

    Thank You, i did it, and it works.
  6. I have the Version: OSCOM CEnix v1.0.7.7 installed in my store. Before, right after setup removed a lot of states and left only United States to ship and sell products only, then i try to install paypal regular but it was too complicated with security certificates and how to make them, then i installed the "Paypal Express module" and when i test to see if it works by clicking on the button, I get this error: Warning: array_filter() expects parameter 1 to be array, null given in /home/www/mysellingstoreexample.com/stores/includes/system/versioned/1.0.5.1/customer.php on line 62 Notice: Only variables should be passed by reference in /home/www/mysellingstoreexample.com/.com/stores/includes/modules/customer_data/cd_country.php on line 112 Notice: Only variables should be passed by reference in /home/www/mysellingstoreexample.com/.com/stores/includes/modules/customer_data/cd_country.php on line 112 Warning: Cannot modify header information - headers already sent by (output started at /home/www/mysellingstoreexample.com/.com/stores/includes/system/versioned/1.0.5.1/customer.php:62) in /home/www/mysellingstoreexample.com/.com/stores/includes/functions/general.php on line 36 I recognise that i'm confused and don't know where to go for help or if I must to remove the whole software and try it again to see if something is broken during the files upload. Is any body in here that can address me for the next steps to make this store funcionable (that operates normally)? Plase.
  7. SolidAmerica

    Error With Checkout Paypal

    Hello, I appreciate if someone can assist me on how to fix this payment issue. have the store with an installation version of CE Phoenix v1.0.7.7 When i test the shopping payment, i get this error. : Notice: Undefined index: in /home/www/mysite.com/stores/includes/system/versioned/1.0.7.3/payment.php on line 65 Notice: Undefined variable: in /home/www/mysite.com/stores/checkout_confirmation.php on line 59 Notice: Trying to get property 'enabled' of non-object in /home/www/mysite.com/stores/checkout_confirmation.php on line 59 Warning: Cannot modify header information - headers already sent by (output started at /home/www/mysite.com/stores/includes/system/versioned/1.0.7.3/payment.php:65) in /home/www/mysite.com/stores/includes/functions/general.php on line 36 " https://bookoflikes.com/stores/
×