TOPIC: New sql 1064 error catastrophe

Hi, there has been some 1064 error issues with DT Register the last months, now I have a catastrophical new one. I cannot get into the admin side of DT Register at all, I get the following:

1064 - An error has occurred.

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 '[],' at line 1 SQL=select * from aj341_dtregister_aros where aro_id in([],

Return to Control Panel

I have sent a support ticket but while waiting: Anyone else experiencing this, any solutions?

Regards Ben

The problem disappeared after some messing around in the sql database. Whether the adjustments I made in the DT Register SQL information had anything to do with the admin side of DT Register again now working I do not know.

Ben

Hi there,

Just wanted to find out how did you manage to resolve the Error 1064 when the Register Now button is clicked?
This is the full error message from my site after click Register Now button:

"1064
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 ')' at line 1"

Unfortunately I do not know what caused that problem (separate from that in this thread) and what it was that resolved it. When DTH Development / Nathan started to investigate in in, it was already gone. But one DT Register user, futuron, stated this in the thread in question ( goo.gl/OCVjJt ) :

futuron wrote: Ok found it.
DTREGISTER 3.1.1 this file:
administrator/components/com_dtregister/dtregister.php

line 28:
$query = "SET OPTION SQL_BIG_SELECTS = 1";

should be:
$query = "SET SQL_BIG_SELECTS = 1";

However, in my case DTH / Nathan never reported altering anything in my php and the problem has been gone now for a few weeks.

Cheers Ben

But am on version 3.1.0b

Does is still apply?
I dont see that line on 3.1.0 version's dtregister,.php file.

cheru - this specific issue is not the same as what you are having, however you need to update to 3.1.1.