Error Approving and Unapproving Images

[seelie]

I get the following error when attempting to Approve or Unapprove Images, and even when clicking on the Approve Images Link:

Code: [Select]

Unknown column 'p.ID_CAT' in 'on clause'
File: /home/<directorypath here>/Sources/Load.php(1711) : eval()'d code
Line: 1575
I checked throughout the forum, and used one of the files in the one thread that referenced this.  Same error.  Any ideas?

[SMFHacks]

Hotfix
Open Gallery.template.php
On line 1575
Find

Code: [Select]

FROM {$db_prefix}gallery_pic AS p, {$db_prefix}members AS m
Replace with

Code: [Select]

FROM ({$db_prefix}gallery_pic AS p, {$db_prefix}members AS m)


[seelie]

I replaced all instances of the initial text with the new text ... and that did the trick.  Thanks!

[SMFHacks]

I replaced all instances of the initial text with the new text ... and that did the trick.  Thanks!

I would be a little care replacing them all. It might cause something unexpected.

Glad it works now though.

[seelie]

I replaced all instances of the initial text with the new text ... and that did the trick.  Thanks!

I would be a little care replacing them all. It might cause something unexpected.

Glad it works now though.

I thought about that ... is why I keep backup files   Thus far, the gallery has been error and oddity free since implementing hotfix.