Feeds:
Posts
Comments

Archive for November, 2008

Breaking referential integrity in MySql

Posted in InnoDB, My Blog, MySql, PHP, tagged , , , , , , , , on November 20, 2008 | 5 Comments »

Integrity constraint violation: 1452 Cannot add or update a child row: a foreign
key constraint fails (`sumaria_magento/mg_catalog_category_product_index`,
CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY` FOREIGN KEY
(`product_id`) REFERENCES `mg_catalog_product_entity` (`entity_id)
Reason..
The Constraint dont find any Parent keys in parent table. But children for these Product ids are present. That means… database have Children entries without Parent …
Is it possible to break the referential integrity [...]

Read Full Post »

How to Get the Current Page URL

Posted in My Blog, PHP, tagged , , , , , , , on November 18, 2008 | 2 Comments »

Sometimes, you might want to get the current page URL that is shown in the browser URL window. For example if you want to let your visitors submit a blog post to Digg you need to get that same exact URL. Another example maybe a page URL has Querystring info appended to it and you [...]

Read Full Post »

OpenposbravoPOS Build from open source file

Posted in Future Web, Integration, My Blog, MySql, PHP, POS, tagged , , , , , , on November 4, 2008 | 6 Comments »

Few days ago I have discussed Openbravo POS systen intregation with MySql. Today I will discuss How to built OpenbravoPOS after modification logo, image etc.
 
Requirements:

JDK5 or latter ( Download link: http://java.sun.com/javase/downloads/index.jsp/ )
Apache ant 1.6 or latter ( Download link: http://ant.apache.org/bindownload.cgi/ )
Openbravopos source file ( Download link: http://sourceforge.net/project/showfiles.php?group_id=127939/ )

 
Configuration:

First we have to need environment variable [...]

Read Full Post »