Hello - just in case this helps anyone I mananged to fix the problem.
I am now quite sure that the initial problem is that the windows server I am using does not have permissions set to allow a web page to create tables within a database.
So I looked in Admin > Includes > additional_images_configure.php
Begining from line 212 is the following code:
// this array is used for creating new tables
$tables_array = array();
$tables_array [] = array ( 'tablename' => 'additional_images',
'create' => "CREATE TABLE additional_images (
additional_images_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL default '0',
images_description varchar(64) default NULL,
thumb_images varchar(64) default NULL,
medium_images varchar(64) default NULL,
popup_images varchar(64) default NULL,
PRIMARY KEY (additional_images_id),
KEY products_id (products_id)
);",
'remove' => "DROP TABLE IF EXISTS additional_images;" );
// this array is used for altering table that already exist in the default osC shop
$table_mods_array = array();
$table_mods_array [] = array ( 'tablename' => 'products',
'columnname' => 'products_image_med',
'create' => "ALTER TABLE products ADD products_image_med VARCHAR(64) default NULL AFTER products_image;",
'remove' => "ALTER TABLE products DROP products_image_med" );
$table_mods_array [] = array ( 'tablename' => 'products',
'columnname' => 'products_image_pop',
'create' => "ALTER TABLE products ADD products_image_pop VARCHAR(64) default NULL AFTER products_image_med;",
'remove' => "ALTER TABLE products DROP products_image_pop" );
$table_mods_array [] = array ( 'tablename' => 'products',
'columnname' => 'products_image_description',
'create' => "ALTER TABLE products ADD products_image_description VARCHAR(64) default NULL AFTER products_image_pop;",
'remove' => "ALTER TABLE products DROP products_image_description" );
// table mod added to catch earlier versions of Additional Images
$table_mods_array [] = array ( 'tablename' => 'additional_images',
'columnname' => 'thumb_images',
'create' => "ALTER TABLE additional_images ADD thumb_images VARCHAR(64) default NULL AFTER images_description;",
'remove' => "ALTER TABLE additional_images DROP thumb_images" );
I gave this to my techie mate and he manually created the tables using php myadmin
Then I logged in and went to
http://www.mydomain.com/catalog/admin/addi...s_configure.php and it said that some of the items were not installed and I clicked on the "Force Configuration Defaults" and lciked the button and hey presto it all worked!!!
I must admit this whole problem would have been much simpler if the sql for a fresh install had been included..
great contribution otherwise!!