This topic is locked

Query was empty error

2/8/2008 7:34:06 PM
PHPRunner General questions
J
jetacera author

I'm using PHPRunner 4.1 with a MySQL database. I've built a project and almost everything works with one major exception. I have a table called "gallery" and the list page comes up fine showing all the records as it should. But when I click on Add New, I get this error:
PHP error happened
Technical information

Error type: 256

Error description: Query was empty

URL: xxx/xxx/gallery_add.php?

Error file: /xxx/include/dbconnection.php

Error line: 26

SQL query

When I click Edit on a record, I get this error:
PHP error happened
Technical information

Error type: 256

Error description: Query was empty

URL: xxx/xxx/gallery_edit.php?editid1=1

Error file: /xxx/include/dbconnection.php

Error line: 26

SQL query: select `id`, `item_id`, `name`, `image_sm`, `image_lg`, `category`, `subject`, `dimensions_metric`, `dimensions_english`, `weight_kg`, `weight_lb`, `price`, `retail_value`, `available`, `sold`, `method`, `material`, `completion_time`, `stone_size`, `marble_thickness`, `background`, `desc_short`, `desc_long`, `alt_text`, `status`, `contact_id` From `gallery` where `gallery`.`id`=1

But if I click View on a record, the View page also comes up fine.
For my query, I'm just using the basic query for the table - no inner joins or anything fancy.
select `id`, `item_id`, `name`, `image_sm`, `image_lg`, `category`, `subject`, `dimensions_metric`, `dimensions_english`, `weight_kg`, `weight_lb`, `price`, `retail_value`, `available`, `sold`, `method`, `material`, `completion_time`, `stone_size`, `marble_thickness`, `background`, `desc_short`, `desc_long`, `alt_text`, `status`, `contact_id`From `gallery`
I've already tried simply rebuilding the project, but I get the same error.
Please Help!

J
Jane 2/11/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and post a URL to your pages here or send it to [email=support@xlinesoft.com]support@xlinesoft.com[/email] along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site