Advertisement:

Author Topic: members column not working suddenly  (Read 2408 times)

Offline maarten

  • Newbie
  • *
  • Posts: 8
members column not working suddenly
« on: January 11, 2006, 07:25:35 PM »
Hi
I suddenly had the following error:

Databasefout

Bestand: /scoutnet.be/users/scoutsaleydis/public_html/site/forum/Sources/Load.php
Regel: 777

after that i tried to upgrade to RC2 and got this error:

Updating Settings.php... Successful.
Backing up old table data...
   Backing up "members"... Unsuccessful!
This query:

    CREATE TABLE backup_smf_members (
    PRIMARY KEY (`ID_MEMBER`),
    KEY `memberName` (`memberName`(30)),
    KEY `dateRegistered` (`dateRegistered`),
    KEY `ID_GROUP` (`ID_GROUP`),
    KEY `birthdate` (`birthdate`),
    KEY `posts` (`posts`),
    KEY `lastLogin` (`lastLogin`),
    KEY `lngfile` (`lngfile`(30)),
    KEY `ID_POST_GROUP` (`ID_POST_GROUP`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0)
    TYPE=MyISAM
    SELECT *
    FROM smf_members;

Caused the error:

    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 ')
    TYPE=MyISAM
    SELECT *
    FROM smf_members' at line 11

any help?