Messages

16

Installation problems / Re: Error (DBQueryError) after upgrade 1.0 RC3 -> 1.3.1 -- HELP!

« on: April 06, 2009, 08:37:46 pm »

My original problem stemmed from accidently upgrading from 1.1 to 1.3.1.  I restored my original database and site, and reinstalled, choosing 1.0 to 1.3.1 (no option for 1.0 RC 3).  Similar database issue, but different 'column'.

Still errored out and would not load.  I had to re-restore my original 1.1 RC3 install. 

The error as recorded in the log is:

"Session "default" started at 2009-04-02T04:03:00+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.24878692626953 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-04-02T04:04:16+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.21113705635071 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-04-02T04:04:51+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.10020089149475 seconds
-------------------------------------------------------------------------------
"

17

Installation problems / Error (DBQueryError) after upgrade 1.0 RC3 -> 1.3.1 -- HELP!

« on: March 30, 2009, 12:58:46 am »

Existing install and dB backed up, overwrote appropriate files to update via FTP, ran public/install, no hitches, no errors.  Click 'back to opengoo' and returns following error:

  Error (DBQueryError)
Query failed with message 'Unknown column 'trashed_by_id' in 'where clause''
Error params:
File:    /home/tinwdub4/public_html/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'
Backtrace:
#0 /home/tinwdub4/public_html/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/tinwdub4/public_html/opengoo/environment/library/database/DB.class.php(199): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/tinwdub4/public_html/opengoo/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/tinwdub4/public_html/opengoo/application/models/ProjectDataObjects.class.php(31): DataManager->find(Array)
#4 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(125): ProjectDataObjects->find(Array)
#5 /home/tinwdub4/public_html/opengoo/environment/classes/dataaccess/DataManager.class.php(228): BaseCompanies->find(Array)
#6 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(159): DataManager->findOne(Array)
#7 /home/tinwdub4/public_html/opengoo/application/models/companies/base/BaseCompanies.class.php(161): BaseCompanies->findOne(Array)
#8 /home/tinwdub4/public_html/opengoo/application/models/companies/Companies.class.php(48): BaseCompanies::findOne(Array)
#9 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(62): Companies::getOwnerCompany()
#10 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(45): CompanyWebsite->initCompany()
#11 /home/tinwdub4/public_html/opengoo/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#12 /home/tinwdub4/public_html/opengoo/application/application.php(20): CompanyWebsite::init()
#13 /home/tinwdub4/public_html/opengoo/init.php(135): require_once('/home/tinwdub4/...')
#14 /home/tinwdub4/public_html/opengoo/index.php(9): require('/home/tinwdub4/...')
#15 {main}
Autoglobal varibles:
$_GET:    
$_POST:    
$_COOKIE:    Array (
  ['logintheme'] => (string) 'cpanel'
  ['cprelogin'] => (string) 'no'
  ['cpsession'] => (string) 'closed'
  ['rp_user'] => (string) 'bG9naW5faXA9NjkuMTQ4LjI1MC4xNjkmdXNlcl9pZD0xJnVzZXJfbmFtZT1hZG1pbiZkaWdlc3Q9
NnBIdnFtcitrT0plZVBXMWFxKzRqQ1daTkJv
'
  ['PHPSESSID'] => (string) 'cc858cc35dcae355396886fd6751f9e1'
)
$_SESSION:    Array (
  ['cal_version'] => true
  ['month'] => (string) '3'
  ['year'] => (string) '2009'
  ['day'] => (string) '30'
)
Execution time:
Total execution time: 0.028480 seconds


===paste text from log.php===

Session "default" started at 2009-03-30T00:51:56+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 8.2967040538788 seconds
-------------------------------------------------------------------------------

Session "default" started at 2009-03-30T00:53:25+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.21280097961426 seconds
-------------------------------------------------------------------------------
===end paste===

HELP!

18

Feng Office 1 / Re: Calendar - missing ')' error?

« on: November 11, 2008, 06:48:49 pm »

I did not experienced this error in RC3 but after I upgraded to version 1.

It was the calendar and i had to go through the descriptions of every single event before the error stopped happening.

What do you mean by 'go through the descriptions'?  Editing each one, or simply hovering your cursor over each item?

19

Feng Office 1 / Re: Calendar - missing ')' error?

« on: November 11, 2008, 12:22:11 am »

It doesn't seem to be; I had one with a line break, corrected it, and the error persists:

It reads:

ERROR:
missing ) after argument list
        Click to remove

20

Feng Office 1 / Re: Calendar - missing ')' error?

« on: November 09, 2008, 12:48:39 am »

This began occurring after my upgrade to 1.0RC3

21

Feng Office 1 / Re: Calendar - missing ')' error?

« on: November 07, 2008, 11:48:40 pm »

Firefox 3.0.3

Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3

22

Feng Office 1 / Calendar - missing ')' error?

« on: November 07, 2008, 02:54:22 am »

I'm getting an odd error when I view the entire month on the calendar, then browse 'back' to the previous month.

Screenshot and log info included (not sure which to include, so covered several incidents):

Session "default" started at 2008-10-23T16:15:08+0000
#1 ERROR: Error: Undefined variable: pm in '/home/tinwdub4/public_html/opengoo/application/views/event/event.php' on line 110 (error code:
Time since start: 0.150038003922 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-10-23T16:15:29+0000
#1 ERROR: Error: Undefined variable: pm in '/home/tinwdub4/public_html/opengoo/application/views/event/event.php' on line 110 (error code:
Time since start: 0.206872940063 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-10-24T19:37:17+0000
#1 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.opengoo.org/versions.xml:14: parser error : Opening and ending tag mismatch: versions line 2 and version in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#2 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:   &lt;/version&gt; in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#3 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:             ^ in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#4 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.opengoo.org/versions.xml:15: parser error : Extra content at the end of the document in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#5 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;/versions&gt; in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#6 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: ^ in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
Time since start: 1.56552815437 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-10-24T19:38:50+0000
#1 ERROR: Error: Undefined variable: pm in '/home/tinwdub4/public_html/opengoo/application/views/event/event.php' on line 110 (error code:
Time since start: 0.200593948364 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-10-29T21:10:18+0000
#1 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.opengoo.org/versions.xml:14: parser error : Opening and ending tag mismatch: versions line 2 and version in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#2 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:   &lt;/version&gt; in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#3 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:             ^ in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#4 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.opengoo.org/versions.xml:15: parser error : Extra content at the end of the document in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#5 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;/versions&gt; in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#6 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: ^ in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
Time since start: 5.79292201996 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-11-07T05:09:04+0000
#1 ERROR: Error: simplexml_load_file(http://www.opengoo.org/versions.xml) [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: failed to open stream: HTTP request failed! HTTP/1.1 500 Internal Server Error
     in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
#2 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: I/O warning : failed to load external entity &quot;http://www.opengoo.org/versions.xml&quot; in '/home/tinwdub4/public_html/opengoo/application/models/versons_feed/VersionsFeed.class.php' on line 113 (error code: 2)
Time since start: 2.12922596931 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-11-07T05:36:44+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.62706398963928 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-11-07T05:37:33+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.19759702682495 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-11-07T05:45:22+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.20626306533813 seconds
-------------------------------------------------------------------------------

Session "default" started at 2008-11-07T05:45:46+0000
#1 ERROR: Error: Invalid argument supplied for foreach() in '/home/tinwdub4/public_html/opengoo/application/models/comments/Comments.class.php' on line 70 (error code: 2)
Time since start: 0.19612312316895 seconds
-------------------------------------------------------------------------------

23

Feature requests / Re: Switch user

« on: October 20, 2008, 11:15:37 pm »

Also, if users want to give up their privacy to ease administration, that is fine, and up to them. Me, I take my nude pictures more seriously than Paris Hilton does.

lol, I was thinking of more benign items, but you are right.  The admin should at the very most—assuming user privacy is turned on—be able to view the workspace name (and perhaps the permission settings), but not the individual items assigned to those workspaces (nor be able to change the permissions, but viewing them would be helpful from a 'help desk' scenario for walking the user through editing permissions themselves.

At least that's my understanding of your the privacy vs convenience argument.

I guess if there ever was a reason for a so-called 'super-admin' to have complete and unfettered access, it should be in the form of a 'pushbutton permission' whereby the user gives an admin (general or specific) complete permissions for that one session only, and the permission would expire within a predetermined time frame or when the user logs off...

As always, 2¢.

24

How To's / Re: Reporting

« on: October 20, 2008, 10:57:32 pm »

It is looking good so far.  I'll add in some tasks and check that end out.  Is the plan just to spit out raw data for stats/etc., or perhaps use something a little fancier, such as jpgraph?

25

How To's / Re: Reporting

« on: October 20, 2008, 04:56:40 pm »

I've got the 0.9 betasite running, and see the Reports tab, but am unable to see any information (stats, activity, etc.).  Is it still incomplete, or is it more for tasks instead of other items?

26

Feng Office 1 / Re: Forum Bug/Issue

« on: October 20, 2008, 02:20:40 pm »

Any word on this yet?

Every time I visit the forums, I repeatedly get these error messages, along with a similar  'Security' message when I log on:

Database Error: Lost connection to MySQL server during query
File: /home/content/t/h/e/theoserper/html/opengooorg/forums/Sources/Security.php
Line: 272

: Lost connection to MySQL server during query
/home/content/t/h/e/theoserper/html/opengooorg/forums/Sources/Load.php
390

I frequently have to refresh 4-5 times before am able to log in, view posts, reply, or post.

27

Feature requests / Re: Switch user

« on: October 20, 2008, 02:02:31 pm »

As an administrator I can see any information in any workspace anyway... In other words: There is no privacy for standard users anyway...

That is what worries me! Privacy (confidentiality) should always come first. So we should rather work on fixing that, before we make things easier for administrators.

Right?

I think it could be addressed in such a manner to recognize both privacy and ease-of-use concerns, in that the admin could set permissions up until the actual user disallowed admin override for a particular workspace.  Thus the end user could have control over the privacy issues, and the admin could have ease of use up until the end user decides to take control of their own workspaces (thereby being the 'admin' for their own workspace/data).  The actual admin would then be able to make system wide changes (even removing user or their workspaces) but just not to change what is in those workspaces, or to change the permissions.

The future help file, or sytem messages could walk the end users through the process before they add sensitive material.

28

Feature requests / Re: Switch user

« on: October 18, 2008, 06:35:14 pm »

...Therefore I'd like to have a "Switch user" feature which is available for administrators only and which allows you to see your OpenGoo installation from the perspective of another user without the necessity to log in with this users credentials (which you may not have anyway since users can change their passwords).

I imagine a dropdown in the upper right corner (where your own user name is displayed) which allows you to select any other user immediately. This would help very much to check if a user is able to see what he/she should, but doesn't see what he/she shouldn't.

Ditto.  I've played around with Goo quite a bit, but still have to log in as a 'standard' user to verify permisions are working as I intended.  This would be an awesome feature request.  Perhaps even with the ability to edit global permissions as an admin while in 'filter view' so that changes/corrections can be viewed (or disappear, as the case may be) immediately.

Is this even feasible, given the current roadmap, or would it require too much coding to make it break-even attractive?

29

How To's / Re: Permissions for Contacts? Help!

« on: October 17, 2008, 05:55:16 pm »

Should we copy/move this thread to Feature Requests?

30

How To's / Re: Permissions for Contacts? Help!

« on: October 17, 2008, 02:25:51 pm »

Gotcha.

I guess I was presuming that 'Contacts' were also considered 'Content'.

So in it's current state, Workspaces assigned to a particular Contact only work as far as filtering/drilling down is concerned?

Alternatively (perhaps as an enhancement), I really like the contact window that opens up when the contact is selected.  It would be cool to be able to do something similar with the Weblinks whereby a copy of the link/page could be saved or stored (ala G00gle Notebook) for future reference, with a button/link giving the option to open the 'live' link in a separate tab/window.  That would really tighten up the Weblink usability.

2¢