Subdomains for domain-aliases

[owhosting]

Thank you for the response...when I added this I get the following

Code:

ALSMOUNT/
MOUNT POINT/123456

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 '? LIMIT 1' at line 1

What I added is

Code:

$sub_mnt_pt = $als_mnt.$sub_mnt_pt;
                   $sub_mnt_temp = str_replace('//','/',$sub_mnt_pt);
                   $sub_mnt_pt = $sub_mnt_temp;

I guess the strange thing it actually says Addition in progress, but nothing is happening I am unable to delete it or force it to finish adding.

[zpin]

true, I forgot something in my last post. With the updated fix it works, though, I just tested it.

Code:

$sub_mnt_pt = str_replace( '//', '/', $sub_mnt_pt );

This is equivalent to what you did. Are you able to create normal subdomains?

[owhosting]

I am trying to create subdomains on an alias account with this patch.

Even with your version i still get

Code:

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 '? LIMIT 1' at line 1

[zpin]

Thats odd... Are you using RC3 (rev 987)?
/e: and you are using the patch from post #7?

[owhosting]

Yes
with the last version of patch included in this post

[zpin]

Ok, then we need to find out which query is causing this... Does anyone know how to output more information about such an error?

[owhosting]

I would hope someone does, seems no one wants to touch this one tho

[zpin]

I guess there should be an option for this somewhere... But as long as we don't know that you can add an "echo $query;" in the exec_query and execute_query functions in /var/www/ispcp/gui/include/sql.php. Probably you also have to add a "die();" before the system_message calls, because this redirects to a new page, afair...

[owhosting]

OK Ill give this a try once I wake up a little more and get back to you...thanks!

[popsikle]

"SELECT created_by FROM admin WHERE admin_id = ? LIMIT 1; " is the sql its erroring out on.