Print

[valhall01]

Hello,

When attempting to install CPG at a Yahoo Small Business site, I receive the following error message:

mySQL Error: Unknown MySQL erroron query ' CREATE TABLE cpg133_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', pic_count int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', last_addition datetime NOT NULL default '0000-00-00 00:00:00', stat_uptodate enum('YES','NO') NOT NULL default 'NO', keyword VARCHAR( 50 ), PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'


Can one of you wonderful and patient experts PLEASE help?



Many thanks, in advance.

Valerie

[Nibbler]

It says 'Unknown MySQL error', that's not a lot to go on. Check your db user has CREATE rights to the database.

[valhall01]

Hi Nibbler,

I do so appreciate you getting back to me so quickly.  Using MyPHP Admin, I have checked that my database user specified in the install screens DOES have the appropriate privildedges and I am still receiving the same error message.



Thank you.

[Joachim Müller]

Did you take a look at the sticky thread coppermine + yahoo hosting right on this very sub-board?