My Sql Error after uploading - Need help regarding to this sql file

Chatz

Jul 18 2006, 12:08 PM

Ive uploaded this sql file to my database but it seems to have an error which i cant find.please help me find the error.The eroor says:

QUOTE

SQL query:

UNIQUE KEY id( id )
) 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 'UNIQUE KEY id (id)
) TYPE=MyISAM' at line 1

SQL FILE

CODE

CREATE TABLE banned (
  username varchar(16) NOT NULL default '',
  reason varchar(100) NOT NULL default '',
  banner varchar(16) NOT NULL default ''
) TYPE=MyISAM;

CREATE TABLE buddylist (
  id bigint(6) NOT NULL auto_increment,
  username1 varchar(13) default NULL,
  username2 varchar(13) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE chat (
  id bigint(12) NOT NULL auto_increment,
  username varchar(14) NOT NULL default '',
  type tinyint(7) NOT NULL default '0',
  towhere varchar(15) NOT NULL default '',
  message varchar(170) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE chatusers (
  id mediumint(5) NOT NULL auto_increment,
  username varchar(15) NOT NULL default '',
  where_they varchar(15) NOT NULL default '',
  time varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE devices (
  id mediumint(7) NOT NULL auto_increment,
  deviceid varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE forum (
  id mediumint(4) NOT NULL auto_increment,
  username varchar(10) default NULL,
  date datetime default NULL,
  lastreply datetime default NULL,
  reply_amount smallint(5) unsigned default NULL,
  subject varchar(20) default NULL,
  message varchar(150) default NULL,
  forum varchar(40) default NULL,
  haspoll varchar(5) NOT NULL default 'no',
  pass varchar(22) NOT NULL default '',
  choices varchar(8) NOT NULL default '',
  views varchar(5) NOT NULL default '0',
  locked tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE forumindex (
  id mediumint(5) NOT NULL auto_increment,
  forum varchar(10) NOT NULL default '',
  position smallint(3) NOT NULL default '0',
  access char(2) NOT NULL default '',
  display varchar(20) NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM;

CREATE TABLE forumpoll (
  id mediumint(10) NOT NULL auto_increment,
  question varchar(200) NOT NULL default '',
  choice1 varchar(50) NOT NULL default '',
  choice2 varchar(50) NOT NULL default '',
  choice3 varchar(50) NOT NULL default '',
  choice4 varchar(50) NOT NULL default '',
  choice5 varchar(50) NOT NULL default '',
  result1 varchar(6) NOT NULL default '',
  result2 varchar(6) NOT NULL default '',
  result3 varchar(6) NOT NULL default '',
  result4 varchar(6) NOT NULL default '',
  result5 varchar(6) NOT NULL default '',
  pass varchar(22) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE highest (
  id char(3) NOT NULL default '',
  highest mediumint(4) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE hits (
  page varchar(15) NOT NULL default '',
  hits mediumint(23) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE ignorelist (
  id mediumint(6) NOT NULL auto_increment,
  username1 varchar(13) default NULL,
  username2 varchar(13) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE inbox (
  id mediumint(200) NOT NULL auto_increment,
  from_who varchar(12) NOT NULL default '',
  to_who varchar(12) NOT NULL default '',
  title varchar(15) NOT NULL default '',
  message blob NOT NULL,
  been_read varchar(5) NOT NULL default 'no',
  archive varchar(5) NOT NULL default 'no',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  password2 varchar(12) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE latest (
  ip varchar(15) NOT NULL default '',
  time int(15) NOT NULL default '0',
  cameonline int(15) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE members (
  id mediumint(7) NOT NULL auto_increment,
  username varchar(10) NOT NULL default '',
  password varchar(10) NOT NULL default '',
  owner tinyint(2) NOT NULL default '0',
  admin tinyint(2) NOT NULL default '0',
  stars tinyint(2) NOT NULL default '0',
  forumadmin tinyint(2) NOT NULL default '0',
  banned tinyint(2) NOT NULL default '0',
  phone varchar(120) NOT NULL default '',
  subno varchar(90) NOT NULL default '',
  registerdate datetime NOT NULL default '0000-00-00 00:00:00',
  lastloggedin datetime NOT NULL default '0000-00-00 00:00:00',
  lastpost varchar(15) NOT NULL default '',
  email varchar(30) NOT NULL default '',
  validation tinyint(2) NOT NULL default '0',
  fp tinyint(2) NOT NULL default '0',
  ban tinyint(2) NOT NULL default '0',
  unban tinyint(2) NOT NULL default '0',
  deletem tinyint(2) NOT NULL default '0',
  deletepms tinyint(2) NOT NULL default '0',
  pass tinyint(2) NOT NULL default '0',
  pmname varchar(15) NOT NULL default 'P.M',
  buddyname varchar(10) NOT NULL default 'Buddy',
  validated varchar(4) NOT NULL default 'no',
  visit mediumint(22) NOT NULL default '0',
  device varchar(10) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY username (username)
) TYPE=MyISAM;

CREATE TABLE mood (
  id mediumint(6) NOT NULL auto_increment,
  username varchar(14) default NULL,
  mood varchar(50) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE notify (
  id mediumint(10) NOT NULL auto_increment,
  username1 varchar(17) NOT NULL default '',
  username2 varchar(17) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE outbox (
  id mediumint(200) NOT NULL auto_increment,
  from_who varchar(12) NOT NULL default '',
  to_who varchar(12) NOT NULL default '',
  title varchar(15) NOT NULL default '',
  message blob NOT NULL,
  been_read varchar(5) NOT NULL default 'no',
  archive varchar(5) NOT NULL default 'no',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  password2 varchar(12) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE privatemessage (
  id bigint(6) NOT NULL auto_increment,
  to_username varchar(11) default NULL,
  from_username varchar(11) default NULL,
  date_sent datetime default NULL,
  has_it_been_read varchar(16) default NULL,
  pm_message varchar(200) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE profile (
  id mediumint(7) NOT NULL auto_increment,
  username varchar(10) NOT NULL default '',
  name varchar(10) NOT NULL default '',
  age smallint(3) NOT NULL default '0',
  sex varchar(7) NOT NULL default '',
  location varchar(12) NOT NULL default '',
  about varchar(200) NOT NULL default '',
  picture varchar(100) NOT NULL default '',
  onlinetime bigint(255) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE replies (
  id bigint(4) NOT NULL auto_increment,
  subject_id varchar(10) default NULL,
  username varchar(15) default NULL,
  date datetime default NULL,
  reply_number smallint(5) unsigned default NULL,
  message varchar(150) default NULL,
  forum varchar(40) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE shoutbox (
  id tinyint(4) NOT NULL auto_increment,
  name varchar(10) default NULL,
  message varchar(150) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

Using proper bbcode is part of Trap17 forum rules. Next time will result in warning.

farsiscript

Jul 23 2006, 08:30 AM

hi dear Chatz
i think at banned tabel you dont have a UNIQUE KEY id its your code

CODE

CREATE TABLE banned (
  username varchar(16) NOT NULL default '',
  reason varchar(100) NOT NULL default '',
  banner varchar(16) NOT NULL default ''
) TYPE=MyISAM;

change it to this :

CODE

CREATE TABLE banned (
  id bigint(6) NOT NULL auto_increment,
  username varchar(16) NOT NULL default '',
  reason varchar(100) NOT NULL default '',
  banner varchar(16) NOT NULL default ''
) TYPE=MyISAM;

Have good time

Similar Topics

Keywords : sql error uploading sql file

Wordpress Error - Bytes Exausted - NextGEN Gallery (0)
Phpbb3 - Error 28 - (5)
I get the following error when I try changing a users group of my Phpbb3 powered forums. QUOTE
SQL ERROR Got error 28 from storage engine SQL SELECT ug.*, g.* FROM groups g, user_group ug
WHERE ug.user_id = 83 AND g.group_id = ug.group_id ORDER BY g.group_type DESC, ug.user_pending ASC,
g.group_name BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE:
includes/acp/acp_users.php LINE: 1881 CALL: dbal_mysql->sql_query() FILE:
includes/functions_module.php LINE: 471 CALL: acp_users->main() FILE: adm/index.php LINE: 74 CALL:
p_master->l...

My File Manager Is Working - (2)

I tried to change the html for my site in file manager but it just has the default page - the one
when you activate your site. /sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' />
How do i change files?...

Error 28 (on Phpmyadmin) - What does this error message mean? (6)

I have a shopping cart system on my website. It always worked before, but all of a sudden, when I
try to access it i get "Got error 28 from storage engine". Has that got something to do with the
recent problems again, or can someone tell me what this error message means? Thanks. After posting
this I noticed I cannot get into my PHPAdmin anymore. It gives loads of errors: QUOTE Warning:
session_write_close() : SQLite: session write query failed: database is full in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: session_write_close() :
Fai...

Page Load Error When Accessing Cpanel - (0)

Not sure what the issue is. I cannot even load up any of the cpanel's to allow me to put in a
password. I have tried the link that is located in the Credit System 2.0 I have tried the links
with subdomain/cpanel I have tried the links with subdomain:2082 All 3 of these just give page
load errors. Please note : This isn't a "my password doesn't work" thread. This is a "I
can't even get cpanel to TRY to load" thread. Thanks in advance....

Coppermine Gallery Error - (2)

Okay.. so i have my gallery set up at photos.chantellepaige.org and everytime i try to access it i
get this error "Coppermine critical error: Unable to connect to database ! MySQL said: Access
denied for user 'giselle_copp1'@'localhost' (using password: YES)" how do i change
the password etc?? or fix the problem??...

File Manager Not Working - (2)

When I goto upload files using the file manager(legacy mode), the files do not upload correctly.
Every time I try to upload a file, it takes the time to upload it, but the file always comes out
being 0kb so it does not upload the file. Why is this happening?...

Error Code In Subscriptions Page - problems subscribing to topics (5)

I'm seeing some weird warning message show up at the top of my page when I go into "my
controls," then load my topic subscriptions page. At the top of the page, the following code appears
several times: IPB WARNING in_array() : Wrong datatype for second argument (Line: 2711 of
/sources/action_public/usercp.php) I'm guessing maybe that has something to do with the fact
I'm having problems subscribing to my topics and posts? Thanks in advance for your help....

Issues Uploading A File [resolved] - (3)

Hi there. I have been trying to upload a zip file only about 2mb to my account through CPanel.
First I tried uploading it to a new folder in public_ftp. Then i tried to put it in the main part
of public_ftp. I also tried the same thing in public_html. It shows the file being uploaded, and i
get 100 %, but alas, when i look in the folders nothing is there. Is there a restriction on .zip
files? I have had no problems as of yet uploading htm and html pages. Please let me know ASAP.
Thank you....

Unable To Replace .png File In Directory - Can't even delete it using Cpanel (7)

I can't delete a little file using file manager in Cpanel. I'm trying to delete a .png
image, actually, I'm trying to replace it. The response comes back as a success, but when I
reload my site it's still there. Then I go back to the file manager and go up a level, then back
and WOOP! There it is! I'm beyond frustrated here. What is going on?...

How Do I Make A (video) File Smaller? - (11)

Ok, I want to host a video that I have in my computer, but the problem is that the video is too
big, 790MB. My host can't handle a file that huge so I was wondering if there is any way I can
make the video file in my computer smaller? I don't want to mess up the video and make it
smaller, I was wondering if I can keep the current 790MB video that I already have but copy only
about 10MB of the video into a new file that I can use for hosting. Anyone know?...

403 Forbidden Error When Accessing My Site - (10)

umm this is a problem that i have been looking in other topics to try to fix but i can't seem to
find a answer to what i lookin for. I got my site workin again the other day ok and so i went on to
see it (so i can make more changes) and when i got there i got this QUOTE Forbidden You
don't have permission to access / on this server. Additionally, a 403 Forbidden error was
encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.33 Server at
www.clansga.trap17.com Port 80 now i looked at everything and i can't seem to find t...

Phpmyadmin Error [resolved] - (7)

I get this error message each time I attempt to work phpMyAdmin. QUOTE Cannot start session
without errors, please check errors given in your PHP and/or webserver log file and configure your
PHP installation properly. Help would be very grateful....

Phpmyadmin Error - Not able to enter PhpMyAdmin (4)

Currently I try to access my PhpMyAdmin and I get the following error displayed among the screen:
My PhpMyAdmin worked prior the migration but suddenly stopped working after. I wanted to know if
anyone else is getting this error also or anyway can help me fix this o.o....

Cannot Delete Folder After Lost Ftp Connection - permission not given to delete file (7)

hello, well i had created a subdomain and was transferring files into the folder i was disconnect
from the server many times while uploading the files via ftp once when i reconnect, i saw a file
with an unusual name something starting with preftp... i tried deleting the file, but it said that
permission was not granted to do that i tired deleting the complete folder and also tried deleting
the subdomain from the cpanel but it was of no use can anyone help me with this? thx for your time
Modified topic title. ...

Ftp Problem - zero file-length? (8)

I'm using FileZilla right now, and trying to upload a second copy of WordPress onto the account
to use as a comic repository. For some reason, a lot of the files are missing, and when I look into
the folders, I see that a lot of the files have a filelength of 0. What gives? Could someone
please help me out?...

Mysqli Error - Phpbb3 - (3)

Ok, my forum (phpbb3) works but sometimes it displays this message CODE General Error SQL ERROR
[ mysqli ] Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) [2002] An sql error occurred while fetching
this page. Please contact an administrator if this problem persists. This normally happens about
once a week for about 2 minutes but it is really getting annoying. I installed phpbb3 fine, it
didn't show any errors. But the main thing is that before this happens normally I can't
connect...

Parse Error: Syntax Error, Unexpected '<' On Line 29 - (11)

ok when i try and access the page i want, iget the following error: Parse error: syntax error,
unexpected ' however, my page looks like this: QUOTE // Connects to your Database
$username = "evolved_creation"; $password = "mypasswordishere"; $hostname =
"localhost"; $dbh = mysql_connect($hostname, $username, $password) or
die("Unable to connect to MySQL"); $selected =
mysql_select_db("evolved_clancreation",$dbh) or die("Could not connect to DB");
mysql_close($dbh); //checks cookies to make sure they ar...

Keep Getting Socket Error - mail won't send. (3)

When trying to send email, I keep getting a socket #10061 error. I use the Trap 17 smtp server,
related to my own domain, which is mail.vlaanderen-flanders.org.uk. This seems to be happening
regularly lately. Has anyone got any idea why this could be happening? Thanks for any support. ...

/tmp Folder In File Manager - (4)

I know awhile back there was a question brought up about the /TMP folder taking up space, and if
anyone remembers that topic do you remember if TMP was an acronym for temporary, and can you safely
delete the contents in that folder? Right now I am cleaning out my hosting account and the files in
that folder are the only ones taking up space at the moment....

Email Creation Error - Not receving emails, can't create new account (3)

Hi, When I try to create an email account in the CPanel, I get this error QUOTE The e-mail
account xxxxxxxx@ wildcatexotics.com with the login Sorry, you have exceeded the maximum allowed
email accounts. and password xxxxxxxx with a quota of unlimited megabytes was successfully created.
Can anybody help me out? And also My default email account is xxxxx@xxxx.com, but when I sent
myself an email from another account, I didn't receive any. Thank you...

Got A Great Phpbb File With Mods Already Installed? - If you do put it here. (3)

As the name implies, I think it would be a good idea to giving those who aren't really "mod
savvy" a chance to look at what phpBB's could look like with some regular mods installed. If
this thread is innappropriate I'll be glad to delete it away or rather, I give permission to
have it deleted if it isn't appropriate....

Help: Internet Server Error - (20)

Hello! I decided to try YaBB as a forum now, just testing....and ... Well first my question is,
this is in ADDONSCRIPTS, not FANTASTICO, whats the difference? Secondly, about my problem: I was
in the YaBB admin panel, I got through the Forum Settings, got to Advanced settings, filled out the
info, and pressed save. The 5000 times I have tried this, I get this: QUOTE Internal Server
Error The server encountered an internal error or misconfiguration and was unable to complete your
request. Please contact the server administrator, webmaster@sherwoodinfo.trap1...

Error During Upgrade [resolved] - Xisto tells me to contact Admin (3)

While trying to upgrade my hosting account (I got an email I was approved), I encountered the
following: When I clicked on the link in my confirmation email, I was taken to the Xisto menu page,
where I selected "Upgrade your hosting account". I was then asked to enter my forum username and
password, and was then taken to the upgrade page, but almost immediately got the message: "There
were problems creating your account! Please Contact Administrator." Then, underneath, it said:
"Debug Info", followed by two lines with nothing in between them, and below the two lines ...

Suspended Account Error [resolved] - (12)

OK, my hosting account was upgraded so my hosting credits were set to 0. I went to stay with my
sister for a couple of days and when I got back I had -4 hosting credits and my account was
suspended. I've now got 6 hosting credits. My main site is working but all of the addon
domains I added go to the Suspended Account Page. What do I do???...

Help! Forum Error Please Reply - (4)

I'm very sorry for making so many topics, but just now I can't get to my forum because of
this! QUOTE Fatal error: Cannot redeclare addlinenumbers() (previously declared in
/home/omega/public_html/Sources/Subs.php:3671) in /home/omega/public_html/Sources/Subs.php on line
3721 Help me please! (PS: sorry for being so dumb)...

File Permissions And Umask Question ?help Pleases - file permissions and umask question ??help pleases (2)

when i create new file using ftp or the file manger the file get the default permission of (rwx-r-r)
when any php script create file it gets the sam permission right but i cant edit any new file crated
by the php script i cant even Chang the permissions for it i have to delete the file and create new
one why ???? and if the new file was a folder i cant edit any thing inside of it and how can i fix
this??? I'm fumler with the file permissions cause i use Linux debian /biggrin.gif"
style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" /> i just don...

Installing Joomla And Shell Question - i get error when i trayed to install joomla i get some (0)

i get error when i trayed to install joomla about the default premising check this out i have set
the file premising to 777 and to 755 and the same problem what to do where to fix this
http://zam.trap17.com/earn-money/installation/index.php and in my hosting plans i did see shell
access but i cant it at my cpanel why ??? ---UPDATE--- will i have been able to install joomla
thanks but i still asking about the shell account double post merged ...

Uploading Files And Connecting To Ftp - using WsFtppro (27)

The fastest, most reliable way to upload or download files is through FTP. If you don't already
have your own Web page, read our reviews of over 80 free Webhost. If you don't have an FTP
client, Download WS_FTP Pro now. Step 1 - Connect your computer to the Internet. Step 2 - Launch
WS_FTP Pro by clicking on the WS_FTP Pro icon that's on your desktop. If you do not have a
WS_FTP Pro icon on your desktop, click on the Start button and then select Programs, then WS_FTP,
and then WS_FTP Pro. Step 3 - Connecting to an FTP site: When you open WS_FTP Pro, you&#...

File Transfer From Angelfire To Trap17? - P.S. I use my Wii. (1)

I'm wondering, how would I do this. Also, how would I install IPB or PHPBB3. I just have those
questions....

Looking for sql, error, uploading, sql, file

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE