Error: Datatype mismatch: argument of AND must be type boolean, not type integer

A quick follow-up:

I disabled the menu module with drush:

$ drush pm-disable authcache_menu

And I was able to open and browse the site normally. Reenabled the module and the error is back. However, I discovered two interesting things:

• The problem affects logged in users only, anonymous users can use the site just fine, even when the page wasn't previously cached (the paged is cached just fine).
• Logged in users can browse administrative pages as well (I don't use the admin overlay), but cannot open regular, content pages (the error kicks in).

Thanks for the quick response. I applied the patch and at first look everything works great, the error is gone. I'll perform the testing suite and report back.

Best regards.

Hi again znerol, I finally had the time to setup a site to run the testing. In the development site I didn't enable all Authcache submodules, but in the testing site I did enable them all except Authcache Varnish since I don't have Varnish installed. First thing I noticed is that these new error messages appear (the page is loaded fine, though):

Warning: Missing argument 2 for authcache_usercookie_authcache_cookie() en authcache_usercookie_authcache_cookie() (línea 12 de /www/sites/all/modules/authcache/examples/authcache_usercookie/authcache_usercookie.module).

Notice: Undefined variable: account en authcache_usercookie_authcache_cookie() (línea 13 de /www/sites/all/modules/authcache/examples/authcache_usercookie/authcache_usercookie.module).

Notice: Use of undefined constant AUTHCACHE_FLAGS_ACCOUNT_ENABLED - assumed 'AUTHCACHE_FLAGS_ACCOUNT_ENABLED' en authcache_usercookie_authcache_cookie() (línea 14 de /www/sites/all/modules/authcache/examples/authcache_usercookie/authcache_usercookie.module).

Notice: Object of class stdClass could not be converted to int en authcache_usercookie_authcache_cookie() (línea 14 de /www/sites/all/modules/authcache/examples/authcache_usercookie/authcache_usercookie.module).

Clearing the caché didn't help, so I disabled the Authcache User Cookie module and proceed with the testing. Again, I checked all submodules in the admin testing screen except Varnish. The site is translated to spanish, but the reported results are something like this:

3470 pass, 2 failures, 5663 exceptions, and 983 depuration messages

The two failures were found in one single test, "Cache backend". I'll copy here only the entries labeled as errors:

Message: X-Drupal-Cache header should be absent, when request was not delivered through authcache builtin backend.
Group: Other
File name: authcache_builtin.cache-backend.test
Line: 86
Function: AuthcacheBuiltinTestCacheBackend->testDeliverThroughBackend()

Message: X-Drupal-Cache header should be absent, when request was delivered through the test frontcontroller but without having specified that the backend should be used.
Group: Other
File name: authcache_builtin.cache-backend.test
Line: 90
Function: AuthcacheBuiltinTestCacheBackend->testDeliverThroughBackend()

Anyway, where other SQL errors popped up was in the "Default Request Handler", "Fragment Assembly Request
", "Fragment Request" and "Setting Request" tests (part of the Authcache Personalization set). These tests threw all 5663 exceptions (most of them just say Illegal string offset 'filename') but these SQL errors were reported several times as well:

PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "simpletest63481locales_source" does not exist LINE 1: SELECT s.lid, t.translation, s.version FROM simpletest63481l... ^: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => es [:source] => Value @first is equal to value @second. [:context] => ) en locale() (línea 720 de /www/modules/locale/locale.module).

I think it has something to do to the testing procedure and not with the module itself, but I wanted to report it anyway.

From what I gather, none of these messages are related to the database code of Authcache (or I think so). Since I ran the test using the patched authcache_menu.module file, I was curious to see whether the test actually would catch the error reported before (datatype mismatch). I reverted to the unpatched version (made sure I actually see the error message) and ran the test again, this time only for the authcache menu module. Effectively, the test failed and the SQL error popped up several times.

This makes me think that after the patch on #2 it's safe to assume that there are no more SQL incompatibilities so far, at least with PostgreSQL.

I hope you'll find some helpful information here. If you want me to do more testing, I'll be more than glad to help.

Best regards.

Hi again znerol. Been really busy last days, but just for the peace of mind: as you mentioned I did have that line in settings.php. I didn't know it would cause problems, sorry, but after removing it effectively the test comes out perfectly clean :)

Best regards.

Apparently, whether the page is previously cached or not has nothing to do with the issue.