Jump to content
Sign in to follow this  
JoeWoodworker

MoPics Question

Recommended Posts

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


Evil will always triumph over good...

Because good is dumb.

- D.H.

Share this post


Link to post
Share on other sites

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


Evil will always triumph over good...

Because good is dumb.

- D.H.

Share this post


Link to post
Share on other sites

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`

Share this post


Link to post
Share on other sites

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?


Evil will always triumph over good...

Because good is dumb.

- D.H.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×