Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: SQL query error when installing  (Read 4166 times)

0 Members and 1 Guest are viewing this topic.

nelgar

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
SQL query error when installing
« 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.
Logged

casNuy

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 671
  • My other hobby
    • Nuy Community
Re: SQL query error when installing
« Reply #1 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL query error when installing
« Reply #2 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.