osCmax v2.5 User Manual
Results 1 to 6 of 6

1054 - Unknown column 'popt.products_options_type

This is a discussion on 1054 - Unknown column 'popt.products_options_type within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; opening detail downloadable products but get this error Code: sample download [DL 1] $0.00 Click to enlarge Test download 1054 ...

      
  1. #1
    Anonymous
    Guest


    Default 1054 - Unknown column 'popt.products_options_type

    opening detail downloadable products but get this error

    Code:
    sample download
    [DL 1] 	$0.00
    
    Click to enlarge
    
    Test download
    1054 - Unknown column 'popt.products_options_type' in 'field list'
    
    select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from products_options popt, products_attributes patrib where patrib.products_id='64' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_name
    
    [TEP STOP]
    any clue?[/code]

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    You have added the option type feature mod, but have not run the included sql files on the database. Do that and the error goes away.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Anonymous
    Guest


    Default

    what do you mean? its all ok but after updating the newest template bts patch from this site this error comes up
    i did inserting the bts sql from btsv1.2a_For_max_upgrade.zip

  4. #4
    Anonymous
    Guest


    Default

    its weird i didn't installing option type 1.6 before patching the BTS 1.5a
    i did clean install max 1.5.5 working fine then i did the bts1.5a patch and the errors showed up

    i just inserting this without any files from option type 1.6 zip file, is that ok?
    ALTER TABLE products_options
    ADD products_options_type INT( 5 ) NOT NULL ,
    ADD products_options_length SMALLINT( 2 ) DEFAULT '32' NOT NULL ,
    ADD products_options_comment VARCHAR( 32 ) ;

    ALTER TABLE customers_basket_attributes
    ADD products_options_value_text VARCHAR( 32 ) ;

    error is gone...

  5. #5
    Anonymous
    Guest


    Default

    it seems the bts 1.2 upgrade for max 1.5.5 has some code included in the products_info.tpl.php file included in the aabox template content folder.

    this should be taken out of the bts upgrade or it forces everyone to install option type feature 1.6

  6. #6
    Anonymous
    Guest


    Default

    Quote Originally Posted by Anonymous
    it seems the bts 1.2 upgrade for max 1.5.5 has some code included in the products_info.tpl.php file included in the aabox template content folder.

    this should be taken out of the bts upgrade or it forces everyone to install option type feature 1.6
    i meant code from the option type 1.6 products_info.tpl.php

Similar Threads

  1. 1054 - Unknown column 'a.authors_id' in 'on clause'
    By fuzzyphil in forum osCmax v2 Customization/Mods
    Replies: 29
    Last Post: 01-08-2009, 04:05 PM
  2. Error: 1054 - Unknown column
    By islander in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 02-27-2006, 11:31 AM
  3. 1054 - Unknown column 'p.vendors_product_price'
    By RoyceK in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 02-12-2006, 08:22 PM
  4. 1054 - Unknown column when restock product
    By DigitalPimp in forum osCmax v2 Customization/Mods
    Replies: 3
    Last Post: 07-25-2005, 02:57 PM
  5. 1054 - Unknown column - Help, please !
    By Anonymous in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 11-27-2002, 11:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •