hey as i am importing my sql i receive this error #1067 - Invalid default value for 'time_stamp' in my db time_stamp coding is time_stamp datetime default 'now()', so tell me guys what to do
Default values in MySQL must be constant - they cannot be functions or expressions that evaluate to anything. Consider using the timestamp type with the default set to 'CURRENT_TIMESTAMP'.
i changed it to time_stamp datetime default 'CURRENT_TIMESTAMP', but still same error i have attached the orignal database file if u u can see what is the problem in it and fix it then that would be great
You still haven't changed the data type of the field 'time_stamp'. Change line 18: time_stamp datetime default 'now()', Code (markup): To this: time_stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, Code (markup):
i only changed 'now()', to 'CURRENT_TIMESTAMP', before it was not working i didnt know that i had to replace the whole file and i did change it the file i attached was the orignal 1 in which i didnt change a thing and thanks mate now the sql has been imported thanx mate thanx gave u rep