2. PHPRunner General questions
  3. error 256 unknown column
This topic is locked

error 256 unknown column

 		3/11/2010 15:02:04
PHPRunner General questions
S
 stevebrettler author

I get the error below when forst entering one of my tables from the generated menu.
The field "date" exists in the database. Im not really sure how to go about trouble shooting this. Could any one give me an idea or two.
thanks
Steve
Error type 256

Error description Unknown column 'date' in 'field list'

URL localhost/clients/polarbear/root/time-line/time_line_list.php?

Error file C:\Documents and Settings\Steve\My Documents\web_dev\polarbear\root\time-line\include\dbconnection.php

Error line 34

SQL query SELECT date, date_accuracy, location, description,(SELECT count() FROM (SELECT date FROM images ) subQuery_cnt WHERE subQuery_cnt.date=time_line.date) as images_cnt ,(SELECT count() FROM (SELECT date FROM log ) subQuery_cnt WHERE subQuery_cnt.date=time_line.date) as log_cnt FROM time_line ORDER BY 1 ASC limit 0,20
A
 		alang 3/11/2010

Theoretically should be able to use date but I tend to avoid using something that is reserved word in SQL and PHP. Have you tried renaming the field?
Sergey Kornilov admin 3/11/2010

As a first step I would make sure date column exists in all three tables: images, log and time_line.
If this doesn't help post your app to Demo Account and contact support team directly.
S
 		stevebrettler author 3/13/2010



Theoretically should be able to use date but I tend to avoid using something that is reserved word in SQL and PHP. Have you tried renaming the field?


Thanks very much thats a good thought, though I used 'date" as field name with some regularity. I'll try it