SMF Support > Install and Upgrade Help

SQL Problems

(1/1)

Travis:
With the file I downloaded, there seems to be a problem with the SQL. I couldn't get it uploaded, so I contacted the tech department and they couldn't get it uploaded either. I don't know what could have happened to it, but the file I downloaded as the file name of: smf_1-0-beta5p_install.zip
If someone has a undamaged SQL file for this, please contact me. I don't know what is wrong with it, but the SQL file is located at http://www.coconutproject.com/forums/smf_1-0.sql [nofollow]. Please help me!

Grudge:
Eh?

That sql file is completly fine - nothing wrong with it at all. Have you read the installation instructions? You don't need to do anything with the sql file - the install script does everything for you. Just run:

http://www.coconutproject.com/forums/install.php

and fill in all the details correctly. If you've already done that and you have problems you must have got an error during install. Check your database with phpMYAdmin to work out whether the tables were created - if not try install again.

Travis:

--- Quote from: Grudge on June 03, 2004, 06:27:43 PM ---Eh?

That sql file is completly fine - nothing wrong with it at all. Have you read the installation instructions? You don't need to do anything with the sql file - the install script does everything for you. Just run:

http://www.coconutproject.com/forums/install.php [nofollow]

and fill in all the details correctly. If you've already done that and you have problems you must have got an error during install. Check your database with phpMYAdmin to work out whether the tables were created - if not try install again.

--- End quote ---
I know there is a way with PHP to create the tables. Because this is what I always get when I try to upload the file in phpMyAdmin:
Database coco563_smf running on localhost
Error

SQL-query : 

CREATE TABLE {$db_prefix}attachments(

ID_ATTACH int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
ID_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER int( 10 ) unsigned NOT NULL default '0',
filename tinytext NOT NULL default '',
size mediumint( 8 ) unsigned NOT NULL default '0',
downloads mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( ID_ATTACH ) ,
KEY ID_MSG( ID_MSG ) ,
KEY ID_MEMBER( ID_MEMBER )
) TYPE = MYISAM

MySQL said:


#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(11) unsigned NOT NULL

I am about ready to find some place that will host one for me for free. This is really getting me ticked off!!

Ben_S:
Yes but you aren't supposed to upload the sql dump like that, the install file sets it up how it's supposed to be.

Navigation

[0] Message Index