upgrade from 7.8 issues

What you cut out was what I wanted to see. :slight_smile:

If you can grab it in text mode (from Putty, for example), then you can use a find-and-replace to hide your username by swapping it for something else.

Anyway, now that you have SSH access, just reapply all permissions, it might magically solve all your problems.

So in SSH I set the rigths again;
chmod -R 755 .
chmod -R 775 cache custom modules themes data upload
chmod 775 config_override.php 2>/dev/null
(sudo is not needed says my provider)
I don’t see any difference, Show Leads, etc all not working, no dashboard, progress indicator keeps turning;

The browser dev. console show errors, like this last ones after home refresh:

I insist, without user names and “chown” commands all this is essentially meaningless. Linux permissions don’t mean anything by themselves.

So if you don’t want to post this online, ok, but make sure that

  • you determine the user name that your web server is using to run

  • you chown all files and directories recursively to that user

Also make sure you haven’t set up your cron jobs in crontab of a different user (typically root), because that ruins permissions.

https://docs.suitecrm.com/blog/scheduler-jobs/

So I was able to use chmod (although my provider says it is not necessary because this goes automatic on uploading) on all files/folder -R
But I can’t use sudo, i.e. if I use sudo chown xxx:xxx manifest.php then I get
-bash: sudo: command not found
Same error if try crontab

No changes so far, still no content on Show , the Admin Menu seems to work, in Shedule I see 14 job, some Inactive.
On myhost I have no cronjobs, not sure where I can see ‘different users’ cronjobs?

another grab from errors.php

A[Mon Jun 25 19:58:42.356925 2018] [error] [pid 11692] mod_proxy_fcgi.c(848): [client 81.83.9.82:58448] AH01071: Got error ‘PHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_base has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 321\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_fault has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1455\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_xmlschema has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1744\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soapval has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 2924\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soap_transport_http has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 3227\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_server has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 4733\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; wsdl has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 6069\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_parser has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 8205\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_client has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 9057\n’
[Mon Jun 25 19:59:22.889221 2018] [error] [pid 18234] mod_proxy_fcgi.c(848): [client 81.83.9.82:58633] AH01071: Got error ‘PHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_base has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 321\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_fault has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1455\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_xmlschema has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1744\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soapval has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 2924\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soap_transport_http has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 3227\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_server has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 4733\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; wsdl has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 6069\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_parser has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 8205\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_client has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 9057\n’

All those “deprecated” errors are safe to ignore. We’ll take care of those when we’re preparing to make some older PHP versions unsupported.

If you can’t use sudo, just try the command without sudo. Your hosting might let you use some (restrained) versions of those commands.

As for the crontab, if you use “crontab -u username” you will see each user’s crontab.

Your hosting is probably right, maybe none of this is necessary because if they set the ownerships for you, and don’t let them change them, then they should be right.

Basically, all you need to check is that if your web server is running under user “joebloggs”, then the files in that “ls -al” command are owned by “joebloggs”. If some of them aren’t, you need to set ownerships. If after setting ownerships they break again, you need to check crontab user because it’s likely your cron jobs that are messing things up.

I understand the rights, I was able to use chmod and chown -R on all files/folders. Now I can’t see any user/group with other than my name.
The providers says to open crontab manually in ssh for edit with vi, in folder /etc.
There I have only this line:
*/5 * * * * cd /data/sites/web/xxxxbe/subsites/crm.xxxx.be; php -f cron.php > /dev/null 2>&1

In the meantime I setup a complete new v7.8.3 on another host. I was able ro restore a DB and it seems to work fine. Now I can try the Upgrade here.
Is there a way to see a CRM version or a DB date in de SQL backup file?
Can I import a DB from v7.8.20 into a v7.8.3? Does the version matters?
I noticed that Search don’t return any result? I enter like %text in the top right box, but I get an emptu result with basic search on it. Do I need to repair an index somehow?

  1. Is there a way to see a CRM version or a DB date in de SQL backup file?

You can see the upgrade_history table, sort by date to see the latest “installed” package. This has upgrades, I’m not sure what it has on a clean install…

  1. Can I import a DB from v7.8.20 into a v7.8.3? Does the version matters?

Normally it is not advised to import a DB into anything except the exact version where it was exported.

  1. I noticed that Search don’t return any result? I enter like %text in the top right box, but I get an emptu result with basic search on it. Do I need to repair an index somehow?

Yes you might have to set up cron jobs so AOD will index again, which might take hours with lots of data, or force a Reindex if necessary (see https://pgorod.github.io/Reindex-AOD/ )

Have you tried simply migrating your 7.8.3 to the new server, and trying the upgrade there? Maybe the problem you’re getting won’t happen on the new server…

alright, so on my test hosting the upgrade worked fine, now I have a working v7.10.6
I did need to re-set the rights 775 and 755 on all files/folders before the upgraded version worked fine.

But the search functions still only seems to find recent edited items. I added the crontab code 4h ago, maybe it takes more time? Is there a way to check crontab is OK?
Maybe I need to do the manual steps mentioned before.

So what steps are best to move my working test host setup back to the original host?

It’s possible that Reindexing takes more than 4 hours, but you’d have to have a LOT of data for that to happen. It’s also possible, that there is no Reindexing taking place, and that explains why only recently created or edited items are going into the index.

I gave you a link above explaining how to force reindexing.

But before that… I am still not content that your ownerships/permissions are properly installed. Our talk is too vague for me to know, and you have weird things (like “I did need to re-set the rights”) which make me suspect something is still not right.

You need to achieve exactly and surely this:

  • the web server user name is X
  • the files and directories are all chown’ed to X
  • the crontab that runs cron jobs is X’s crontab, not the crontab of another user.

If you’re getting permissions’ degradation (you set things right, they become wrong afterwards) one of these things isn’t right.

Maybe this will help
https://docs.suitecrm.com/blog/scheduler-jobs/

About the migration, have you made the versions on the two servers match?

The index is OK.
It was me, doing a wrong search, i.e. %carp doesn’t find carparts, I do need to enter the full word, like %carparts before it show.
Somehow I thought this worked earlier with the short version, or like this %carp%. No diffrence in result with 1 or 2 % signs.

About the migration, no the version don’t match, on my test host I have 7.10.6, but on the original host I can’t the upgrade to work, it is stuck at 7.8.20.
But why do I need the orginal host data? All I need is in the test host on the latest version.
Can I just delete all files and move the others from the test host? Then export en import the DB?

The DB in 7.8 is not exactly the same as the DB in 7.10. It is the upgrade scripts that handle these differences.

  1. So you should install a clean 7.8.20 in your new server

  2. Migrate the database

  3. Upgrade to 7.10 on the new server

I think I need to make myself more clear.
The test host is already on v7.10. So if I like to move this good working set to my original host. I think I need to fresh install there v7.10 and then migrate the database. Or can I just copy all the files and folders with filezilla instead of the install?

Or maybe I just start using this host, but then I like to change the folder, can move the files 1 level higher? Like crm.domain.com/suitercrm to crm.domain.com, is that possible or do I need to change config somehow?

Thanks for all the effort so far, I’m getting real close to a final solution.

You were clear before :slight_smile:

What you want to do is not possible, you need to do what you don’t want to do, which is what I described above.

You can’t move 7.8 data into a 7.10, unless you do a much more tedious and risky process of exporting and importing individual tables, including relationship tables, while adapting to any structural changes. It’s really not worth it.

You said you couldn’t upgrade your 7.8.20, why is that? If you can solve that problem you will get more options.

I’m afraid there is a misunderstanding here.
My initial problem was that I got stuck on v7.8.20 because when I try to upgrade to v7.10 the setup wizzard did’nt get any further after uploading the upgrade package. Whatever I tried, rights, cache,… no luck.
So I started a new install of suitecrm 7.8.20 on a test server import my DB from the orginal and there I could do the upgrade to 7.10 without issues.

Now I would like to copy the working 7.10 on the test server to the orginal location where the non-upgradeable 7.8.20 still is.

Ok, I thought your 7.10 was a clean install without any data. If you imported all the data when it was still in version 7.8.10, then it should be ok - unless you have new data from this past week or so that you need to include? If you do, you’re back to the problem I was saying in my previous post.

There are two moves you can do with SuiteCRM

  1. Migration to a clean installation (this means merging database and custom files into a fresh SuiteCRM on a different server).
  2. Upgrade the server (this can only be done through upgrader scripts, never through simple file copy

So the rule is: you should never attempt the two at the same time. If you need both (go to a new server with a newer version), you have to do one first, until it’s successful, then the other. So you migrate the old version, and then upgrade OR you upgrade first, and then migrate it.

It seems you are asking about a third option

  1. Just move everything!

So are you ok to simply WIPE OUT what you have in the old server, and migrate all files and entire database, as it is now in the new server?

Yes my test server works fine and seems complete, altough I notice 1 glitch in the Lead view, the column E-mail shows the e-mail twice, first in bold red with the dotted line and immediatly there after a second time in normal text, with no space between the two.
Contact and Account view is OK with only the red email. I tried removing E-mail from the layout in Studio and then re-adding it but it stays the same.
Also I personalised the Lead Edit view and this modifactions seems lost and is back to standard now somehow. But that is a small thing to do over again.

So now I’m considering 2 options:

  1. Deleting the corrupt setup on the old server. Then moving the setup from the test server to the original location. Therefor I would erase all files/folders and DB on the old server and start a new fresh v7.10 setup (the same version as on the test server) and then migrating the DB.

  2. Forgetting the orginal server and keeping the setup on test server, all seems OK there. But ideally I like to move it to a folder higher up, now it is in crm.testdomain.be/suitecrm and I like to have it in crm.testdomain.be just like it was on the orginal server on another domain.
    Can I just the move the files/folders 1 folder higher?

About the folder locations of the files. Now on my test setup, Admin profile, tab Advanced, section calendar Options, I see the current folder location for Publish and iCal location. But I can’t change these fields, do I need to Reset User Preferences, in order to actualise these?

About the Email showing double, can you please post a screenshot? If you have trouble uploading here, use https://pasteboard.co

About moving to the old server, I probably don’t even have to install a fresh 7.10. there, you can simply move the entire SuiteCRM directory and the database, it should work.

Check config.php if you’re changing domain name (entries site_url and host_name)

You can move one level up, as long as you adjust settings on your Web server configuration accordingly. Don’t forget to set correct ownerships/permissions.

I’m not sure I understand your issue with the iCal folders, but that might be solved with what I said above regarding config.php entries.

thanks for tip on Pasteboard, not sure if the link shows directly here with the IMG tag?
I’ll will try the folder rmoving.