Graphicpoet

I may end up having to just re-up my back-ups and start all over but I really need to stumble thru this and make it happen so any help will be appriciated ... Thanks in advance..... the error message that shows as my index.php loads is: Fatal error: Call to a member function on a non-object in /www/X/XXXXXXX/htdocs/XXXX/includes/header.php on line 51 Graphicpoet ..... the name says it all ...... not a brag.... it means I am lost in this PHP stuff but I am learining.... :rolleyes:

I get this error when signing on my site .... any ideas. Thanks in advance

Well Chris they always said common sense beats any book or nerd-heavy-manaul .. so thanks for the common approach I did find all the tables and with doing so I also found the missing part of the data and simply pasted it in the sql query window and "WALLA" its all done. Thanks Graphicpoet

Thank you Carine, I did as you said: "run the sql query; select * from products_options_types" I got this: Error SQL-query : SELECT * FROM products_options_types LIMIT 0 , 50 MySQL said: #1146 - Table 'XXXXXX.products_options_types' doesn't exist [Documentation] ? [back] NOW as far as DATA is concerned other than the esthetics of the design there is NO data needed to be saved. From the data perspective this is a "NEW INSTALL." I just do not want it to effect any of the 3 or 4 other contributions already installed on this store site. Now I looked for the column to see if it was present, b[/b]ut got this back: The reason I am being so detailed here is this is the VERY LAST THING I HAVE TO DO to make this contribution operational. I have spent hours merging .php files and rechecking and confirming those merges. I get to this one database install and get stuck. My lack of knowledge of course but still disheartening..... I could pay someone, but I really need to do this. here is a link to the data I am trying to put in------The Database content Is there anything I can do here in this area below to put this into the database?:

Thanks so much for your reply. I was told: It just reports that the column already exists, so you probably already executed the query. Since these queries do not return results, it's not that obvious if it ran successfully. --To check if it finished the last step, run the sql query; select * from products_options_types I did that and got: Error SQL-query : SELECT * FROM products_options_types LIMIT 0 , 50 MySQL said: #1146 - Table 'XXXXXX.products_options_types' doesn't exist [Documentation] ? [back] NOW as far as DATA is concerned other than the esthetics of the design there is NO data needed to be saved. From the data perspective this is a "NEW INSTALL." I just do not want it to effect any of the 3 or 4 other contributions already installed on this store site. Now I looked for the column to see if it was present, but got this back: The reason I am being so detailed here is this is the VERY LAST THING I HAVE TO DO to make this contribution operational. I have spent hours merging .php files and rechecking and confirming those merges. I get to this one database install and get stuck. My lack of knowledge of course but still disheartening..... I could pay someone, but I really need to do this. here is a link to the data I am trying to put in------The Database content Is there anything I can do here in this area below to put this into the database?:

well thanks for your suggestion and I will do that but this is kinda the LAST Step on a project I share with one other person that needs to be up by monday. SO at least tell what you think of this error and from there I shall seek a solution: 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] Thankx alot Graphicpoet

I have been pretty sure to do everything slow and percise, now I am kinda just stuck. I am not at all versed on database lingo or methodology so I am getting an error trying to install ------option_type_feature.sql----- can i just paste this into the query window as is or do I need to do some manual stuff? 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); Thankx for any help in advance. Graphicpoet.

Well I am pretty new at all this but here goes a suggestion. Just offer a free catalog to your customers from your store and give it a price of $0 that way as they register they simply order at no cost your free print catalog. Graphicpoet

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

which contribution are you trying to install?

Is there a contribution that allows customers to upload files to a server for collection by a store owner. FOR EXAMPLE: UPLOAD a .JPG for placement on a mouse pad that was purchased for the customizaition of putting a .JPG of a newborn on the PAD. Thanks GraphicPoet B)

sorry but the actual address I found the categories.php is <-------admin/includes/languages/english/categories.php-------> -NOT - <------admin/includes/categories.php-----------------> thanks

MASTER PRODUCT INSALL (Contribution) I have not went any further but I installed every single thing as written to the letter but came across something very interesting..... I can not find this .php page...... <-----admin/includes/languages/categories.php----->|||| Does it exist or is it simply this <------admin/includes/categories.php-----------------> The installation doc says the first one but the only one I can find is the latter and I'd hate to get this far and mess it up. Graphicpoet....Please help///// :blink: