Month: February 2011

mysql error while executing propel:insert-sql in symfony 1.4

[propel-sql-exec] SQLSTATE[42000]: Syntax error or access violation: 106 you have an error in your SQL syntax; check the manual that corresponds to you
server version for the right syntax to use near ‘Type=InnoDB’ at line 16
>> propel Running “insert-sql” phing task
[propel-sql-exec] Failed to execute:

CREATE TABLE `tblName`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`description` TEXT,
`image` VARCHAR(255),
`created_at` DATETIME,
PRIMARY KEY (`id`),
)Type=InnoDB

[propel-sql-exec] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Type=InnoDB’ at line 16

Some problems occurred when executing the task:
If the exception message is not clear enough, read the output of the task for more information
>> file- D:/xampp/htdocs/s…1_4/config/generated-schema.xml

The solution to this is
Edit the file D:/xampp/htdocs/symfony_1_4/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/classes/propel/engine/builder/sql/mysql/MysqlDDLBuilder.php
Line 156, change
$script .= “Type=$mysqlTableType”;
to
$script .= “Engine=$mysqlTableType”;

London shop to make breast milk ice cream

Women breast milk ice-cream
LONDON (Reuters Life!) – A specialist ice cream parlour plans to serve up breast milk ice cream and says people should think of it as an organic, free-range treat.

The breast milk concoction, called the “Baby Gaga”, will be available from Friday at the Icecreamists restaurant in London’s Covent Garden.

Icecreamists founder Matt O’Connor was confident his take on the “miracle of motherhood” and priced at a hefty 14 pounds ($23) a serving will go down a treat with the paying public.

The breast milk was provided by mothers who answered an advertisement on online mothers’ forum Mumsnet.

Victoria Hiley, 35, from London was one of 15 women who donated milk to the restaurant after seeing the advert.

Hiley works with women who have problems breast-feeding their babies. She said she believes that if adults realised how tasty breast milk actually is, then new mothers would be more willing to breast-feed their own newborns.

“What could be more natural than fresh, free-range mother’s milk in an ice cream? And for me it’s a recession beater too — what’s the harm in using my assets for a bit of extra cash,” Hiley said in a statement.

“I tried the product for the first time today — it’s very nice, it really melts in the mouth.”

The Baby Gaga recipe blends breast milk with Madagascan vanilla pods and lemon zest, which is then churned into ice cream.

O’Connor said the Baby Gaga was just one of a dozen radical new flavours at the shop.

“Some people will hear about it and go, ‘yuck’ but actually it’s pure, organic, free-range and totally natural,” he said. “I had a Baby Gaga just this morning and I feel great.”

(Reporting by Paul Casciato; Editing by Steve Addison)

How to check if requested url exits or not

$requestedUrl = “http://www.example.com/abc.php”;
$tags = get_headers($requestedUrl);
if(preg_match(“/Not Found/i”,$tags[0]) || preg_match(“/Service Unavailable/i”,$tags[0]))
{
echo “Requested Url does not exists”;
}
else
{
echo “Requested Url exists”;
}