Recent Posts

Pages: [1] 2 3 ... 10
1
Installation problems / Re: Problem avter migrating from 3.4.0.17 to 3.4.1
« Last post by nadir.latif on July 19, 2018, 08:12:12 AM »
We tried to upgrade Feng Office from version 2.3 to version 3.5.1.5. We followed this migration guide: http://www.fengoffice.com/web/wiki/doku.php/installation:migration.

When running the migration command: php public/upgrade/console.php it gave the error: Error: Failed to execute DB schema transformations. MySQL said: Specified key was too long; max key length is 1000 bytes

The problem was that the table schema for the tables: fo_contacts and fo_members had too many indexes. As a result the index size of table rows became too large. The sql queries for setting the column size were failing during migration. The solution was to edit the migration script and lower the column size. We had to change the following queries:

```
ALTER TABLE  `fo_contacts` MODIFY `surname` varchar(255) COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '';
ALTER TABLE `fo_members` CHANGE `name` `name` varchar(511) COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '';
```
to

```
ALTER TABLE  `fo_contacts` MODIFY `surname` varchar(75) COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '';
ALTER TABLE `fo_members` CHANGE `name` `name` varchar(100) COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '';
```

The changes had to made to the file: BauruUpgradeScript.class.php in public/upgrade/scripts folder. After making the changes we got the following error:

Error: Failed to execute DB schema transformations. MySQL said: Subquery returns more than 1 row

The problem was that the migration script had added duplicate data. We had to remove this duplicate data. After that migration script worked without problems.

To find the sql queries that were causing the problem, we had to first location the migration script that was relevant for our version of Feng Office. The migration script basically adds several sql queries to a variable. The queries are all executed together. To find out the sql queries that were being run we printed out the value of this variable and then ran the sql queries one by one from PhpMyAdmin. This allows us to find out which sql queries were failing.

Here is the final output:

root@ExergoDevelopment:/mnt/public_html/ccs1# php public/upgrade/console.php 
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.
2018-07-19 10:39:24 - Starting upgrade to 3.4.4.52
Database schema transformations executed (total queries: 35)
Updating users timezone settings...
Feng Office has been upgraded. You are now running Feng Office 3.4.4.52 Enjoy!
2018-07-19 10:44:04 - Finished upgrade to 3.4.4.52
2018-07-19 10:44:04 - Starting upgrade to 3.5.1.5
Database schema transformations executed (total queries: 15)
Feng Office has been upgraded. You are now running Feng Office 3.5.1.5 Enjoy!
2018-07-19 10:44:05 - Finished upgrade to 3.5.1.5
2018-07-19 10:44:05 - Updating plugins...
2018-07-19 10:48:26 - Finished plugins update.
2
Same issue here! Anybody?
3
Getting Started / Re: php 7.0
« Last post by ghostwriter on July 05, 2018, 10:27:40 AM »
Hi

Is this still an issue? I have an Ubuntu Server 16.04 LTS with mysqld and the default php 7.0x.
What do I need to change to be able to use Feng Office?

I tried it but got the error noticed above about the missing extension (Error: 'mysql' extension is not loaded)

Regards,
ghostwirter
4
How To's / restore the documents
« Last post by arenskov on July 02, 2018, 12:11:37 PM »
Hi

I am trying to backup and make a restore but I can not restore the documents. Where are they on the server? because I do not seem to have a backup of them. I can see them inside the restore system but get a error when I try to open them up inside the Feng system

Yours sincerely

Jesper
5
Tiếng Việt / Re: Problem Installing OpengGoo 1.1
« Last post by onapthanh on June 20, 2018, 05:38:19 AM »
I think that Make your content shareable via popular platforms, place Social Share Buttons to your content!
6
Tiếng Việt / Re: I have problem when install OpenGoo
« Last post by onapthanh on June 20, 2018, 05:36:37 AM »
OpenGoo is for any size company looking for a solid collaboration suite that can be served up in-house, without breaking the bank. OpenGoo offers all of the features of most any collaboration tool (and then some), so I won't have to try to add on any tools once installation is complete
7
Installation problems / Re: blank page after installation of feng office 1.6.2
« Last post by saorabh on June 17, 2018, 10:23:50 AM »
go to the root folder of the feng office installtion and give the following permission :

chmod -R 777 cache/ config/ tmp/ upload/

:-)
8
Feng Office 3 / feng 3.5-beta failed to update
« Last post by rolf_m on June 05, 2018, 01:38:41 AM »
hello
when updating from feng 3.5-beta to 3.5.1.5 I get the following error message:

Failed to execute DB schema transformations. MySQL said: Duplicate column name 'worked_time'

where do i have to look for the error or even better how can i fix the error?

thank you very much for line leading solution proposals

ran
9
General Discussion / Re: Digest Algorithm with timeout
« Last post by onapthanh on May 31, 2018, 12:04:56 PM »
I think that simply could not depart your website before suggesting that I extremely loved the usual info an individual supply on your visitors? Is going to be again frequently to check up on new posts:
Keep it up the good work. Your article is really looked nice and great because in this way we can learn a lot of things in our life
10
Installation problems / 300 S Biscayne BLVD
« Last post by Lanajakrin on May 29, 2018, 01:14:15 PM »
For a look at your new Met 1 Condominium for sale or rent, visit our site now for more details.

Pages: [1] 2 3 ... 10
anything