This topic is locked

plz help with this

3/17/2007 11:31:03 PM
PHPRunner General questions
A
ahmedmah author

hi all

i got this error when i try to login
error number: 256
Unknown column '' in 'where clause'
page:login.php?
file: include/dbconnection.php
line number: 26
sql: select * from `members` where ``='ahmed' and ``='123456'
----------------------------------------------------------------

here is my table dump:
--

-- Table structure for table `members`

--
CREATE TABLE `members` (

`id` int(10) NOT NULL auto_increment,

`username` varchar(100) NOT NULL default '',

`password` varchar(10) NOT NULL default '',

`group_id` int(2) NOT NULL default '1',

`active` enum('0','1') NOT NULL default '1',

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--

-- Dumping data for table `members`

--
INSERT INTO `members` (`id`, `username`, `password`, `group_id`, `active`) VALUES

(1, 'ahmed', '123456', 0, '1');
-------------------------------------------------------------

the key column in phprunner is (id)

and it works fine on my local apche server
i got this error only when puplished the mysql db is ok
so what's the problem

thanks,

ahmed

T
thesofa 3/18/2007

Hi

you are trying to insert a number into an autoincrement field, leave out the ID from fields list in the query and leave out the value you are trying to put in it, the value will be auto incremented by MYSQL when you insert the record.

hth

A
ahmedmah author 3/18/2007

thnks for replay
but iam not trying to insert iam ust trying to select as u can see the sql :
sql: select from `members` where ``='ahmed' and ``='123456'
it suppose to be like that
sql: select
from `members` where `username`='ahmed' and `password`='123456'
so the main problem the runner can't get the filed name

kujox 3/18/2007

thnks for replay

but iam not trying to insert iam ust trying to select as u can see the sql :
sql: select from `members` where ``='ahmed' and ``='123456'
it suppose to be like that
sql: select
from `members` where `username`='ahmed' and `password`='123456'
so the main problem the runner can't get the filed name


Ahmed, did you create the table in phprunner and have you modified the sql and or events?.

Alexey admin 3/19/2007

Ahmed,
please zip and send to support@xlinesoft.com a full set of geberated pages along with your phprunner project file and a database creation script.

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