SQL query error when installing

[nelgar]

When I try to install Coppermine on PostNuke I get this error on one of the queries (the other all give me a beautiful green dot  ) :

ALTER TABLE pn_cpg_pictures
DROP INDEX search, ADD FULLTEXT search (title,caption,keywords,filename,user1,user2,user3,user4)
mySQL Error: Table 'snl93826.pn_cpg_pictures' doesn't exist

I don't know a thing about creating/adding/editing mySQL tables so any help  on what to do now will be muchly apprectiated.

[casNuy]

This is not about pnCPG since my module does not change any standard tables. I think you also posted the same question on my home site.
You need the following :
Postnuke .75x or lower
- Coppermine 1.3.5
- pnCPG 2.7

Postnuke 0.76x or higher :
- Coppermine 1.4.2
- pnCPG 3.1

Cas

[Joachim Müller]

make sure that your mysql user has the permissions to execute the alter table and drop index commands.