bugphpGroupWare - Bugs: bug #9474, Cannot save a new trouble ticket

 
 

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

bug #9474: Cannot save a new trouble ticket

Submitter:  None
Submitted:  Sun 27 Jun 2004 08:35:29 PM UTC
   
 
Category:  tts Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  fipsfuchs Open/Closed:  Open
Component Version:  MDK Operating System:  GNU/Linux - Mandrake
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Thu 24 Nov 2005 05:35:47 AM UTC, comment #2: 

 <a href='http://wvvw.dynu.net/door/fat-slut-pic.html'> http://wvvw.dynu.net/door/fat-slut-pic.html - fat slut pic </a> http://wvvw.dynu.net/door/fat-slut-pic.html
 <a href='http://pivasik.dynu.net/kozel/free-pictures-of-huge-tits.html'> http://pivasik.dynu.net/kozel/free-pictures-of-huge-tits.html - free pictures of huge tits </a> http://pivasik.dynu.net/kozel/free-pictures-of-huge-tits.html
 <a href='http://pivasik.dynu.net/vatnik/absolute-shemale-com.html'> http://pivasik.dynu.net/vatnik/absolute-shemale-com.html - absolute shemale com </a> http://pivasik.dynu.net/vatnik/absolute-shemale-com.html
 <a href='http://mamba.dynu.net//blacks-on-blondes-sex.html'> http://mamba.dynu.net//blacks-on-blondes-sex.html - blacks on blondes sex </a> http://mamba.dynu.net//blacks-on-blondes-sex.html
 <a href='http://wvvw.dynu.net//interracial-sex-xxx.html'> http://wvvw.dynu.net//interracial-sex-xxx.html - interracial sex xxx </a> http://wvvw.dynu.net//interracial-sex-xxx.html
 <a href='http://wvvw.dynu.net/kozel/huge-hanging-tits.html'> http://wvvw.dynu.net/kozel/huge-hanging-tits.html - huge hanging tits </a> http://wvvw.dynu.net/kozel/huge-hanging-tits.html
 <a href='http://mamba.dynu.net/vatnik/shemale-escorts-miami.html'> http://mamba.dynu.net/vatnik/shemale-escorts-miami.html - shemale escorts miami </a> http://mamba.dynu.net/vatnik/shemale-escorts-miami.html
 <a href='http://mamba.dynu.net/masterzone/asian-model-scans.html'> http://mamba.dynu.net/masterzone/asian-model-scans.html - asian model scans </a> http://mamba.dynu.net/masterzone/asian-model-scans.html
 <a href='http://mamba.dynu.net/masterzone/thai-recipies.html'> http://mamba.dynu.net/masterzone/thai-recipies.html - thai recipies </a> http://mamba.dynu.net/masterzone/thai-recipies.html
 <a href='http://mamba.dynu.net/vatnik/smoking-shemale.html'> http://mamba.dynu.net/vatnik/smoking-shemale.html - smoking shemale </a> http://mamba.dynu.net/vatnik/smoking-shemale.html
 <a href='http://pivasik.dynu.net/masterzone/lolidus-boys-and-girls-japanese.html'> http://pivasik.dynu.net/masterzone/lolidus-boys-and-girls-japanese.html - lolidus boys and girls japanese </a> http://pivasik.dynu.net/masterzone/lolidus-boys-and-girls-japanese.html
 <a href='http://wvvw.dynu.net/kozel/big-fat-busty-boobs.html'> http://wvvw.dynu.net/kozel/big-fat-busty-boobs.html - big fat busty boobs </a> http://wvvw.dynu.net/kozel/big-fat-busty-boobs.html
 <a href='http://mamba.dynu.net/puzan/pictures-of-mature-women.html'> http://mamba.dynu.net/puzan/pictures-of-mature-women.html - pictures of mature women </a> http://mamba.dynu.net/puzan/pictures-of-mature-women.html
 <a href='http://wvvw.dynu.net/masterzone/asian-exploited-xxx.html'> http://wvvw.dynu.net/masterzone/asian-exploited-xxx.html - asian exploited xxx </a> http://wvvw.dynu.net/masterzone/asian-exploited-xxx.html
 <a href='http://wvvw.dynu.net/puzan/naked-mature-women-older-babes.html'> http://wvvw.dynu.net/puzan/naked-mature-women-older-babes.html - naked mature women older babes </a> http://wvvw.dynu.net/puzan/naked-mature-women-older-babes.html
 <a href='http://pivasik.dynu.net/vatnik/free-shemale-videos.html'> http://pivasik.dynu.net/vatnik/free-shemale-videos.html - free shemale videos </a> http://pivasik.dynu.net/vatnik/free-shemale-videos.html
 <a href='http://pivasik.dynu.net/green/movies-of-blowjobs.html'> http://pivasik.dynu.net/green/movies-of-blowjobs.html - movies of blowjobs </a> http://pivasik.dynu.net/green/movies-of-blowjobs.html
 <a href='http://pivasik.dynu.net/vatnik/free-thai-she-male-pics.html'> http://pivasik.dynu.net/vatnik/free-thai-she-male-pics.html - free thai she male pics </a> http://pivasik.dynu.net/vatnik/free-thai-she-male-pics.html
 <a href='http://wvvw.dynu.net/puzan/mature-women-sex-young-men.html'> http://wvvw.dynu.net/puzan/mature-women-sex-young-men.html - mature women sex young men </a> http://wvvw.dynu.net/puzan/mature-women-sex-young-men.html
 <a href='http://pivasik.dynu.net/kozel/busty-babes-beach.html'> http://pivasik.dynu.net/kozel/busty-babes-beach.html - busty babes beach </a> http://pivasik.dynu.net/kozel/busty-babes-beach.html
 <a href='http://pivasik.dynu.net/kozel/natural-large-tits.html'> http://pivasik.dynu.net/kozel/natural-large-tits.html - natural large tits </a> http://pivasik.dynu.net/kozel/natural-large-tits.html
 <a href='http://wvvw.dynu.net/puzan/mature-sluts-sex.html'> http://wvvw.dynu.net/puzan/mature-sluts-sex.html - mature sluts sex </a> http://wvvw.dynu.net/puzan/mature-sluts-sex.html
 <a href='http://pivasik.dynu.net/vatnik/free-daily-shemale-galleries.html'> http://pivasik.dynu.net/vatnik/free-daily-shemale-galleries.html - free daily shemale galleries </a> http://pivasik.dynu.net/vatnik/free-daily-shemale-galleries.html
 <a href='http://mamba.dynu.net/kozel/free-old-tits.html'> http://mamba.dynu.net/kozel/free-old-tits.html - free old tits </a> http://mamba.dynu.net/kozel/free-old-tits.html
 <a href='http://pivasik.dynu.net/masterzone/learn-japanese-rope-bondage.html'> http://pivasik.dynu.net/masterzone/learn-japanese-rope-bondage.html - learn japanese rope bondage </a> http://pivasik.dynu.net/masterzone/learn-japanese-rope-bondage.html
 <a href='http://wvvw.dynu.net/vatnik/free-glamour-tranny-pics.html'> http://wvvw.dynu.net/vatnik/free-glamour-tranny-pics.html - free glamour tranny pics </a> http://wvvw.dynu.net/vatnik/free-glamour-tranny-pics.html
 <a href='http://mamba.dynu.net/kozel/free-gallery-black-pussy-tits-ass.html'> http://mamba.dynu.net/kozel/free-gallery-black-pussy-tits-ass.html - free gallery black pussy tits ass </a> http://mamba.dynu.net/kozel/free-gallery-black-pussy-tits-ass.html
 <a href='http://pivasik.dynu.net/puzan/divorced-older-women.html'> http://pivasik.dynu.net/puzan/divorced-older-women.html - divorced older women </a> http://pivasik.dynu.net/puzan/divorced-older-women.html
 <a href='http://wvvw.dynu.net/puzan/free-porn-thumbnails-of-hot-mature-sluts.html'> http://wvvw.dynu.net/puzan/free-porn-thumbnails-of-hot-mature-sluts.html - free porn thumbnails of hot mature sluts </a> http://wvvw.dynu.net/puzan/free-porn-thumbnails-of-hot-mature-sluts.html
 <a href='http://pivasik.dynu.net/puzan/granny-slave.html'> http://pivasik.dynu.net/puzan/granny-slave.html - granny slave </a> http://pivasik.dynu.net/puzan/granny-slave.html
 <a href='http://mamba.dynu.net/puzan/free-mature-women.html'> http://mamba.dynu.net/puzan/free-mature-women.html - free mature women </a> http://mamba.dynu.net/puzan/free-mature-women.html
WBR LSvEupoVDhfmgCyGi

Anonymous
Thu 24 Nov 2005 05:33:39 AM UTC, comment #1: 

 <a href='http://pivasik.dynu.net/green/free-granny-cumshots.html'> http://pivasik.dynu.net/green/free-granny-cumshots.html - free granny cumshots </a> http://pivasik.dynu.net/green/free-granny-cumshots.html
 <a href='http://wvvw.dynu.net/green/internial-cum-shots.html'> http://wvvw.dynu.net/green/internial-cum-shots.html - internial cum shots </a> http://wvvw.dynu.net/green/internial-cum-shots.html
 <a href='http://mamba.dynu.net/vatnik/shemals.html'> http://mamba.dynu.net/vatnik/shemals.html - shemals </a> http://mamba.dynu.net/vatnik/shemals.html
 <a href='http://pivasik.dynu.net/puzan/free-naked-pictures-of-mature-women.html'> http://pivasik.dynu.net/puzan/free-naked-pictures-of-mature-women.html - free naked pictures of mature women </a> http://pivasik.dynu.net/puzan/free-naked-pictures-of-mature-women.html
 <a href='http://pivasik.dynu.net/puzan/mature-wemen-videos.html'> http://pivasik.dynu.net/puzan/mature-wemen-videos.html - mature wemen videos </a> http://pivasik.dynu.net/puzan/mature-wemen-videos.html
 <a href='http://mamba.dynu.net/masterzone/japanese-artwork.html'> http://mamba.dynu.net/masterzone/japanese-artwork.html - japanese artwork </a> http://mamba.dynu.net/masterzone/japanese-artwork.html
 <a href='http://wvvw.dynu.net/puzan/lesbian-nurse-sex.html'> http://wvvw.dynu.net/puzan/lesbian-nurse-sex.html - lesbian nurse sex </a> http://wvvw.dynu.net/puzan/lesbian-nurse-sex.html
 <a href='http://mamba.dynu.net/puzan/granny-series.html'> http://mamba.dynu.net/puzan/granny-series.html - granny series </a> http://mamba.dynu.net/puzan/granny-series.html
 <a href='http://pivasik.dynu.net/puzan/mature-busty-galleries.html'> http://pivasik.dynu.net/puzan/mature-busty-galleries.html - mature busty galleries </a> http://pivasik.dynu.net/puzan/mature-busty-galleries.html
 <a href='http://pivasik.dynu.net/door/ass-fat-joke.html'> http://pivasik.dynu.net/door/ass-fat-joke.html - ass fat joke </a> http://pivasik.dynu.net/door/ass-fat-joke.html
 <a href='http://pivasik.dynu.net/kozel/free-teen-porn-big-tits.html'> http://pivasik.dynu.net/kozel/free-teen-porn-big-tits.html - free teen porn big tits </a> http://pivasik.dynu.net/kozel/free-teen-porn-big-tits.html
 <a href='http://wvvw.dynu.net/masterzone/free-asian-gallaries-pussy.html'> http://wvvw.dynu.net/masterzone/free-asian-gallaries-pussy.html - free asian gallaries pussy </a> http://wvvw.dynu.net/masterzone/free-asian-gallaries-pussy.html
 <a href='http://pivasik.dynu.net/green/free-nude-babes-cumshot-pics.html'> http://pivasik.dynu.net/green/free-nude-babes-cumshot-pics.html - free nude babes cumshot pics </a> http://pivasik.dynu.net/green/free-nude-babes-cumshot-pics.html
 <a href='http://wvvw.dynu.net//fetish-fucking-gallery-interracial.html'> http://wvvw.dynu.net//fetish-fucking-gallery-interracial.html - fetish fucking gallery interracial </a> http://wvvw.dynu.net//fetish-fucking-gallery-interracial.html
 <a href='http://wvvw.dynu.net//nterracial-porn-style.html'> http://wvvw.dynu.net//nterracial-porn-style.html - nterracial porn style </a> http://wvvw.dynu.net//nterracial-porn-style.html
 <a href='http://wvvw.dynu.net/masterzone/chloroformed-japanese-girls.html'> http://wvvw.dynu.net/masterzone/chloroformed-japanese-girls.html - chloroformed japanese girls </a> http://wvvw.dynu.net/masterzone/chloroformed-japanese-girls.html
 <a href='http://pivasik.dynu.net/kozel/vintage-photos-of-busty-ladies.html'> http://pivasik.dynu.net/kozel/vintage-photos-of-busty-ladies.html - vintage photos of busty ladies </a> http://pivasik.dynu.net/kozel/vintage-photos-of-busty-ladies.html
 <a href='http://pivasik.dynu.net/puzan/adult-fucking-loud-mature.html'> http://pivasik.dynu.net/puzan/adult-fucking-loud-mature.html - adult fucking loud mature </a> http://pivasik.dynu.net/puzan/adult-fucking-loud-mature.html
 <a href='http://wvvw.dynu.net/vatnik/transgendered-lifestyle.html'> http://wvvw.dynu.net/vatnik/transgendered-lifestyle.html - transgendered lifestyle </a> http://wvvw.dynu.net/vatnik/transgendered-lifestyle.html
 <a href='http://pivasik.dynu.net/kozel/big-tits-huge.html'> http://pivasik.dynu.net/kozel/big-tits-huge.html - big tits huge </a> http://pivasik.dynu.net/kozel/big-tits-huge.html
 <a href='http://mamba.dynu.net/vatnik/free-shemale-tranny.html'> http://mamba.dynu.net/vatnik/free-shemale-tranny.html - free shemale tranny </a> http://mamba.dynu.net/vatnik/free-shemale-tranny.html
 <a href='http://wvvw.dynu.net/vatnik/free-movies-transexuals.html'> http://wvvw.dynu.net/vatnik/free-movies-transexuals.html - free movies transexuals </a> http://wvvw.dynu.net/vatnik/free-movies-transexuals.html
 <a href='http://mamba.dynu.net/kozel/huge-tits-on-motorcycles.html'> http://mamba.dynu.net/kozel/huge-tits-on-motorcycles.html - huge tits on motorcycles </a> http://mamba.dynu.net/kozel/huge-tits-on-motorcycles.html
 <a href='http://pivasik.dynu.net/puzan/mature-spread-pussy-pictures.html'> http://pivasik.dynu.net/puzan/mature-spread-pussy-pictures.html - mature spread pussy pictures </a> http://pivasik.dynu.net/puzan/mature-spread-pussy-pictures.html
 <a href='http://mamba.dynu.net/vatnik/shemale-ladyboys.html'> http://mamba.dynu.net/vatnik/shemale-ladyboys.html - shemale ladyboys </a> http://mamba.dynu.net/vatnik/shemale-ladyboys.html
 <a href='http://pivasik.dynu.net/vatnik/tranny-chicks-with-dicks.html'> http://pivasik.dynu.net/vatnik/tranny-chicks-with-dicks.html - tranny chicks with dicks </a> http://pivasik.dynu.net/vatnik/tranny-chicks-with-dicks.html
 <a href='http://pivasik.dynu.net/kozel/asian-tits-free-thumbnail-post-listing.html'> http://pivasik.dynu.net/kozel/asian-tits-free-thumbnail-post-listing.html - asian tits free thumbnail post listing </a> http://pivasik.dynu.net/kozel/asian-tits-free-thumbnail-post-listing.html
 <a href='http://pivasik.dynu.net/masterzone/asian-bar-girls-pictures.html'> http://pivasik.dynu.net/masterzone/asian-bar-girls-pictures.html - asian bar girls pictures </a> http://pivasik.dynu.net/masterzone/asian-bar-girls-pictures.html
 <a href='http://pivasik.dynu.net/door/cute-fat-teen.html'> http://pivasik.dynu.net/door/cute-fat-teen.html - cute fat teen </a> http://pivasik.dynu.net/door/cute-fat-teen.html
 <a href='http://pivasik.dynu.net/masterzone/asian-women-sucking-cock.html'> http://pivasik.dynu.net/masterzone/asian-women-sucking-cock.html - asian women sucking cock </a> http://pivasik.dynu.net/masterzone/asian-women-sucking-cock.html
 <a href='http://pivasik.dynu.net//adult-interracial-movie.html'> http://pivasik.dynu.net//adult-interracial-movie.html - adult interracial movie </a> http://pivasik.dynu.net//adult-interracial-movie.html
WBR dvHPMQuWLZreUOAyn

Anonymous
Sun 27 Jun 2004 08:35:29 PM UTC, original submission:  

Attempt to save a new troubleticket gives this error msg:

"
Database error: Invalid SQL: insert into phpgw_tts_tickets * * (ticket_group,ticket_priority,ticket_owner,ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,ticket_billable_rate,ticket_status,ticket_deadline,ticket_effort,ticket_type,ticket_platform,ticket_attachment,ticket_details) values ('7','8','13','13','a test','2','0.00','0.00','O','--','','','','','test data ')
 MySQL Error: 1064 (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 '* * (ticket_group,ticket_priority,ticket_owner,ticket_assi)

File: /var/www/html/phpgroupware/tts/newticket.php
Line: 88

Session halted. "



phpgw_tts_tickets does not have some of the fields referenced by the insert. I made the following change at ~line 70 to remedy the problem:

$GLOBALS['phpgw']->db->query("insert into phpgw_tts_tickets (ticket_group,ticket_priority,ticket_owner,"
. "ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,"
. "ticket_billable_rate,ticket_status,ticket_details) values ('"
                        . $_POST['ticket']['group'] . "','"
. $_POST['ticket']['priority'] . "','"
. $GLOBALS['phpgw_info']['user']['account_id'] . "','"
. $_POST['ticket']['assignedto'] . "','"
. $_POST['ticket']['subject'] . "','"
. $_POST['ticket']['category'] . "','"
. $_POST['ticket']['billable_hours'] . "','"
. $_POST['ticket']['billable_rate'] . "','O','"
. addslashes($ticket['details']) . "')",__LINE__,__FILE__);


Note that I removed the offending field references. I assume that those fields represent planned but not yet implemented new functionality.

Anonymous

 

(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 2 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2005-01-16 skwashd Assigned tolpiepho fipsfuchs
2004-06-30 skwashd Assigned toNone lpiepho

Back to the top

Powered by Savane 3.13-758e.
Corresponding source code