Foutmelding bij backup..
Geplaatst: 27 mar 2004, 21:12
misschien is het al eerder genoemt maar ik heb het niet kunnen vinden hier mijn probleem..
dit is de foutmelding(via adminpaneel)
dezelfde fout heb ik via myadmin
kan iemand me hier mee helpen?
dit is de foutmelding(via adminpaneel)
Code: Selecteer alles
Error importing backup file
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near '--------------------------------------------------------- -- Server version 3.23' at line 4
-- MySQL dump 8.23 -- -- Host: localhost Database: messageboard_nl_5735 --------------------------------------------------------- -- Server version 3.23.58 -- -- Table structure for table `phpbb_auth_access` -- CREATE TABLE phpbb_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) ) TYPE=MyISAM
Line : 980
File : /var/www/html/phpbb/admin/admin_db_utilities.php
Code: Selecteer alles
Fout
SQL-query :
--
------------------------------------------------------- --
--
--
CREATE TABLE phpbb_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 )
) TYPE = MYISAM
MySQL retourneerde:
#1064 - You have an error in your SQL syntax near '---------------------------------------------------------
--
--
CREATE TABL' at line 2