mainSavannah Administration - Support: sr #106095, Task exports doesnt work

 
 

sr #106095: Task exports doesnt work

Submitter:  Jose E. Marchesi <jemarch>
Submitted:  Wed 21 Nov 2007 11:51:44 AM UTC
   
 
Category:  Savannah trackers - bugs, tasks, etc. Priority:  5 - Normal
Severity:  4 - Important Status:  Done
Privacy:  Public Assigned to:  Beuc
Operating System:  None Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Jump to the original submission

Fri 22 Feb 2008 09:51:49 PM UTC, comment #9: 

Superb! Many thanks Sylvain.

Jose E. Marchesi <jemarch>
Fri 22 Feb 2008 09:08:14 PM UTC, comment #8: 

Hey Jose.

Thanks for the report, it was a pedantic PHP warning.
It's fixed.

Sylvain Beucler <Beuc>
Thu 21 Feb 2008 09:03:56 PM UTC, comment #7: 

The immediate export seems to work, but I got this error while scheduling a periodic export (every days):

Strict Standards: mktime() [function.mktime]: You should be using the time() function instead in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 315

Warning: Cannot modify header information - headers already sent by (output started at /usr/src/savane/frontend/php/include/trackers_run/export.php:315) in /usr/src/savane/frontend/php/include/session.php on line 305

Jose E. Marchesi <jemarch>
Sun 09 Dec 2007 09:08:15 AM UTC, comment #6: 

OK, this oughta work now.
(Note: I recreated your export task, maybe check the parameters)

On Sat, Dec 08, 2007 at 05:33:47PM +0100, -email is unavailable- wrote:

>
>
>    I went ahead and did some clean-up in that code. I didn't write it and I
>    don't think it was stable already :)
>
>    Should work now.
>
> It works. Many thanks :)


Just received a mail from cron - apparently something went
wrong. Sigh..

--
Sylvain

Sylvain Beucler <Beuc>
Sat 08 Dec 2007 03:51:16 PM UTC, comment #5: 

I went ahead and did some clean-up in that code. I didn't write it and I don't think it was stable already :)

Should work now.

Sylvain Beucler <Beuc>
Wed 28 Nov 2007 09:09:07 AM UTC, comment #4: 

The error message changed:

Notice: Undefined variable: sumORdet in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 224

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 275

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 280

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 292

Notice: Undefined variable: timestamp in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 334

Notice: Undefined variable: requested_day in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 335

Notice: Undefined variable: requested_hour in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 336
db_query: SQL query error Column 'date' cannot be null in [INSERT INTO `trackers_export` (`task_id`,`artifact`,`unix_group_name`,`user_name`,`sql`,`status`,`date`,`frequency_day`,`frequency_hour`) VALUES (0,'task','pdf','jemarch','SELECT bug_id FROM task WHERE group_id=\'9375\' AND status_id IN (Array) ','I',NULL,NULL,NULL)]

Jose E. Marchesi <jemarch>
Wed 28 Nov 2007 09:03:39 AM UTC, comment #3: 

Sorry I didn't replicate the changes online.

Sylvain Beucler <Beuc>
Wed 28 Nov 2007 05:32:40 AM UTC, comment #2: 

Still with problems:

Notice: Undefined variable: sumORdet in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 224

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 275

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 280

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 292

Notice: Undefined variable: timestamp in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 334

Notice: Undefined variable: requested_day in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 335

Notice: Undefined variable: requested_hour in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 336
db_query: SQL query error Unknown column 'unix_group_name ' in 'field list' in [INSERT INTO `trackers_export` (`task_id`,`artifact`,`unix_group_name `,`user_name`,`sql`,`status`,`date`,`frequency_day`,`frequency_hour`) VALUES (0,'task','pdf','jemarch','SELECT bug_id FROM task WHERE group_id=\'9375\' AND status_id IN (Array) ','I',NULL,NULL,NULL)]

Jose E. Marchesi <jemarch>
Tue 27 Nov 2007 11:44:18 PM UTC, comment #1: 

Hey,

I fixed the extra space in 'unix_group_name ', how about now?

Sylvain Beucler <Beuc>
Wed 21 Nov 2007 11:51:44 AM UTC, original submission:  


I get the following when trying to queue a export job (pdf project):

Notice: Undefined variable: sumORdet in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 224

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 275

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 280

Notice: Undefined variable: mainchoice in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 292

Notice: Undefined variable: timestamp in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 334

Notice: Undefined variable: requested_day in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 335

Notice: Undefined variable: requested_hour in /usr/src/savane/frontend/php/include/trackers_run/export.php on line 336
db_query: SQL query error Unknown column 'unix_group_name ' in 'field list' in [INSERT INTO `trackers_export` (`task_id`,`artifact`,`unix_group_name `,`user_name`,`sql`,`status`,`date`,`frequency_day`,`frequency_hour`) VALUES (0,'task','pdf','jemarch','SELECT bug_id FROM task WHERE group_id=\'9375\' AND status_id IN (Array) ','I',NULL,NULL,NULL)]

Jose E. Marchesi <jemarch>

 

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

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by Beuc (Posted a comment)
  • -email is unavailable- added by jemarch (Submitted the item)
  •  

    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.

    Only logged-in users can vote.

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2008-04-26 Beuc StatusNone Done
        Open/ClosedOpen Closed
    2007-11-27 Beuc Assigned toNone Beuc

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code