Twitch Hidden Searchable Model Number

[dharrison]

Hi This looks like a good attribute, can you set part numbers for attributes?

Basically we sell desks depending on size, top, adjustment and feet. We basically need part numbers for every attribute.

Please advise.

[dharrison]

Also I just tried to install this plugin and I get A warning message in Catalog > Categories/Products

Warning: an error occured, please refresh the page and try again

Please advise.

[twitchtoo]

Also I just tried to install this plugin and I get A warning message in Catalog > Categories/Products



Please advise.

There should be an error log in your /logs folder from the admin to see where it failed to load.

[dharrison]

Hi

I'm on XAMPP but I have no error logs. Also I have uninstalled SBA as it was of no use to me.

Can this plugin be used for attributes?

[twitchtoo]

Hi

I'm on XAMPP but I have no error logs. Also I have uninstalled SBA as it was of no use to me.

Can this plugin be used for attributes?

Yes the products_model_spoon is not limited to the products, however no one has paid me to add the code to attributes... so it's not on my site priority list under 'current projects' yet.

To make it work for attributes - the product field would need to be added as an input in admin, a display in the attributes controller and a new table in the database beside the attributes.

[twitchtoo]

If you have no errors, my guess is the module was not installed correctly or the files were merged incorrectly. That WILL cause the error you're seeing as I have fixed this a number of times for various clients/forum members.

[gearheadniko]

Hey Twitch, thanks for the plug in. I know this will do the trick for me, but alas I cannot get it to work. I have gone over you install every file etc. to confirm the code, aside from some code not being at the exact line number all is good, I re-installed again, uploaded the sql patches, still nothing shows.
I am using the following
Ver using: v1.5.4
Template westminster_new
Opps could it be the ver of ZC I am running?

[gearheadniko]

I have reinstalled, now when I select Catalog - Categories/Products, I am now able to see the menu with your add in but am getting an error message above it that reads "WARNING: An Error occurred, please refresh the page and try again." and the category is not visible. Nothing changes on a refreash.

[twitchtoo]

Twitch Hidden Searchable Model Number for ZC v1.54

Check the forum plugins or my website for your copy.

- This module will add a products_model_spoon input for each product.
- It will be displayed and searchable in admin, searchable on the live site but not displayed there.

Other Uses:
Second Model Number, Internal Part Number, UPC Barcode Number, Searchable Size, Stock SKU Number, Manufacturer Model Number.

What's New:
- Files included are now based on a stock 'vanilla' Zen Cart v1.54 install
- Instructions have been organized, line numbers updated for ZC v1.54

Optional Bonus Feature
- Add Hidden Model to Admin->Edit Order - Admin can see hidden model number while viewing orders
- Add Hidden Model to Admin Product Search

Yes it is compatible with ZC v1.53 - line numbers will be out by 2 - 5 digits.

[Green Books]

Hi Twitch,

Thanks for your plugin, it is exactly what I need.
Unfortunately, I have the same problem with gearheadniko, that I can't see any products displayed in Categories/Product.


A error occurred: "WARNING: An Error occurred, please refresh the page and try again."
(Before & After)


I take a look at my log file, it said:

[19-Mar-2015 17:02:26 Asia/Hong_Kong] PHP Fatal error:  1054:Unknown column 'p.products_model_spoon' in 'field list' :: select p.products_type, p.products_id, pd.products_name, p.products_quantity,                                        p.products_image, p.products_price, p.products_date_added,                                        p.products_last_modified, p.products_date_available,                                        p.products_status, p.products_model, p.products_model_spoon,                                         p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,                                        p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,                                        p.products_quantity_order_max, p.products_sort_order                                 from products p, products_description pd, products_to_categories p2c                                 where p.products_id = pd.products_id                                 and pd.language_id = '1'                                 and p.products_id = p2c.products_id                                 and p2c.categories_id = '23' order by p.products_sort_order, pd.products_name limit 0, 10 in /home/brightenbookscom/public_html/includes/classes/db/mysql/query_factory.php on line 120

Therefore, I went for the php file it mentioned:
/public_html/includes/classes/db/mysql/query_factory.php

Here is line 120, but I don't know how to fix the code.

trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR); 

Could you please help me to due with this problem?

Thanks,
Eva



----------------------------------------------------------------------------------------------------------------
P.S. Since you may want to know more information, here is line 110~137 in query_factory.php:

  function show_error() {
    if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
    echo '<div class="systemError">';
    if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true) 
    {
      echo $this->error_number . ' ' . $this->error_text;
      echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
    } else {
      echo 'WARNING: An Error occurred, please refresh the page and try again.';    
    }
    trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);
    if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
    echo '</div>';
  }

  function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {
    // bof: collect database queries
    if (defined('STORE_DB_TRANSACTIONS') && STORE_DB_TRANSACTIONS=='true') {
      global $PHP_SELF, $box_id, $current_page_base;
      if (strtoupper(substr($zf_sql,0,6))=='SELECT' /*&& strstr($zf_sql,'products_id')*/) {
        $f=@fopen(DIR_FS_SQL_CACHE.'/query_selects_' . $current_page_base . '_' . time() . '.txt','a');
        if ($f) {
          fwrite($f,  "\n\n" . 'I AM HERE ' . $current_page_base . /*zen_get_all_get_params() .*/ "\n" . 'sidebox: ' . $box_id . "\n\n" . "Explain \n" . $zf_sql.";\n\n");
          fclose($f);
        }
        unset($f);
      }
    } 

----------------------------------------------------------------------------------------------------------------