Jump to content

bigun007

New Members
  • Posts

    8
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

bigun007's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Which seems the samea s yours but this backup won\'t restore either :S
  2. Here is what i now have - just checked another backup DROP TABLE IF EXISTS phpbb_privmsgs_text; CREATE TABLE phpbb_privmsgs_text( privmsgs_text_id mediumint( unsigned NOT NULL, privmsgs_bbcode_uid varchar(10) NOT NULL, privmsgs_text text, PRIMARY KEY (privmsgs_text_id), KEY privmsgs_bbcode_uid (privmsgs_bbcode_uid), KEY privmsgs_text (privmsgs_text) ); # # Table Data for phpbb_privmsgs_text # INSERT INTO phpbb_privmsgs_text (privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text)
  3. No i\'ve not modded it at all, i can send you the backup if you\'d like?
  4. Its just the notepad edit of the backup
  5. SQL Error : 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 \' KEY privmsgs_bbcode_uid (privmsgs_bbcode_uid), KEY privmsg CREATE TABLE phpbb_privmsgs_text( privmsgs_text_id mediumint( unsigned NOT NULL, privmsgs_bbcode_uid varchar(10) NOT NULL default \'0\', privmsgs_text text, PRIMARY KEY (privmsgs_text_id),) TYPE=MyISAM, KEY privmsgs_bbcode_uid (privmsgs_bbcode_uid), KEY privmsgs_text (privmsgs_text) Line : 978 File : /home/jame8279/public_html/forum/admin/admin_db_utilities.php
  6. Ok have found it, and getting another error after edting
  7. OMG some URGENT help needed. MY Forum went down adn i thought oh that\'s ok i just made a backup, when it came to restoring it i got the following message \"Error importing backup file DEBUG MODE SQL Error : 1170 BLOB column \'privmsgs_text\' used in key specification without a key length CREATE TABLE phpbb_privmsgs_text( privmsgs_text_id mediumint( unsigned NOT NULL, privmsgs_bbcode_uid varchar(10) NOT NULL, privmsgs_text text, PRIMARY KEY (privmsgs_text_id), KEY privmsgs_bbcode_uid (privmsgs_bbcode_uid), KEY privmsgs_text (privmsgs_text) ) Line : 980 File : /home/jame8279/public_html/forum/admin/admin_db_utilities.php PLEASE PLEASE PLEASE Help is there any way i can edit the backup or something to sort this?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.