Problema con l'inserimento di piu' immagini nel pann. admin

[Mariosuper]

Salve a tutti ho istallato http://www.oscommerce.com/community/contributions,1611 solo che non mi funziona in quanto mi da' questo errore :

1054 - Unknown column 'p.products_subimage1' in 'field list'

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

[TEP STOP]

Premetto che ho scaricato il primo dowloand grazie..

[lavoriamopervoi]

Salve a tutti ho istallato http://www.oscommerce.com/community/contributions,1611 solo che non mi funziona in quanto mi da' questo errore :

1054 - Unknown column 'p.products_subimage1' in 'field list'

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

[TEP STOP]

Premetto che ho scaricato il primo dowloand grazie..

non hai eseguito la query...

[Mariosuper]

scusa per la mia incapacita' ma non so' fare una query....

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', 'false', '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', 'false', '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''),');
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);

queste sono le tabelle d'aggiungere non e' che mi potresti fare un file sql e mandarmi il codice in modo tale che le query me le fanno in automatico... Scua..

[lavoriamopervoi]

ma questa che hai citato è una query, devi solo lanciarla....
PhpMyAdmin-->*tuodatabase*-->SQL

[Mariosuper]

Ora pultroppo mi si e' insorto un altro problema mettendo il file della contribution mi esce una strano errore :
credo che e' un problema di file categories che cliccandoci alla scritta potrete scaricare. Spero di risolverlo questo pesante enigma. Forse il problema sta' in questa definizione:

Then to replace the files by those of the file More Pics on FCKeditor.rar

ATTENTION If you made certain modification on the of the same files name this will erase these modifications, you will have to add them on these files.

Mi sono accorto che crea altre 5 sfoglia ma manca quella principale ovvero quella che secerna l'immagine del prodotto. P.S: ho istallato fkeditor

[Mariosuper]

Solo a me si e' verificato questo errore?

[hsg26]

usa la 1.3b clean and beauty e lascia perdere l'integrazione con fck che secondo me non funziona.

[Mariosuper]

Cioe'...mi potresti mandare il link di eventuali plugin... Grazie

[hsg26]

Cioe'...mi potresti mandare il link di eventuali plugin... Grazie

ogni tanto mi sembra che non leggete.

Hai la pagina della contribution che tu stesso hai indicato, e io ti ho detto quale versione di quella contribution scaricare. Semplice no?