ispCP - Board - Support
Subdomains for domain-aliases - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Contributions Area (/forum-40.html)
+--- Forum: Enhancements (/forum-43.html)
+--- Thread: Subdomains for domain-aliases (/thread-1475.html)

Pages: 1 2 3 4 5 6 7 8


RE: Subdomains for domain-aliases - owhosting - 02-20-2008 11:49 PM

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.


RE: Subdomains for domain-aliases - zpin - 02-21-2008 03:28 AM

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?


RE: Subdomains for domain-aliases - owhosting - 02-21-2008 03:39 AM

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



RE: Subdomains for domain-aliases - zpin - 02-21-2008 05:59 AM

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


RE: Subdomains for domain-aliases - owhosting - 02-21-2008 06:01 AM

Yes
with the last version of patch included in this post


RE: Subdomains for domain-aliases - zpin - 02-21-2008 06:15 AM

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


RE: Subdomains for domain-aliases - owhosting - 02-21-2008 06:47 AM

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


RE: Subdomains for domain-aliases - zpin - 02-21-2008 06:54 PM

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


RE: Subdomains for domain-aliases - owhosting - 02-21-2008 09:09 PM

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


RE: Subdomains for domain-aliases - popsikle - 02-29-2008 06:36 PM

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