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.


Topics - tamalita

Pages: [1] 2
1
Installation problems / Purpose of OpenGoo?
« on: September 30, 2009, 04:59:05 pm »
I am not really sure where to put this and it is not my intent to be inflammatory -- I am simply curious.

With FengOffice available, what is the purpose of OpenGoo?

I know that personally, I prefer having an installation on my own server so that I can be 'in charge', maintain backups (both schedule and physical) of the files and the database, and I'd prefer to send users to my own website.

I use my OG on a daily basis, and pretty much all day long. It is where I store all of my notes and keep track of all of my time for all of my work. I have been using OG since February 2009 and it has become an essential part of my business.

I am not a PHP programmer, but have used many different types of scripts over the years and successfully updgraded working installations of said scripts (shopping carts, content management, etc).  I feel that I have a certain level of technical proficiency that allows me to do the things that I need to and usually want to do.

I have not hacked the OG code in any way, but I'm using the files directly from the downloads.  It seems that each upgrade for OpenGoo that I have gone through has broken my installation. The automatic upgrade does not work and I have to do manual upgrades. That's ok because I'm used to doing manual upgrades for several different types of programs and understand how things need to be done. I follow the instructions. Then when I get to the part where I'm supposed to upgrade (domain.com/opengoo/public/install) the upgrade fails and I'm left with a broken installation.

I then have to spend a large part of my day reverting back to my old installation that was working and once that is back again, deal with the annoying message that a new upgrade is available.

Obviously since I have been able to do a completely new installation in another directly and successfully upgraded that --- something is amiss with my current installation. I can understand that --- but how do I go about figuring out what the problem is?

Is there a way to successfully import data from an old installation into a new installation?

Does this type of issue occur in FengOffice? 

Again, I'm not trying to be inflammatory, I am just frustrated and looking for some sort of advice. I do not mind paying for FengOffice except that I have months worth of data that won't be there ... and I'd prefer to send users to my own site ... and I'd prefer to be in charge of my own backups.

2
Installation problems / Unable to upgrade
« on: September 30, 2009, 04:25:05 pm »
I have previously tried to upgrade from 1.4.2 to versions of 1.5. It has never worked. I tried upgrading to 1.5.3 last week and totally broke my installation. Someone suggested that I try to incrementally upgrade.

First, I created a new installation of 1.4.2 on my server. With that installation, I have managed to successfully upgrade from 1.4.2 to 1.5 and to 1.5.1 with no errors. The database is of course empty :)

So I thought I would try on my working installation. Started with a fresh, working 1.4.2 and just now tried to go to 1.5. I get the same error as others, and that I've mentioned:
first that og_template_parameters already exists, so I delete that table (it's empty) from the database), then that og_gs_borderStyles already exists, so I delete that ... and now I get "# Failed to execute DB schema transformations. MySQL said: Duplicate column name 'cc'
# Error upgrading to version 1.5"

And I ask again, what column is this referring to??

You can see the results of this fiasco here:
http://i129.photobucket.com/albums/p234/tamalita1/9-30-20091-22-54PM.png

---
Now, since I have been able to upgrade my new installation, is there a way that I can import my working data into this new installation???

---

Another issue that I am having is in my current installation (well before it broke again), I click on Notes on the dashboard and see:

but on my brand new installation I don't have this problem!
In the same browser (Firefox)

---
I have begun a trial with FengOffice. The only thing I don't like is that I won't have the backups on my computer. And I don't want to send clients off my website. I love having OpenGoo when it works, but I really hate the upgrade process. For now I am going to go back to 1.4.2.

3
Installation problems / fresh installation 1.4.2 - database
« on: September 26, 2009, 06:38:43 pm »
Because I was unable to upgrade to 1.5.3, and my installation was broken, I decided to try a fresh installation. The installation went perfectly, but when I replace the newly created database with my backup (both 1.4.2) I get an error.

Code: [Select]
Error
We are sorry, but a fatal error prevented OpenGoo from executing your request.
An Error Report has been sent to the administrator.
So, what is the proper way to go about adding the data from my database backup?



4
Older versions / Error upgrading to version 1.5.3
« on: September 25, 2009, 05:29:38 pm »
I was attempting to upgrade from 1.4.2 to 1.5.3. I have not upgraded regularly from 1.4.2 on because anything I tried to do broke my installation and I don't have time to deal with that :) I use my installation constantly.

So, today, since it is Friday, I decided to spend some time and try to upgrade. I have not been able to do an automatic upgrade through admin for quite some time and have to do a manual upgrade.

 I deleted all old files off the server and replaced with new files. I went to the upgrade location and started the upgrade process.

The first error that I received was:

Code: [Select]
    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Table 'og_template_parameters' already exists
    * Error upgrading to version 1.5.3
So I deleted the table 'og_template_parameters' from my database and ran the upgrade again and received the following error:

Code: [Select]
    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Table 'og_gs_borderstyles' already exists
    * Error upgrading to version 1.5.3
So I deleted the table 'og_gs_borderstyles' and of course had to re-delete the table 'og_template_parameters' from my database. I ran the upgrade again and received this error:
Code: [Select]
    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Duplicate column name 'cc'
    * Error upgrading to version 1.5.3
I do not know which column this is referring to
Code: [Select]
Duplicate column name 'cc'
And now I have a non-working installation.

I am going to do a completely new installation, but will I be able to add all of my old data?

5
Older versions / Notes no longer available
« on: August 15, 2009, 01:57:13 pm »
Last night I was making notes ... no problems at all. I didn't make any changes to my installation, no changes to my database, just creating a few notes. No problems.

This morning I logged in to look over my notes and no matter where I look (all workspaces, or in a specific workspace) ... my notes are no longer available from the dashboard. This is what I see:

Code: [Select]
GIF89a�����������!�����,�������D�;
Now, if i enter "notes" into my search, I can display the notes and if I am in a specific workspace it will show the notes for that workspace ....  but I'm not see the notes from last night ...

And I do not have the ability to create new notes.

6
Installation problems / Reverting to 1.4.2 from 1.5
« on: July 29, 2009, 05:41:32 pm »
Installing 1.5 completely broke my OG installation  :(

I have had to remove all the files from my server and upload the 1.4.2 files.

I had a fatal error as reported in this post.

7
Older versions / Fatal error 1.5 cannot login
« on: July 29, 2009, 05:23:57 pm »
Now that I've successfully downloaded and upgraded from 1.4.2 to 1.5, I can't access anything within the open goo installation. I get a fatal error anytime I load the site or click on any link

this is one example:
Fatal error: Call to private method ProjectMessages::getWorkspaceString() from context 'ObjectController' in /home/xxx/public_html/goo/application/controllers/ObjectController.class.php on line 770

I just logged out and tried to log back in and received this error:
Fatal error: Undefined class constant 'ACTION_LOGIN' in /home/xxx/public_html/goo/application/controllers/AccessController.class.php on line 149

8
Older versions / Update from 1.5 undefined function - failure
« on: July 28, 2009, 01:02:06 pm »
Fatal error: Call to undefined function zip_open() in /home/xxx/public_html/goo/public/upgrade/auto.php on line 21

this is for an update from 1.4.2 to 1.5.
I have debug on, but no log file is generated (no log.php)
I am using firefox 3.5.1
Linux/PHP 5.2.10/MySQL 5.0.81

9
Ideas / Change time and task
« on: June 12, 2009, 08:26:02 pm »
I would like to be able to edit the time to be able to change the task it is associated with.

10
How To's / Still unable to backup
« on: May 28, 2009, 05:49:02 pm »
I have never been able to generate a backup of my OpenGoo installation. I go to Administration>Backup>Launch Backup Process and the little window pops up telling me the backup process is completed, but there is no backup file showing, and there is not one on the server. I just ran it and have my log file. This is from clicking the Launch Backup Process a single time ....

Code: [Select]
<?php die(); ?>

Session "default" started at 2009-05-28T20:39:49+0000

#1 ERROR: Error: ZipArchive::addFile() [<a href='ziparchive.addfile'>ziparchive.addfile</a>]: Invalid or unitialized Zip object in '/home/XXX/public_html/goo/application/controllers/BackupController.class.php' on line 185 (error code: 2)


***** this ERROR is repeated  over 3000 times and then *****

Code: [Select]

#3030 ERROR: Error: ZipArchive::addFile() [<a href='ziparchive.addfile'>ziparchive.addfile</a>]: Invalid or unitialized Zip object in '/home/XXX/public_html/goo/application/controllers/BackupController.class.php' on line 196 (error code: 2)

#3031 ERROR: Error: ZipArchive::close() [<a href='ziparchive.close'>ziparchive.close</a>]: Invalid or unitialized Zip object in '/home/XXX/public_html/goo/application/controllers/BackupController.class.php' on line 197 (error code: 2)

Time since start: 0.43003582954407 seconds

-------------------------------------------------------------------------------



Session "default" started at 2009-05-28T20:39:50+0000

#1 ERROR: Error: Undefined variable: last_backup in '/home/XXX/public_html/goo/application/controllers/BackupController.class.php' on line 54 (error code: 8)

#2 ERROR: Error: Undefined variable: date in '/home/XXX/public_html/goo/application/controllers/BackupController.class.php' on line 59 (error code: 8)

Time since start: 0.089313983917236 seconds

-------------------------------------------------------------------------------

11
1.4 beta / can't end task and other errors- 1.4rc
« on: May 19, 2009, 04:56:53 pm »
I just upgraded from 1.3.1 (I think) to 1.4RC. I can't end my task. I get the following:

Code: [Select]
Error (DBQueryError)
Query failed with message '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 '' at line 1'
Error params:
File: /home/XXX/public_html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Sql: SELECT * FROM `og_workspace_billings` WHERE project_id = '144' AND billing_id =
Error number: 1064
Error message: 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 '' at line 1
Backtrace:
#0 /home/XXX/public_html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php(304):

AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/XXX/public_html/goo/environment/library/database/DB.class.php(199):

AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/XXX/public_html/goo/environment/classes/dataaccess/DataManager.class.php(231):

DB::executeAll('SELECT * FROM `...')
#3

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

112): DataManager->find(Array)
#4 /home/XXX/public_html/goo/environment/classes/dataaccess/DataManager.class.php(277):

BaseWorkspaceBillings->find(Array)
#5

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

146): DataManager->findOne(Array)
#6

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

148): BaseWorkspaceBillings->findOne(Array)
#7 /home/XXX/public_html/goo/application/models/projects/Copy of Project.class.php(455):

BaseWorkspaceBillings->findOne(Array)
#8 /home/XXX/public_html/goo/application/controllers/TimeslotController.class.php(164):

Project->getBillingAmount(0)
#9 /home/XXX/public_html/goo/environment/classes/controller/Controller.class.php(75):

TimeslotController->close()
#10 /home/XXX/public_html/goo/environment/classes/controller/PageController.class.php(62):

Controller->execute('close')
#11 /home/XXX/public_html/goo/environment/classes/Env.class.php(133):

PageController->execute('close')
#12 /home/XXX/public_html/goo/init.php(150): Env::executeAction('timeslot', 'close')
#13 /home/XXX/public_html/goo/index.php(9): require('/home/XXX/...')
#14 {main}
Autoglobal varibles:
$_GET: Array (
  ['active_project'] => (string) '0'
  ['ajax'] => (string) 'true'
  ['c'] => (string) 'timeslot'
  ['a'] => (string) 'close'
  ['id'] => (string) '317'
  ['current'] => (string) 'overview-panel'
)
$_POST: Array (
  ['timeslot'] => Array (
    ['description'] => (string) 'XXX'
  )
)
$_COOKIE: Array (
  ['exp_last_visit'] => (string) '1242701756'
  ['exp_last_activity'] => (string) '1242772504'
  ['exp_perpage'] => (string) '50'
  ['exp_mode'] => (string) 'normal'
  ['id'] => (string) '1'
  ['token'] => (string) 'a51b7a4143bb5a1c400dead9f4eaecd1bacebdc4'
  ['remember'] => (string) '1'
  ['PHPSESSID'] => (string) 'd9b245e9d8ae2a58be36d194f85f4817'
)
$_SESSION: Array (
  ['cal_version'] => true
  ['month'] => (string) '5'
  ['year'] => (string) '2009'
  ['day'] => (string) '19'
  ['cal_loginfailed'] => (int)0
  ['cal_user'] => (string) 'tamalita'
  ['cal_userid'] => (int)1
)
Execution time:
Total execution time: 0.156226 seconds
I was able to Complete the task and the time was ended, but I got an error:
Code: [Select]
Error:
App.modules.addTaskForm is undefined
When I try to navigate around the dashboard, the calendar also gives me an error:
Code: [Select]
Error
og.CalendarTopToolbar is not a constructor
If I look at the calendar and click on a task I get a duplicate error as above:
Code: [Select]
Error

App.modules.addTaskForm is undefined.
I have also tried to view the tasks and they are not showing up under Tasks on the dashboard. I get an error:
Code: [Select]
ogTasks is not defined
If I try to add a task I get
Code: [Select]
Og.CSVCombo is not a constructor
og.DateField is not a constructor
og.DateField is not a constructor
if I try to edit the milestone, I get:
Code: [Select]
Og.CSVCombo is not a constructor
og.DateField is not a constructor
If I try to save the changes I get
Code: [Select]
Fatal error: Call to a member function getMonth() on a non-object
in /home/XXX/public_html/goo/application/controllers/MilestoneController.class.php on line 297

12
Getting Started / Reporting Module
« on: May 08, 2009, 12:50:06 am »
How is this supposed to work? When I click on the link, I see 4 links on the left: Activity, Tasks, Statistics, Administration.

Activity, Statistics, and Administration are blank.

Tasks has a link for total task execution time, and then basically gives a report of just that.

My apologies for being a pest .... just had a chance to logon to the forum and figured I'd get all my questions out of the way!

13
Getting Started / Time report customization?
« on: May 08, 2009, 12:47:25 am »
I'm just wondering if it is possible to 'customize' the time report? For example, since I'm not currently able to use the categories, I was wondering if it is possible to have the tags included with the time report? Somehow, when doing my time report, I need to be able to know the breakdown of task by category.

14
Getting Started / How to use workspaces
« on: May 08, 2009, 12:36:52 am »
The way that I have set up my OpenGoo is for each client to have their own workspace, and then within that workspace, I create the milestones and tasks associated with different projects. Now that I'm seeing how the billing categories are working, I am thinking that within the client workspace, I need to create project workspaces, so that I can actually assign billing categories to the projects. How do you use the workspaces?

15
How To's / Billing Categories
« on: May 08, 2009, 12:30:12 am »
The way this is set up seems backwards to me, or perhaps I am doing things backwards. I only currently have 3 users in my setup, myself and my 2 assistants. I have not moved my clients into the system yet, as users, because I'm not ready to do so. My assistants work with 1) keeping things updated (workspaces, tasks, scheduling) and 2) billing. I do all the other work. I use Quickbooks to actually do my invoicing and was hoping that I would be able to take the time data from OpenGoo and bring it into Quickbooks using the same billing categories. So I set up all my billing categories. My thought was that I would be able to choose each task and assign it to the proper category so that my billing assistant would know where to put it in Quickbooks. But the way the billing categories system is set up, each category has to be assigned to a user. Well, all the billing categories need to be assigned to me. And each client would require multiple billing categories as well.

So how is the billing category system *supposed* to work, obviously I am doing something incorrect, or looking at things incorrectly.

Pages: [1] 2