net-admin.fr

ERROR 144 (HY000) at line 1: Table ‘./centstorage/log’ is marked as crashed and last (automatic?) repair failed

Posted on by

How to repair a MySQL table of type MyISAM that could not be repaired.

* First STOP MYSQL

* cd into the data folder of your database where the table is crashed, by default :

cd /var/lib/mysql/NameOfDatabase

For me :

cd /var/lib/mysql/centstorage

* Run the myisamchk on the table

myisamchk -r NameOfTableCrashed

* If that does not work run :

myisamchk -r -v -f NameOfTableCrashed

For me (note the -t option which permits to specify where to use the temp folder, because this can take a lot of space. :

myisamchk -r log -t=/data/tmp/

POI – How to change rotation for only some of column titles ?

Posted on by

Baseline

We wish to edit a xls file with 5 colum titles but we want the two last columns with a different rotation.
2013-02-28_103015

... 
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
HSSFRow row = null;
HSSFCell cellTitre = null;	
        
//Style cell
HSSFCellStyle style = workbook.createCellStyle();

//data for titles

String [][] excelData = new String [0][5]
excelData[0][0]="Title1";
excelData[0][1]="Title2";	   
excelData[0][2]="Title3";
excelData[0][3]="Title4";
excelData[0][4]="Title5";

...

//Insert titles
for (int rowNum = 0; rowNum < excelData.length; rowNum++){ //just one row  
	 row = sheet.createRow(rowNum);
       	 for (int cellNum = 0; cellNum < excelData[0].length ; cellNum++){
	        cellTitre = row.createCell((short) cellNum);
	        if(cellNum==3 || cellNum==4){
		      styleTitre.setRotation((short)-90);
	        }
	        cellTitre.setCellStyle(styleTitre);
	        cellTitre.setCellValue(new HSSFRichTextString( excelData[rowNum][cellNum]));
         }
}
...

Problem

That sets rotation for all titles !

Error

2013-02-28_102822

Solution

Create two differents HSSFCellStyle.
Remark : don’t do as below ! 

//Style cell
HSSFCellStyle style = workbook.createCellStyle();
...
HSSFCellStyle style2 = workbook.createCellStyle();
style2=style; //Error - two pointers for the same object 
style2.setRotation((short)-90);
...

In java "style2=style;" means you add a new name to call the same object with same parameters.

... 
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
HSSFRow row = null;
HSSFCell cellTitre = null;	
        
//Style cell
HSSFCellStyle style = workbook.createCellStyle();
...//add font into style etc...
style.setRotation((short)0); 

//Style2 cell
HSSFCellStyle style2 = workbook.createCellStyle();
...//add font into style etc... even if it's same as the first style
style.setRotation((short)-90); 

//data for titles

String [][] excelData = new String [0][5]
excelData[0][0]="Title1";
excelData[0][1]="Title2";	   
excelData[0][2]="Title3";
excelData[0][3]="Title4";
excelData[0][4]="Title5";

...

//Insert titles
for (int rowNum = 0; rowNum < excelData.length; rowNum++){ //just one row  
	 row = sheet.createRow(rowNum);
       	 for (int cellNum = 0; cellNum < excelData[0].length ; cellNum++){
	        cellTitre = row.createCell((short) cellNum);
	        if(cellNum==3 || cellNum==4){
		       cellTitre.setCellStyle(styleTitre2);
	        }
                else cellTitre.setCellStyle(styleTitre);
	        cellTitre.setCellValue(new HSSFRichTextString( excelData[rowNum][cellNum]));
         }
}
...

JSF & RichFaces – how to display Rich:toolTip for a disabled h:commandButton ?

Posted on by

Baseline

We want to display information overview of a h:commandButton. This information is different if the button is disabled or not.

Problem

If the h:commandButton is disabled, the rich:toolTip doesn’t appear.

 
<h:commandButton id="myButton" value="Action" action="#{myBean.myFunction()}" disabled="#{myBean.myVariable}" >
	<rich:toolTip for="myButton" followMouse="true" styleClass="tooltip" showDelay="300" > 
	         <h:outputText value="my message if the button is not disabled" rendered="#{myBean.myVariable==false}"/>
                 <h:outputText value="my message if the button is not disabled" rendered="#{myBean.myVariable==true}"/>
	</rich:toolTip>
</h:commandButton>

Solution

 
<a4j:outputPanel>
	<h:panelGrid columns="1">
		<h:commandButton id="myButton" onmouseover="#{rich:component('infoBtn')}.show()" onmouseout="#{rich:component('infoBtn')}.hide()" value="Action" disabled="#{myBean.myVariable}" action="#{myBean.myFunction()}" />
	</h:panelGrid>
	<rich:toolTip id="infoBtn" >
		<h:outputText value="my message if the button is not disabled" rendered="#{myBean.myVariable==false}"/>
												<h:outputText value="my message if the button is not disabled" rendered="#{myBean.myVariable==true}"/>
	</rich:toolTip>
</a4j:outputPanel>

iText 5 – just display checkbox with label in a PDF

Posted on by

Baseline

Using iText 5,we wanted to display a list of labels with checkboxs just for printing a pdf.

Solution

Using unicode caharacters to display white squares is a easy solution if it’s just to print.
We need to implement this special character thanks the font and just write the unicode in the string. 

...
Font fontArial = FontFactory.getFont("Arial",BaseFont.IDENTITY_H); //IDENTITY_H to implement specials characters
Paragraph myParagraph= new Paragraph("\u25A1 choice 1\n\n\u25A1 Choice 2\n\n",fontArial);
document.add(myParagraph);
...

No space left on device – Linux disk space used

Posted on by

No space left on device

In order to know how much space you have on a Linux machine, run the following command :

df -h

This will show you the space available and used for every mounted partition

Another command can be usefull, indeed sometimes you found that you have some space left but in fact your inode tables could be full even more on an ext-3 filesystem, so run the following to check :

df -i

Seam – <action execute="…"> in Pages.xml run with JSF Ajax component

Posted on by

Baseline

 
...
<h:panelGrid id="panelMyButton">
      <a4j:commandButton value="myButton" action="#{myBean.execute()}" reRender="panelMyButton" ajaxSingle="true" />
</h:panelGrid>
...

@Name("myBean")
@Scope(ScopeType.SESSION)
@Synchronized(timeout=99999999)
public class EditReclamationAction implements Serializable{   
    ...
    public void init(){
       ...
    }
    public void execute(){

    }
    ...
}

<page view-id="myView.xhtml">
    ...
    <action execute="#{myBean.init()}" />
</page>

Problem

Even if the action in <a4j:commandButton> is in ajax, the tag in pages.xml run the function init(). That’s how work in Seam.

Solution

Change the way to execute function and the scope type of the bean.

  • In the bean, modify @Scope(ScopeType.SESSION) by @Scope(ScopeType.PAGE) to let possibility to initialize for each page loading
  • In the bean, add “@Create” upper init(), that means for Seam run this function for each page loading
  • Delete the tag <action> in pages.xml

like this :

 
...
<h:panelGrid id="panelMyButton">
      <a4j:commandButton value="myButton" action="#{myBean.execute()}" reRender="panelMyButton" ajaxSingle="true" />
</h:panelGrid>
...

@Name("myBean")
@Scope(ScopeType.PAGE)
@Synchronized(timeout=99999999)
public class EditReclamationAction implements Serializable{   
    ...
    @Create
    public void init(){
       ...
    }
    public void execute(){

    }
    ...
}

<page view-id="myView.xhtml">
    ...

</page>

SQL – How to select all fields from only one table in a query with joins ?

Posted on by

Baseline

To get all fields from a table in a query with one or several joins. We wish avoid to write all name of fields from one table if the list of fields is really long.

Probleme

The following queries select all fields in all tables using “where” or “inner join”.

SELECT * 
FROM table1, table2
WHERE table1.id=table2.table2_id
{AND ...others conditions}

SELECT * 
FROM table1
INNER JOIN table2 ON table1.id=table2.table2_id
{AND ...others conditions}

the following queries don’t work (tested on postgreSQL).

SELECT table1.* 
FROM table1, table2
WHERE table1.id=table2.table2_id
{AND ...others conditions}

SELECT table1.* 
FROM table1
INNER JOIN table2 ON table1.id=table2.table2_id
{AND ...others conditions}

Error

ERROR: invalid reference to an entry in the FROM clause for table "table1"
SQL state: 42P01

Solution

Using alias is the solution.

SELECT t1.* 
FROM table1 t1, table2 t2
WHERE t1.id=t2.table2_id
{AND ...others conditions}

SELECT t1.* 
FROM table1 t1
INNER JOIN table2 AS t2 ON t1.id=t2.table2_id
{and ...others conditions}
CyberChimps