[Solved] Unable to fix "system's timezone settings"

Frequently asked questions and solutions to common issues with IntraMessenger products. Please check here before posting a problem.

[Solved] Unable to fix "system's timezone settings"

Unread postby sai343 » Mon Apr 18, 2016 7:32 am

Hi Everyone,

I'm unable to fix this error "Strict Standards: date(): It is not safe to rely on the system's timezone settings." :(
I'm using version "IntraMessenger server (2.0.6.251) setup".
From below given link I have tried those steps but unable to fix it.
viewtopic.php?p=6606#p6606

Coming to the step 7 I clicked on "Update" option and it went to step 8 to "Create ACP administrator". By default Username was "admin" when I tried to update password and when I clicked on add button I'm getting this error "[ERR-P1c] Invalid request (Requ�te invalide) : Incorrect date value: '0000-00-00' for column 'ADM_DATE_LAST' at row 1"

Please help me out guys...!

Thanks in advance
Attachments
time zone error1.png
timezone error
time zone error1.png (232.57 KiB) Viewed 1927 times
sai343
 
Posts: 3
Joined: Sun Apr 17, 2016 2:36 pm

Re: Unable to fix "system's timezone settings"

Unread postby THeUDS » Tue Apr 19, 2016 8:41 pm

sai343 wrote:I'm unable to fix this error "Strict Standards: date(): It is not safe to rely on the system's timezone settings." :(
I'm using version "IntraMessenger server (2.0.6.251) setup".
From below given link I have tried those steps but unable to fix it.
viewtopic.php?p=6606#p6606

This message is always displayed (on install) to inform you IF it's happen...


sai343 wrote:Coming to the step 7 I clicked on "Update" option and it went to step 8 to "Create ACP administrator". By default Username was "admin" when I tried to update password and when I clicked on add button I'm getting this error "[ERR-P1c] Invalid request (Requete invalide) : Incorrect date value: '0000-00-00' for column 'ADM_DATE_LAST' at row 1"

This problem looks strange,
your serveur dont want default value '0000-00-00'.
Wich MySQL server version you have ?
User avatar
THeUDS
 
Posts: 2311
Joined: Fri Apr 15, 2005 6:56 pm

Re: Unable to fix "system's timezone settings"

Unread postby sai343 » Thu Apr 21, 2016 12:05 pm

Hi bro thank you very much for your reply I really appreciate :)
Before I answer about which sql I've used, I want to explain how I've installed intramessenger and what kind of issues I got and how I fixed them.

So please read my post and correct me if I made any mistakes while installing intramessenger.

http://localhost/intramessenger/install/install.php?
Till setp 5 everthing was correct..., coming to the next step..,

I've used intramessenger server (2.0.6.251) near "step 6: create tables" I got this error "[ERR-install_table-4] Invalid

request (Requ?te invalide) : Invalid default value for 'USR_DATE_CREAT'".
I got this above error becuase there were no tables in db intramessenger.
so, I imported install.sql file "loc: C:\wamp\www

\intramessenger\install\install.sql" on myphpadmin (web server Apache/2.4.17 (Win32) PHP/5.6.15, PHP extension: mysqli, PHP

version: 5.6.15 )
so I got this error after importing install.sql on phpmyadmin intramessenger(DB).

Error
Static analysis:

2 errors were found during analysis.

Unrecognized data type. (near "COMMENT" at position 544)
A comma or a closing bracket was expected. (near "=" at position 552)
SQL query:

CREATE TABLE IF NOT EXISTS IM_FLV_FILEVOTE ( ID_FILE MEDIUMINT UNSIGNED NOT NULL, ID_USER_VOTE MEDIUMINT NOT NULL,

ID_USER_AUT MEDIUMINT NOT NULL COMMENT 'For stats', FLV_DATE date NOT NULL, FLV_VOTE_M TINYINT NOT NULL COMMENT 'More',

FLV_VOTE_L TINYINT NOT NULL COMMENT 'Less', PRIMARY KEY (ID_FILE, ID_USER_VOTE), KEY FLV_IND_1 (ID_USER_AUT), CONSTRAINT

im_flv_filevote_fk1 FOREIGN KEY im_flv_filevote_fk1 (ID_FILE) REFERENCES IM_FIL_FILE (ID_FILE) ON DELETE NO ACTION ON UPDATE

NO ACTION, ) COMMENT = 'Share files votes'

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right

syntax to use near ') COMMENT = 'Share files votes'' at line 13

I came back to localhost and I have refreshed to check.. then I got like below error however remaining tables status was "OK"

Table IM_FLV_FILEVOTE : Not found !
Table IM_FST_FILESTATS : Not found !
Table IM_FSD_FILESTATSDOWNLOAD : Not found !
Table IM_ADM_ADMINACP : Not found !
Table IM_FIB_FILEBACKUP : Not found !

Then I opened install.sql file in notepad++ and fixed above issue by removing ",(Comma)" in table"IM_FLV_FILEVOTE" and I

have droped tables from phpmyadmin and I imported updated "install.sql".

Soon after that I got another error...

Error
Static analysis:

4 errors were found during analysis.

Unrecognized data type. (near "-" at position 364)
A comma or a closing bracket was expected. (near "FIB_PASSWORD" at position 365)
Unexpected beginning of statement. (near "32" at position 386)
Unrecognized statement type. (near "NOT NULL" at position 390)
SQL query:

CREATE TABLE IF NOT EXISTS IM_FIB_FILEBACKUP ( ID_FILEBACKUP INT UNSIGNED NOT NULL auto_increment, FIB_NAME VARCHAR(20) NOT

NULL, ID_USER MEDIUMINT UNSIGNED NOT NULL, FIB_ONLINE CHAR(1) NOT NULL, FIB_DATE_ADD date NOT NULL default '0000-00-00',

FIB_SIZE INT UNSIGNED NULL, FIB_HASH CHAR(32) NOT NULL, FIB_PROTECT VARCHAR(32) NOT NULL, --FIB_PASSWORD VARCHAR(32) NOT

NULL, --FIL_COMPRESS CHAR(1) NOT NULL, PRIMARY KEY (ID_FILEBACKUP), KEY FIB_IND_1 (ID_USER, FIB_ONLINE, FIB_NAME) ) COMMENT

= 'Files backup'

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right

syntax to use near '--FIB_PASSWORD VARCHAR(32) NOT NULL,
--FIL_COMPRESS CHAR(1) NOT NULL,
PRIM' at line 9

So, I removed those two lines which are inactive then did same as above droped and imported again.

then got this message
Import has been successfully finished, 28 queries executed. (install.sql)

This fixed step 6 and then went to step 7 there I have seen that error which I explained in my previous post "Strict

Standards: date(): It is not safe to rely on the system's timezone settings."

and in step 8 getting error "[ERR-P1c] Invalid request (Requ?te invalide) : Incorrect date value: '0000-00-00' for column

'ADM_DATE_LAST' at row 1" after giving password for default "username:admin".

As we know in ../intramessenger/install we have two .sql files but I have imported only one install.sql file I haven't

imported permissions.sql please advise

So here is what I'm using

my sql version 5.7.9
PHP version 5.6.15
Apache version 2.4.17

I hope above info will help you to give me good solution..
If I have done any mistakes please instruct me so that I can fix from scratch.

Thank you very much...!
sai343
 
Posts: 3
Joined: Sun Apr 17, 2016 2:36 pm

Re: Unable to fix "system's timezone settings"

Unread postby THeUDS » Thu Apr 21, 2016 9:07 pm

Thanks a lot !
You find/solve by yourself most of problem, very good !

So i update zip file for
/install/install.sql
/install/install.inc.php
/common/create_tables.inc.php
(i remove all comments, and the comma you find already)


For the problem [ERR-P1c]... Incorrect date value: '0000-00-00'
Could you change and try (into install.sql) all
Code: Select all
default '0000-00-00'
by
Code: Select all
default '1999-01-01'

(i think some server now don't want years before 1970)
(after drop all tables)



step 7 there I have seen that error which I explained in my previous post
"Strict Standards: date(): It is not safe to rely on the system's timezone settings."

I think it's just message (I put) to inform you before you get this error message...
But you can at end (before ?> ) of file /common/functions.inc.php
Code: Select all
date_default_timezone_set("Europe/Paris");

to manually force ("Europe/Paris" it's just an example)

(can exist already, just remove # on line begin)
User avatar
THeUDS
 
Posts: 2311
Joined: Fri Apr 15, 2005 6:56 pm

Re: Unable to fix "system's timezone settings"

Unread postby sai343 » Sun Apr 24, 2016 10:12 am

Hi Bro,

Thanks a lot for all your assistance... :D :D :D

Finally fixed all my issues and it is now working like a charm.. :)

This is how I fixed my issue

For the problem [ERR-P1c]... Incorrect date value: '0000-00-00'
Could you change and try (into install.sql) all
Code:
default '0000-00-00'
by
Code:
default '1999-01-01'

Steps I followed:-
Near /install/install.sql file --> I replaced all default '0000-00-00' to this default '1999-01-01' and I droped all my tables from phpmyadmin and uploaded this new install.sql file again and I reopened localhost from browser and followed those instructions and it worked for me.

Next coming to my another issue was "Strict Standards: date(): It is not safe to rely on the system's timezone settings."

I fixed this by going to php manual timezone official website http://php.net/manual/en/timezones.php#timezones first and then I have selected content as per my location then and I went back to ..common\functions.inc.php
and I commented this below lines
// if (function_exists('date_default_timezone_set'))
// {
// $fus = ini_get('date.timezone');
// if ($fus != "")
// date_default_timezone_set($fus);
// else
// date_default_timezone_set("Europe/Paris");
// }

Next I've selected only below line and I have updated with my location...

date_default_timezone_set("Europe/Paris");

and I refreshed my localhost page then all my errors gone.

Note: before fixing above issue (date.timezone) I got different time-zones in (ACP) "manage/check config !" page near 'Time' for "PHP Timezone & PHP Time" were different from "MySQL time" but after updating like above this issue has been fixed.

This all happened because of you bro THeUDS :D

Thanks a lot once again
have a nice day :)
sai343
 
Posts: 3
Joined: Sun Apr 17, 2016 2:36 pm

Re: Unable to fix "system's timezone settings"

Unread postby THeUDS » Sun Apr 24, 2016 8:50 pm

Thanks for your feed back !



(i will move soon this topic in "FAQ" area)
User avatar
THeUDS
 
Posts: 2311
Joined: Fri Apr 15, 2005 6:56 pm


Return to Frequently Asked Questions (FAQ)

Who is online

Users browsing this forum: No registered users and 1 guest

cron