SQL error processing query: DB function failed with error number 1065

[griffiths245]

Hi,

I'm having an "SQL error processing query: DB function failed with error number 1065" error.

I first noticed this when using JoomGallery (3.1.0) when it would not allow any images to be uploaded and gave the same error as above every time.
It also gave the same error when trying to update to the latest version of JoomGallery.

I have uninstalled JoomGallery and have trued to reinstall it and again get the same error

JInstaller: :Install: Error SQL Query was empty SQL=
Extension Install: SQL error processing query: DB function failed with error number 1065
Query was empty SQL=
SQL =

Any thoughts?
Thanks in advance

General SQL error 1065

Error SQL Query was empty SQL=

Joomla! Instance :: Joomla! 3.6.2-Stable (Noether) 4-August-2016
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: user_1070766849 (uid: 1/gid: 1) | Group: vweb (gid: 1) | Valid For: 3.6
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 2.6.18-406.el5.centos.plus | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/linweb27/l/llangollen-ruralcc.co.uk/user/htdocs | System TMP Writable: Yes

PHP Configuration :: Version: 5.6.24 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 32767 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 20M | Max. POST Size: 20M | Max. Input Time: -1 | Max. Execution Time: 60 | Memory Limit: 64M

MySQL Configuration :: Version: 5.1.73-log (Client:5.0.91) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 6.85 MiB | #of Tables:  73

PHP Extensions :: Core (5.6.24) | date (5.6.24) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7-dev) | zlib (2.0) | bz2 () | calendar () | ctype () | curl () | hash (1.0) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gettext () | gmp () | SPL (0.2) | iconv () | pcntl () | session () | standard (5.6.24) | posix () | readline (5.6.24) | Reflection ($Id: fbcf7a77ca8e3d4cd7501de8025235b947b8240f $) | Phar (2.0.2) | shmop () | SimpleXML (0.1) | sockets () | mbstring () | sysvmsg () | sysvsem () | sysvshm () | tokenizer (0.1) | wddx () | xml () | cgi-fcgi () | bcmath () | dba () | dom (20031129) | gd () | imap () | json (1.2.1) | ldap () | exif (1.4 $Id: 5564de4b4a8fd6b32ae8bd44debf9f13b18c7768 $) | mcrypt () | mssql () | mysql (1.0) | mysqli (0.1) | odbc (1.0) | PDO (1.0.4dev) | pdo_dblib (1.0.1) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_pgsql (1.0.2) | pdo_sqlite (1.0.1) | pgsql () | pspell () | snmp (0.1) | soap () | tidy (2.0) | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.12.5) | mhash () | ionCube Loader () | Zend OPcache (7.0.6-devFE) | Zend Engine (2.6.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Core Folders :: --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) | --protected-- (755) |

Elevated Permissions (First 10) :: --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) | --protected-- (707) |

Database _FPA_STATS :: Uptime: 730702 | Threads: 18 | Questions: 498961904 | Slow queries: 995 | Opens: 5406058 | Flush tables: 1 | Open tables: 16384 | Queries per second avg: 682.852 |

Strict Information Privacy was selected. Nothing to display.

_FPA_STRICT Information Privacy Nothing to display.

[griffiths245]

Also if it helps...

Database schema version (in #__schemas): 3.6.0-2016-06-01.
Update version (in #__extensions): 3.6.2.
Database driver: mysql.
95 database changes were checked successfully.
156 database changes did not alter table structure and were skipped