Error when adding an attachment to an issue

[JayDeeTee]

We have a new installation of phpMyFAQ:

System Information
phpMyFAQ Version phpMyFAQ 2.6.7
Server Software Apache/2.2.3 (CentOS)
PHP Version PHP 5.2.14
Register Globals off
Safe Mode off
Open Basedir off
Database Server Mssql
Database Client Version Database Server Version Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Webserver Interface APACHE2HANDLER
PHP Extensions date, libxml, openssl, pcre, zlib, bz2, calendar, ctype, hash, filter, ftp, gettext, gmp, session, iconv, Reflection, standard, shmop, SimpleXML, SPL, sockets, exif, tokenizer, xml, apache2handler, curl, dbase, dom, gd, imap, json, ldap, mbstring, mcrypt, mssql, mysql, mysqli, PDO, pdo_dblib, pdo_mysql, pdo_sqlite, snmp, wddx, xmlreader, xmlwriter, xsl, zip

When ever we attempt to add an attachment to a FAQ we get the following error:


Add an attachment to the issue


phpMyFAQ warning [2]: mssql_query() [function.mssql-query]: message: The name "FALSE" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. (severity 15) in Mssql.php on line 94

phpMyFAQ warning [2]: mssql_query() [function.mssql-query]: Query failed in Mssql.php on line 94

The file has been attached successfully.

.... and the file is not added to the FAQ, does anyone have any ideas on how to resolve this problem?

[Thorsten]

Hi,

this should fix your issue: http://github.com/thorsten/phpMyFAQ/com ... 0fd48531cc

bye
Thorsten

[JayDeeTee]

Thanks you, your fix worked a treat.

Nice App.

Regards,

John