October 22, 2020, 11:11:18 pm
News: IF YOU ARE A MEMBER FROM THE ORIGINAL SITE AND CAN'T LOGIN. POST IN THE FEEDBACK FORUM (AS GUEST) AND AN ADMIN WILL ASSIST YOU TO ACCESS THE SITE!
Pages: [1] 2   Go Down
Author Topic: Lost Topic Title  (Read 3147 times)
supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« on: October 11, 2004, 01:22:18 pm »


ERROR 1170 at line 8513: BLOB column 'passwd' used in key specification without a key length


I am using putty and a ssh connection to import a database onto the new server.
Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #1 on: October 11, 2004, 01:47:41 pm »

what is at line 8513?

The error message is pretty specific though - you have attempted to add a key without specifying its length.
Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #2 on: October 11, 2004, 01:53:11 pm »

Quote
what is at line 8513?

The error message is pretty specific though - you have attempted to add a key without specifying its length.
[snapback]119478[/snapback]
How do I find that out with out counting all the lines?
Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #3 on: October 11, 2004, 01:57:02 pm »

vi filename.sql
:8513
Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #4 on: October 11, 2004, 02:03:42 pm »

Quote
vi filename.sql
:8513
[snapback]119488[/snapback]
e3mr_complete_20041011.sql
bash: ./e3mr_complete_20041011.sql: Permission denied

It will not let me do to lines.
Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #5 on: October 11, 2004, 02:05:17 pm »

you missed out the "vi" bit
Code:
vi e3mr_complete_20041011.sql
:8513
Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #6 on: October 11, 2004, 02:07:31 pm »

never mind lift out the vi.
Code:
CREATE TABLE yabbse_members (
   ID_MEMBER int(10) unsigned NOT NULL auto_increment,
   memberName varchar(80) NOT NULL,
   realName tinytext,
   passwd text,
   emailAddress tinytext,
   dateRegistered bigint(20),
   personalText tinytext,
   memberGroup tinytext,
   gender tinytext,
   birthdate date DEFAULT '0000-00-00' NOT NULL,
   websiteTitle tinytext,
                                                              8513,1        35%
« Last Edit: October 11, 2004, 02:07:55 pm by supagal » Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #7 on: October 11, 2004, 02:11:33 pm »

I need to see to the end of the SQL Statement
Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #8 on: October 11, 2004, 02:15:22 pm »

Confused?
Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #9 on: October 11, 2004, 02:18:31 pm »

That is only the first part of the CREATE statement - I need to see the entire statement up to the closing brace.

you need to scroll down a few lines i suspect.
Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #10 on: October 11, 2004, 02:23:02 pm »

Quote
That is only the first part of the CREATE statement - I need to see the entire statement up to the closing brace.

you need to scroll down a few lines i suspect.
[snapback]119508[/snapback]
Code:
INSERT INTO yabbse_topics VALUES ( '456', '1', '6', '6', '15054', '15073', '-1', '5', '17', '0', NULL, '0');
# --------------------------------------------------------
You mean that?
That is the last thing on the sql document.
Logged

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #11 on: October 11, 2004, 02:24:28 pm »

Code:
INSERT INTO yabbse_censor VALUES ( 'vore', 'BRAAAAAAAAAAAAAAAAINS');
# --------------------------------------------------------

#
# Table structure for table 'yabbse_instant_messages'
#

DROP TABLE IF EXISTS yabbse_instant_messages;

CREATE TABLE yabbse_instant_messages (
   ID_IM bigint(20) NOT NULL auto_increment,
   ID_MEMBER_FROM int(11) DEFAULT '0' NOT NULL,
   ID_MEMBER_TO int(11) DEFAULT '0' NOT NULL,
   deletedBy int(11) DEFAULT '-1' NOT NULL,
   fromName tinytext NOT NULL,
   toName tinytext NOT NULL,
   msgtime bigint(20),
   subject tinytext,
   body text,
   readBy tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (ID_IM),
   KEY ID_MEMBER_FROM (ID_MEMBER_FROM),
   KEY ID_MEMBER_TO (ID_MEMBER_TO),
   KEY deletedBy (deletedBy),
   KEY msgtime (msgtime),
   KEY readBy (readBy)
);


#
# dumping data 'yabbse_instant_messages'
#
Logged

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #12 on: October 11, 2004, 03:36:06 pm »

I will just call 1and1.com as all I am getting from email replies is a copied and pasted thing from the faq.
Logged

Martin Wallace
Founders
*

Stars: +1/-0
Offline Offline

Posts: 3602


God is dead, I have surpassed him.


WWW
« Reply #13 on: October 11, 2004, 03:38:11 pm »

good luck aparently there support sucks big time - and if you are signed up for a root server they are not particularly helpful.

If you post the entire create statement for the yabbse_members table I can probably help.

Although it's a bit strange that it should be causing any problem if it is just a standard export dump.
« Last Edit: October 11, 2004, 03:39:50 pm by Slaine » Logged

Every time god kills an angel, I masturbate.

supagal
Monster Poster
*

Stars: +0/-0
Offline Offline

Posts: 1285



WWW
« Reply #14 on: October 11, 2004, 03:44:30 pm »

Well right below what I have in code above is the start of the posts I think , no wait it is the start of the PM. and if I read the whole line it is the very first PM sent from a member to another admin. I am not pasteing that.  Like you said it would be a vilation of privicy laws.
Logged

Pages: [1] 2   Go Up
Print
 
Jump to: