FreeHostia Forums
https://forum.freehostia.com/

phpBB Error importing backup file
https://forum.freehostia.com/viewtopic.php?f=4&t=107
Page 1 of 1

Author:  Bananapicker [ Tue May 02, 2006 4:48 pm ]
Post subject:  phpBB Error importing backup file

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

Author:  steve [ Tue May 02, 2006 4:56 pm ]
Post subject: 

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.

Author:  Bananapicker [ Tue May 02, 2006 5:34 pm ]
Post subject: 

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

Author:  jazzy [ Tue May 02, 2006 8:00 pm ]
Post subject: 

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

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/