Upgrade got freezed while "Copying Files"

[p.konetskiy]

@sma

My Popup Windows with the search/list view of email templates or account, or quote etc. are not working. I can see the List but when clicking on an entry nothing happend.

Look at errors in console of browser.

@sma

Wed May 26 11:04:21 2021 [1985390][32d40667-cd32-e356-4e56-6088344d9083][FATAL] SugarPHPMailer encountered an error: Invalid address: (to):

I think that the error wrote the Workflow when call “Sent Email”.

[p.konetskiy]

@sma

Does the Update affect the Database?

Can i in the worst case roll back easily with just rolling back the complete files of the crm system?

From which version and to which version did you update?

[sma]

When opening the Mail Client this errors where shown:

After selecting an Template this was shown:

The Subject and attachment of the Template was loaded, the body is empty.

[sma]

Hello,

thanks for your educated advices.

Is downloaded and installed the Version at the 16.04.2020. Actually i am not sure which version was the actuall Version on that date.

And i upgraded to the Version: 7.11.19

[p.konetskiy]

@sma
Maybe it’s problem with file .htaccess. You can do: Admin -> Repair -> Rebuild .htaccess File.

[sma]

I did the Rebuild of the htaccess and did a quick repair and rebuild too again after that.

Now this is the actual error:

Template is been loading but without the Body.

My WYSIWYG Fields (Textareas with html format) are simple Text Inputs too now.

Maybe there is something gone wrong with the HTML Editor?

[sma]

When i am just clicking on a email adress from the contact detail view, this is logged on error log level: Error

Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] EmailController::action_getFromFields() expects an outbound email id as stored option of inbound email (d7dbef2f-1db0-fb85-9643-60017cff58bd) but it isn’t valid.
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] EmailController::action_getFromFields() panic: An error occurred! (203)
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] Incorrect “replay to” format found: xxxxxx@xxxxx.de
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] EmailController::action_getFromFields() error: 205
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] Signature html not found!
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] Signature plain text not found!
Thu May 27 11:18:39 2021 [169561][78039cf5-6f87-6c10-735a-5e996ae0432f][ERROR] EmailController::action_getFromFields() is Panicking: Reply-To address is not filled.

[p.konetskiy]

@sma

Maybe there is something gone wrong with the HTML Editor?

It’s problem with loading files to frontend only. Sorry, I can’t see you installation. The file vendor/tinymce/tinymce/tinymce.min.js is loading for version 7.11.x .

[sma]

Hmm? Can you help me? What should i do? Do you think the Upgrad was not installed successfull?

[p.konetskiy]

@sma

1. Install new copy of SuiteCRM.
2. Compare tables of database
3. Copy custom files from current to new copy.

[sma]

Ohhh, thats a big thing.

Are Workflows etc. saved in the Database?
Should i compare every single Table of the database and every single column?

There is no easier way?
Thanks for your Feedback.

I found some Threads with the tinymce problem, isn`t it a part of the problem?

ReferenceError: tinyMCE is not defined

I cannot edit any email template anymore because I assume its related to following error message. ReferenceError: tinyMCE is not defined in the Browser. What can be done to fix tinyMCE in SuiteCRM?

[p.konetskiy]

@sma

Maybe. I don’t know because i don’t see your system. I wrote how to do full check. If you want fix the tinyMCE editor only you can do new installation version 7.11.19 and copy file .htaccess from it. But I can’t give you garanty that it’s will be enough. Before copying keep the current version of .htaccess.

[sma]

OK, thank you.
I read about upgrading again and maybe the problem could be, that i forgot to disable the cronjob for shedulers?

Thats maybe the difference to my test-system, where the Upgrade run pretty well.

[sma]

OK, i installed a brand new 7.11.19 Version and deleted/imported my old database.

I think i need to know how to identify the custom files that i need to upload to the new system Are there Folders i can transfer to the new system?

[p.konetskiy]

@sma

If you don’t modified core files you can copy custom directory and file config_override.php only.

[sma]

OK, thank you.

I tried everything now.
@p.konetskiy

1. Installing a brand new Version (Same Error with Tiny MCE)
2. Rolling Back the Backup (Same Error)
3. Checking the complete Permissions of Folders again and changing everything to 775. (Same Error).

I think i need to fix the 403 Status that the Console is showing me first, and maybe its done after that or i can continue with bug fixing after that.

[sma]

@p.konetskiy This is my current HTACCESS File, is this correct like it is?

php_value memory_limit 512M
php_value max_execution_time 180

# BEGIN SUITECRM RESTRICTIONS
RedirectMatch 403 .*\.log$
RedirectMatch 403 /+not_imported_.*\.txt
RedirectMatch 403 /+(soap|cache|xtemplate|data|examples|include|log4php|metadata|modules|vendor)/+.*\.(php|tpl)
RedirectMatch 403 /+emailmandelivery\.php
RedirectMatch 403 /+.git
RedirectMatch 403 /+.cache/
RedirectMatch 403 /+tests
RedirectMatch 403 /+RoboFile\.php
RedirectMatch 403 /+composer\.json
RedirectMatch 403 /+composer\.lock
RedirectMatch 403 /+upload
RedirectMatch 403 /+custom/+blowfish
RedirectMatch 403 /+cache/+diagnostic
RedirectMatch 403 /+files\.md5$

<IfModule mod_rewrite.c>
    Options +SymLinksIfOwnerMatch
    Options -Indexes
    Options -MultiViews
    RewriteEngine On
    RewriteBase /
    RewriteRule ^cache/jsLanguage/(.._..).js$ index.php?entryPoint=jslang&modulename=app_strings&lang=$1 [L,QSA]
    RewriteRule ^cache/jsLanguage/(\w*)/(.._..).js$ index.php?entryPoint=jslang&modulename=$1&lang=$2 [L,QSA]

    # --------- DEPRECATED --------
    RewriteRule ^api/(.*)$ - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
    RewriteRule ^api/(.*?)$ lib/API/public/index.php/$1 [L]
    # -----------------------------

    RewriteRule ^Api/(.*)$ - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
    RewriteRule ^Api/access_token$ Api/index.php [L]
    RewriteRule ^Api/V8/(.*?)$ Api/index.php [L]
</IfModule>
<IfModule mod_headers.c>
    Header unset ETag
    FileETag None
</IfModule>
<IfModule mod_headers.c>
    Header unset X-Powered-By
    Header always unset X-Powered-By
</IfModule>
<IfModule mod_expires.c>
 ExpiresActive on
 ExpiresDefault "access plus 1 month"

 # CSS
 ExpiresByType text/css "access plus 1 year"
 
 # Data
 ExpiresByType application/atom+xml "access plus 1 hour"
 ExpiresByType application/rdf+xml "access plus 1 hour"
 ExpiresByType application/rss+xml "access plus 1 hour"
 ExpiresByType application/json "access plus 0 seconds"
 ExpiresByType application/ld+json "access plus 0 seconds"
 ExpiresByType application/schema+json "access plus 0 seconds"
 ExpiresByType application/geo+json "access plus 0 seconds"
 ExpiresByType application/xml "access plus 0 seconds"
 ExpiresByType text/calendar "access plus 0 seconds"
 ExpiresByType text/xml "access plus 0 seconds"

 # Favicon
 ExpiresByType image/x-icon "access plus 1 week"

 # HTML
 ExpiresByType text/html "access plus 0 seconds"

 # JavaScript
 ExpiresByType application/javascript "access plus 1 year"
 ExpiresByType application/x-javascript "access plus 1 year"
 ExpiresByType text/javascript "access plus 1 year"

 # Markdown
 ExpiresByType text/markdown "access plus 0 seconds"

 # Media files
 ExpiresByType audio/ogg "access plus 1 month"
 ExpiresByType image/bmp "access plus 1 month"
 ExpiresByType image/gif "access plus 1 month"
 ExpiresByType image/jpeg "access plus 1 month"
 ExpiresByType image/jpg "access plus 1 month"
 ExpiresByType image/png "access plus 1 month"
 ExpiresByType image/svg+xml "access plus 1 month"
 ExpiresByType image/webp "access plus 1 month"
 ExpiresByType video/mp4 "access plus 1 month"
 ExpiresByType video/ogg "access plus 1 month"
 ExpiresByType video/webm "access plus 1 month"

 # Fonts
 ExpiresByType font/eot "access plus 1 month"
 ExpiresByType font/opentype "access plus 1 month"
 ExpiresByType font/otf "access plus 1 month"
 ExpiresByType application/x-font-ttf "access plus 1 month"
 ExpiresByType font/ttf "access plus 1 month"
 ExpiresByType application/font-woff "access plus 1 month"
 ExpiresByType application/x-font-woff "access plus 1 month"
 ExpiresByType font/woff "access plus 1 month"
 ExpiresByType application/font-woff2 "access plus 1 month"
 ExpiresByType font/woff2 "access plus 1 month"

 # Other
 ExpiresByType text/x-cross-domain-policy "access plus 1 week"
</IfModule>
<IfModule mod_headers.c>
    Header set X-Content-Type-Options "nosniff"
</IfModule>
<IfModule mod_rewrite.c>
        RewriteEngine On
        RewriteCond %{REQUEST_FILENAME} !-d
        RewriteCond %{REQUEST_URI} (.+)/$
        RewriteRule ^ %1 [R=301,L]
</IfModule>
# END SUITECRM RESTRICTIONS

[sma]

@p.konetskiy Based on the same error based on different approached to get the system running it think it is definitly a permission / webserver specific problem.

I have not changed the Server config etc.

Is there anyone who can help me with this thing?

Thanks a lot.

[pgr]

When you go in Admin / Schedulers, what is the username showing at the bottom, in the crontab instructions?

1. Is this the username you have been using in the chown command when setting permissions?

2. Is this the username you have in default_permissions in your config.php?

3. If you have set up crontab, did you set it for this same user, or for root?

[p.konetskiy]

@sma
You can use install to local computer or take ready installation for virtualbox (https://suitecrm.com/download/).