Recent Topics

1 Mar 18, 2016 01:48    

Hi,

In order to update from 5.2.0 to the latest stable version of B2Evo, i made two backups of the whole Mysql files.

One backup with phpMyAdmin export feature
Another one with the backup feature of Plesk

The automatic update went wrong for a unknown reason in the middle of the B2Evo's database update leaving with no other option than to reinstall the whole.

I thought this would be easy since I done it already without problem but this time, I could not import any of the 2 backups I made :(

Both makes lots of 1064 errors. I tried to update manually and it was of till I realise semicolons and quotation marks were causing lots of errors. Since the whole base is 161MB and counting thousands of posts I don't know what to do to have the backup working.

Your kind help very much appreciated. All my blogs are down since 3 days now and I'm starting to feel very depressed.

Thanks

Mysql 5.1.73
phpmyadmin 4.5.5
B2Evo 5.2.0
Plesk 12.5
Backups saved in utf8 and gzip

2 Mar 18, 2016 03:53

@inde
It seems that there are many kinds of possibilities may cause this mistake. Maybe only a small negligence, so please don't worry too much. I have a suggestion:

  • Copy a new backup file first, then open it with a large file editor( such as PilotEdit ), copy and execute only one table sql statement at a time, until you find one single error sql. Then we can have a research and be much easier to seek the solution.

3 Mar 18, 2016 12:15

I did that already. All is fine till we reach comments and other textual fields. I did the correction on comments to see how much time it will take and it's huge ! Something bugs me. Why a backup which is completed normally with the same parameters than usual is not working the same day I did it?

I tried lots of backup I have made since 2 years and none of them is working except the whole folder backup made with tar. Unfortunately it is too old to be relevant...

Now the problems I have...

Accents and symboles are transformed in all&#XXX; -> not accepted by MYSQL import because of semicolon... Do I have to replace them ?

Same probleme with smileys like ;) :-) ;) which are generating errors... Why???????????

What the sake of having a backup of text which creates so much errors. That's insane! Is there a way to avoid that????

4 Mar 18, 2016 12:46

Here a sample of error I encounter...

In evo_coll_settings

(8,'blog_footer_text','©$year$ by $owner$')
(11,'blog_footer_text','©$year$ by $owner$'),
(12,'blog_footer_text','©$year$ by $owner$'),
(13,'blog_footer_text','©$year$ by $owner$'),
(14,'blog_footer_text','©$year$ by $owner$'),
(15,'blog_footer_text','©$year$ by $owner$'),
(16,'blog_footer_text','©$year$ by $owner$'),
(18,'blog_footer_text','©$year$ by $owner$'),
(19,'blog_footer_text','©$year$ by $owner$'),
(20,'blog_footer_text','©$year$ by $owner$'),
(21,'blog_footer_text','©$year$ by $owner$'),
(22,'blog_footer_text','©$year$ by $owner$'),
(23,'blog_footer_text','©$year$ by $owner$'),
(24,'blog_footer_text','©$year$ by $owner$'),
(25,'blog_footer_text','©$year$ by $owner$'),

the semicolon between &copy and $year is not accepted...

Same problem with a February 2015 backup

can anybody check its backup and tell me what am I suppose to have in these fields???

5 Mar 18, 2016 13:58

in evo_coll_settings

accepting (22,'ping_plugins','ping_pingomatic,evo_twitter'),
refusing (23,'ping_plugins','ping_pingomatic,evo_twitter'),

accepting (11,'plugin18_twitter_msg_format','Nouveau post: $title$ $url$ #b2p'),
refusing (23,'plugin18_twitter_msg_format','Nouveau post: $title$ $url$ #b2p'),

refusing (23,'plugin18_twitter_msg_format','Nouveau post: $title$ $url$ #b2p'),
accepting (23,'plugin18_twitter_msg_format',''),

What kind of nonsense is that??????

6 Mar 18, 2016 14:07

@inde

Where do you paste and execute your sql statement? It's impossible to cause this error only by a semicolon unless you use the command line which consider the semicolon as an end mark. Don't you use the phpMyAdmin sql textarea to execute your sql statement?
However the best way I guess is executing the command mysql> source your-backup.sql to import backup data into your mysql database. In this way, would you also meet a 1064 error ?

7 Mar 18, 2016 15:25

haharen, you are just the BEST!

First try with the plesk backup did not ended up correctly but the phpmyadmin's one went like a breath!

I was using phpmyadmin import option and that was just the problem. I will never do it again!

I still have the phpbb files not loaded for a reason I still have to discover but the blogs are back!!!!

Thanks so much!

I will try again the update tonight. Do you have an idea why the previous one I made stopped in the middle of the database upgrade?

8 Mar 18, 2016 15:39

@inde

Perhaps the page execution time of your web server is limited in a relatively short time.
Can you modify the configuration file php.ini? If you can, please increase the value of max_execution_time ( default is 30), you can set it to 300( or more ), and restart the apache server, then have a try.

9 Mar 18, 2016 15:42

Ok I will try that tonight and will let you know... thanks again and again!

10 Mar 18, 2016 15:48

@inde
You're welcome.
Waiting for your good news.

11 Mar 18, 2016 19:35

haharen,

I realize how huge the evo_session is. Do I really need to keep all records?

12 Mar 18, 2016 23:10

@inde wrote earlier:

Do you have an idea why the previous one I made stopped in the middle of the database upgrade?

"stopped in the middle of" does give no workable info.

Please make a complete screenshot next time you have an error.

13 Mar 19, 2016 00:39

@Haharen -> One more time you saved my life! max_execution_time was the problem and 300 was not enough. 600 did the trick and everything went perfectly right. You're damn efficient. Thanks a zillion times!

@François -> Sorry for that. I meant the page where the update in converting all files. It stopped in the middle of the PHP files with error to all files.

Now it's working just fine. The back office is just perfect. Too bad there are so few 3 colonnes templates. The installed Zen is not working anymore. I may have to reinstall from a fresh download.

Thanks for all guys and keep up the good work.


Form is loading...