Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELECTS

This forum is for general questions about extensions for Joomla! 2.5.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
HasanB
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Jun 22, 2012 2:14 pm

Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELECTS

Post by HasanB » Fri Jun 22, 2012 2:27 pm

I was getting this error :
AEAbstractDump :: Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_BIG_SELECTS=1' at line 1 SQL=SET OPTION SQL_BIG_SELECTS=1
The correct syntax is :

Code: Select all

SET SQL_BIG_SELECTS=1
This syntax is not correct :

Code: Select all

SET OPTION SQL_BIG_SELECTS=1
The faulty line is in the file :

Code: Select all

${HTDOCS}/administrator/components/com_akeeba/akeeba/engines/dump/native/mysql.php

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by humvee » Fri Jun 22, 2012 5:04 pm

Refer to the Akeeba Backup FAQs, announcements and forums.

Read the extensive documentation on-line at Akeeba Backup or download a copy of the same.;
Check the recent announcement:
See Installation, upgrade and update troubleshooting for Akeeba Backup, Admin Tools and other software

HasanB
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Jun 22, 2012 2:14 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by HasanB » Fri Jun 22, 2012 7:12 pm

I don't get it?

- Backup attempts got me that error.
- I tracked it down to the PHP code issuing a command MySql rejected.
- I corrected the command.
- Backups began working for the first time.
- I publish the fix for anyone else with the same problem.

By way of thanks a **JOOMLA MASTER** , tells me to rtfm.

Huh? wtf!

User avatar
MoonfireArt
Joomla! Explorer
Joomla! Explorer
Posts: 466
Joined: Wed Feb 29, 2012 3:27 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by MoonfireArt » Fri Jun 22, 2012 7:14 pm

Thank you for the code fix, I'm sure it will be useful for anyone else with that issue. Perhaps you should also post it on the Akeeba forum as well.
The burned hand teaches best... - The Two Towers

http://webdesign.moonfireartstudios.com Joomla web design for small businesses

HasanB
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Jun 22, 2012 2:14 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by HasanB » Sat Jun 23, 2012 10:13 am

Dear MoonfireArt,

Thanks for your suggestion.

I did try to post it there. Unfortunately, they want money for that. If I was sure I'd continue to use Akeeba Backup, I might consider shelling out but, since this is all kind of exploratory right now, I'll leave it to someone else who hits the same thing.

I am sure, as humvee suggested, there is something unusual about my configuration. If that Is the case, Akeeba's product, with my change, is now less sensitive to installation environments than before. I don't see why I should pay to tell them that.

Hasan

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25864
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by Per Yngve Berg » Sat Jun 23, 2012 12:30 pm

SET OPTION is deprecated at least from version 5.0 of mysql.

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by humvee » Sat Jun 23, 2012 5:04 pm

HasanB wrote:I am sure, as humvee suggested, there is something unusual about my configuration. If that Is the case, Akeeba's product, with my change, is now less sensitive to installation environments than before. I don't see why I should pay to tell them that. Hasan
I am glad the tone has been moderated since your initial response to my post which was simply intended to refer you to the available error information that was available either within the substantial documentation or on the forums themselves. Or as MoonfireArt indicated that you might notify the developers.

You can contact the main developer direct here: https://www.akeebabackup.com/contact-us.html (for free!)

hntgzr
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Apr 25, 2014 1:40 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by hntgzr » Fri Apr 25, 2014 1:42 pm

many thanks HasanB for the code amendment.

saved me a lot of searching when the servers used for a few of my customers websites were upgraded to a later version of MySQL.

jhalsan
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Fri Sep 28, 2007 1:49 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by jhalsan » Fri Nov 21, 2014 6:27 pm

Thanks from another Akeeba backup user for this fix. Saved me a lot of time and trouble. Cheers :)

User avatar
beagler
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Tue Aug 31, 2010 7:22 am
Location: Moscow
Contact:

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by beagler » Mon Jan 12, 2015 1:25 pm

thanks HasanB
beagler.ru Решения для интернет-магазинов
https://aloris.ru/
https://alorisman.ru/

mucacran
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Feb 09, 2015 6:34 pm

Agradecimiento

Post by mucacran » Wed Mar 25, 2015 4:39 pm

MUchas GRacias:
Tenia un buen rato buscando la solucion a este problema, y no lo encontraba en los foros de backup
Muchas gracias por su ayuda.
Señor "HasanB"

rbradbury
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Apr 03, 2015 11:16 pm

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELEC

Post by rbradbury » Fri Apr 03, 2015 11:21 pm

Very many thanks indeed for a simply perfect solution. Never mind the Joomla 'Master' unhelpful comments - this information is invaluable! 8)

Note that in Joomla 1.5.26, the file is actually
/public_html/administrator/components/com_akeeba/akeeba/engines/dump/native.php

Serchi
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Aug 25, 2016 9:58 am

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELECTS

Post by Serchi » Thu Aug 25, 2016 10:00 am

Thank you soo much HassanB, you´ve saved my day!

stkontra
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Mar 11, 2015 11:06 am

Re: Akeeba B'Up bug. Syntax err. SET OPTION SQL_BIG_SELECTS

Post by stkontra » Wed Jul 19, 2017 10:26 am

HassanB, you are an absolute lifesaver. Don't know how I could have fixed this without your post.
Many thanks!!!!


Locked

Return to “Extensions for Joomla! 2.5”