2. PHPRunner General questions
  3. [SOLVED]  Unknown column '' in 'field list'
This topic is locked
[SOLVED]

 Unknown column '' in 'field list'

 		3/6/2007 2:13:19 PM
PHPRunner General questions
W
 wilmer author

Hi! As a newbie I got this error message when trying the missing password option:

Unknown column '' in 'field list'
/customers/my.space/my.space/httpd.www/museum5/include/dbconnection.php

error on line 26

SQL-query select `MuspassBRnavn`,`MuspassPass`,`` from `_Muspass` where `MuspassBRnavn`='testbruker'
Any suggestions?
D
 		Dale 3/7/2007

You have a couple of `` in your select command. If your creating the query yourself then the explanation below should do it, if you are not and PHPRunner is generating the query for you, then I would check your database table MuspassBRnavn to see if some field definition is the problem.
SQL-query select `MuspassBRnavn`,`MuspassPass`,`` from `_Muspass` where `MuspassBRnavn`='testbruker'
Delete them and the preceding comma and all should be good. Example below
SQL-query select `MuspassBRnavn`,`MuspassPass` from `_Muspass` where `MuspassBRnavn`='testbruker'
Admin 3/7/2007

Hi,
please zip and send to support@xlinesoft.com your PHPRunner project folder contents along with your database creation script.

I'll find what's wrong with your project running it on my test box.
W
 		wilmer author 3/17/2007

Hi,

please zip and send to support@xlinesoft.com your PHPRunner project folder contents along with your database creation script.

I'll find what's wrong with your project running it on my test box.


Thanks Alexey!
Oops, missing that. You save my day. Now it works just fine.