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

[HasanB]

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

[humvee]

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.;

• Kickstart User Guide.
• Akeeba Backup Quick Start Guide
• Akeeba Backup Guide

Check the recent announcement:
See Installation, upgrade and update troubleshooting for Akeeba Backup, Admin Tools and other software

[HasanB]

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!

[MoonfireArt]

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.

[HasanB]

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

[Per Yngve Berg]

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

[humvee]

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]

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]

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

[beagler]

thanks HasanB

[mucacran]

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]

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

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

[Serchi]

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

[stkontra]

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