From: Pottle, B. <BPottle@RHFoster.com> - 2005-11-04 19:06:16
|
Whoops, noticed that, sorry for hijacking the thread, hit reply on the wrong message :-\ But, good news is, that CREATE SEQUENCE was all I was missing, everything is working fine now! Thanks! Richard, give that query a shot and see if it helps you too. --Ben -----Original Message----- From: Andy Deakin [mailto:an...@ha...] Sent: Thursday, November 03, 2005 4:33 PM To: hel...@li... Subject: Re: [Helpmeict-discuss] Addition of colours for new priorities Hi (this post has the wrong title, but nevermind.....) Have you run the following? CREATE SEQUENCE "tbl_files_id_seq" START 1 INCREMENT 1 MAXVALUE 9223372036854775807 MINVALUE 1 CACHE 1; Andy Pottle, Ben wrote: >Hah, ookay, well, let's see... > >I actually just finished getting things back up and running (took less time >today than I thought). >Richard, I'm getting the same error you are. This may have something to do >with the fact that I was previously on a v.8 install and decided to go with >a fresh v.9 this time around... Either something changed with the code I >originally modified this for, or there's a problem with how I'm copying my >old code into the new page. From uploadfile.php, I receive: > >Fatal Error: SQL Query Failed. >INSERT INTO tbl_files(filename,filesize,type,issue) > VALUES('test.bmp','36366','image/bmp','1') >This could be because there is no valid connection, or because the query is >incorrect. > >And when I manually enter the query: > >helpdesk=# INSERT INTO tbl_files(filename,filesize,type,issue) >helpdesk-# VALUES('test.bmp','36366','image/bmp','1'); >ERROR: relation "tbl_files_id_seq" does not exist > >So it looks like I'm in the same boat you are. I'll let you know if I can >come up with anything... in the meantime, anyone else have an idea? > >--Ben > >-----Original Message----- >From: Pottle, Ben [mailto:BPottle@RHFoster.com] >Sent: Thursday, November 03, 2005 12:42 PM >To: 'hel...@li...' >Subject: RE: [Helpmeict-discuss] Addition of colours for new priorities > > >Err, and by after, I meant before. > >--Ben > >-----Original Message----- >From: Pottle, Ben [mailto:BPottle@RHFoster.com] >Sent: Thursday, November 03, 2005 12:31 PM >To: 'hel...@li...' >Subject: RE: [Helpmeict-discuss] Addition of colours for new priorities > > >Richard -- > >I haven't gotten my helpdesk all the way back up and running yet, but I did >notice one thing along the way: The code I pasted in for the addendum to >issue.php is missing an opening <?php after the #### START FILE-UPLOAD MOD >comment. Check to make sure that's in your code and see if it changes >anything. > >--Ben > >-----Original Message----- >From: R J Thompson [mailto:ric...@re...] >Sent: Wednesday, November 02, 2005 5:30 AM >To: hel...@li... >Subject: [Helpmeict-discuss] Addition of colours for new priorities > > >Hello > >Would like to know if it's possible to add more colours to the >priorities list, we have created some new priorities but can only select >3 colours (red, yellow, green). > >Many thanks ! > >Richard > > >------------------------------------------------------- >SF.Net email is sponsored by: >Tame your development challenges with Apache's Geronimo App Server. Download >it for free - -and be entered to win a 42" plasma tv or your very own >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >_______________________________________________ >Helpmeict-discuss mailing list >Hel...@li... >https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss > > >------------------------------------------------------- >SF.Net email is sponsored by: >Tame your development challenges with Apache's Geronimo App Server. Download >it for free - -and be entered to win a 42" plasma tv or your very own >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >_______________________________________________ >Helpmeict-discuss mailing list >Hel...@li... >https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss > > >------------------------------------------------------- >SF.Net email is sponsored by: >Tame your development challenges with Apache's Geronimo App Server. Download >it for free - -and be entered to win a 42" plasma tv or your very own >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >_______________________________________________ >Helpmeict-discuss mailing list >Hel...@li... >https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss > > >------------------------------------------------------- >SF.Net email is sponsored by: >Tame your development challenges with Apache's Geronimo App Server. Download >it for free - -and be entered to win a 42" plasma tv or your very own >Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php >_______________________________________________ >Helpmeict-discuss mailing list >Hel...@li... >https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss > >. > > > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Helpmeict-discuss mailing list Hel...@li... https://lists.sourceforge.net/lists/listinfo/helpmeict-discuss |