2. PHPRunner General questions
  3. error when searching
This topic is locked

error when searching

 		8/24/2006 4:34:27 PM
PHPRunner General questions
A
 amirgulamali author

I am still using version 3.0..
I am getting an error on just 1 page when i use the search bar:

When i search for anything using:
Search for: (whatever)
i am getting this error message:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') like upper('%amir%') or upper(`_students`.`SessionalGPA`) lik


the field sessionalGPA is a varchar type and is only in the table: _students
However other pages(tables) which do not have the field SessionalGPA work fine..
Anyone know why im getting this?
A
 		amirgulamali author 8/24/2006

This is wierd..
The error message says:

Error file: /var/www/html/ecs/eccs_db/include/dbconnection.php
I dont get any error message when i run it on my local machine but when i upload it to my webserver, i get that error.
Is this one of those things that need to be edited when uploaded into the webserver (for instance $host = hostname for some webservers has to be edited to $host = localhost manually)
Admins , any help would be greatly appreciated
Alexey admin 8/25/2006

Amir,
show me the full message.

Post here everything displayed on the page.
A
 		amirgulamali author 8/25/2006

I had to regenerate the pages once again to get it work. Its working now
Thanks