bugphpGroupWare - Bugs: bug #897, Search for comic SQL error

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #897: Search for comic SQL error

Submitter:  Invalid User ID <#9151>
Submitted:  Wed 24 Jul 2002 05:15:23 AM UTC
   
 
Category:  comic Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  5 - Normal
Status:  Fixed Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  None Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Wed 14 Jul 2004 11:58:54 PM UTC, comment #2: 

This has been fixed in CVS and should be available in the next
release.

Dave Hall <skwashd>
Group administrator
Wed 14 Aug 2002 08:09:10 AM UTC, comment #1: 

Yup. It's something to do with $qfield not being passed properly. I've just downloaded the phpgroupware system, and noticed that myself. Trying to fix it.

Also, there was a problem with adding a new comic...
It said 'Error with SQL(Insert into phpgw_comic_data (comic_name) VALUES ('whatever'))
This was easy to fix - the field name should be data_name rather than comic_name.
This is for rc4, rather than devel, but thought it might be useful.

Invalid User ID <#9736>
Wed 24 Jul 2002 05:15:23 AM UTC, original submission:  

Searching the comic database via administration:

Daily Comics -> Global Comics -> type word in search field at top.

Returns an SQL error, like so:

Database error: Invalid SQL: select * from phpgw_comic_data WHERE like '%dilbert%' order by data_title asc LIMIT 15

File: inc/comic_data.inc.php
Line: 126
Session halted.

The problem is the SQL query does not specify a table to search through.  If I manually log into the database and query like so, it works:

select * from phpgw_comic_data WHERE data_title like '%dilbert%' order by data_title asc LIMIT 15

Invalid User ID <#9151>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 4 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-07-14 skwashd Item GroupSVN trunk (dev code) 0.9.16.000 release
    StatusNone Fixed
    Assigned toNone skwashd
    Open/ClosedOpen Closed

Back to the top

Powered by Savane 3.13-4b48.
Corresponding source code