Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: SQL query error when installing  (Read 4466 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.014 seconds with 19 queries.