Gallery will not install

[FirstGateDreamer]

Tried installing the Gallery module but it crashed the entire system front and back. I get the following error.

ERROR 99: Unknown column 'template' in 'field list'

I have the gallery installed on another site on the same server on the same CMS version and no problems.

Sounds complicated but I had 1.0.3 and hadn't used it yet. When I came to use it it told me to upgrade so I did and got the error. Deleted it then uploaded v 1.4.4 via XML and the module page said I was still using v1.0.3. If I hit install it gives me that error. Tried re-installing a few times and different versions with no luck. You will notice the Gallery is listed several times below. Yes I cleared the cache.

Any ideas?

my setup

Cms Version: 1.9.4.1

Installed Modules:

CMSMailer: 2.0.1
TinyMCE: 2.8.4
MenuManager: 1.7.6
ModuleManager: 1.4.2
News: 2.11.2
nuSOAP: 1.0.2
Search: 1.6.10
ThemeManager: 1.1.4
MleCMS: 1.6
CGSimpleSmarty: 1.4.8
Gallery: 1.4.4
Printing: 1.1.2
Gallery: 1.0.3
VisitorStats: 0.2.2
CGGoogleMaps: 2.1.4
CGExtensions: 1.24.2
FileBackup: 0.5
GBFilePicker: 1.3
CGExtensions: 1.24.2
Gallery: 1.4.4
FileManager: 0.3.0b2
ContentCache: 1.2
MysqlDump: 1.2.4
Gallery: 1.4.4
Gallery: 1.4.4


Config Information:

php_memory_limit:
process_whole_template: false
output_compression: false
max_upload_size: 50000000
default_upload_permission: 664
url_rewriting: mod_rewrite
page_extension: /
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding:
admin_encoding: utf-8
set_names: false


Php Information:

phpversion: 5.2.16
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
memory_limit: 64M
max_execution_time: 30
output_buffering: On
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 64M
upload_max_filesize: 64M
session_save_path: /tmp (1777)
session_use_cookies: On (True)
xml_function: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysql)
Server Db Version: 5.1.52

[Jos]

Try to de-install first through the link in the Modules list. Gallery will delete the database tables. If you only delete the Gallery files, the (wrong) database tables will still exist.

Then try to install again.

[FirstGateDreamer]

Try to de-install first through the link in the Modules list. Gallery will delete the database tables. If you only delete the Gallery files, the (wrong) database tables will still exist.

It doesn't show up in the Modules list because as soon as I install the system crashes.

Can I go into phpMyAdmin and manipulate any tables myself to get rid of any old installs?

PS: I also still have a few images in the Gallery and Thumbnails folders that I will still need.

[Jos]

Can I go into phpMyAdmin and manipulate any tables myself to get rid of any old installs?

Yes, you can delete every table that starts with "module_gallery"

PS: I also still have a few images in the Gallery and Thumbnails folders that I will still need.

You don't need to delete those. They are safe. You will only lose the titles and descriptions that you entered in the gallery-database