Messages

1

Installation problems / Re: Fatal Error: escapeValue() close() DB.class.php line 294 75

« on: August 04, 2011, 09:35:17 pm »

Never mind!

I deleted all of the old files off of the server and re-uploaded the new files and now all is well.

This seems to solve a lot of issues and I keep forgetting to do this, rather than simply  overwriting the files.

2

Installation problems / Re: Fatal Error: escapeValue() close() DB.class.php line 294 75

« on: August 04, 2011, 09:08:29 pm »

I am receiving this same error. I upgraded from 1.7.3 to 1.7.5

The upgrade went 'perfect' with no errors, however, when i clicked the link to go back to Feng Office I get the error
top of page: Error (DBAdapterDnx)
Database adapter 'mysql' (class 'MysqlDBAdapter') was not found
.
.
.
Fatal error: Call to a member function close() on a non-object in /home/xxxx/public_html/xxxx/xxx/environment/library/database/DB.class.php on line 75

I looked in my log.php and see this:

Code: [Select]

Session "default" started at 2011-08-04T22:58:42+0000

#1 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:1: parser error : Space required after the Public Identifier in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#2 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;!DOCTYPE HTML PUBLIC &quot;-//IETF//DTD HTML 2.0//EN&quot;&gt; in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#3 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:                                                  ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#4 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:1: parser error : SystemLiteral &quot; or ' expected in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#5 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;!DOCTYPE HTML PUBLIC &quot;-//IETF//DTD HTML 2.0//EN&quot;&gt; in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#6 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:                                                  ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#7 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:1: parser error : SYSTEM or PUBLIC, the URI is missing in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#8 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;!DOCTYPE HTML PUBLIC &quot;-//IETF//DTD HTML 2.0//EN&quot;&gt; in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#9 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:                                                  ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#10 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:9: parser error : Opening and ending tag mismatch: hr line 7 and body in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#11 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;/body&gt;&lt;/html&gt; in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#12 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:        ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#13 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:9: parser error : Opening and ending tag mismatch: body line 4 and html in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#14 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: &lt;/body&gt;&lt;/html&gt; in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#15 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:               ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#16 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: http://www.fengoffice.com/versions.xml:10: parser error : Premature end of data in tag html line 2 in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#17 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]:  in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

#18 ERROR: Error: simplexml_load_file() [<a href='function.simplexml-load-file'>function.simplexml-load-file</a>]: ^ in '/home/xxxx/public_html/xxxx/xxxx/application/models/versons_feed/VersionsFeed.class.php' on line 114 (error code: 2)

Time since start: 0.440099000931 seconds

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



3

New Community Members / Re: Hello from New Mexico

« on: January 25, 2010, 06:44:01 pm »

Hello from another user in New Mexico!

I have over 40 or so workspaces, about 6 users.

I am not using tags or documents, but I have a ton of notes and tasks.

4

Installation problems / Re: Upgrade from 1.4.2 to 1.5.0 - not working at all - Table 'og_template_parameters

« on: October 01, 2009, 01:04:41 pm »

I just wish I could understand what causes the glitches. In my case, the original files are not changed and I completely replace them on the server. I think something with the database goes wacky. 

I have a second installation on my server that has no data at all; I have managed to upgrade it with absolutely no problems 1.4.2 --> 1.5.1, just have not had time to go further.

So again, I am thinking there must be some type of corruption in the database --- but at what point?

5

Installation problems / Re: Purpose of OpenGoo?

« on: October 01, 2009, 12:52:17 pm »

@darkhelmet The automatic upgrade had not worked for me because my host does not have the php  zip function activated.

@Pet so exactly how does that work, getting the support from Feng folks on your OpenGoo? I could go with that ..... thank you.

I really do love my OpenGoo and am quite attached to it .... lol.

6

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.

7

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.

8

Installation problems / Re: Upgrade from 1.4.2 to 1.5.0 - not working at all - Table 'og_template_parameters

« on: September 30, 2009, 04:08:16 pm »

I am having this same problem and yes I have tried going straight to 1.5.3. That was a disaster.

9

Installation problems / Re: fresh installation 1.4.2 - database

« on: September 28, 2009, 07:31:26 pm »

yeah me too

10

Installation problems / Re: fresh installation 1.4.2 - database

« on: September 28, 2009, 06:31:41 pm »

i managed to get my installation to work by just deleting everything again and started over.

11

Feature requests / Re: do away with zip

« on: September 28, 2009, 06:25:04 pm »

i completely agree. I cannot get the automatic upgrade to work and pretty much have not been able to since one of my earlier installations.

12

Installation problems / Re: fresh installation 1.4.2 - database

« on: September 26, 2009, 06:48:03 pm »

So, I emptied out the database, deleted the config file that had been created and ran the install script again. No problems. I got to the final step to finish by creating an admin login and got this error:

Code: [Select]

Complete the installation

Query failed with message 'Unknown column
'updated_by_id' in 'field list''

This is the final step of the installation process that
will let you create administrator account and provide
brief info about your company

13

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?

14

Older versions / Re: Error upgrading to version 1.5.3

« on: September 25, 2009, 05:47:27 pm »

yes, I have a backup of everything. thank you.

15

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?