Fehler nach MySQL Restore MyBB 1.4.4

Code:

Warning [2] Invalid argument supplied for foreach() - Line: 1870 - File: admin/modules/user/users.php PHP 4.4.8 (Linux)



File                            Line            Function

[PHP]                                        errorhandler->error

/admin/modules/user/users.php        1870            build_users_view

/admin/modules/user/users.php        1774            build_users_view

/admin/index.php                378            require

Code:

Error at the line 195: INSERT INTO forum_adminviews

(vid,uid,title,type,visibility,fields,conditions,sortby,sortorder,perpage,view_type) VALUES ('1','0','All

Users','user','2','a:7:{i:0;s:6:"avatar";i:1;s:8:"username";i:2;s:5:"email";i:3;s:7:"

egdate";i:4;s:10:"lastactive";i:5;s:7:"postnum";i:6;s:8:"controls";}','a:14:{s:8:"us

rname";s:0:"";s:5:"email";s:0:"";s:7:"website";s:0:"";s:3:"icq";s:0:"";s:3:"aim";s:0:"";s:5:"yahoo";s:0:"";

s:3:"msn";s:0:"";s:9:"signature";s:0:"";s:9:"usertitle";s:0:"";s:11:"postnum_dir";s

12:"greater_than";s:7:"postnum";s:0:"";s:5:"regip";s:0:"";s:6:"lastip";s:0:"";s:6:"

ostip";s:0:"";}','username','asc','40','card');Query: INSERT INTO

forum_adminviews

(vid,uid,title,type,visibility,fields,conditions,sortby,sortorder,perpage,view_type)

VALUES ('1','0','All

Users','user','2','a:7:{i:0;s:6:"avatar";i:1;s:8:"username";i:2;s:5:"email";i:3;s:7:"

egdate";i:4;s:10:"lastactive";i:5;s:7:"postnum";i:6;s:8:"controls";}','a:14:{s:8:"us

rname";s:0:"";s:5:"email";s:0:"";s:7:"website";s:0:"";s:3:"icq";s:0:"";s:3:"aim";s:

:"";s:5:"yahoo";s:0:"";s:3:"msn";s:0:"";s:9:"signature";s:0:"";s:9:"usertitle";s:0:""

s:11:"postnum_dir";s:12:"greater_than";s:7:"postnum";s:0:"";s:5:"regip";s:0:"";s

6:"lastip";s:0:"";s:6:"postip";s:0:"";}','username','asc','40','card');MySQL: 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

'fields,conditions,sortby,sortorder,perpage,view_type) VALUES ('

Code:

INSERT INTO forum_adminviews

(vid,uid,title,type,visibility,fields,conditions,sortby,sortorder,perpage,view_type)

VALUES ('1','0','All

Users','user','2','a:7:{i:0;s:6:\"avatar\";i:1;s:8:\"username\";i:2;s:5:\"email\";i:3;

:7:\"regdate\";i:4;s:10:\"lastactive\";i:5;s:7:\"postnum\";i:6;s:8:\"controls\";}','a:

4:{s:8:\"username\";s:0:\"\";s:5:\"email\";s:0:\"\";s:7:\"website\";s:0:\"\";s:3:\"i

q\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:9:\"s

gnature\";s:0:\"\";s:9:\"usertitle\";s:0:\"\";s:11:\"postnum_dir\";s:12:\"greater_th

n\";s:7:\"postnum\";s:0:\"\";s:5:\"regip\";s:0:\"\";s:6:\"lastip\";s:0:\"\";s:6:\"post

p\";s:0:\"\";}','username','asc','40','card');

Code:

Fehler

SQL-Befehl:



CREATE TABLE IF NOT EXISTS  `mybb_adminviews` (

 `vid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,

 `uid` INT( 10 ) UNSIGNED NOT NULL DEFAULT  '0',

 `title` VARCHAR( 100 ) NOT NULL DEFAULT  '',

 `type` VARCHAR( 6 ) NOT NULL DEFAULT  '',

 `visibility` INT( 1 ) NOT NULL DEFAULT  '0',

 `fields` TEXT NOT NULL ,

 `conditions` TEXT NOT NULL ,

 `sortby` VARCHAR( 20 ) NOT NULL DEFAULT  '',

 `sortorder` VARCHAR( 4 ) NOT NULL DEFAULT  '',

 `perpage` INT( 4 ) NOT NULL DEFAULT  '0',

 `view_type` VARCHAR( 6 ) NOT NULL DEFAULT  '',

PRIMARY KEY (  `vid` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;





MySQL meldet: 



#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=utf8 AUTO_INCREMENT=2' at line 14