Author Topic: Logged In basic Seach fails Migrated users only  (Read 12683 times)

FrankA

  • Jr. Member
  • **
  • Posts: 225
Re: Logged In basic Seach fails Migrated users only
« Reply #30 on: December 29, 2009, 04:10:06 am »
Still no solution :-( any advice on the 500 error, it might help if I understood why it gives an error?

rb

  • Advanced
  • Full Member
  • *****
  • Posts: 1503
Re: Logged In basic Seach fails Migrated users only
« Reply #31 on: December 29, 2009, 15:46:38 pm »
Frank, here's another user who had a MySQL 1104 error:
     http://forum.virtuemart.net/index.php?topic=64212.msg213829#msg213829

Even though it's a different problem, it may be worth trying his solution since you share one symptom.

FrankA

  • Jr. Member
  • **
  • Posts: 225
Re: Logged In basic Seach fails Migrated users only
« Reply #32 on: December 29, 2009, 16:24:42 pm »
Wow!!! Tom Tomm's
--------------------------------------------------
in the Joomla file mysql.php I found a line which says:
$this->setQuery( "SET sql_mode = 'MYSQL40'" );
(around line 153).
UNDER this line I added:
$this->setQuery( "SET OPTION SQL_BIG_SELECTS=1" );
---------------------------------------------------

solved the problem. Intrigued that this turns out to be a Joomla bug! And so happy that it is easily fixed. Thanks folks.

Puzzling that the problem only affected migrated users and not newly registered ones though.