Ok, I've gotten my sql tables set up in my database. I have the files where I want them, I cannot run php values.php from the command line (doesn't work).
I think that is my problem.
I can open the values.php file in a web broswer, but nothing happens.
I cannot create a new login due to an error "MySQL Query Failed : Unknown column 'USERS_SETTINGS_SPACE_DEFAULT_SIZE' in 'field list'
"
WHAT AM I DOING WRONG???
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You must run values.php. It populates the database with settings, like USERS_SETTINGS_SPACE_DEFAULT_SIZE, without which PHPWebHosting won't work. See the PHP section of the INSTALL file for how to make a php binary, or you can get a binary from an RPM install.
If that's not an option, you /should/ be able to run values.php from a web browser. You must first set up sql.inc and main.inc with your database and path settings, and then visit it with your browser. It should return no data (ie 'Document contained no data'). If that doesn't work, try putting the full paths in the require()'s in values.php, sql.inc, and main.inc.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1) Make sure main.inc and sql.inc are set up properly
2) Make sure your PHP binary has all the necessary parts compiled in (MySQL)
3) Make sure you have the latest version of PHP. A lot has changed, and it might just be a bug in an older version.
If none of that helps, send the output of 'php sql/values.php' and 'php -v'. Also a link to a webpage on the server containing
<? phpinfo (); ?>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i have the same problem too, as the path is correct and i run the php thru my IE 5.5 Brwoser, it shows a blank page and I've checked the PHP haven't add the settings to the setting table, the table is setup w/o problem, please help.
Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As noted in the replies above, you MUST run sql/values.php. If you don't have the 'php' binary installed, re-compile PHP without the --with-apache option to create it. Also, make sure you're running the latest version of PHP, as older versions may have had bugs.
If that doesn't fix it, the only alternative is to add the values to the settings table by hand, or put explicit defines in public_html/main.inc, such as:
In case you have not figured out or found out the problem as of yet, there is a type in the sql.inc file, preventing the values.php from installing. When you edit this file, look for 'mysql_pconnect' and remove the 'p'. Also make sure you have the proper settings in this file for logging into your mysql db, but if you have already successfully created the tables, then those should be fine. I currently have this script running, and am still figuring out a few things. Look for my new post, "up and sorta running?".... later!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, I've gotten my sql tables set up in my database. I have the files where I want them, I cannot run php values.php from the command line (doesn't work).
I think that is my problem.
I can open the values.php file in a web broswer, but nothing happens.
I cannot create a new login due to an error "MySQL Query Failed : Unknown column 'USERS_SETTINGS_SPACE_DEFAULT_SIZE' in 'field list'
"
WHAT AM I DOING WRONG???
You must run values.php. It populates the database with settings, like USERS_SETTINGS_SPACE_DEFAULT_SIZE, without which PHPWebHosting won't work. See the PHP section of the INSTALL file for how to make a php binary, or you can get a binary from an RPM install.
If that's not an option, you /should/ be able to run values.php from a web browser. You must first set up sql.inc and main.inc with your database and path settings, and then visit it with your browser. It should return no data (ie 'Document contained no data'). If that doesn't work, try putting the full paths in the require()'s in values.php, sql.inc, and main.inc.
I've just down loaded it and have the same problem, even after runing
# php values.php It doesn't seem to change anything.
1) Make sure main.inc and sql.inc are set up properly
2) Make sure your PHP binary has all the necessary parts compiled in (MySQL)
3) Make sure you have the latest version of PHP. A lot has changed, and it might just be a bug in an older version.
If none of that helps, send the output of 'php sql/values.php' and 'php -v'. Also a link to a webpage on the server containing
<? phpinfo (); ?>
i have the same problem too, as the path is correct and i run the php thru my IE 5.5 Brwoser, it shows a blank page and I've checked the PHP haven't add the settings to the setting table, the table is setup w/o problem, please help.
Thanks.
As noted in the replies above, you MUST run sql/values.php. If you don't have the 'php' binary installed, re-compile PHP without the --with-apache option to create it. Also, make sure you're running the latest version of PHP, as older versions may have had bugs.
If that doesn't fix it, the only alternative is to add the values to the settings table by hand, or put explicit defines in public_html/main.inc, such as:
define ('HTML_TABLE_FILES_HEADER_BG_COLOR', "green");
In case you have not figured out or found out the problem as of yet, there is a type in the sql.inc file, preventing the values.php from installing. When you edit this file, look for 'mysql_pconnect' and remove the 'p'. Also make sure you have the proper settings in this file for logging into your mysql db, but if you have already successfully created the tables, then those should be fine. I currently have this script running, and am still figuring out a few things. Look for my new post, "up and sorta running?".... later!