Uutiset:

Wondering if this will always be free?  See why free is better.

Main Menu
Advertisement:

Installation Error

Aloittaja Borboco, helmikuu 14, 2011, 08:26:55 IP

« edellinen - seuraava »

Borboco

Hello,

Forgive my translation and to use google translator.

My problem arose after the first step to Intal, the strange thing is that I use the last xamp and I think it meets the requirements of mysql and php simplemachine calling.

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.

anyone know I have to do? or fix it?

Borboco

#1
anyone know how I fix it?
Forum saw several with the same problem but no one leaves a fix


when I import the database that comes with the pack, I get this


Error

consulta SQL:

#### ATTENTION: You don't need to run or use this file! The install.php script does everything for you!
#
# Table structure for table `attachments`
#
CREATE TABLE {$db_prefix}attachments(
ID_ATTACH int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
ID_THUMB int( 10 ) unsigned NOT NULL default '0',
ID_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER mediumint( 8 ) unsigned NOT NULL default '0',
attachmentType tinyint( 3 ) unsigned NOT NULL default '0',
filename tinytext NOT NULL ,
file_hash varchar( 40 ) NOT NULL default '',
size int( 10 ) unsigned NOT NULL default '0',
downloads mediumint( 8 ) unsigned NOT NULL default '0',
width mediumint( 8 ) unsigned NOT NULL default '0',
height mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( ID_ATTACH ) ,
UNIQUE ID_MEMBER( ID_MEMBER, ID_ATTACH ) ,
KEY ID_MSG( ID_MSG )
) ENGINE = MYISAM ;

MySQL ha dicho: Documentación
#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 '{$db_prefix}attachments (
  ID_ATTACH int(10) unsigned NOT NULL auto_increment,' at line 7

JimM

You might try installing xampplite.  It's a stripped down version of xampp that works great for a local install of SMF.
Jim "JimM" Moore
Former Support Specialist

Advertisement: