PDA

View Full Version : mysql error number: 1060


WhiteRook
6-26-05, 10:16 AM
I've got a couple of questions for anyone who might be willing to lend a hand.

I'm trying to insall a shout box, but get the following error:

Invalid SQL: ALTER TABLE language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'

mysql error number: 1060

Date: Saturday 25th of June 2005 02:10:31 PM
Script: http://XXX.xxxcom/forums//install/hack_install.php?do=install&step=dodatabasequeries&hacks=Shoutbox_Hack

Any ideas on what to do?

Also, one more question. I downloaded my database for a friend to have a look at, what application would he use to read the database? The data base is a .dmp

Thank You for any help offered,

Regards,
WR

RTH10260
6-27-05, 01:31 AM
I'm trying to insall a shout box, but get the following error:
mysql error: Duplicate column name 'phrasegroup_shoutbox'
Sounds like you already had installed this shoutbox application, when it tells you that you now are adding another column with the same name to a table.
Also, one more question. I downloaded my database for a friend to have a look at, what application would he use to read the database? The data base is a .dmpTo restore the file, mysqldmp. But just to view the content, eg to visually check the stuff, any plain text editor.

WhiteRook
6-27-05, 02:46 PM
thanks RTH10260...
That's a big help :D