Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Database Migration mysql error

Database Migration mysql error

1 Nov 06, 2013 21:39    

I get this error when I attempted the upgrade - How to manually fix?

MySQL error!
Unknown column 'user_showonline' in 'where clause'(Errno=1054)

Your query: Set show online on users_usersettings
INSERT INTO evo_users__usersettings ( uset_user_ID, uset_name, uset_value )

SELECT user_ID, "show_online", 0

FROM evo_users

WHERE user_showonline = 0

Back to top

3 Nov 07, 2013 18:21

Ok I restored the database thank you!

Now I'm getting this error - should I go ahead with the upgrade anyways?

Warning: Cannot modify header information - headers already sent by (output started at /home/famili88/public_html/plog/conf/_advanced.php:1392) in /home/famili88/public_html/plog/inc/sessions/model/_session.class.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /home/famili88/public_html/plog/conf/_advanced.php:1392) in /home/famili88/public_html/plog/inc/_core/_template.funcs.php on line 619

Warning: Cannot modify header information - headers already sent by (output started at /home/famili88/public_html/plog/conf/_advanced.php:1392) in /home/famili88/public_html/plog/inc/_core/_template.funcs.php on line 419

Back to top

4 Nov 08, 2013 05:02

Those messages are just warnings and maybe the upgrade will work with no problem, but they should not be there.

Before to go further, please tell us the versions involved in your upgrade (from where to where). Then, look into the file: /home/famili88/public_html/plog/conf/_advanced.php at line 1392. This file in version 5.0.6 is not that long, so, please copy and paste that line here.

Back to top

5 Nov 08, 2013 20:24

It was a blank line after the ?> so I deleted it and the error went away! Too simple! thanks so much for pointing me in the right direction.

Back to top

6 Nov 13, 2013 22:04

No I found this error when i attempt to post an article,
Requested Chapter from T_categories without ID!

I have not done the upgrade -

will doing the upgrade fix this or is it something else?

Back to top

7 Nov 13, 2013 22:59

Hi @gjensen,

It looks like something related with the categories. You still didn't say us which version of b2evo are you currently using, but as general rule, sometimes this weird errors are solved after upgrade to the latest version.

Please remember to activate the debug mode and share its relevant output with us if the error is still there after upgrading.

Regards !

Back to top


Form is loading...