after set the
Basic Setting and
MySQL Server Settings, the next page output is like this :
LainaaSome of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.
Technical information about the queries:
Line #563: 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 '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3
Click here to try this step again.
wondering what happen there, i've been check all the support system, repeating the first setting many times. but still installing just can't... need solution.
What version of MySQL is running on your server?
Also try here http://wiki.simplemachines.org/smf/Introduction_to_installing
and in particular
http://wiki.simplemachines.org/smf/Requirements_and_recommendations
Lainaus käyttäjältä: yakyakyak - kesäkuu 13, 2011, 10:10:10 AP
What version of MySQL is running on your server?
Also try here http://wiki.simplemachines.org/smf/Introduction_to_installing
and in particular
http://wiki.simplemachines.org/smf/Requirements_and_recommendations
I use MySQLi 5.5.8,
doesn't support???
even i've been checking SQL from
install_1-1.sql the line 563
LainaaCREATE TABLE {$db_prefix}log_online (
session varchar(32) NOT NULL default '',
logTime timestamp(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,
ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
ip int(10) unsigned NOT NULL default '0',
url text NOT NULL,
PRIMARY KEY (session),
KEY logTime (logTime),
KEY ID_MEMBER (ID_MEMBER)
) ENGINE=MyISAM;
the italic text is the problem, making me brain-tweaking on that line. damn i dont know what to do..... 8) haha, the script 8) just become a smiley
Please replace that line with:
logTime timestamp /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,
This should have been fixed already. What version of SMF are you trying to install, and/or what package for installation did you download please?
Lainaus käyttäjältä: Norv - kesäkuu 13, 2011, 10:33:15 AP
Please replace that line with:
logTime timestamp /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,
This should have been fixed already. What version of SMF are you trying to install, and/or what package for installation did you download please?
been download SMF 2.0 full install. why with that stuff??
SMF 2.0 full installation pack should not contain such file ("install_1-1.sql"), and it does not seem to contain it: I checked install zip archive from here: http://download.simplemachines.org/ and I don't see such file in it...
Is it possible you had an older install script on your server? Do you also have a file install_2-0_mysql.sql on your server?
Lainaus käyttäjältä: Norv - kesäkuu 13, 2011, 11:07:48 AP
SMF 2.0 full installation pack should not contain such file ("install_1-1.sql"), and it does not seem to contain it: I checked install zip archive from here: http://download.simplemachines.org/ and I don't see such file in it...
Is it possible you had an older install script on your server? Do you also have a file install_2-0_mysql.sql on your server?
I just use the localhost, still wanna learn to mange it <kind a testing>. how was that???
what is the exact name of the file you downloaded that you are using to install your forum?