Pagina 1 van 1

Foutmelding bij backup..

Geplaatst: 27 mar 2004, 21:12
door Rambo
misschien is het al eerder genoemt maar ik heb het niet kunnen vinden hier mijn probleem..

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
dezelfde fout heb ik via myadmin

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
kan iemand me hier mee helpen?

Geplaatst: 27 mar 2004, 22:25
door mosymuis

Code: Selecteer alles

------------------------------------------------------- -- 
Is geen geldige SQL, dit moet je eerst handmatig uit je backup halen. In het vervolg kan je beter backups maken en herstellen in phpMyAdmin, dit is bertrouwbaarder dan deze optie in phpBB zelf.

Geplaatst: 28 mar 2004, 01:57
door Rambo
Oke bedankt.. heb het er uitgehaald en hij werkt nogmaals hartstikke bedankt :) :thumb: