Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 Table does not exist


Guest

Recommended Posts

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

 

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

Link to comment
Share on other sites

The contents of the SQL update file, or the lines of SQL in the install files

Nic

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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);

 

 

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

Link to comment
Share on other sites

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 ;

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...