MySql error

[jamaicasearch]

I am tring to install the MO_PIC mod but for some reason the PHPMyAdmin gives this error...when i try to do the alter table part of it..... any idea why?

 

Database commercecart running on localhost

Error

 

SQL-query :

 

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

 

MySQL said:

 

ALSO: when adding the additional tables for the new affiliate program MYSQL gives an error...this should be a simple procedure why the error??

 

 

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

[hobbzilla]

denied to user is the key to the error.

 

Have you checked to make sure that you have rights to alter the table with the catalog1 MySQL userid?

[Ajeh]

Is your MySQL database really called catalog or is it called fred ... that is hard coded in there with the MySQL database name with the assumption it's name is catalog.

 

Just edit the name to your MySQL database name.

[jamaicasearch]

woow!...thanks...my database is called commercecart and not catalog...thank for the reminder

 

two heads are truly better than one

 

Everton

[jamaicasearch]

my database name is "commercecart" username is "catalog1" password is "catalog2"

 

i change the name catalog to commercecart...but i still get the same error

[Ajeh]

Last time I loaded this, I was in phpMyAdmin ... sitting in the products table, pasted in:

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

 

Edited that to:

ALTER TABLE `mystore`.`products` ADD `products_bimage` VARCHAR(64) AFTER `products_image`

 

Make sure you are using the right back tick marks and not quote marks on the database name.

[Mark Evans]

Or you could use

 

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

 

Then it doesn't matter what your database is called ;)

[Ajeh]

*cough*cheater*cough* :D

[jamaicasearch]

Mark & Linda thanks for the assistance ..I will try both way later today....gonna try mark's way first as it looks a little familiar...then if it doesnt work i will try Linda's way....if that doesn,t work i will then resort to my life long motto

 

"If at first you dont succeed, QUIT !!!! no sence making a DAMN FOOL of yourself"

 

 

Hey I am just kidding Just wanted to tell a JAMAICAN joke.

 

thanks again guys ...

[jamaicasearch]

Hi,

 

I am having problems with the sql file when installing the affiliate V2.0 preview MOD the below is the error i get

 

Database commercecart running on localhost

Error

 

SQL-query :

 

CREATE TABLE configuration (

 

configuration_id int(11) NOT NULL auto_increment,

 

configuration_title varchar(64) NOT NULL default '',

 

configuration_key varchar(64) NOT NULL default '',

 

configuration_value varchar(255) NOT NULL default '',

 

configuration_description varchar(255) NOT NULL default '',

 

configuration_group_id int(11) NOT NULL default '0',

 

sort_order int(5) default NULL,

 

last_modified datetime default NULL,

 

date_added datetime NOT NULL default '0000-00-00 00:00:00',

 

use_function varchar(255) default NULL,

 

set_function varchar(255) default NULL,

 

PRIMARY KEY (configuration_id)

 

) TYPE=MyISAM

 

MySQL said:

 

 

Table 'configuration' already exists

 

 

any ideas??