coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: nelgar on December 04, 2005, 06:51:21 PM

Title: SQL query error when installing
Post by: nelgar on December 04, 2005, 06:51:21 PM
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  :D) :

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.
Title: Re: SQL query error when installing
Post by: casNuy on December 05, 2005, 06:12:03 PM
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
Title: Re: SQL query error when installing
Post by: Joachim Müller on December 08, 2005, 08:13:53 AM
make sure that your mysql user has the permissions to execute the alter table and drop index commands.