after I set up the header.inc.php file It takes me to the install applications page and I get a warning that say's:
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/mycityshopper.net/htdocs/advertisers/phpgwapi/inc/class.db_mysql.inc.php on line 576
can anyone help?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hrm, well the query it's trying to run on line 576 of phpgwapi/inc/class.db_mysql.inc.php is "SHOW TABLES", which could in no way result in a syntax error. It's unlikely that the piece of code in question is incorrect, given that it comes from a separate, very well tested library. So it looks like it's a problem with your database setup. Check these things in the header admin screen:
1) The username and password are correct
2) 'mysql' is selected as the database type
3) The database is 'phpgroupware'
And after checking that, by far the most likely answer is that you have not created the database 'phpgroupware', in which case a "SHOW TABLES" would indeed fail. How to create the database, along with complete installation instructions, can be found in the INSTALL file included in the distribution.
Hope this helps,
Jason Wies aka Zone
zone@users.sourceforge.net
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-11-20
I got it to work without any errors but when I try to log in with the admin username & password I created after I hit the log in button the browser gives me a page not found error
this is where it goes after I hit the login button: http://www.mycityshopper.net/login.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You need to change the hostname path in setup, on the main setup screen under "Edit Current Configuration", in the third box down ("Enter the location of phpGroupWare's URL."). Set it to the directory where the main phpwebhosting installation is (where index.php and login.php are). Per your previous message, this may be:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-11-20
I got it to work without any errors but when I try to log in with the admin username & password I created after I hit the log in button the browser gives me a page not found error
this is where it goes after I hit the login button: http://www.mycityshopper.net/login.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-11-20
I fixed both of the above issues but now when open up phpwebhosting I get 2 errors on top of the page the page comes in fine except for the errors:
Warning: Variable passed to reset() is not an array or object in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpwebhosting/index.php on line 9
Warning: Variable passed to each() is not an array or object in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpwebhosting/index.php on line 10
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
These are easy enough to fix, but I'm interested in why the error is occurring. It may be because you are using an older version of PHP (4.0.1pl2), or it may be because track_vars is set off in the server's php[4].ini. Try this first:
On line 2 of phpwebhosting/index.php add:
<? php_track_vars; ?>
If that doesn't fix it, you can add @ before the calls on lines 9 and 10, so they become like this:
@reset ($GLOBALS['HTTP_POST_VARS']);
while (list ($name,) = @each ($GLOBALS['HTTP_POST_VARS']))
I'm interested in which one was the cause, please let me know which method was able to stop the errors.
Jason Wies aka Zone
zone@users.sourceforge.net
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-11-20
When I added the first piece of code I got a pase error so I deleted that and just added the @ to lines 9 and 10 and it worked fine no errors.
But now I have an error right above where webhosting lists the file for the user that says:
Warning: MkDir failed (Permission denied) in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpgwapi/inc/class.vfs_sql.inc.php on line 1643
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please read the INSTALL file. Then read it again. It tells you how to set the permissions on the directory, and should be your first reference for any errors.
Jason Wies aka Zone
zone@users.sourceforge.net
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
after I set up the header.inc.php file It takes me to the install applications page and I get a warning that say's:
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/mycityshopper.net/htdocs/advertisers/phpgwapi/inc/class.db_mysql.inc.php on line 576
can anyone help?
Hrm, well the query it's trying to run on line 576 of phpgwapi/inc/class.db_mysql.inc.php is "SHOW TABLES", which could in no way result in a syntax error. It's unlikely that the piece of code in question is incorrect, given that it comes from a separate, very well tested library. So it looks like it's a problem with your database setup. Check these things in the header admin screen:
1) The username and password are correct
2) 'mysql' is selected as the database type
3) The database is 'phpgroupware'
And after checking that, by far the most likely answer is that you have not created the database 'phpgroupware', in which case a "SHOW TABLES" would indeed fail. How to create the database, along with complete installation instructions, can be found in the INSTALL file included in the distribution.
Hope this helps,
Jason Wies aka Zone
zone@users.sourceforge.net
I got it to work without any errors but when I try to log in with the admin username & password I created after I hit the log in button the browser gives me a page not found error
this is where it goes after I hit the login button:
http://www.mycityshopper.net/login.php
You need to change the hostname path in setup, on the main setup screen under "Edit Current Configuration", in the third box down ("Enter the location of phpGroupWare's URL."). Set it to the directory where the main phpwebhosting installation is (where index.php and login.php are). Per your previous message, this may be:
http://www.mycityshopper.net/advertisers
Jason Wies aka Zone
zone@users.sourceforge.net
I got it to work without any errors but when I try to log in with the admin username & password I created after I hit the log in button the browser gives me a page not found error
this is where it goes after I hit the login button:
http://www.mycityshopper.net/login.php
I fixed both of the above issues but now when open up phpwebhosting I get 2 errors on top of the page the page comes in fine except for the errors:
Warning: Variable passed to reset() is not an array or object in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpwebhosting/index.php on line 9
Warning: Variable passed to each() is not an array or object in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpwebhosting/index.php on line 10
These are easy enough to fix, but I'm interested in why the error is occurring. It may be because you are using an older version of PHP (4.0.1pl2), or it may be because track_vars is set off in the server's php[4].ini. Try this first:
On line 2 of phpwebhosting/index.php add:
<? php_track_vars; ?>
If that doesn't fix it, you can add @ before the calls on lines 9 and 10, so they become like this:
@reset ($GLOBALS['HTTP_POST_VARS']);
while (list ($name,) = @each ($GLOBALS['HTTP_POST_VARS']))
I'm interested in which one was the cause, please let me know which method was able to stop the errors.
Jason Wies aka Zone
zone@users.sourceforge.net
When I added the first piece of code I got a pase error so I deleted that and just added the @ to lines 9 and 10 and it worked fine no errors.
But now I have an error right above where webhosting lists the file for the user that says:
Warning: MkDir failed (Permission denied) in /usr/local/www/vhosts/advertisers.mycityshopper.net/htdocs/phpgwapi/inc/class.vfs_sql.inc.php on line 1643
Please read the INSTALL file. Then read it again. It tells you how to set the permissions on the directory, and should be your first reference for any errors.
Jason Wies aka Zone
zone@users.sourceforge.net