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.


Messages - Mist. GraphX

Pages: [1] 2
1
How To's / Task and billing reports
« on: April 03, 2012, 05:11:40 am »
Hi,

As a freelancer i use the task panel and billing function to estimate quickly a project cost.
For doing this i've create multiple users and associated billings / hours cost .
exemple : graphic designer, project management, developper ...

It's ok when i use the General timeslots panel , i can generate a report, with multiples users times and billings informations.

But for my convenience i'll be better to do the same with the Milestone and task with the estimated times and associated fake users.
it seems that even an administrator/manager can't add different timeslot for users, or generate reports with estimated times and billing informations

Is it possible to do this ?

thanks for your answers

2
Hi,

 i've just try the latest release of Fo 2.0.0 and i've the same sql error message.

with the modifications mentionned above the problem is solved.

thx

3
Français / Re: Official translation to French
« on: August 26, 2011, 05:35:56 am »
A chaque mise à jour de fengoffice c'est la même !! le fichier fr n'est pas du tout organisé comme le modèle anglais ce qui ne facilite pas la comparaison.

Il serait pas mal de structurer un peut tout ça et de garder une cohérence.

Qui s'occupe de la traduction fr ?
Y'a til moyen d'aider ou de contribuer plutôt que chacun fasse ses petites corrections à chaque mise à jour ???

4
Components / Re: Excel / PDF documents
« on: February 22, 2011, 06:20:34 pm »
not yet ;-) but maybe it's better to ask or post in the GoogleCode project GelSheet about this issue. This tiket  is already open ...

5
Components / Re: Excel / PDF documents
« on: February 22, 2011, 03:18:04 am »
You can also have look too gelSheet , witch is a excel like integrated in FengOffice (search on google code)

it' s already integrated in fengOffice but in my last test saving sheets was impossible. Test it and see : maybe a new version is on the road mab correcting this issue

6
thx ;) i add the missing field 'sync' too. Mail seems to work well now, i've clean the database mail_content and create a new account for ...

The innoDB engine is quite slow on my server, it's a Synology NAS DS209 thats why i first choose the MylSAMM engine.

i've just a problem with search form , i've no result think the table searchable_object is corrupt whith all the manipulations i've done :)


7
:) if it could help !

i've forgot something : first i've copy all the instalation of FO on my computer, :) more sure and quick than working on the web server ...

8
How To's / Re: Some questions about a future release and actual bugs
« on: October 29, 2010, 12:09:18 pm »
ok thanks for all your answers !!! Community spirit is really impressive here ;-)
So i answer to me : A new fresh instal of FO works well , but the update failed !!! Why ..

i've solved my problems and my instalation of feng office works well ;-) so if someone is interested : i CONTRIBUTE by giving the way and my conclusions

The update of the tables is corrupted when you make a comparaison between shema there is no update or a bug in the SQL update shema

1/ the first time i install FO i've choose MylSAAM engine (maybe the basic bug source is here) ... new tables are created in innodb even if it's specified in config file MylSAAM :/ first update bug. for example in my installation the og_administration_logs was in innodb engine and the other tables where in MylSAAM

so i've convert the engine of all my tables :
How ? Command lines in a  shell :
mysqldump -hHOST -uUSER -pPASS DataBase > file.sql

convert MylSAAM > InnoDB
sed -i .new 's/ENGINE=MylSAM/ENGINE=InnoDB/g' /path/to/fengoffice.sql

quick and sure ;-) don't try with phpMyAdmin or a text editor i've lost time by trying this with a 13M database , command line take 3 seconds to do the job

2/ The mail tables are not updated and fields are not present in the instalation :
og_user_account  table : missing fields
last_error_date
last_error_msg
sync_addr varchar
sync_pass
sync_server
sync_ssl
sync_ssl_port
sync_folder

i've made a SQL update of this table manualy in phpMyAdmin :

DROP TABLE IF EXISTS `og_mail_accounts`;
CREATE TABLE `og_mail_accounts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(100) collate utf8_unicode_ci default '',
  `email_addr` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(40) collate utf8_unicode_ci default '',
  `server` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `is_imap` int(1) NOT NULL default '0',
  `incoming_ssl` int(1) NOT NULL default '0',
  `incoming_ssl_port` int(11) default '995',
  `smtp_server` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `smtp_use_auth` int(10) unsigned NOT NULL default '0',
  `smtp_username` varchar(100) collate utf8_unicode_ci default NULL,
  `smtp_password` varchar(100) collate utf8_unicode_ci default NULL,
  `smtp_port` int(10) unsigned NOT NULL default '25',
  `del_from_server` int(11) NOT NULL default '0',
  `outgoing_transport_type` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `last_checked` datetime NOT NULL default '0000-00-00 00:00:00',
  `is_default` tinyint(1) NOT NULL default '0',
  `signature` text collate utf8_unicode_ci NOT NULL,
  `workspace` int(10) NOT NULL default '0',
  `sender_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `last_error_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_error_msg` varchar(255) collate utf8_unicode_ci NOT NULL,
  `sync_addr` varchar(100) collate utf8_unicode_ci NOT NULL,
  `sync_pass` varchar(40) collate utf8_unicode_ci NOT NULL,
  `sync_server` varchar(100) collate utf8_unicode_ci NOT NULL,
  `sync_ssl` tinyint(1) NOT NULL default '0',
  `sync_ssl_port` int(11) NOT NULL default '993',
  `sync_folder` varchar(100) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

3/ og_searchable_objects is not added when you update from an older version (in my case)
 create this table with this sql command in phpMyAdmin :

--
-- Structure de la table `og_searchable_objects`
--

CREATE TABLE `og_searchable_objects` (
  `rel_object_manager` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `rel_object_id` int(10) unsigned NOT NULL default '0',
  `column_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `content` text collate utf8_unicode_ci NOT NULL,
  `project_id` int(10) unsigned NOT NULL default '0',
  `is_private` tinyint(1) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rel_object_manager`,`rel_object_id`,`column_name`),
  KEY `project_id` (`project_id`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

update the  `og_mail_account_users` : missing field last_error_state


DROP TABLE IF EXISTS `og_mail_account_users`;
CREATE TABLE `og_mail_account_users` (
  `id` int(10) NOT NULL auto_increment,
  `account_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `can_edit` tinyint(1) NOT NULL default '0',
  `is_default` tinyint(1) NOT NULL default '0',
  `signature` text collate utf8_unicode_ci NOT NULL,
  `sender_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `last_error_state` int(1) unsigned NOT NULL default '0' COMMENT '0:no error,1:err unread, 2:err read',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uk_useracc` (`account_id`,`user_id`),
  KEY `ix_account` (`account_id`),
  KEY `ix_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

update the 'og_mail_content' table missing sync field

--
-- Structure de la table `og_mail_contents`
--

DROP TABLE IF EXISTS `og_mail_contents`;
CREATE TABLE `og_mail_contents` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `account_id` int(10) unsigned NOT NULL default '0',
  `uid` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `from` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `from_name` varchar(250) collate utf8_unicode_ci default NULL,
  `sent_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `received_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `subject` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `has_attachments` int(1) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `state` int(1) NOT NULL default '0' COMMENT '0:nothing, 1:sent, 2:draft',
  `is_deleted` int(1) NOT NULL default '0',
  `is_shared` int(1) NOT NULL default '0',
  `is_private` int(1) NOT NULL default '0',
  `created_on` datetime default NULL,
  `created_by_id` int(10) unsigned NOT NULL default '0',
  `trashed_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `trashed_by_id` int(10) unsigned default NULL,
  `imap_folder_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `account_email` varchar(100) collate utf8_unicode_ci default '',
  `content_file_id` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `archived_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `archived_by_id` int(10) unsigned default NULL,
  `message_id` varchar(255) collate utf8_unicode_ci NOT NULL COMMENT 'Message-Id header',
  `in_reply_to_id` varchar(255) collate utf8_unicode_ci NOT NULL COMMENT 'Message-Id header of the previous email in the conversation',
  `conversation_id` int(10) unsigned NOT NULL default '0',
  `sync` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`),
  KEY `sent_date` (`sent_date`),
  KEY `received_date` (`received_date`),
  KEY `uid` (`uid`),
  KEY `conversation_id` (`conversation_id`),
  KEY `message_id` (`message_id`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


Thats all folks ;-) it works fine for me , i've all my e-mails, i can modify my account, all bugs have desapeared ;-)

sorry if my english is not really good, hope it could help someone
i can writte this in french for helping french users if necessary

@supaDoctor : is it a contribution ??? :)





9
How To's / Re: Some questions about a future release and actual bugs
« on: October 28, 2010, 11:09:17 am »
Totaly agree with your answer, and know exactly what using an free product is : thats why i prefer to use an existing project and contribute by bugs return, or something else (promote, helping users by teaching them,posting answers in forum's when i can), than creating forks or changing the software i use without discusions :)
In my opinion free software exist with the community of users just because if no one use it or need it... it don't have to exist even if it's free.

Anyway, i wrote this post first to know if my feng office install is corrupt or if someone have the same problems  before trying to make a new install and importing old corrupts data ... that's all (money can do something for that ????)

thank for your answer

10
How To's / [SOLVED] Some questions about a future release and actual bugs
« on: October 28, 2010, 06:47:35 am »
hi,

i use FengOffice for my work everyDay and i want to say first that it's really a great app so thanks for developping it !!

Since the 1.7.1 and after 1.72 release i've experience some bugs in my instalation of FO : new tabs created at launch with error message, no more e-mails or account witch appeared , imposible to create new task in the task tab, and today i've discover that it's impossible for me to modify a contact... i've post  bugs report  but i'would like to know if i'm the only one with these problems, or when a new version correcting these bugs 'll comming.

i'm really sorry to  insist , but it's begin to be annoying for my work and just want to know if a fresh new install could resolved my problems...

thx for your answers

11
Français / Re: messages d'erreur au lancement de feng office 1.72
« on: October 18, 2010, 04:25:01 am »
Essaye une autre version que la 1.7.2 ...ou 1.7.1 tu aura peut être plus de chance ... je n'ai eut que des problèmes depuis ces maj ///

12
Français / Re: Nouveau problème de mise à jour...
« on: October 18, 2010, 04:13:58 am »
Oui, ben a ta place je resterais sur une version stable et éviterais de passer en 1.7.2 pour le moment : elle est pleine de bug cette version et perso je conseille de ne pas faire la maj 1.7.1 et 1.7.2 !!!! mieux vaut rester en 1.7 RC 3 au max ... y'a des bugs mais au moins c'est fonctionnel au niveau du mail ...

Je n'ai que des problèmes depuis, après tu ne peut pas revenir en arrière : sauf si tu as backuppé tes base et en admettant que tu n'est pas travaillé avec la nouvelle mise a jour (ce qui est difficille pour tester une maj ;-) ....)

13
Français / Re: messages d'erreur au lancement de feng office 1.72
« on: October 11, 2010, 05:40:29 am »
1 -> Quel est l'hébergeur
2-> As tu regardé la config de php de ton hébergeur : dès fois il faut a la racine du site mettre un fichier htaccess ou tu indique la version de php a utiliser php4 par défaut et php5 via .htaccess
3-> As tu vérifié les droits CHMOD de tes dossiers après les avoir envoyés en FTP, et aussi le droit maximum autorisé par ton hébergeur (par exemple chez ovh : 755)


14
Français / Re: Modification de l'éditeur CKeditor
« on: October 03, 2010, 07:20:44 am »
Effectivement, ç'est super pratique de modifier la config dan chaque page ou l'éditeur est utilisé !!

j'ai tenté dans les documents, j'arrive a désactiver le plugin ScaiT (déjà ça ralentit moin le chargement des pages) , par contre impossible d'avoir l'accès au clic droit en rajoutant : browserContextMenuOnCtrl
c'est la seule option que je n'arrive pas a activer :/ sinon les changement de thème et autres options se surcharge bien ...

une idée ??? :/

15
How To's / task and subtask are not shown in time module
« on: July 28, 2010, 07:45:41 am »
hi,

I use feng Office 1.7 RC3 and can't show active task in the time managment module and even in the reports ...

i work with subtask, Task are reserved for project, subtask for modifications or bugs, context for my customers. Is there any problem or bug related to subtask and time management module ???

thx for your answers.

Pages: [1] 2