phpBB Error importing backup file

Bananapicker · **Joined:** Tue May 02, 2006 4:39 pm **Posts:** 2

Code:

Error importing backup file

DEBUG MODE

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 'DEFAULT CHARSET=latin1' at line 18

CREATE TABLE `360squadronatc_auth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Line : 980
File : admin_db_utilities.php

I get this error when i try to restore my database, also in phpMyAdmin i cannot imprt the database, which would be the easiest way of resolveing this.
Please can someone help me

Thanks
Chris

steve · **Joined:** Thu Mar 23, 2006 1:07 pm **Posts:** 238

Try editing line 18 this way:

Quote:

Error importing backup file

DEBUG MODE

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 'DEFAULT CHARSET=latin1' at line 18

CREATE TABLE `360squadronatc_auth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`) ) ENGINE=MyISAM CHARSET=latin1 ;

Line : 980
File : admin_db_utilities.php

*I am using the quote tag to make the line that you need to edit appear red.

Bananapicker · **Joined:** Tue May 02, 2006 4:39 pm **Posts:** 2

Thanks, I have got past that error, i now have a new one:

Code:

Error importing backup file

DEBUG MODE

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 'collate latin1_bin NOT NULL default '', `word_id` mediumint(8

CREATE TABLE `360squadronatc_search_wordlist` ( `word_text` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) ) ENGINE=MyISAM CHARSET=latin1

Line : 980
File : admin_db_utilities.php

jazzy · **Joined:** Thu Mar 30, 2006 7:51 am **Posts:** 208

Please open a trouble ticket and we will check the problem in details.

Note that you can inport the database only using the inbuild PHPMyAdmin. tool

Forum rules

phpBB Error importing backup file