2. PHPRunner General questions
  3. Http error
This topic is locked

Http error

 		6/19/2006 10:35:51 AM
PHPRunner General questions
L
 learning_to_run author

Hello. I had connected to my sql database on hosting server.

Here is my XML code from phprunner.php:

−

<phprunner phpversion="4.4.1" mysqlversion="4.1.11">

−

<tables>

−

<table name="tch">

−

<fields>

<field name="id" size="10" scale="0" type="varchar" key="PRI" default="" null=""/>

<field name="name" type="text" key="" default="" null=""/>

<field name="place" type="text" key="" default="" null=""/>

</fields>

</table>

</tables>

</phprunner>


And the default SQL query from PHPrunner

select From `tch`


I recieve this window when I click "Next":

Cannot retrieve columns information. Please modify SQL query and try again.

Error message:

HTTP Error


What can I do? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2812&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
Alexey admin 6/20/2006

Hi,
could you provide me with an access to your database ?

Send the URL to phprunner.php, MySQL hostname, username,password and database name to support@xlinesoft.com

I'll find what's wrong with them.
Otherwise please open the following URL in the browser and send me the results:

http://.../phprunner.php?todo=tablefields&host=hostname&login=username&pwd=password&port=&db=databasename&table=tch
where hostname, username, password and databasename are your actual MySQL connection parameters.
L
 		learning_to_run author 6/25/2006

Ok. I did what you said to me, the hosters had disabled the URL security checking for my site, but this problem is back.
So I make a new database table with PHPRunner, and when I come to the MYSQL query step, I see this thing in the code:

select From `_table`


and then, when I perss "Next" button;

Cannot retrieve columns information. Please modify SQL query and try again.

Error message:

HTTP Error


Is it a bug or I need to write the MSQL query, what should I write if I need to chenge the query?
Alexey admin 6/26/2006

Hi,
I checked your site and the URL checking is still there.

There is nothing you can do while the URL security checking system is on.
You can test if the checking is on using the URL I sent you in the letter.