Jump to content

Graphicpoet

Members
  • Content count

    49
  • Joined

  • Last visited

Everything posted by Graphicpoet

  1. I have pretty much done everything short of putting up the altered pages from the installation folder. I am just now becoming aquainted with database technology so I would appriciate any help as to why I get an error trying to install the .....---option_type_feature.sql---- When I install the below content I get the error--------------------------------------------------------------- Error SQL-query : 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 ) MySQL said: #1060 - Duplicate column name 'products_options_type' [Documentation] ? [back]-------------------------------------------------------------------------------------- Here is the install::::: 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 ) ; INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (169, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (170, 'Text product option type', 'PRODUCTS_OPTIONS_TYPE_TEXT', '1', 'Numeric value of the text product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (171, 'Radio button product option type', 'PRODUCTS_OPTIONS_TYPE_RADIO', '2', 'Numeric value of the radio button product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (172, 'Check box product option type', 'PRODUCTS_OPTIONS_TYPE_CHECKBOX', '3', 'Numeric value of the check box product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (173, 'File product option type', 'PRODUCTS_OPTIONS_TYPE_FILE', '4', 'Numeric value of the file product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (174, 'ID for text and file oroducts options values', 'PRODUCTS_OPTIONS_VALUE_TEXT_ID', '0', 'Numeric value of the products_options_values_id used by the text and file attributes.', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (175, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (176, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL); CREATE TABLE `products_options_types` ( `products_options_types_id` int(11) NOT NULL default '0', `products_options_types_name` varchar(32) default NULL, `language_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_options_types_id`,`language_id`) ) TYPE=MyISAM COMMENT='Track products_options_types'; INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (0, 'Select', 1); INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (1, 'Text', 1); INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (2, 'Radio', 1); INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (3, 'Checkbox', 1); INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (4, 'File', 1); Thanks Graphicpoet
  2. Graphicpoet

    UPLOAD IS GHOST!?

    I have installed it twice and now i get the upload form with my product. Now my question is WHY after the order is placed the image uploaded seems to not upload? I know this may be a broad question but I sure would appreciate any help. Yes the my folder is located at images/upload it is chmod 777 is there a line or something I am missing cause I see no error messages anywere... thanks in advance graphicpoet
  3. Graphicpoet

    [CONTRIBUTION] File uploads as an Option Feature

    I do not know if any questions are being answered off the board here but I have a question. I got the feature-.77 all installed and error FREE! it works like a charm. Theres on small problem however.....NOTHING uploads. I also have read thru the forum and I do have not encountered any link that says "View Now." Could someone please direct me in the correct direction to correct or figure out what is needed? THanks in Advance
  4. Graphicpoet

    UPLOAD IS GHOST!?

    Oh I am sorry. I thought I was replying directtly into a contribution area on the forum for the contribution that allows a customer to upload a file to your server per their customize order from your store. "Feature .77" So since I am here anyone with any help? thanks Graphicpoet
  5. hello, I hope someone can help me with this small issue. In the image below you will see a small powder blue square image and a space that is made to fit a infobox header title in. For the sake of design esthetics I would like to get this gone. I have tried to edit the "infopages.php" box page and no good results and the english. php with no success, any ideas?? :-" Thanks in advance
  6. Graphicpoet

    Credit Card Number Question?

    Hey I aint mad atcha .... cause your right. Thanks though let me see if I can find the information. And while your looking on here what is a more conventional way to secure such information other than relying on the so called Secure mode of powwebs offerings?
  7. I have chosen the split option for my store meaning. I get the inside digits to my email and the outside digits to the database. My question is how do I retrieve the digits from the database? Actually my store is still being designed but live and I am getting orders already so I would really appriciate a quick HINT!! Thanks from Graphicpoet
  8. I have about 80 products i need to re-apply their attributes but to do this by hand would be a nightmare. Is there any way to do this more efficiently?? Thanks Grapahicpoet
  9. I have installed everything as instructed. NOW. When I go to my admin area and try and make use of the contribution.... WELL? I get nothing ... NADA....no errors .. no new features... no way to sort ... no nothing! Can someone point me in the right direction. Thanks Graphicpoet
  10. Graphicpoet

    Products Attributes Sort v1.0

    Ok... now I am about to install THIS contribution. Before I do can someone tell me if it is a needed thing to have the "Weight Mod installed?" My siituation will never use this feature (WEIGHT). Graphicpoet
  11. Graphicpoet

    Products Attributes Sort v1.0

    I am not a code person at all I am a visual designer but even we have to think every now and then. (SMILE) I would suggest setting up your sorting as instructed... you know? s (sort 1) m (sort 2) L (sort 3) XL(sort 4) and in order to not do this for all the products you have? You need to download this contribution which I use. http://www.oscommerce.com/community/contributions,1664/ hope this helps ..... THIS COPIES THE PRODUCT Attributes to other products you choose. it takes a little to install it but if you take your time and do not be impatient it should work for you...
  12. hello all I am having a problem keeping my dropdown menues in the proper sequence. for instance I want it to read. s m l xx xxx xxxx but after a while I get xxxx xxx xx l m s for no apparent reason and its on many products .... can someone please tell me how to cure this.... Thanks Graphicpoet...~
  13. Graphicpoet

    Is there a contribution that does this with...?

    Thanks very much.... I ended up using what you suggested ... I found it bundled with another feature i needed..... UPLOADING images .... it works like a dream..... LOts of errors at first but a few questions and its all up like magic..... :D Thanks again....
  14. Is there a contribution that adds a text box field to the product purchase box. I need to give the option up-front to give phrases or names to be put on product such as clothing, cups, mugs etc. Any thoughts Thanks Graphicpoet
  15. Graphicpoet

    file feature 77 (Uploading Images to site)

    I have encountered a fatal error since installing the upload contribution. The admin side seems to be going great just need to get the sight back showing... Fatal error: Cannot redeclare class tablebox in /www/M/Mysight/root/Mystore/includes/classes/boxes.php on line 13 Thanks in advance...
  16. Graphicpoet

    Fatal error NEED help.

    I have encountered a fatal error since installing the upload contribution. The admin side seems to be going great just need to get the sight back showing... Fatal error: Cannot redeclare class tablebox in /www/M/Mysight/root/Mystore/includes/classes/boxes.php on line 13 Thanks in advance...
  17. Graphicpoet

    Attribute Sets Contribution

    well I kinda figured it out. You simply edit the first set and revisit and the other sets appear..... NOW i hope that is the way it was meant to be. FOR me it works so cool.... Great TIME saver!!!SweeeWWW I was about to die with all the product I need to put up!!!!LOL
  18. Graphicpoet

    Attribute Sets Contribution

    Hello all, I am using versrion 2.0 just waiting a more defined 3.0. For my purposes 2.0 is fine. I have a slight problem however. How do you create multiple drop down list on the "EDIT" page where you create your new product. I keep getting all the attribute sets in one drop down. ----also I have other contributions installed to help with some of the admin side with attributes. Has anyone encountered a adverse reaction by using other contributions in the admin area? Graphicpoet
  19. Graphicpoet

    Products Attributes Sort v1.0

    Ok I got one DUH question..... I installed everything but how do you begin to use it. I have no errors as far as I can see and i see some modifications in the admin but how do I manipulate the sort order. THanks..... Graphicpoet! :blink:
  20. Graphicpoet

    Need Master Product number definitions?

    Thanks Mugitty..... I do believe you got me solved.... :thumbsup:
  21. Hello all, I need a little help. I do not want to start installing things and then its all wrong. Anyone now what the numbers mean or do you put "YES" , "NO?" THanks in advance.
  22. Hello all, I am having a bit of a deal with my product options I am selling shirts and here is what keeps happening: I assign the attributes to a single item - T-shirt Long Sleeve T-shirt Sweat Shirt Hooded Sweat Shirt Next because of price difference: I add T-shirt Long Sleeve T-shirt (+5.00) Sweat Shirt (+10.00) Hooded Sweat Shirt (+15.00) Now the problem is when I go to the store and make a purchase on the T-shirt that has absolutely no additional cost associated to it goes up by $10 and the other items price our weird as well any ideas. ( I do have the contribution Master Products installed) and may just use the slave option but I was kinda just seeing how I could just do this at this time to get things rolling. any suggestions ? Thanks. GraphicPoet
  23. Graphicpoet

    [CONTRIBUTION] File uploads as an Option Feature

    THanks alot Matt. ANY clues as to why I get this error on my site index?: Fatal error: Call to a member function on a non-object in /www/X/XXXXXXX/htdocs/XXXX/includes/header.php on line 51 Thanks again and in advance :thumbsup:
  24. Graphicpoet

    [CONTRIBUTION] File uploads as an Option Feature

    I have an error in my admin after installing the contribution..... and I am not really that versed at database stuff so could someone please gimme a hand on solving this problem: 1146 - Table 'Freshair.TABLE_PRODUCTS_OPTIONS_TYPES' doesn't exist select products_options_types_id, products_options_types_name from TABLE_PRODUCTS_OPTIONS_TYPES where language_id='1' order by products_options_types_id [TEP STOP] it seems simple to solve if you know what you are doing, but alas I do not :D THanks in advance. Graphicpoet
  25. Graphicpoet

    using the upload contribrution -NON php person

    Here it is John. http://www.oscommerce.com/community/contri...customer+upload
×