Messages

1

Installation problems / Re: Blank Page - Help!

« on: March 01, 2009, 12:01:18 pm »

I just upgraded from 1.1 to 1.2.1 and received the following error with debug on:

Query failed with message 'Unknown column 'trashed_by_id' in 'where clause''
Error params:
File:    /var/www/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    386
Sql:    SELECT * FROM `og_companies` WHERE `trashed_by_id` = 0 AND (`client_of_id` = '0')
Error number:    1054
Error message:    Unknown column 'trashed_by_id' in 'where clause'

When I ran the upgrade, (/public/upgrade) everything said it went perfect.  Yet, I was getting white screens.  Found the debug, and came across this.  I backed up the source code to another directory.  After I encountered this issue, I swapped back to the 1.1 version, and now I can't connect to the DB! {chuckle}

This particular OpenGoo copy isn't all that important.  The data is still there, I'm sure, but I suppose I should do a dump.

2

How To's / Re: Writing my own iCal output for OpenGoo

« on: February 13, 2009, 03:57:22 pm »

This is going to sound backwards, but will it be able to pull the ICS file from remote locations, say, for instance, Google Calendar?

The reason is that I have Thunderbird setup to work with Google Calendar, I make my changes within Thunderbird.  Everything else then, like my cell phone, hooks into Google Calendar to get updates and syncs, etc.  Typically, its a one-way ordeal for anything OTHER THAN manual modification on Google Calendar, or Thunderbird.  I don't want to speak for anyone else, but for MY purposes, one-way integration would be perfect.

3

How To's / Writing my own iCal output for OpenGoo

« on: January 15, 2009, 11:35:32 pm »

Hey all;

I'm getting into the back end portion of writing the code to come up with an ICS file.  The wife is reluctant to use OpenGoo until I see the events daily.  I tend to use my mail client more than OpenGoo. heh

Anyways, I'm creating some sample data and have found that I am unsure of how OpenGoo decides when a calendar event is an "ALL DAY" event.  I don't see a particular field being set true or false, and the time stamps for start and duration in the ??_project_events table is only one hour different.

Where/how do I consider an event as an ALL DAY event?

Thanks.

PS> If its all the same to the admins, I'd like to keep this thread going for any other questions I have.   Thanks!

4

How To's / Re: Accessing opengoo locally and remotely

« on: December 26, 2008, 10:49:30 am »

Well the VPN is not so a great solution...
Of course you get encoded data stream over the internet, but it will be possible for any worm to affect directly the host LAN (in case of a host-to-lan VPN)...
I will go for an HTTPS solution, then maybe it's a little bit more secure than building up a VPN (instead of this proprietary vpn you can use OpenVPN)

If you want to start talking about trojans, key loggers, and viruses, then is any data safe, regardless of HTTPS/VPN/Security?

VPN is an additional layer of security.  Its not the end-all or say-all of methods, its just in my case the easiest thing to do for OpenVPN as you can only HAVE one home URL address.

5

Installation problems / Re: Fail to complete Step 3.

« on: December 26, 2008, 10:38:23 am »

What are the permissions for the database?  Does the user you're using to connect as have sufficient permissions to create tables?

I've noticed that depending on what version of PHP you are using, the `default` settings change as far as reporting errors.

In my case, I found that using OpenGoo using WAMP results in white pages when some sort of issue occurs, then I've used a LAMP server, and this time been bombarded with WARNING messages.

If you check out error_reporting you'll see how to use it.

It seems that if you're receiving a white page, and nothing else after DB connectivity attempts, you may try and change the default PHP settings so that it reports on ERRORS, or you can attempt to change the PHP files the devs here have created and include:

Code: [Select]

<?php
error_reporting(6143);
?>
at the begging of the page that does the DB connectivity.

6

Installation problems / Re: Solved: 1.1 RC1: Error: /config/config.php is not writable

« on: December 26, 2008, 10:28:04 am »

Interesting.  All I did was touch that file, made sure it had RW-RW-RW access, and it worked.  Is there any other file that is written to that directory?

7

Feng Office 1 / Re: Another minor annoyance

« on: December 16, 2008, 12:36:07 pm »

Alright, let me clarify.

I have a document thats about 6 pages long.  If I scroll to the top of the document, using the scroll bar, select where I want to start editing, then press ENTER, the page immediately goes right to the bottom of the document.  If I press another key, be it ENTER, SPACE, a character, or whatever, the document scrolls back to where the cursor is, USUALLY as being the very first line.

After I wrote this, I noticed just general odd behaviors with this editor.  If I use the scroll bar and scroll back and forth a few lines (Not pages), if I use the mouse, select where I want to start editing, press ENTER, the page ends up being centered to where the cursor is, regardless if I moved the cursor to the top or bottom of the current page.  I do not see odd behaviors happen when I'm using just the keyboard.  It seems only to happen when I use the mouse to do some panning around.

8

Feature requests / Document Default Font

« on: December 14, 2008, 05:39:00 pm »

Have the ability to select what default font I write in when there is nothing selected in the FONT drop box.  I prefer writing in Courier New or a fixed-width font.  (Back from the good 'ol DOS days. )

9

Feature requests / Note Font Type

« on: December 14, 2008, 05:36:27 pm »

I'd like to have the ability when entering Notes that whats displayed both in the text area, as well as when I preview the note, to have the option of selecting a variable width font, or fixed width font.  This could maybe be set on a per-note basis by storing that preference in the DB for that particular note.

10

Feng Office 1 / Another minor annoyance

« on: December 14, 2008, 05:34:25 pm »

When working on a very long document that spans pages, if I scroll up a few pages or to the near beginning of the document, then press ENTER to insert a new line, what displays in the document ends up scrolling down to the bottom of the page.  However, the cursor stays in the same spot, so if I start typing, the window scrolls back up to where the cursor is.

11

Feng Office 1 / *VERY* minor issue with document editor

« on: December 13, 2008, 06:42:32 pm »

I'm doing some work with OpenGoo in the Document Writer, and noticed that there are two scroll bars along the right side of the document part.  It seems that the frame that contains the formatting tools as well as the actual document is set just a tad bit too tall by just a few pixels.

This is true for Windows and Linux FireFox.  I'm not trying in IE, as I don't want to get a virus when going to http://localhost.

12

Getting Started / Re: Which webhosting company do you use for OpenGoo?

« on: December 13, 2008, 02:54:14 pm »

I'm running OpenGoo in house. ... no pun.  .. its.. in my house.

OpenGoo is running in a Virtual Machine with a Linux OS.  The metal is a 3ghz P4 on a 533mhz bus, 2gig of PC3200 on an 80gig 7200rpm HDD.  Currently, only 256meg of memory is assigned to the OS running OpenGoo.  This particular metal is also hosting 2 other OS's, and soon to be a third.

Speed wise, I sometimes wonder if running OpenGoo on metal would be better than in the VM arena, but, for all intents and purposes, instead of having 3 machines running all day, much nicer to have one machine running, hosting 3 operating systems.  1/3 of the electricity bill.

13

How To's / Re: Accessing opengoo locally and remotely

« on: December 13, 2008, 02:32:03 pm »

What I did was install a VPN server, open up ports on my router to point the server.  This allowed any Win2K/XP/Vista/Linux machine I may be using to connect to my home machine so that I may use OpenGoo.  This creates a big extra layer of security so that OpenGoo just isn't flapping out on the internet.

If you're not all that interested in setting up a VPN server as I did, another alternative would be using a service called Hamachi.  You can find it at http://www.logmein.com.  Its free for private use.

In both cases, you have to configure OpenGoo to either use the servers static IP, or Hamachis IP.

If theres enough interest, I may be convinced to come up with a walk through on setting up either Hamachi or a VPN server.

14

How To's / Re: Google Calendar

« on: December 13, 2008, 01:33:43 pm »

I personally don't really like how OpenGoo has its calendar event creation mechanism, as its not `quick enough` for me to replicate like Sunbird/Thunderbird[with addons].  That said, however, the wife and I use OpenGoos calendar now instead of Google Calendar as she's had issues with it.  I very much do look forward to having the ability to get Sunbird/Thunderbird[with addons] to sync up with OpenGoo so I can use one of these clients to update the calendar at home without too much trouble. :]

15

Feature requests / Re: Issue tracker for OpenGoo development

« on: December 12, 2008, 10:58:37 am »

I don't think it'd be a good idea to use OpenGoo as an issue tracker for two reasons.

First, this is supposed to be a PIM tool, not a development tool.  I have no desire to have a tracking system in my office suite.

Second, I have my OpenGoo hidden behind a firewall which requires VPN connectivity to get to it.  No way I'm going to allow that particular system to go outside the LAN to grab content from a foreign sight, trusted or not (And its not meant to sound that I don't trust OpenGoo Devs or their site.  Personal information is stored on that machine)

Going with an external Tracker or Source Control service like Source Forge or even home-brews would probably be the better idea.