It is currently Mon Dec 09, 2024 8:50 pm


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: phpBB Error importing backup file
PostPosted: Tue May 02, 2006 4:48 pm 
Newbie
Newbie

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


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 02, 2006 4:56 pm 
Support Tech
Support Tech

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.

_________________
Cheers,
Steve
Support Team Supervisor

Before asking a question, please read the F.A.Q.


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 02, 2006 5:34 pm 
Newbie
Newbie

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


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 02, 2006 8:00 pm 
Site Admin

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011