MoPics Question

[JoeWoodworker]

I was hoping someone could give me a hand with this little issue regarding the MoPics contribution.

 

When I go add the new column info in MYPHPAdmin I get this error.

 

 

Error

 

SQL-query :

 

ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`

 

MySQL said:

 

 

alter command denied to user: 'joewood@localhost' for table 'products'

 

 

Any suggestions would be sincerely appreciated.

 

Thanks

Joe

[JoeWoodworker]

I noticed that I was confused about the instructions where they read....

 

Insert a new column into the products table - products_bimage.

 

Obviously, I have to do that first. But now I dont quite get how to do that in MYPHPAdmin

 

Any ideas?

 

Thanks

Joe

[Ajeh]

This command includes a database name as well as the table and field:

ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`

 

Change that to read:

ALTER TABLE `products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`

[JoeWoodworker]

Database weinerd_osc2 running on localhost

Error

 

SQL-query :

 

ALTER TABLE `products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`

 

MySQL said:

 

 

Unknown column 'products_bimage' in 'products'

--------------------

I'm not sure how to add the new column for 'products_bimage'.

 

Any suggestions for such a fool?

[Ajeh]

On the alter statements do you have one above that for adding the new field products_bimage? If so, add that line first ... :D