Newscoop 4.4.5 - backup problems from 4.2.4...
  • Vote Up0Vote Down Wagner de QueirozWagner de Queiroz
    Posts: 5Member
    Hello for all, I have two newscoop instalations on Ubuntu machines on amazon aws.

    One use 4.2.4 version, what lost the translation without notice. (the _config translation are ok) but the translation not appear.

    So, I instaled another vm with 4.4.5 version, after restore the backup from 4.2.4 at 4.4.5, I cant log at panel.

    I check the password at database, are ok, and I put another one with

    UPDATE liveuser_users SET Password = SHA1('<alongpassword>') WHERE UName = '<admin>';

    but i have the same "bad credentials' at panel admin login.

    I check the error.log of the apache2 and I got this:

    [Tue Sep 08 13:11:41.630618 2015] [:error] [pid 1031] [client 192.168.0.232:56250] PHP Notice:  date_default_timezone_set(): Timezone ID '-3' is invalid in /var/lib/newscoop/application/AppKernel.php on line 21, referer: http://192.168.0.40/admin/login
    [Tue Sep 08 13:11:41.681757 2015] [:error] [pid 1031] [client 192.168.0.232:56250] PHP Notice:  date_default_timezone_set(): Timezone ID '-3' is invalid in /var/lib/newscoop/include/campsite_init.php on line 38, referer: http://192.168.0.40/admin/login
    [Tue Sep 08 13:11:41.704443 2015] [:error] [pid 1031] [client 192.168.0.232:56250] Newscoop error: Undefined offset: 2 in /var/lib/newscoop/library/Newscoop/Entity/User.php:352, referer: http://192.168.0.40/admin/login
    [Tue Sep 08 13:11:41.704830 2015] [:error] [pid 1031] [client 192.168.0.232:56250] Newscoop error: Undefined offset: 1 in /var/lib/newscoop/library/Newscoop/Entity/User.php:352, referer: http://192.168.0.40/admin/login
    [Tue Sep 08 13:11:41.750266 2015] [:error] [pid 1031] [client 192.168.0.232:56250] PHP Notice:  date_default_timezone_set(): Timezone ID '-3' is invalid in /var/lib/newscoop/application/AppKernel.php on line 21, referer: http://192.168.0.40/admin/login
    [Tue Sep 08 13:11:41.797507 2015] [:error] [pid 1031] [client 192.168.0.232:56250] PHP Notice:  date_default_timezone_set(): Timezone ID '-3' is invalid in /var/lib/newscoop/include/campsite_init.php on line 38, referer: http://192.168.0.40/admin/login

    About the timezone I'm in America/Sao_Paulo timezone. I put this info at /etc/php5/apache2/php.ini, after the #dpkg-reconfigure tzdata to same region.

    I'm not understand why the message about timezone and why i get the message about Newscoop error: Undefined offset: 1 in /var/lib/newscoop/library/Newscoop/Entity/User.php:352

    Any hint?
  • 1 Comment sorted by
  • Vote Up0Vote Down Mischa GorinskatMischa Gorinskat
    Posts: 20Member
    Just using SHA1 in SQL won't work, that's why you are getting the bad credentials and 
    [Tue Sep 08 13:11:41.704830 2015] [:error] [pid 1031] [client 192.168.0.232:56250] Newscoop error: Undefined offset: 1 in /var/lib/newscoop/library/Newscoop/Entity/User.php:352, referer: http://192.168.0.40/admin/login

    Use this query please.

    UPDATE liveuser_users SET Password = 'sha1$L8ve0WLGOkbE$80b56a21a265417d31f8a04f2733c435977d7c7c' WHERE UName = 'admin';

    Now your password will be the value password .

    You are getting the timezone error, because we changed the timezone format, but apparently the upgrade hasn't gone 100% right for you. -3 should be upgraded. Two things you can do:
    1. Log in to the backend 
    2. Go to System Preferences
    3. Change the value for TimeZone to disabled if you want to use the value from your php.ini or select the correct one 
    Another way would be:
    1. Open up phpmyadmin / mysql shell
    2. Go to the table SystemPreferences
    3. Search for the varname TimeZone
    4. Change the value to '' (empty value)
    5. Save the row



    Post edited by Mischa Gorinskat at 2015-09-11 04:41:41
Add a Comment