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: 1.2.1 -> 1.4.5 - mySQL error: Table 'tablename.gallery_filetypes' doesn't exist  (Read 4559 times)

0 Members and 1 Guest are viewing this topic.

pieter

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

hi,

i just tried to upgrade from version 1.2.1 to 1.4.5.
after running update.php, i got an overview of all changes that had been made, and this gave no errors.

i clicked the version checker link, and i just got a blank page saying "fatal error: ", with nothing more.
same goes for my indexpage.
with debug_mode = 1 (i had to change it in the database itself since every page is blank now), i got the following message:

While executing query "SELECT extension, mime, content, player FROM gallery_filetypes;" on 0
mySQL error: Table 'tablename.gallery_filetypes' doesn't exist

can anyone please help me?
many thanks in advance...
Logged

Nibbler

  • Guest

Post a link, ensure you uploaded the new version of update.sql before you updated and taht your mysql user has the ALTER privilege.
Logged

pieter

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

hi nibbler,

many thanks for your quick response...
i can 't post a link, as the gallery is in a password protected part of the website  :(

i uploaded the new version of update.sql, but my mysql user has no alter privilege.
can i change my mysql privileges, and run the update.php again to fix it?

and can i remove the alter privilege again afterwards?

thx,
pieter
Logged

Nibbler

  • Guest
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.