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...!