Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - robrob

Pages: [1]
1.3-beta / Re: task view crashed
« on: April 08, 2009, 08:56:44 pm »
Similar error here - similar fix (different file though):

- Cause: in the task panel, I did this:
--- Filter > Milestone > ---none--- > Status Pending

- Error msg: SQL syntax error in environment/library/database/adapters/AbstractDBAdapter.class.php on line 386

- Solved it by commenting that line out. The result (with the filter still in place as noted above): no milestones/tasks showing (blank panel content) instead of error msg

To confirm that this was the exact cause, I reversed the change to the code and repeated my steps. Same error again.

It seems as if the SQL query for that filter is corrupt, since the error is a result of $query_result being false in the prepareAndExecute function.

I hope this helps.

Ideas / Re: Improve predefined date spans in reports
« on: March 13, 2009, 09:55:52 pm »
Really? Without having looked at the code - and I apologize for that - wouldn't it only be a matter of querying all entries in a table instead of a select range? I.e. simply dropping the WHERE argument when building the query.

Same for quarters - determine the start and end dates of quarters first, then determine in which quarter you currently are.

I may be mistaken and if so, would love to be enlightened :) If there isn't something I have overlooked, I may just try coding it up myself and putting it on here (if anyone is interested, lol).

Ideas / Improve predefined date spans in reports
« on: March 12, 2009, 01:53:15 pm »
A suggestion that I believe would be easy to implement, but will improve and speed up the workflow, is adding a couple predefined date spans to the "date" dropdown field on the reporting page.

Currently exist: Today, this week, last week, this month, last month.

I often need to generate reports for the complete project/workspace, and to do that, I have to select "select dates" in the dropdown and then click back a few months in the date field and select a random date in the past as starting date. This is a bit tedious, as some workspaces do go back in time for months :)

How about adding at least an "all time" option, and then maybe:
- "current quarter" and "last quarter",
- "current year" and "last year"?

Alternatively (but this would take a bit more work), why not enable custom setup of these date spans in the administration of this module?


1.2 RC2 / Re: Working for 2 days, suddenly jumping to Installation screen
« on: February 16, 2009, 05:36:45 pm »
Thanks Todd, that's just what I needed.

Ignacio, that sounds great - looking forward to it. Thanks!

1.2 RC2 / Re: Working for 2 days, suddenly jumping to Installation screen
« on: February 13, 2009, 05:43:21 pm »
Ok I hardcoded the database credentials into config/config.php and at least I'm back in now. The config.php file on the server somehow got wiped/overwritten and returned false. Note this happened without me changing anything either in the db or on the server. This looks like a bug to me.

Anyway, in the course of trying to get this to work again, I dropped the table "og_administration_tools. I did back the entries up but not the field names. Can anyone please let me know the 5 field names for this table so that I can recreate it and import the two rows it had?


1.2 RC2 / Working for 2 days, suddenly jumping to Installation screen
« on: February 13, 2009, 05:18:44 pm »

After having OpenGoo installed and running for two days so far, all I get when calling up the page is the Installation welcome screen. The database is fine, nothing has changed, and it seems as if this is coming out of thin air. When I type in the database details, it comes back with an error message and tells me:

Failed to import database construction. MySQL said: Table 'og_administration_tools' already exists

...and then the whole game starts over and I'm at the install screen again.

I can't log in or access my data. Clearing cookies doesn't help. The owner company has a client_of_id of 0 in the database. The last backup I tried to make with the backup function didn't produce any results (or any backup) whatsoever.

I'm really lost since I was so happy about finding OpenGoo but now it just locked me out entirely. Any help is appreciated. Thanks.

Pages: [1]