Guest Posted June 23, 2009 Posted June 23, 2009 I tried to install the "more pix add on" and now my site is saying: 1146 - Table 'hardt2_ShamelessTemptations.products_images' doesn't exist select p.products_id, pi.image_filename, p.products_tax_class_id, p.products_price from products p left join products_images pi on p.products_id = pi.products_id and pi.category_page = '1' where p.products_status = '1' order by p.products_date_added desc limit 10 [TEP STOP] I have the table defined in the database_tables file as define('TABLE_PRODUCTS_IMAGES', 'products_images'); I have no clue what to do next. Can someone please help me out a bit?
Jan Zonjee Posted June 23, 2009 Posted June 23, 2009 I have the table defined in the database_tables file as define('TABLE_PRODUCTS_IMAGES', 'products_images'); That's good but did you also "run" the sql file or sql code to add that table and it's fields to the database?
Guest Posted June 23, 2009 Posted June 23, 2009 That's good but did you also "run" the sql file or sql code to add that table and it's fields to the database? no can you tell me how to do that?
FIMBLE Posted June 23, 2009 Posted June 23, 2009 log into your Web host control panel click on phpmyadmin (you might have to search for it under Databases) When the page loads select your database, you will see the tables down one side (the left). in the main windows click the SQL tab a new page will load and in here you can paste the SQL. OR you can click on insert >> Browse >> select the SQL file and then click GO Back up before you attempt any of this Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
Guest Posted June 23, 2009 Posted June 23, 2009 log into your Web host control panelclick on phpmyadmin (you might have to search for it under Databases) When the page loads select your database, you will see the tables down one side (the left). in the main windows click the SQL tab a new page will load and in here you can paste the SQL. OR you can click on insert >> Browse >> select the SQL file and then click GO Back up before you attempt any of this Nic I am a total newb to this what sql file am I pasting, I know how to navigate around phpmyadmin but I have no idea what I'm supposed to be pasting as the SQL
FIMBLE Posted June 23, 2009 Posted June 23, 2009 The contents of the SQL update file, or the lines of SQL in the install files Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
Guest Posted June 23, 2009 Posted June 23, 2009 The contents of the SQL update file, or the lines of SQL in the install filesNic it's obvious I'm not understanding what to do, I don't see any contents of the SQL update file or lines, I just updated the files like the read me file said in dreamweaver. I'm over my head I guess lol looks like i just need to forget about the more images for now
FIMBLE Posted June 23, 2009 Posted June 23, 2009 Which contribution is it ? Give me the link to it and i will get the SQL for you so you can paste it Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
Guest Posted June 23, 2009 Posted June 23, 2009 Which contribution is it ?Give me the link to it and i will get the SQL for you so you can paste it Nic The contribution I downloaded is here : http://addons.oscommerce.com/info/1611 the latest version of it. This is my site: http://shamelesstemptations.com/catalog/ I'm really not trying to act like a baby but I thank you for taking the time to help me.
FIMBLE Posted June 23, 2009 Posted June 23, 2009 The SQL you need is here Copy the code and then paste it into your phpmyadmin SQL window (directions above) Copy all of the code in the code box. BTW i noticed there is an auto installer there, i have never used it before so do not know if it is any good or not, have you tried it? ALTER TABLE `products` ADD `products_subimage1` VARCHAR(64) AFTER `products_image`; ALTER TABLE `products` ADD `products_subimage2` VARCHAR(64) AFTER `products_subimage1`; ALTER TABLE `products` ADD `products_subimage3` VARCHAR(64) AFTER `products_subimage2`; ALTER TABLE `products` ADD `products_subimage4` VARCHAR(64) AFTER `products_subimage3`; ALTER TABLE `products` ADD `products_subimage5` VARCHAR(64) AFTER `products_subimage4`; ALTER TABLE `products` ADD `products_subimage6` VARCHAR(64) AFTER `products_subimage5`; INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (6124, 'More Pics', 'Configuration Options for More Pics', 20, 1); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Show All MorePics on Product Info page', 'MOPICS_SHOW_ALL_ON_PRODUCT_INFO', 'true', 'Show All extra images from the MorePics contrib on Product Info page.', 6124, 2, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Group parent image with sub-images', 'MOPICS_GROUP_WITH_PARENT', 'true', 'Set to true to group all images with parent (original) image.', 6124, 4, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Use SMALL_IMAGE_ Restrictions', 'MOPICS_RESTRICT_IMAGE_SIZE', 'true', 'Restrict all product images to SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT values.', 6124, 6, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Restrict parent image size', 'MOPICS_RESTRICT_PARENT', 'true', 'Restrict parent image size to SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT values. This setting overrides "Use SMALL_IMAGE_ Restrictions" setting.', 6124, 8, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Table Alignment', 'MOPICS_TABLE_ALIGNMENT', 'center', 'Align Pics table to the left or to the right of the products description.', 6124, 10, now(), now(), NULL, 'tep_cfg_select_option(array(''left'', ''right'', ''center''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Table Location', 'MOPICS_TABLE_LOCATION', 'below', 'Align Pics table to the sides, above or below description.', 6124, 12, now(), now(), NULL, 'tep_cfg_select_option(array(''sides'', ''above'', ''below'', ''bottom''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Number of Columns', 'MOPICS_NUMBER_OF_COLS', '3', 'Number of columns to display.', 6124, 14, now(), now(), NULL, NULL); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Number of Rows', 'MOPICS_NUMBER_OF_ROWS', '2', 'Number of rows to display.', 6124, 16, now(), now(), NULL, NULL); Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
Guest Posted June 23, 2009 Posted June 23, 2009 The SQL you need is hereCopy the code and then paste it into your phpmyadmin SQL window (directions above) Copy all of the code in the code box. BTW i noticed there is an auto installer there, i have never used it before so do not know if it is any good or not, have you tried it? ALTER TABLE `products` ADD `products_subimage1` VARCHAR(64) AFTER `products_image`; ALTER TABLE `products` ADD `products_subimage2` VARCHAR(64) AFTER `products_subimage1`; ALTER TABLE `products` ADD `products_subimage3` VARCHAR(64) AFTER `products_subimage2`; ALTER TABLE `products` ADD `products_subimage4` VARCHAR(64) AFTER `products_subimage3`; ALTER TABLE `products` ADD `products_subimage5` VARCHAR(64) AFTER `products_subimage4`; ALTER TABLE `products` ADD `products_subimage6` VARCHAR(64) AFTER `products_subimage5`; INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (6124, 'More Pics', 'Configuration Options for More Pics', 20, 1); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Show All MorePics on Product Info page', 'MOPICS_SHOW_ALL_ON_PRODUCT_INFO', 'true', 'Show All extra images from the MorePics contrib on Product Info page.', 6124, 2, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Group parent image with sub-images', 'MOPICS_GROUP_WITH_PARENT', 'true', 'Set to true to group all images with parent (original) image.', 6124, 4, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Use SMALL_IMAGE_ Restrictions', 'MOPICS_RESTRICT_IMAGE_SIZE', 'true', 'Restrict all product images to SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT values.', 6124, 6, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Restrict parent image size', 'MOPICS_RESTRICT_PARENT', 'true', 'Restrict parent image size to SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT values. This setting overrides "Use SMALL_IMAGE_ Restrictions" setting.', 6124, 8, now(), now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Table Alignment', 'MOPICS_TABLE_ALIGNMENT', 'center', 'Align Pics table to the left or to the right of the products description.', 6124, 10, now(), now(), NULL, 'tep_cfg_select_option(array(''left'', ''right'', ''center''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Table Location', 'MOPICS_TABLE_LOCATION', 'below', 'Align Pics table to the sides, above or below description.', 6124, 12, now(), now(), NULL, 'tep_cfg_select_option(array(''sides'', ''above'', ''below'', ''bottom''),'); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Number of Columns', 'MOPICS_NUMBER_OF_COLS', '3', 'Number of columns to display.', 6124, 14, now(), now(), NULL, NULL); INSERT INTO `configuration` ( `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ( 'Number of Rows', 'MOPICS_NUMBER_OF_ROWS', '2', 'Number of rows to display.', 6124, 16, now(), now(), NULL, NULL); Ok so I tried this and it's giving me the same exact error, I did actually try the auto installer after I couldn't get it to work but I just got a page that said it was installed and to delete the install immediately, it didn't even go through any motions of trying to do anything. I'm kinda under the impression I may have to start all over with a clean database, which is fine since I needed to delete alot anyway. I just switched servers and have been having issues with all my sites that use databases so it's been a little frustrating to me. Thanks for your help though
Guest Posted June 23, 2009 Posted June 23, 2009 I think I may have fixed it, I added this as well CREATE TABLE IF NOT EXISTS `products_images` ( `images_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL, `image_filename` varchar(64) NOT NULL, `images_order` int(11) NOT NULL, `category_page` tinyint(1) NOT NULL default '0', `product_page` tinyint(1) NOT NULL default '0', `popup_page` tinyint(1) NOT NULL default '0', `last_modified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`images_id`), KEY `products_id` (`products_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
FIMBLE Posted June 23, 2009 Posted June 23, 2009 there you are then you CAN fix your cart!! Well done Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.