upgrade 3.5.5 to 4.0.2 problem
  • hi

    trying to upgrade a 3.5.5 to 4.0.2 - once i start copying over the source files - i start receiving emails - change article status and add image notifications

    after a short while the other websites on the vps we are on crashed - the ISP emailed me to say - there are currently 128,033 emails being sent to me

    he also sait: It appears to be this script causing it:
    /home/xxxxxxx/public_html/bin/events-notifier

    anyway have deleted the site and started again but the same thing has happened - although this time i deleted the site when i started receiving emails

    is their something i can change in the source files to stop this

    cheers

    mark
  • 19 Comments sorted by
  • Vote Up1Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    1. rename /home/xxxxxxx/public_html/bin/events-notifier to *.bak
    2. edit administrator role permissions and disable event notification
    3. rename back
    events-notifier
  • thanks for that

    will try it first thing in the morning
  • this has worked fine


    A couple of things i noticed on the update

    1 their is no option for Featured Article List - its there but no edit box

    2 its not in admin > contents either

    3 when you attach a picture the Next: Upload and Edit Metadata takes you to a blank screen


    how can i get these to work

    cheers
    Post edited by mark casson at 2012-11-20 07:30:42
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    add into .htaccess

    SetEnv APPLICATION_ENV "development"



    and try again.Also check apache error log file for php errors
  • tried that but still not appeared in content or on article creation page

    error logs for today are below but nothing i can see - the theme is new custodian (theme 2) so i dont know why there are references to other themes

    [Tue Nov 20 12:57:56 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 12:56:02 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 12:26:05 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:05 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:04 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:04 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:03 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:02 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:02 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:02 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:26:02 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 12:08:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/themes/publication_2/theme_2/_css/ui-lightness/jquery-ui.custom.css
    [Tue Nov 20 11:57:45 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 11:51:04 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/themes/publication_2/theme_2/_css/ui-lightness/jquery-ui.custom.css
    [Tue Nov 20 11:50:59 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_img/favicon.ico
    [Tue Nov 20 11:50:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/themes/publication_2/theme_2/_css/ui-lightness/jquery-ui.custom.css
    [Tue Nov 20 11:50:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_img/favicon.ico
    [Tue Nov 20 11:22:09 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 11:20:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 11:20:13 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 10:07:59 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_1/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:59 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_1/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:58 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_1/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:57 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:57 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:56 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/zsystem_templates/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:55 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_zen/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/article.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/section.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:07:54 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/unassigned/set_thejournal/front.jpg, referer: http://www.eastmidlandsbusinesslink.co.uk/admin/themes
    [Tue Nov 20 10:05:47 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 10:05:38 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:59:07 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:57:56 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:55:07 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:51:39 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:51:29 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:49:46 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:49:36 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:49:33 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:44:53 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:44:50 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/Finance/
    [Tue Nov 20 09:44:47 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:44:45 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:44:35 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:44:31 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/Manufacturing/
    [Tue Nov 20 09:44:23 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/Finance/
    [Tue Nov 20 09:44:08 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:44:07 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:37:13 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/en/blm/News/
    [Tue Nov 20 09:36:51 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
    [Tue Nov 20 09:35:01 2012] [error] [client 81.104.203.81] File does not exist: /home/eastmidl/public_html/themes/publication_2/theme_2/_css/ui-lightness/images/ui-bg_highlight-soft_0_ffffff_1x100.png, referer: http://eastmidlandsbusinesslink.co.uk/
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    enable display_errors = on in php.ini and restart apache server
  • sorry nothing

    its like its not installed at all
  • hi,

    the featured article lists - it might be permissions - can u check if you are allowed to edit it?
  • thats it, as admin i thought everything would have been granted - so didnt even look
     
    worryingly tho i just went to users to change permission and - this is an unreleased test site - there are 700 users - all spam

    went to try and look as i know their is a tick box to register - but i get error - too big to post all error here - so here is the start


    Hey, this is error!Error: Application error (*)object(PDOException)#770 (8) { ["message":protected]=> string(83) "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'UName' cannot be null" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "23000" ["file":protected]=> string(62) "/home/eastmidl/public_html/library/Doctrine/DBAL/Statement.php" ["line":protected]=> int(131) ["trace":"Exception":private]=> array(14) { [0]=> array(6) { ["file"]=> string(62) "/home/eastmidl/public_html/library/Doctrine/DBAL/Statement.php" ["line"]=> int(131) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> NULL } } [1]=> array(6) { ["file"]=> string(83) "/home/eastmidl/public_html/library/Doctrine/ORM/Persisters/BasicEntityPersister.php" ["line"]=> int(237) ["function"]=> string(7) "execute" ["class"]=> string(23) "Doctrine\DBAL\Statement" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(62) "/home/eastmidl/public_html/library/Doctrine/ORM/UnitOfWork.php" ["line"]=> int(726) ["function"]=> string(14) "executeInserts" ["class"]=> string(44) "Doctrine\ORM\Persisters\BasicEntityPersister" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(62) "/home/eastmidl/public_html/library/Doctrine/ORM/UnitOfWork.php" ["line"]=> int(292) ["function"]=> string(14) "executeInserts" ["class"]=> string(23) "Doctrine\ORM\UnitOfWork" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Doctrine\ORM\Mapping\ClassMetadata)#596 (32) { ["reflFields"]=> array(19) { ["id"]=> object(ReflectionProperty)#656 (2) { ["name"]=> string(2) "id" ["class"]=> string(20) "Newscoop\Entity\User" } ["email"]=> object(ReflectionProperty)#657 (2) { ["name"]=> string(5) "email" ["class"]=> string(20) "Newscoop\Entity\User" } ["username"]=> object(ReflectionProperty)#660 (2) { ["name"]=> string(8) "username" ["class"]=> string(20) "Newscoop\Entity\User" } ["password"]=> object(ReflectionProperty)#663 (2) { ["name"]=> string(8) "password" ["class"]=> string(20) "Newscoop\Entity\User" } ["first_name"]=> object(ReflectionProperty)#666 (2) { ["name"]=> string(10) "first_name" ["class"]=> string(20) "Newscoop\Entity\User" } ["last_name"]=> object(ReflectionProperty)#668 (2) { ["name"]=> string(9) "last_name" ["class"]=> string(20) "Newscoop\Entity\User" } ["created"]=> object(ReflectionProperty)#670 (2) { ["name"]=> string(7) "created" ["class"]=> string(20) "Newscoop\Entity\User" } ["updated"]=> object(ReflectionProperty)#662 (2) { ["name"]=> string(7) "updated" ["class"]=> string(20) "Newscoop\Entity\User" } ["status"]=> object(ReflectionProperty)#665 (2) { ["name"]=> string(6) "status" ["class"]=> string(20) "Newscoop\Entity\User" } ["is_admin"]=> object(ReflectionProperty)#675 (2) { ["name"]=> string(8) "is_admin" ["class"]=> string(20) "Newscoop\Entity\User" } ["is_public"]=> object(ReflectionProperty)#674 (2) { ["name"]=> string(9) "is_public" ["class"]=> string(20) "Newscoop\Entity\User" } ["points"]=> object(ReflectionProperty)#679 (2) { ["name"]=> string(6) "points" ["class"]=> string(20) "Newscoop\Entity\User" } ["image"]=> object(ReflectionProperty)#681 (2) { ["name"]=> string(5) "image" ["class"]=> string(20) "Newscoop\Entity\User" } ["role"]=> object(ReflectionProperty)#683 (2) { ["name"]=> string(4) "role" 
  • does that register box contain email or username field ?
  • email and tick box for Accepting terms of use
  • looks like there is missing db upgrade command. UName should be allowed to be null.
    that's a bug we have to fix (you can do this on db level). i've created a ticket
  • can you give me basic instructions of what table and what to add etc
  • ALTER TABLE  `liveuser_users` CHANGE  `UName`  `UName` VARCHAR( 70 ) NULL;
  • # Column Type         Collation           Attributes Null     Default Extra 
    4 UName varchar(70) utf8_general_ci                 Yes      NULL          


    this has not worked
  • sorted

    the row 3 Name was set to No
  • what about those spam users? any ideas how could they got there? i guess they are all inactive (status = 0) right?
  • actually i dont know - while i was messing with the sql i deleted them - didnt take any notice

    was more concerned with why they could join but i couldnt
  • hi petr - this is one of the spam users- any idea how to stop this - not sure how it will show up on the screen - its just copy and paste from sql
    IdKeyIdNameUNamePasswordEMailReaderfk_user_typeCityStrAddressStateCountryCodePhoneFaxContactPhone2TitleGenderAgePostalCodeEmployerEmployerTypePositionInterestsHowLanguagesImprovementsPref1Pref2Pref3Pref4Field1Field2Field3Field4Field5Text1Text2Text3time_updatedtime_createdlastLoginisActivepassword_reset_token 966601576ddlvuddlvu7513c5bad38347edc84977aa7fcd595443f6ae5ff.av.o.rgh.s@gmail.comYNULLTunisia|Carthage,Gafsa,Djerba,Msaken,Monastir,Tuni...NULL123456Mr.NULL0-17NULLNULLNNNNNULLNULLNULL2012-11-22 21:03:362012-11-22 21:03:361970-01-01 00:00:001NULL






    1252
    Post edited by mark casson at 2012-11-29 05:39:00