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: Upgrade database permission problem  (Read 3650 times)

0 Members and 1 Guest are viewing this topic.

jabetcha

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • http://www.justfour.us
Upgrade database permission problem
« on: October 21, 2003, 04:43:27 pm »

I discovered this when upgrading, I thought I might pass it along, in case it happens to someone else....

The upgrade went fine, and I ran the update.php script to upgrade from 1.1. However I recieved 4 messages like:

ALTER TABLE cpg_comments add msg_raw_ip tinytext  ALREADY DONE

Whenever I tried to view a picture, it gave be a critical database error.

I found that my database user didn't have ALTER TABLE permission.

If this happens you will need to run the 4 ALTER TABLE commands in the sql/update.sql file as a user with update permission.

Perhaps a permissions check should be added to the update script?
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.