Hi guys,
I'm a total newbie to webhosting, i've got myself a reseller account courtesy of a friend using WHM and cPanel, i've found two possible scripts for auto account creation and I much prefer the look of one of them over the other, however i've come to a few difficulties in setting them it up. The script is called cPanel Auto Account Creator v3.0 by jnshosts, the problem i get is, i log in after installing it (i think i installed it ok???) then i go to config and enter all the details although i'm not sure what auto-host is? but i set it to the folder the scripts are located in, then i click apply and get this error:

Cannot query the database.
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 'SET ='http://www.stronghosting.co.uk/account1', ='/home/strong/public_html/acc' at line 1

hmm, ive never came across that before. i use WHMCS panel for my WHM, and ive never came across an error like that. You couldve installed it wrong, or theres a folder that isnt CMOD 777?

this is the install document that came with it:

Step 1
Create a new database on your server.

Step 2
Open the file : Cpanel_Auto_Account_Creator/inc/sqlinf.php with notepad and enter your database connection info where commented to do so.

Then enter in a desired username & password to enter the Auto-Host administration area where commented to do so.

Step 3
Upload the entire Cpanel_Auto_Account_Creator folder to your server and rename it to some easy name like "account"

Step 4
Visit the following URL in your browser :
http://www.yourdomain.com/account/install/
here i presume that you will rename the script folder to "account".

Step 5
Cpanel Auto Account Creator v3.0 is now installed, you may log in using the username/password you entered into sqlinf.php

Step 6
To configure Cpanel Auto Account Creator v3.0, click "Configuration" under the Setup menu & input the asked for paths & settings

Step 7
Click "Email Templates" under the Setup menu, and click "Apply" - You may adjust the default email templates as you wish, but you MUST click apply once to insert the default settings.

Thats its for setup.


I can't see any instructions to chmod any folders, any other ideas?

sometimes they dont list it. You just have to go on gut feeling. Ive installed many scripts that didnt say to change the CMOD, and when i did that, it worked perfectly. It never hurts to check the config file and its permissions.

I'm a complete newbie and i've never learnt any PHP programming, so i'm a bit stuck. the directories are:

admin
img
inc
install
ipn
members

ok, check ur config file and check its permissions, it should be at 777 and then try installing the script. if that doesnt work, then try asking the owner of the script for help.

i think it is to do with the bit i put in to auto-host, it asks for url and root-path, everytime i change what i input, the bit after set=" changes in the error message to the new url i input

mess around with it a bit, and ull get it.

Use phpcoin or a clientexec, modernbill script.

i'd preferably like to stick with this one because it is free.

ok, check ur config file and check its permissions, it should be at 777


777 is generally a bad idea.

--Tina

SET ='http://www.stronghosting.co.uk/account1', ='/home/strong/public_html/acc'

Yep, that's a SQL syntax error! It looks like a bug in your script, so you would need to either contact the developer, or have someone fix it for you.

ok thanks, i've purchased a new reseller account with a 10 times better server so when the domain name is sorted and everything i might have a go on the new account and see if i've still got problems

I've just tried setting it up using the ip address using the new server and i've not had the same problem, i think the older server was setup incorrectly