Post Reply  Post Thread 
Subdomains for domain-aliases
Author Message
owhosting
Junior Member
*


Posts: 32
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #21
RE: Subdomains for domain-aliases

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.

This post was last modified: 02-21-2008 03:09 AM by owhosting.

02-20-2008 11:49 PM
Find all posts by this user Quote this message in a reply
zpin
Junior Member
*


Posts: 64
Group: Registered
Joined: Sep 2007
Status: Offline
Reputation: 0
Post: #22
RE: Subdomains for domain-aliases

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?

02-21-2008 03:28 AM
Find all posts by this user Quote this message in a reply
owhosting
Junior Member
*


Posts: 32
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #23
RE: Subdomains for domain-aliases

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

This post was last modified: 02-21-2008 03:44 AM by owhosting.

02-21-2008 03:39 AM
Find all posts by this user Quote this message in a reply
zpin
Junior Member
*


Posts: 64
Group: Registered
Joined: Sep 2007
Status: Offline
Reputation: 0
Post: #24
RE: Subdomains for domain-aliases

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

This post was last modified: 02-21-2008 06:00 AM by zpin.

02-21-2008 05:59 AM
Find all posts by this user Quote this message in a reply
owhosting
Junior Member
*


Posts: 32
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #25
RE: Subdomains for domain-aliases

Yes
with the last version of patch included in this post

02-21-2008 06:01 AM
Find all posts by this user Quote this message in a reply
zpin
Junior Member
*


Posts: 64
Group: Registered
Joined: Sep 2007
Status: Offline
Reputation: 0
Post: #26
RE: Subdomains for domain-aliases

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

02-21-2008 06:15 AM
Find all posts by this user Quote this message in a reply
owhosting
Junior Member
*


Posts: 32
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #27
RE: Subdomains for domain-aliases

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

02-21-2008 06:47 AM
Find all posts by this user Quote this message in a reply
zpin
Junior Member
*


Posts: 64
Group: Registered
Joined: Sep 2007
Status: Offline
Reputation: 0
Post: #28
RE: Subdomains for domain-aliases

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

02-21-2008 06:54 PM
Find all posts by this user Quote this message in a reply
owhosting
Junior Member
*


Posts: 32
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #29
RE: Subdomains for domain-aliases

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

02-21-2008 09:09 PM
Find all posts by this user Quote this message in a reply
popsikle



Posts: 3
Group: Registered
Joined: Feb 2008
Status: Offline
Reputation: 0
Post: #30
RE: Subdomains for domain-aliases

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

02-29-2008 06:36 PM
Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump:

| All rights reserved : isp-control.net |