Errors after installation on Windows 7

[bethendo]

I’m new to SuiteCRM and have just installed it on my Laptop running Windows 7 so I can evaluate its capabilities.
When I sign in I got lots of error and warning messages.

On the home page I get the following:

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109

Followed by messages in my dashboard…

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 103
Notice: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php on line 109

When I go to my profile I get:

Notice: Use of undefined constant JSON_LOOSE_TYPE - assumed ‘JSON_LOOSE_TYPE’ in C:\xampp\htdocs\suitecrm\include\SugarEmailAddress\SugarEmailAddress.php on line 914
Notice: Use of undefined constant JSON_LOOSE_TYPE - assumed ‘JSON_LOOSE_TYPE’ in C:\xampp\htdocs\suitecrm\include\utils.php on line 3990
Notice: Use of undefined constant JSON_LOOSE_TYPE - assumed ‘JSON_LOOSE_TYPE’ in C:\xampp\htdocs\suitecrm\include\ytree\Tree.php on line 76
Notice: Use of undefined constant JSON_LOOSE_TYPE - assumed ‘JSON_LOOSE_TYPE’ in C:\xampp\htdocs\suitecrm\include\SugarEmailAddress\SugarEmailAddress.php on line 914

When I go to set currencies I get:

Warning: A non-numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListView.php on line 1605
Warning: A non-numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListView.php on line 1605

If I try to replace the logo the system just hangs.

If I go t0 Marketing Home I a window tells me that “an error has occurred” containing the following messages:

Notice: Use of undefined constant JSON_LOOSE_TYPE - assumed ‘JSON_LOOSE_TYPE’ in C:\xampp\htdocs\suitecrm\include\utils.php on line 3990
{“content”:"
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 103</b>
\n
\nNotice</b>: A non well formed numeric value encountered in C:\xampp\htdocs\suitecrm\include\ListView\ListViewSmarty.php</b> on line 109</b>
\n

And a similar occurrence with whatever I open.

I’ve installed SuiteCRM 7.9.5
and XAMPP which includes: Apache 2.4.27, MariaDB 10.1.26, PHP 7.1.8, phpMyAdmin 4.7.0, OpenSSL 1.0.2, XAMPP Control Panel 3.2.2, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.56 (with mod_proxy_ajp as connector), Strawberry Perl 7.0.56 Portable

Any suggestions as to where I’ve gone wrong.
Thanks.

[pgr]

XAMPP is especially picky about these things.

These messages can (and should!) be turned off by setting display_errors to off in your php.ini file

[bethendo]

Thank you for that. All the messages have gone though I must admit seeing them undermined my confidence in the system

However, when changing the logo via Admin >> System Settings the system just hangs after I’ve selected the replacement.

Also, I didn’t notice it before, but I get logged out very quickly due to inactivity.

[pgr]

Try checking your logs for ERROR or FATAL messages at the time of those failures. Normally you can disregard NOTICE and WARNING without any problems.

There are also php.ini settings that you could check and increase generously:

memory_size
max_execution_time
max_upload_size

[bethendo]

Thank you.

I’ve checked suitecrm.log and found a number of fatal errors. In particular, the last 3 were in quick succession and were I had restarted my system to check if my changes to php.ini had stopped the errors showing. There weren’t any occurrences of this particular error before I made these changes.

Fri Sep 15 18:56:30 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: 127.0.0.1 CLIENT IP: ::1
Fri Sep 15 19:01:07 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: ::1 CLIENT IP: 127.0.0.1
Fri Sep 15 19:04:51 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: ::1 CLIENT IP: 127.0.0.1

I couldn’t find a php_errors.log

[pgr]

Maybe this will help you find it:

https://stackoverflow.com/questions/3719549/where-does-phps-error-log-reside-in-xampp

[bethendo]

Found it. and spotted a logo-related error at the end.

I’m assuming that php_error.log records times as GMT whereas suitecrm.log records in BST

The 18:32:34 timestamp only occurs in php_error.log

[Fri Sep 15 18:05:23.788158 2017] [php7:notice] [pid 3712:tid 1620] [client ::1:49400] PHP Notice: Undefined index: LOGIN_LOGO_ERROR in C:\xampp\htdocs\suitecrm\modules\Users\Login.php on line 120, referer: http://localhost/suitecrm/index.php?module=Configurator&action=EditView
[Fri Sep 15 18:32:34.128041 2017] [php7:notice] [pid 3712:tid 1620] [client ::1:49506] PHP Notice: Undefined index: LOGIN_LOGO_ERROR in C:\xampp\htdocs\suitecrm\modules\Users\Login.php on line 120, referer: http://localhost/suitecrm/index.php?module=Configurator&action=EditView

Do you have any idea what the problem might be?

[pgr]

Check your php.ini for this setting also:

date.timezone

it’s important to have that setting correct. Search online for possible values.

While you’re still getting your PHP straight, I wouldn’t worry about the logo if I were you. That’s just a notice, and it could be caused simply by a jpg or gif format that SuiteCRM is not handling well.

To begin, it’s more important to make sure the environment is behaving like it should, no blank screens, no error messages to the user, working scheduler jobs, working email (if you need it), etc.

SuiteCRM is far more tested and used in Linux than on Windows, and it seems XAMPP users always have a few initial problems. But it should work fine after some work tweaking everything…

[bethendo]

Thank you for your help.

I’ve changed the timezone from…
date.timezone=Europe/Berlin
to…
date.timezone=Europe/London

I can also confirm that trying to change the Logo was causing the premature time-out as I’ve been logged in for ages, seemingly without any problems, as I haven’t been back to that page.

And yes, you are quite right about the relative unimportance of the logo, I was only pursuing it because it was an error and I thought resolving it might resolve some other stuff too.

[bethendo]

When working with employee records I get this error message…

Your session was terminated due to a significant change in your IP address. Return to Home

Return to Home is a URL which takes me back to the sign on page coz my session has expired.

C:\xampp\htdocs\suitecrm\error.log looks like this. As you can see, it has happened several times.

Sat Sep 16 00:33:30 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: 127.0.0.1 CLIENT IP: ::1
Sat Sep 16 00:40:13 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: ::1 CLIENT IP: 127.0.0.1
Sat Sep 16 00:41:45 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: 127.0.0.1 CLIENT IP: ::1
Sat Sep 16 00:42:59 2017 [3712][1][FATAL] IP Address mismatch: SESSION IP: ::1 CLIENT IP: 127.0.0.1

Any advice?
Thanks.

[pgr]

I’ve never seen this happening, but “127.0.0.1” means “localhost” in IPv4, and “::1” means “localhost” in IPv6. Both are the network address that designates your own machine. For some reason, the system is alternating between one and the other, thus giving that error.

You can disable IPv6 on your computer.

You can try using your LAN IP address instead, something like 10.0.0.33 or 192.168.0.4 (you can find your network address with running ipconfig on a command-line, but it might change).

You can check what you have in SuiteCRM’s config.php, under ‘site_url’ and ‘host_name’. I don’t know if changing that might affect this problem or not.

[bethendo]

Thanks for your reply. After posting, I gave up for the night and switched off!

I tried again this morning, with a re-booted PC and added some employee records and then it happened again.

This time I didn’t reboot but used the XAMPP control panel to stop Apache and MySQL and then restarted them.

I went back to the employee records again and deleted all the employees that had got loaded as part of the installation process and played around with the ones that I’d added. No problems!

Next I started playing with products and I’m delighted to say that the problem hasn’t re-occurred.

I’m still none the wiser as to what happened. Could it have been the data?

[pgr]

Every fatal error you had in your logs means that SuiteCRM stopped in the middle of something it was doing. It’s possible (though not very usual) that some data corruption might have crept into those specific records. Don’t worry about it, if it seems to be fixed now.

But do check those config.php items I mentioned.

[bethendo]

OK, I’ve been spending some time playing with SuiteCRM installed on Windows 7.

I’ve found the following glitches and am wondering if they are down to ‘features’ of my installation on Windows or they represent bugs in SuiteCRM. If the former I’d appreciate being pointed in the right direction and if the latter then who and how do I report this to.

The date format defined in Admin >> Locale doesn’t get applied when displaying dates in Accounts, Contacts, Leads and Opportunities. In fact I haven’t seen it applied anywhere apart from the Locale setting.

When changing company logo in Admin >> System Settings the following message occurs:
The file format of the image must be JPEG or PNG. Upload a new file with the file extension .jpg or .png.
However, the extension name does have a .png extension.
This is an improvement to what I was experiencing yesterday when trying to do this was producing a FATAL error

On Create Contact, the following fields don’t have a label associated with them, the field name shows instead:
LBL_PRIMARY_STREET:
LBL_ALT_STREET:

Ditto on Edit Contact.

Ditto on Create Lead.

Ditto on Edit Lead.

Thanks.

[bethendo]

I checked out SuiteCRM’s config.php as suggested and found…

line 93
‘db_host_name’ => ‘localhost’,

line 357
‘site_url’ => ‘http://localhost/suitecrm’

Do you see anything sinister there?

[bethendo]

I had a quick look at the demo system (https://suitecrm.com/demo) and discovered that the field names display instead of the labels for Create Contact, Edit Contact, Create Lead and Edit Lead. Although this is straightforward to put right I would have thought it’s something that would be best done to SuiteCRM itself rather than it having to be done after each install by the installer.

[pgr]

Windows installations are a bit trickier but eventually when you get them working they should be exactly as functional as the rest. Your Windows system is not supposed to be “under suspicion” for ever.

If you have bugs to report you can open an issue on GitHub:
https://github.com/salesagility/SuiteCRM/issues

… but usually it’s better to sort things out here in the forums, like you’re doing, before going there. You have to be sure it’s a bug for the developers to handle when you post there.

The date format: you might try a Admin / Quick Repair and Rebuild. In Linux normally you have to set the timezone in TWO php.ini’s, one for CLI (command-line) and one for Web server. I thought that wasn’t necessary in Windows, but if you find more than one php.ini in your system, set that one also.

The missing labels are, I believe, a bug introduced very recently in 7.9.5. That release eliminated about 8000 unused strings to simplify the job of the translators. It seems about half a dozen weren’t supposed to have been eliminated, and people are getting those errors (specifically, those STREET labels). So keep cool and wait for the next version with fixed labels. In general, if you want a more conservative experience with SuiteCRM, stay away from any recent versions, choose Long Term Support (LTS) versions.

For the logo, search for threads here in these forums about that. I seem to remember PHP is a little picky about image formats, so one JPG can work and other one won’t. It depends on resolution, size, compression, etc. I solved this for myself by starting with an image that works, editing it to become my logo, saving it without any format changes.

But you could also be having permissions problems when uploading any image. Try uploading an employee photo and see if it works. If it doesn’t, give write permissions to the web server user on the appropriate directories, namely “upload”.

Finally, the site_url settings. You can use localhost for now, for your tests. Some things won’t work: when SuiteCRM sends out an email with a notification (meeting reminders, record assignments, etc.) it includes a link back to the record. The link will use “localhost”, so it will only work in your computer. When you go live with your system, you need to have a proper URL there (www.mycompany.com"). Basically, when you see broken links in the app, with “localhost” in them, you know where that’s coming from

Good luck.

[bethendo]

Thank you, again, for your reply.

I’ve gotta come clean with regard to the dates. My misunderstanding entirely! I had changed the global setting for displaying dates but not the setting for each user. Doh!

Not a big deal on the logo. I’ve cheated by replacing the SuiteCRM logo file with one of my own, just to create a good impression for demoing purposes. I was successful when uploading my own picture to my profile.

Thanks for the explanation on the missing labels.

Regarding site_url settings, if the evaluation is successful, we’ll probably go to Salesagility for a hosting solution. So not anticipating any problems there but we willll be in there hands with regard to what release is installed and when. I’m pleased to say that there haven’t been any more stability problems.

[bethendo]

OK, an update on the IP Address issue.

I had a lot of problems with this today. Using the XAMPP control panel to stop Apache and MySQL and then restarting them didn’t work and neither did rebooting the system.

So what was different today to other days when I didn’t hit the problem? Then it dawned on me that on other days I already had a browser tab open before I opened a browser tab for SuiteCRM. And what do you know, I haven’t hit the problem since. By the way I’m using Thunderbird as web browser.

Just thought I’d post this in case anyone else hits this problem. I know it doesn’t fix it but its a very easy work-around.

[pgr]

Thunderbird, the email program? Do you mean Firefox?

Well, SuiteCRM is supposed to work perfectly no matter how many tabs you had open before, and how many SuiteCRM tabs you open simultaneously, or how many other tabs you open afterwards.

There is something curious about your configuration, maybe network config, maybe antivirus or browser config (like any private mode that separates sessions or isolates sessions)?