PHPWebHosting / Discussion / Help: Help required

Ronald John - 2001-08-19

Dear sir/madam,

After downloading the zip file , i unzipped it and uploaded the whole directory to my website.
Am I correct ?
My website is freely hosted at www.dk3.com
I have got mysql,cgi and php support.
My website address is http://c10.home.dk3.com and your software is uploaded to http://c10.home.dk3.com/web/phpwebhosting-0.2.1-1
However when I tried to access the public_html directory, I got an error ( <font face="verdana" color="red"> MySQL Query Failed : Table 'c10.settings' doesn't exist</font> )
please click the link < a href="http://www.c10.home.dk3.com//web/phpwebhosting-0.2.1-1/public_html/">http://www.c10.home.dk3.com//web/phpwebhosting-0.2.1-1/public_html/</a>

I am a beginner to php and mysql. I don't understand the help on your help forum.
Do I require a special program to run sql commands. Dk3 has also a facility to access the mysql database online through the 'Mysql Admin Interface'.

I also read the install file in the zipped package. I didn't understand the lines
**************************************************
Edit sql/user.sql and sql/values.sql and change the password ('hardtoguess' by default)
mysql -uroot -p < sql/user.sql (optional: requires root MySQL access)
mysql -uuser -p < sql/tables.sql
mysql -uuser -p < sql/values.sql
php sql/values.php
*************************************************
I am planning toinstall the package on my website again.
Please explain me in a layman's language and I shall be obliged if you answer my query as soon as possible.
Please reply (<a href="mailto:ronaldson40@hotmail.com">My email address</a>

Thanking you,

Ronald John
ronaldson40@hotmail.com

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Jason Wies - 2001-08-19
  
  MySQL is the database server. There needs to be a phpwebhosting database so information can get stored. The mysql -uuser ... commands set up the database. So however you can, you need to execute the SQL commands in the sql/*.sql files. You might be able to copy and paste them into the web based database manager.
  
  Then access http://yoursite/path/to/sql/values.php using your browser.
  
  If you can't get it, re-read the INSTALL file or ask your hosting provider how best to create databases/tables and import SQL information.
  
  Jason Wies aka Zone
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Ronald John - 2001-08-20
  
  Hello,
  
  Something more:
  
  1)You said something about executing the SQL commands in the sql/*.sql files.
  How do I do it ? Do I require a special program to do so or is it something like the Mysql Admin Inteface on http://mysql2.dk3.com/.\( Requires password and login name)
  If so please tell me what are the commands to follow and how to do it after I login into the SQL database.Dk3 a free hosting website which uses phpMyAdmin 2.2.0rc3 as Mysql Admin Interface.
  To find out the configuration of my website go to
  http://c10.home.dk3.com/test.php.
  I also use WS_FTP PRO as my ftp client
  
  2) Do I have to upload the whole directory available after zipping the download.( i.e. phpwebhosting-0.2.1-1).
  3) When I unzipped your download, I found two sql.inc files. Do I have to upload both of them.
  4)In public_html/main.inc. you have left the following fields to update:-----
  #########
  $rootdir = "/phpwebhosting-0.2.1-1/public_html";    # Directory where this file is
  $hostname = "http://www.c10.home.dk3.com";    # Hostname, including any directories. Examples: https://yoursite.net or http://yoursite.net/phpwebhosting/public_html
  $outdir = "/phpwebhosting-0.2.1-1/";            # Where sql.inc is. Some directory not accessible to the web
  #######
  Have I entered the entries correctly, if not please tell me what do I have to enter.You can check the FAQ on DK3.com on http://www.dk3.com/dk3page.pl?id=faq
  Here they mention the absolute server path as
  /home/yoursite(/home/c10).
  Should I enter the entries as :
  ########
  $rootdir = "/home/c10/phpwebhosting-0.2.1-1/public_html";    # Directory where this file is
  $hostname = "http://www.c10.home.dk3.com";    # Hostname, including any directories. Examples: https://yoursite.net or http://yoursite.net/phpwebhosting/public_html
  $outdir = "/home/c10/phpwebhosting-0.2.1-1/";            # Where sql.inc is. Some directory not accessible to the web.
  #########
  Tell me which is correct.
  5)In public_html/sql.inc or sql.inc in the root directory, You have supplied me the following entries:------
  #########
  $sqlhost = 'moby';    #MySQL host to connect to
  $sqluser = 'phpwebhosting';    #MySQL username
  $sqlpass = 'phppass++';    #MySQL password for username
  $sqldb = 'phpwebhosting';    #MySQL database. 'phpwebhosting' by default
  ########
  According to your instructions , I entered the $sqlhost as localhost instead of moby as given on DK3.com , FAQ on http://www.dk3.com/dk3page.pl?id=faq and $sqluser as c10 instead of phpwebhosting and $sqldb as c10 in place of phpwebhosting.
  
  Am I right or wrong? If I am wrong, please supply me with the right instructions.
  
  6) Please supply more information on the queries not listed above.
  
  Please reply as soon as possible.
  
  Yours faithfully,
  Webmaster,
  c10.home.dk3.com
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Jason Wies - 2001-08-20
    
    1) I haven't used phpMyAdmin, I don't know the procedure for importing tables. If there is a text box where you can enter raw SQL commands, copy and paste the CREATE TABLE lines from sql/tables.sql and the INSERT INTO lines from sql/values.sql.
    
    2) Yes, upload the whole directory.
    3) I don't know why there are two sql.inc files. You only need one (see #5 below)
    
    4) If the files are in /home/c10/phpwebhosting:
    $rootdir = "/home/c10/phpwebhosting/public_html";
    $hostname = "http://www.c10.home.dk3.com/phpwebhosting/public_html";
    $outdir = "/home/c10";
    
    5) Your sql.inc settings look correct. Move sql.inc to /home/c10
    
    Hope this helps,
    Jason Wies aka Zone
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Ronald John - 2001-08-20
  
  Cyberalley:
  
  Something more to add.
  
  I changed the phpwebhosting datbase in sql/*.sql to c10 (i.e use c10 in place of use phpwebhosting) and changed the password to my sql password.
  
  I also replaced the the following entries in public_main/main.inc :-
  
  $rootdir="/home/c10/phpwebhosting"
  $hostname="http://dk3.com"
  $outdir="/home/c10/phpwebhosting"
  
  However when I went to both the following urls,
  
  http://c10.home.dk3.com/phpwebhosting/public_html/
  http://c10.home.dk3.com/phpwebhosting/sql/values.php
  I got this on the screen of the browser:
  
  MySQL Query Failed : Table 'c10.settings' doesn't exist
  
  Please correspond as soon as possible.
  
  Cyberalley
  Webmaster,
  c10.home.dk3.com
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Ronald John - 2001-08-21
  
  Hello , Cyberalley here
  
  Can I execute sql commands on Win98 to an online server.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Jason Wies - 2001-08-21
    
    IF you have mysql installed on your local computer AND IF the server allows it, then yes. You can just change the host/user/password parameters to those of the remote server.
    
    See MySQL's documentation for how to do that.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Ronald John - 2001-08-21
  
  Thanks for everything . The software works and users can signup and login.
  
  I copied it the CREATE TABLE lines from sql/tables.sql and the INSERT INTO lines from sql/values.sql onto a text box provided in mysql Admin Interface provided by DK3.com
  
  But I cannot login as admin.
  
  When type the link http://www.c10.home.dk3.com/phpwebhosting/public_html/ I get the homepage saying Welcome to phpwebhosting and the links Login, Groups and Signup
  But where do I login to change the settings, the look of the website, space for each user, as on
  http://phpwebhosting.sourceforge.net/phpwebhosting/public_html/admin.php
  
  Please assist,
  
  Thanking you.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Jason Wies - 2001-08-21
    
    You login using the username 'admin'. The password was set in the SQL files you copied before. The default password is 'hardtoguess', but as it says in the INSTALL file, you should have changed that before executing the SQL commands.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Ronald John - 2001-08-22
  
  Cyberalley :
  
  Again problems.
  
  1)When I go to the link http://www.c10.home.dk3.com/phpwebhosting/public_html/
  
  I get something else instead of the standard Welcome to phpwebhosting page. The background is green and when I do a demo signup
  link http://www.c10.home.dk3.com/phpwebhosting/public_html/signup.php
  I get this
  
  MySQL Query Failed : Unknown column 'USERS_SETTINGS_SPACE_DEFAULT_SIZE' in 'field list'
  Please reply methods to correct the situation
  
  2) Yesterday I was able to login as admin using password, But when the public_html/admin.php opens,
  I only get the text, and the buttons (commit changes, Reset default settings, etc)
  But I dont get the dialog boxes where we enter the colour of homepage, space for each user, Header and the long list of other details.
  What do I do?
  
  3) Now, when I click on the Login link in the homepage at
  http://c10.home.dk3.com/phpwebhosting/public_html/
  I am taken to public_html/user.php and get the reply that no such username exists.
  
  Please assist on this matter .
  
  I have created the tables in mysql.
  
  Thank you
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Jason Wies - 2001-08-22
  
  You need to run the sql/values.php script, e.g.
  
  http://c10.home.dk3.com/phpwebhosting/sql/values.php
  
  If that doesn't work, download http://phpwebhosting.sourceforge.net/settings.dump and execute the SQL commands like you did before.
  
  Jason Wies aka Zone
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Help required - PHPWEBHOSTING not functional

Forums

Help

Help required - PHPWEBHOSTING not functional

Help required - PHPWEBHOSTING not functional

Forums

Help

Help required - PHPWEBHOSTING not functional document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Help required - PHPWEBHOSTING not functional