2 phpbb boards I run have been hacked. One I've restored but the other one has had some damage to the MySQL db. A table is missing.
As it's a styles table I thought I could could copy a table, from a test board I set up, to the hacked board.
I tried this using phpMyAdmin and I get this error:
-
SQL-query: Edit
-
-
CREATE TABLE `Tabcom`.`phpbb_styles_imageset_data` (
-
`image_id` smallint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
-
`image_name` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
-
`image_filename` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
-
`image_lang` varchar( 30 ) COLLATE utf8_bin NOT NULL default '',
-
`image_height` smallint( 4 ) unsigned NOT NULL default '0',
-
`image_width` smallint( 4 ) unsigned NOT NULL default '0',
-
`imageset_id` smallint( 4 ) unsigned NOT NULL default '0',
-
PRIMARY KEY ( `image_id` ) ,
-
KEY `i_d` ( `imageset_id` ) ,
-
FULLTEXT KEY `image_name` ( `image_name` ) ,
-
FULLTEXT KEY `image_lang` ( `image_lang` ) ,
-
FULLTEXT KEY `image_name_2` ( `image_name` )
-
) ENGINE = MYISAM AUTO_INCREMENT = 79DEFAULT CHARSET = utf8 COLLATE = utf8_bin
-
-
MySQL said: Documentation
-
#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 '79DEFAULT CHARSET = utf8 COLLATE = utf8_bin' at line 12
-
Can you please help?
Thanks
Ashley
