Historique de la page
...
Bloc de code |
---|
<Connector port="8080" maxHttpHeaderSize="8192" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" redirectPort="8443" acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" emptySessionPath="true" /> |
...
Astuce |
---|
...
|
...
|
...
If your Tomcat is behind an frontal server (like Apache), don't forget to set the parameter on the corresponding connector (here with mod_jk/AJPv13):
| ||
Statistics charts do not appear (InternalError)
At first check that the emptySessionPath parameter is correctly set as shown above.
If you get the following error (Unix platforms only):
Bloc de code |
---|
InternalError: Can't connect to X11 window server using 'xxx' as the value of the DISPLAY variable
|
You have to unset the DISPLAY environment variable before launching the application, as shown on the helpdesk.sh script (cf 03 Administration ):
Bloc de code |
---|
unset DISPLAY
|
Statistics charts do not appear (NoClassDefFoundError)
If you get the following error:
Bloc de code |
---|
java.lang.NoClassDefFoundError
|
It is probably an X11 issue (the AWT library tries to use an unexistant X11 server to generate images). Add the following option when launching the application:
Bloc de code |
---|
java -Djava.awt.headless=true ...
|
See:
- http://www.jfree.org/jfreechart/faq.html#FAQ10
- http://java.sun.com/products/java-media/2D/reference/faqs/index.html#Q_I_have_an_application_that_rea
- http://www.jfree.org/phpBB2/viewtopic.php?t=1012
There are unused things in the database
Description: upgrading the database structures with Hibernate creates new tables and fields but does not remove obsolete structures. Depending on the version you started with, there may effectively be unused tables and fields.
Solution: Obsolete fields and tables can be removed manually using the following SQL statements:
Bloc de code |
---|
ALTER TABLE h_acti DROP FOREIGN KEY FKB6E0538EF9CD6EB0;
ALTER TABLE h_acti DROP KEY FKB6E0538EF9CD6EB0;
ALTER TABLE `h_acti`
DROP `faq_conn_afte_id`;
ALTER TABLE `h_cate`
DROP `new_tick_assi_cust_clas`,
DROP `dele`,
DROP `use_defa_tick_temp`;
ALTER TABLE h_depa DROP FOREIGN KEY FKB6E1B7A912177440;
ALTER TABLE h_depa DROP KEY FKB6E1B7A912177440;
ALTER TABLE `h_depa`
DROP `algo_stat`,
DROP `auto_expi`,
DROP `comp_url_cust_clas`,
DROP `new_tick_prop_cust_clas`,
DROP `tick_moni_cust_clas`,
DROP `defa_new_tick_assi_cust_clas`,
DROP `real_cate_id`,
DROP `use_defa_tick_temp`;
ALTER TABLE `h_depa_mana`
DROP `tick_moni_crea_all`,
DROP `tick_moni_crea_mana`,
DROP `tick_moni_crea_cate_memb`,
DROP `tick_moni_crea_free`,
DROP `tick_moni_crea_orph`,
DROP `tick_moni_clos_all`,
DROP `tick_moni_clos_mana`,
DROP `tick_moni_clos_cate_memb`,
DROP `tick_moni_clos_free`,
DROP `tick_moni_clos_orph`,
DROP `tick_moni_othe_all`,
DROP `tick_moni_othe_mana`,
DROP `tick_moni_othe_cate_memb`,
DROP `tick_moni_othe_free`,
DROP `tick_moni_othe_orph`;
ALTER TABLE `h_stat`
DROP `tick_crea_stat_last_time`,
DROP `user_tick_crea_stat_last_time`;
ALTER TABLE `h_tick`
DROP `owne_disp_name`,
DROP `depa_labe`,
DROP `cate_labe`;
ALTER TABLE `h_user`
DROP `pers_tick_moni`,
DROP `invo_tick_moni`,
DROP `lang_id`,
DROP `html_emai_form`,
DROP `text_emai_form`,
DROP `show_new_tick_welc`,
DROP `embo_chan_tick`,
DROP `depa_filt_set`,
DROP `cont_pane_refr_time`,
DROP `cont_pane_stat_filt`,
DROP `cont_pane_invo_filt`,
DROP `sear_page_size`,
DROP `jour_refr_time`,
DROP `jour_date_filt`,
DROP `text_widt`,
DROP `text_heig`,
DROP `last_visi`,
DROP `show_popu_on_tick_clos`,
DROP `cont_pane_orde_by`,
DROP `star_on_cont_pane`;
ALTER TABLE `h_vers_mana`
DROP `inde_upda`;
DROP TABLE `h_faq_dele`;
TRUNCATE TABLE `h_faq_entr`;
TRUNCATE TABLE `h_faq_part`;
TRUNCATE TABLE `h_file`;
TRUNCATE TABLE `h_tick_temp`;
DROP TABLE `h_day_user_tick_crea_stat`;
DROP TABLE `h_hour_tick_crea_stat`;
|
Astuce |
---|
With MySql, the name of the foreign keys is shown with SHOW CREATE TABLE h_acti; (resp. h_depa); once known, the foreign keys can be dropped with ALTER TABLE h_acti DROP FOREIGN KEY FKB6E0538EF9CD6EB0; (resp. h_depa et FKB6E1B7A961B67C78), cf http://lists.mysql.com/mysql/204151). |
Astuce |
---|
In portlet deployment, the menu entries appear as ugly buttons
...