The time now is Sun Jul 06, 2008 12:06 pm
All times are GMT
|
russ
Joined: 22 Nov 2006 Posts: 3 Location: Alanta,Ga. USA
|
Posted: Wed Nov 22, 2006 6:39 am Post subject:
Help with php web host script
Subject description: "Tinytool" web host script
|
|
|
I'm not versed in php (that's an understatement) and am trying to setup a web hosting automation program named tinytool. I'm getting a couple of mysql errors when I try to use it. The errors point to two lines in the code that are supposed to put data into a db table named "IPNlog" which is suppose to be created by a like named file "IPNlog.php". According to the errors I get the db table isn't getting created (see the two errors below).
Errors when I try to use the script.
| Quote: | Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in /home/russell/public_html/purchase/config.php on line 20
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/russell/public_html/purchase/config.php on line 21
failed: Table 'russell_tiny.IPNlog' doesn't exist |
If someone is willing to help me the link to the order form which is the customer starting point for the script is ... http://www.glitterhost.com/purchase/Order.php .
The script can be downloaded here at my website. tinytool
I am monitoring this post and will be notified immediately of your response.
Thanks for any help which I assure you will be greatly appreciated.
Russ
|
|
| Back to top |
|
 |
Urban Legend
Site Admin

Joined: 02 Jan 2006 Posts: 129
|
Posted: Wed Nov 22, 2006 7:49 am Post subject:
|
|
|
Hi russ,
| Quote: | | Unable to save MySQL query result |
This error message is usually due to a corrupted MySQL database. You should try to run the mysqlcheck program (or the check function of PhpMyAdmin is you use it) to see if your database doesn't need to repaired. Also verify that your MySQL installation is correct. If the folders have the right privileges to be accessed and if the temporary folder is also created (you can see its path in the my.ini file).
Hope it can help,
|
|
| Back to top |
|
 |
russ
Joined: 22 Nov 2006 Posts: 3 Location: Alanta,Ga. USA
|
Posted: Wed Nov 22, 2006 8:30 am Post subject:
|
|
|
| Quote: | | If the folders have the right privileges to be accessed and if the temporary folder is also created (you can see its path in the my.ini file). |
The folder permissions! I'll bet that's it!
I'll try and let you know if that was it.
Thanks for your fast response.
Russ
|
|
| Back to top |
|
 |
russ
Joined: 22 Nov 2006 Posts: 3 Location: Alanta,Ga. USA
|
Posted: Wed Nov 22, 2006 10:21 am Post subject:
|
|
|
The problem was the folder permissions. The author recommends that the folder containing the script be chmod at 777 BUT my webhost doesn't allow chmod of 777!
Here is a link to my post at my webhost's forum.
P/S My webhost is a very good hosting company (I'm not bashing them).
http://www.elixant.com/forums/index.php?act=ST&f=20&t=4088
I wonder if there is a work around?
Russ
|
|
| Back to top |
|
 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
| Link to this Page |
|
If you want to link to this page you can use the following URL:
Example:
|
|
| The PHP Web-Ring Community
Sign-up to receive daily news on PHP by email.
|
|