Clicky

I have a 6.22 drupal installation running in the domain of a web hoster.

I decided to purchase a domain on another hoster and copy the installation over.   The way it has been done is:
1. I installed Drupal 6.22 on the new host. I then uploaded the drupal files (having downloaded them from the old host onto my local computer) to the new host, putting them in a folder called drupal6 in the /public_html folder.      
2. I uploaded a mySQL dump file to the root of the new hosts's domain and the hoisters imported the data into the database for me.

When I try to open the home page of the new drupal site, I get the following errors:

Warning: SESSION variable max_allowed_packet is read-only. Use SET GLOBAL max_allowed_packet to assign the value query: SET SESSION max_allowed_packet = 536870912 in /home/faithmov/public_html/drupal6/includes/database.mysql.inc on line 135

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 725

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 728

Fatal error: Call to undefined function filter_xss() in /home/faithmov/public_html/drupal6/includes/common.inc on line 654

Interestingly, if I change the setting of $db_url to point to my old hosters database, the page opens.

I cannot open any of the pages on the site, How can I solve this?

asked 11/18/2011 10:27

bogorman's gravatar image

bogorman ♦♦


39 Answers:
You have to look at your database script and see how the URLs are formed. I bet they are all wrong, so you have to do a global find and replace for all of the references to URLs. Alternatively, if your old hosting account is still active, Drupal has a module called Backup and Migrate, which makes a portable copy of your database to reinstall your Drupal installation on another host.
link

answered

nanharbison's gravatar image

nanharbison

Thanks, I think I will try Backup and Migrate.  I assume I would have to clear my drupal folder on the new host and then install a "clean" version of drupal on it via cPanel. Then install B and M module on the new host, or do you do it another way?
link

answered 2011-11-19 at 11:44:15

bogorman's gravatar image

bogorman

Hi nanharbison,

Have followed your suggestion re Backup and Migrate and have done a backup of my "old" database to my local machine. This ran without error but I note many statements in the file are like:

INSERT INTO `boost_cache_relationships` VALUES ('ca85568d52ed54e7fa3779e526629c3b','cache/normal/209.200.96.22/acquiadrupal','node'.......

The IP address in the statement is the IP address of my old site. Presumably, I should now delete the tables from my new database first.  I have copied all the drupal files including contributed modules over to the new site. Should I run Backup and Migrate and Restore on the new site?  Not sure whether the module will work with all the tables deleted.

Alternatively, should I use SequelPro (on my MacBook running Lion, or SQLYog from within Parallels on my Mac to import the data from the .sql file created by Backup and Restore?   When I do so, as the old IP address is saved to the file will the relevant data be read from the old database to the new?

If you do suggest importing using SequelPro/SQLYog, should I delete everything from the new site first including all files?

Have tried to find the answer to this but the documentation online seems to be sparse when it comes to migrating with Backup and Migrate.

Brian


link

answered 2011-11-19 at 11:51:51

bogorman's gravatar image

bogorman

Hi Brian,
I am not familiar with SequelPro or SQLYog, or with Apple computers. I am a PC person.
I am surprised to see that the IP address of your old site is still in the database using Backup and Migrate, I don't get that.
But anyway, you should delete all of the tables in the new site first. And then can you use notepad, or maybe one of these SQL programs to do a search and replace - replace the old IP address with the new one?
link

answered 2011-11-20 at 04:59:25

nanharbison's gravatar image

nanharbison

Hi nanharbison,
Yes, that is what I have done, at least I think I have. I generated the dump file using Backup and Migrate and then with find and replace I replaced the old IP address with the new url (http://faithmov.com/drupal6)
When I re-ran the import it stopped at :

DROP TABLE IF EXISTS `uc_order_products_pair_vw`;

INSERT INTO `uc_order_products_pair_vw` VALUES ('2956','2958','6','4'),('2956','2959','4','3'),('2958','2956','4','4'),('2958','2959','3','2'),('2959','2956','3','3'),('2959','2958','4','2');
DROP TABLE IF EXISTS `uc_order_products_qty_vw`;

INSERT INTO `uc_order_products_qty_vw` VALUES ('2956','7','1.0000','7','1','1'),('2957','5','1.0000','5','1','1'),('2958','5','1.4000','7','3','1'),('2959','6','1.1667','7','2','1');
DROP TABLE IF EXISTS `uc_order_products_user_vw`;

INSERT INTO `uc_order_products_user_vw` VALUES ('2956','3','7','1.0000','7','1','1'),('2957','3','5','1.0000','5','1','1'),('2958','3','5','1.4000','7','3','1'),('2959','3','6','1.1667','7','2','1');


I replaced these statements with:

DROP TABLE IF EXISTS `uc_order_products_pair_vw`;
CREATE TABLE IF NOT EXISTS `uc_order_products_pair_vw` (
`nid` int(10) unsigned
,`pair_nid` int(10) unsigned
,`pair_sum_qty` decimal(27,0)
,`order_count` bigint(21)
);

INSERT INTO `uc_order_products_pair_vw` VALUES ('2956','2958','6','4'),('2956','2959','4','3'),('2958','2956','4','4'),('2958','2959','3','2'),('2959','2956','3','3'),('2959','2958','4','2');
DROP TABLE IF EXISTS `uc_order_products_qty_vw`;


CREATE TABLE IF NOT EXISTS `uc_order_products_qty_vw` (
`nid` int(10) unsigned
,`order_count` bigint(21)
,`avg_qty` decimal(9,4)
,`sum_qty` decimal(27,0)
,`max_qty` smallint(5) unsigned
,`min_qty` smallint(5) unsigned
);
INSERT INTO `uc_order_products_qty_vw` VALUES ('2956','7','1.0000','7','1','1'),('2957','5','1.0000','5','1','1'),('2958','5','1.4000','7','3','1'),('2959','6','1.1667','7','2','1');

DROP TABLE IF EXISTS `uc_order_products_user_vw`;
CREATE TABLE IF NOT EXISTS `uc_order_products_user_vw` (
`nid` int(10) unsigned
,`uid` int(10) unsigned
,`order_count` bigint(21)
,`avg_qty` decimal(9,4)
,`sum_qty` decimal(27,0)
,`max_qty` smallint(5) unsigned
,`min_qty` smallint(5) unsigned
);
INSERT INTO `uc_order_products_user_vw` VALUES ('2956','3','7','1.0000','7','1','1'),('2957','3','5','1.0000','5','1','1'),('2958','3','5','1.4000','7','3','1'),('2959','3','6','1.1667','7','2','1');

The import works now with no errors but I still get the same error when trying to open the homepage:

Warning: SESSION variable max_allowed_packet is read-only. Use SET GLOBAL max_allowed_packet to assign the value query: SET SESSION max_allowed_packet = 536870912 in /home/faithmov/public_html/drupal6/includes/database.mysql.inc on line 135

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 725

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/faithmov/public_html/drupal6/includes/database.mysql.inc:135) in /home/faithmov/public_html/drupal6/includes/bootstrap.inc on line 728

Fatal error: Call to undefined function filter_xss() in /home/faithmov/public_html/drupal6/includes/common.inc on line 654



I wonder if my replacement of the old ip address in the dump file with the new url is correct. Should I use http://faithmov.com/drupal6?  I just don't know.

It is so frustrating. I too don't really understand why there are so many references to the "old" ip address. Many of them seem to be links:

Print complete issues <a href=\"http://209.200.96.22/acquiadrupal/magazines/pdfs\">click here</a>

Can you suggest how I can sort it out?

Brian



link

answered 2011-11-21 at 08:40:36

bogorman's gravatar image

bogorman

Does this give you a clue.  When I try to run update.php using:

http://faithmov.com/drupal6/update.php

I find the URL changes to:

http://faithmov.com/drupal6/www.faithmov.com/drupal6/update.php?op=info

- you see the way the domain name is repeated.

Brian
link

answered 2011-11-21 at 09:49:10

bogorman's gravatar image

bogorman

You just replaced one IP address with another one? I know in some places Drupal stores the URL, like http://faithmov.com/drupal6

and in others it's the file path:
/home/faithmov/public_html/drupal6

I also do NOT get why Drupal can't use relative addresses!
Did you replace all of the old URLs too?
Are the file paths different now?

 I am SURE you are getting  all of the errors because the URLs/file paths are not correct any more.
link

answered 2011-11-21 at 09:57:33

nanharbison's gravatar image

nanharbison

It's very strange. A lot of the urls are in the boost cache, so I can disable and delete boost. Then, I suppose I ought to create the dump file again and look through the remaining urls. I assume I should remove all specific references to ip address or url?
link

answered 2011-11-21 at 10:07:50

bogorman's gravatar image

bogorman

Have found this:

http://drupal.org/node/1174496

I find applying patches very difficult. Should I try modifying common.inc directly as suggested?

There is another suggestion:

http://drupal.org/node/445854

(see comment 17)

It is driving me mad.  Am beginning to think I will have to recreate the site from scratch!   Anyway, nanharbison, would appreciate your further advice.    Could try removing the Views UI module (comment 13) I suppose,, and then create the dump again.

Brian
link

answered 2011-11-21 at 10:40:38

bogorman's gravatar image

bogorman

Neither of those solutions on Drupal addresses the underlying problem of having the files not be in the place where your Drupal installation is looking for them.

It does seem like Boost is causing some of the problems, so yes, uninstall boost and see what happens. In fact, can you uninstall Boost on the old host and then look at the database from Backup and Migrate and see if that is where the IP addresses were not being removed? In fact I wonder if the issue is for modules that are not in the Drupal core. It would be interesting to know this.

Other thoughts - TRY THIS FIRST- did you try using the restore function in Back Up and Migrate to import the database that way? Maybe that is where the URLs/IP addresses get straightened out.
If not, try using it with the original backed up file you made from the old site using Backup and Migrate (needs to be done with the same version of Backup and Migrate, which you are probably already doing).
link

answered 2011-11-22 at 02:39:09

nanharbison's gravatar image

nanharbison

And, you should never never never mess with Drupal core files! Besides accidentally messing up up function or something, you can never upload new revisions of Drupal without having to deal with a changed core file, and you may forget you made this change and then wonder why a new version has screwed up your site.
link

answered 2011-11-22 at 06:50:31

nanharbison's gravatar image

nanharbison

Hi,
No, I didn't use Backup and Migrate to input the data. Perhaps that's the problem.
Problem is I can't open the site at present. Should I remove everything (delete tables from the database, delete all files) then install drupal 6.22 via cPanel   Presumably the site should run then. Then install Backup and Migrate. Then use it to import. Then import remaining modules.
Is that right?
Brian



link

answered 2011-11-22 at 06:54:42

bogorman's gravatar image

bogorman

re last step. Suppose I could, import all drupal files from backup. Doesn't matter if the previous ones are overwritten including the drupal core ones as they should be the same.
Brian
link

answered 2011-11-22 at 07:51:18

bogorman's gravatar image

bogorman

Yes, try that. I did a Drupal site for a client back in February, and I quite accidentally noticed I still had the production server version still sitting there since February. So I created a back up on the live site and ran it on the old production version, and got an error message in the SQL syntax, but the query did execute, and now the production server site shows all of the new blog posts and articles written by my client. So I think that is the way to go.
Clean install, add all the modules and themes and files, and activate Backup and Migrate module, and do a restore.
Fingers crossed!!!!!!!!!!!!!!!!!!!!!!!!!!
link

answered 2011-11-22 at 07:55:02

nanharbison's gravatar image

nanharbison

You need to have all of the modules in place that have been activated on the old site before the restore.
link

answered 2011-11-22 at 07:58:21

nanharbison's gravatar image

nanharbison

So do I just delete the tables from the database. Then, presumably I will be able to open the site and run Backup and Migrate?
link

answered 2011-11-22 at 07:59:20

bogorman's gravatar image

bogorman

yes, delete the tables, and make sure you have enabled the Backup and M module, of course, as well as all of the other modules the site is using, but you might now have to do that, since the table for each enabled module should be recreated by the restore.
link

answered 2011-11-22 at 08:06:17

nanharbison's gravatar image

nanharbison

WAIT!!!! DOn't delete the tables, you need them to use the site!!! Sorry, that was stupid.
link

answered 2011-11-22 at 08:10:46

nanharbison's gravatar image

nanharbison

Have already deleted them! However, I assume I can now install drupal via cPanel so I have a working copy of drupal on the new site. Then do I:

Upload all the drupal files to the site (do I have to omit ones already installed, or will overwriting these not matter?)  

They will include Backup and Migrate. I assume I need to check whether the modules I need are activated. If not activate them?

Then run Backup and Migrate and import the data.

Is that right?
Brian
link

answered 2011-11-22 at 08:12:54

bogorman's gravatar image

bogorman

Yes, do a clean install, letting Drupal do it for you.You can overwrite the files already there, it doesn't matter. And do enable the modules needed, although as I said, I am not sure that matters.
Then run B&M.
link

answered 2011-11-22 at 08:25:48

nanharbison's gravatar image

nanharbison

If I have to enable multiple modules can I do it in one go by ticking the checkboxes, saving the page and then running update.php for all of them?
link

answered 2011-11-22 at 08:30:38

bogorman's gravatar image

bogorman

Actually you want to make sure you have the exact same versions of the modules you are using, which means no, don't run the update script, you can run that once the new site is up and running.
link

answered 2011-11-22 at 08:32:26

nanharbison's gravatar image

nanharbison

Thanks, so much.  Watch this space!!!! Will let you know how it goes but may be tomorrow
Brian
link

answered 2011-11-22 at 08:40:47

bogorman's gravatar image

bogorman

Okay, will do.
link

answered 2011-11-22 at 08:42:23

nanharbison's gravatar image

nanharbison

I have:
1. Installed drupal 6.22 on the new site via cPanel (also installing a new mySQL database).
2. Uploaded the contents of my acquiadrupal folder on the old site to my new site, changing the name of the folder to drupal6
3. Used Backup and Migrate to create the dump file.  Before doing this I 'cleared all caches' and, in addition 'cleared views cache (don't think all caches clears views cache).  

3 has removed a lot of the URL references in the file but the following are left:

In Boxes table:
<a href=\"http://209.200.96.22/acquiadrupal/Help.pdf\">click here</a>

in “INSERT INTO menu_links VALUES....
<img class=\"admin-menu-icon\" src=\"/acquiadrupal/sites/all/themes/faith_home/favicon.ico\"

Within a node:
<a href=\"/acquiadrupal//files/faith_sept-oct_final.pdf\">/acquiadrupal//files/faith_sept-oct_final.pdf</a>
<a href=\"http://209.200.96.22/acquiadrupal/products/product_list_publications\">Pamphlets, Books and Panorama</a>

(ALSO OTHERS SIMILAR)

IN “insert into variable”
<!--[if IE]>\n<link type=\"text/css\" rel=\"stylesheet\" media=\"all\" href=\"/acquiadrupal/sites/all/themes/zen/zen/ie.css?5\" />\n<link type=\"text/css\" rel=\"stylesheet\" media=\"all\" href=\"/acquiadrupal/sites/all/themes/faith/css/ie.css?5\" />\n<
(SEVERAL LIKE THIS)

(I think, under VIEWS DISPLAY VALUES) :
To View/Print complete issues <a href=\"http://209.200.96.22/acquiadrupal/magazines/pdfs\">click here</a>

Should I change these to relative links before importing? If so, how do I do so in the case of:

href=\"/acquiadrupal/sites/all.......

Or should I leave them and hope, as you suggested, Backup and Migrate will change them?


<a href=\"http://209.200.96.22/acquiadrupal/Help.pdf\"
link

answered 2011-11-22 at 08:44:16

bogorman's gravatar image

bogorman

Sorry, last two lines should be swapped:

<a href=\"http://209.200.96.22/acquiadrupal/Help.pdf\"


Or should I leave them and hope, as you suggested, Backup and Migrate will change them?


link

answered 2011-11-24 at 03:54:35

bogorman's gravatar image

bogorman

I didn't change a thing, I used the sql created by BackUp and Migrate in the real version of the site and ran it on the old production server. Sorry that wasn't more clear!
link

answered 2011-11-24 at 03:57:15

nanharbison's gravatar image

nanharbison

Sorry, can't quite understand. Do you mean:

You ran Backup and Migrate on the old site to create the dump file.
You then ran Backup and Migrate on the NEW site to import the data.

Assume you mean that as, as far as I know, you can only run restore on Backup and Migrate to import the files to whatever site you are on. Not another site.
link

answered 2011-11-24 at 04:02:35

bogorman's gravatar image

bogorman

Think I am gradually getting there, with your help. Problem I discovered is that Backup and Migrate will not work if the sql file is too big. Should have noticed it on the Import form. Have used a file splitter to reduce the size but I then find, when importing the files (first one creates tables, others insert data) that they crash. Maybe there is a limit on file size set by the hoisters - will check.
Also, the first data file crashes as there are three queries (?) in the table list of the old domain:

uc_order_products_pair_vw
uc_order_products_qty.vw
and
uc_order_products_user_vw

These are not tables so they are not created by the first sql file and when the data file is run it, of course, refuses to import the data.

The data structure sql file does in fact contain:

DROP TABLE IF EXISTS `uc_order_products_pair_vw`;
;
DROP TABLE IF EXISTS `uc_order_products_qty_vw`;
;
DROP TABLE IF EXISTS `uc_order_products_user_vw`;
;

but the CREATE TABLE statements are missing.

Think these queries are created by uc_views. Do I delete the uc views module  and then export the data again?  Not sure what effect deleting it will have on my site.

It really is a struggle. If you can suggest anything, I would be grateful. Afraid this question is incredibly long but I am still stuck.

link

answered 2011-11-24 at 04:37:55

bogorman's gravatar image

bogorman

What is the size of the backup file? For the site that I tested it was 1.72 MB. Was yours much larger than that? The site I did the backup on is a huge site, with hundreds of documents on it,and several views. And how many tables are involved?

Can you go into PHP MyAdmin or some program to look at how many tables are in your database?
link

answered 2011-11-27 at 03:21:39

nanharbison's gravatar image

nanharbison

Size of backup file:  17MB
Number of Tables: about 130

I estimate I must have about 800 nodes (pages)

The splitter program splits the sql file into:

Data Structure 106K
1st Data file: 7.9MB
2nd Data File: 6.7MB

(though I can split these into more, smaller, files.
link

answered 2011-11-27 at 03:57:50

bogorman's gravatar image

bogorman

I think the reason this isn't working is that you have to install tables in a database in the correct order. I think if you were just installing Drupal tables, Drupal takes care of that in backup and migrate, but if you have added tables, it may choke on installing a table that has a foreign key to a table that isn't there. Maybe you should just install the drupal tables, and then the custom tables. This might be really hard to do though!
link

answered 2011-11-27 at 04:25:56

nanharbison's gravatar image

nanharbison

Hi nanharbison,]
I'm afraid I've given up. My only solution is to get the hoisters to transfer the site. I wanted to do it myself as I thought it should be so easy.  I have, in the past, restored all the files and imported the data into the database from the backup on my old site and it worked perfectly.
Just to keep you up to date. I decided to deselect the Ubercart Views module (the one related to the views: uc_order_products_pair_vw
uc_order_products_qty.vw
and
uc_order_products_user_vw. I then deleted it.
Then split the files using the utility mentioned above. Then imported the data. No errors.
I still get the errors mentioned above:   "Warning SESSION VARIABLE..........Call to undefined function filter.xss...."
Anyway, thanks so much for all your efforts. Will assign the points.
Brian
link

answered 2011-11-28 at 07:18:47

bogorman's gravatar image

bogorman

So sorry this didn't work! I go to the monthly Drupal meetings in Boston, MA every month, I have one next week. Some of the serious Drupal developers attend this meeting. We can ask questions - I was going to ask if backup and migrate has a size limit over which it totally chokes,
link

answered 2011-11-28 at 09:48:45

nanharbison's gravatar image

nanharbison

Hi nanharbison,

Thanks very much. Very interested to hear if you get any feedback.   Am tackling the first Warning message I get when I try to open the homepage:

Warning: SESSION variable max_allowed_packet is read-only. Use SET GLOBAL max_allowed_packet to assign the value query: SET SESSION max_allowed_packet = 536870912 in /home/faithmov/public_html/drupal6/includes/database.mysql.inc on line 135

The hosters tell me that I can add a statement to the php.ini file. I could not edit it but the hosters say they have increased the limit but I still get all the Warnings and the Error. They suggest that I reinstall drupal. It almost looks as though there is a difference between the 6.22 on the new domain and the 6.22 on the old domain - probably impossible.

If I reinstall drupal via cPanel on the new domain it will recreate the database and I will then have to import the data from the old domain (overwriting the new drupal?). I can't access the new site at present, otherwise I could "update" drupal "manually".  

Don't know what to do.   Alternatively could get the hosters to transfer the site.

Brian
link

answered 2011-11-28 at 16:13:17

bogorman's gravatar image

bogorman

I just came across this:
http://www.aegirproject.org/
I am wondering if it would help you, unless the issue was definitely that your database is too big for your hosting environment,
It says:
The Aegir hosting system allows developers and site administrators to automate many of the common tasks associated with deploying and managing large websites. Aegir makes it easy to install, upgrade, deploy, and backup an entire network of Drupal sites.
link

answered 2011-11-29 at 03:56:33

nanharbison's gravatar image

nanharbison

Hi,
Unfortunately aegir cannot be installed on a shared hosting environment, otherwise it would be very interesting to me.
I have discovered something which I cannot understand.   When I try to import the data from the old site into the new one I get errors specifically relating to one table (there may be others down the line but the import stops at the one table). It is the node_revisions table.   I think the errors relate to max_allowed_packet being too small.   The hosters have increased this to 5MB but will not increase it further.
My node_revisions table is as small as it can be the nodes have rarely been modified. When I look at the sql file I see that there is only one record in the INSERT INTO statement. I understood that there has to be at least one record for every node in the table.  Wonder if this could affect the import - it doesn't seem to relate to the error but I don't know what to do about it.
Brian

link

answered 2011-12-01 at 11:31:10

bogorman's gravatar image

bogorman

SOLVED!!!!!
a) Problems with Importing.  Although there are hundreds of pages online referring to backup/migrating drupal. Nearly all of them do not mention that you need to select the right options when using phpMyAdmin/SQLYog etc.   You must set the program to create separate INSERT statements in the sql file otherwise you may get errors related to max_allowed_packet. I did this and all the data was imported successfully. Mind you it took almost 24 hours!  I used SequelPro (on the Mac). If I had used PuTTY it might have been quicker as it requires the sql file to be on the server and presumably saves having to upload each statement.
b) The Errors. Here again, I had great difficulty to finding the answer. Apparently the module Drupal Tweaks can cause these errors. I deleted the module and it works perfectly with no errors.
Just thought I would let you know how I solved it (with your help).
Thanks
Brian
link

answered 2011-12-02 at 04:17:07

bogorman's gravatar image

bogorman

Oh my GOD!!!!! That is fabulous news. I have to remember this about the separate inserts when migrating a huge Drupal DB. I have never heard of the Tweaks module, may have to steer clear of that one!
Congratulations, you must be walking on air today!
link

answered 2011-12-05 at 04:37:02

nanharbison's gravatar image

nanharbison

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

Asked: 11/18/2011 10:27

Seen: 504 times

Last updated: 11/28/2011 01:49