ACP Fehler ! Bitte um Hilfe

Kolle_1
ausführliche Problembeschreibung:Habe leider im ACP keine auswahl mehr rechts

vollständige Fehlermeldung:
SQL-DATABASE ERROR

Database error in WoltLab Burning Board (): Invalid SQL: SELECT * FROM bb1_acpmenuitemgroups WHERE acpmode<='2' ORDER BY showorder ASC
mysql error: Table 'db60289x571114.bb1_acpmenuitemgroups' doesn't exist
mysql error number: 1146
mysql version: 5.0.41-community
php version: 4.4.2-Debian-0.1~sarge1
Date: 01.11.2007 @ 11:41
Script: /wbb2/acp/misc.php?action=menu&sid=
Referer: http://www.kolle-1.com/wbb2/acp/index.php?sid=&url=


Link zum Problem/Forum und Screenshot(s):Fehler liegt direkt im ACP! Habe den oben angegebenen Fehlerbericht rechts im acp wo sonst die auswahlen sind

letzte Änderungen oder eingebaute Hacks:96 Smilies per SQL hinzufügen

Zugangsdaten für einen Testzugang:
Gebe ich gerne jedoch nur auf Anfrage



Habe vorher extra ein SQL Backup gemacht , nur wenn ich es wieder einspielen möchte , kommt immer eine Fehlermeldung

Fehler

SQL-Befehl:

CREATE TABLE bb1_acpmenuitemgroups(
itemgroupid smallint( 5 ) unsigned NULL AUTO_INCREMENT ,
title varchar( 255 ) NULL ,
condition text NULL ,
conditiontype enum( 'OR', 'AND' ) NULL DEFAULT 'OR',
showorder smallint( 5 ) unsigned NULL DEFAULT '0',
acpmode tinyint( 3 ) unsigned NULL DEFAULT '0',
PRIMARY KEY ( itemgroupid )
);

MySQL meldet: Dokumentation
#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 'condition text NULL,
conditiontype enum('OR','AND') NULL DEFAULT 'OR',
sho' at line 4
Bolop
Hast Du voher nen Backup gemacht?
Kolle_1
ja hab im forum über Datenbank sichern ein backup gemacht!
Alexdo
Führe folgende SQL-Abfragen aus:

code:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
DROP TABLE IF EXISTS bb1_acpmenuitemgroups;
CREATE TABLE bb1_acpmenuitemgroups (
  itemgroupid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  `condition` text,
  `conditiontype` enum('OR','AND') NOT NULL default 'OR',
  showorder smallint(5) unsigned NOT NULL default '0',
  acpmode tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemgroupid)
) TYPE=MyISAM;

INSERT INTO bb1_acpmenuitemgroups VALUES (1, 'board', 'a_can_boards_add;a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit', 'OR', 1, 1),
(2, 'users', 'a_can_users_add;a_can_users_edit;a_can_users_delete;a_can_users_email;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation', 'OR', 2, 1),
(3, 'threads', 'a_can_threads_mass_edit;a_can_threads_edit;a_can_threads_moderate;a_can_threads_moderate_posts', 'OR', 3, 1),
(4, 'group', 'a_can_groups_add;a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_variablegroups_set_securitylevel;a_can_boards_permissions;a_can_users_email', 'OR', 4, 1),
(5, 'style', 'a_can_style_add;a_can_style_edit;a_can_style_del;a_can_style_export;a_can_style_import', 'OR', 5, 1),
(9, 'avatar', 'a_can_avatars_readfolder;a_can_avatars_edit;a_can_avatars_del;a_can_avatars_add', 'OR', 9, 1),
(10, 'ranks', 'a_can_ranks_add;a_can_ranks_edit;a_can_ranks_del', 'OR', 10, 2),
(6, 'designpack', 'a_can_designpack_add;a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del', 'OR', 6, 2),
(7, 'template', 'a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del;a_can_templatepack_add;a_can_templatepack_edit;a_can_templatepack_del;a_can_template_import;a_can_template_export;a_can_template_search;a_can_template_cache', 'OR', 7, 1),
(8, 'languagepack', 'a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_import;a_can_languagepack_translate;a_can_languagepack_delitem;a_can_languagepack_additem;a_can_languagepack_addcategory;a_can_languagepack_delcategory;a_can_languagepack_search;a_can_languagepack_sync', 'OR', 8, 2),
(11, 'smilie', 'a_can_smilie_add;a_can_smilie_edit;a_can_smilie_del', 'OR', 11, 2),
(12, 'icon', 'a_can_icon_add;a_can_icon_edit;a_can_icon_del', 'OR', 12, 2),
(13, 'bbcodes', 'a_can_bbcodes_add;a_can_bbcodes_edit;a_can_bbcodes_del', 'OR', 13, 2),
(14, 'profilefield', 'a_can_profilefield_add;a_can_profilefield_edit;a_can_profilefield_del', 'OR', 14, 2),
(15, 'database', 'a_can_database_backup;a_can_database_query;a_can_database_extra', 'OR', 15, 1),
(16, 'other1', 'a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_memberslist;a_can_otherstuff_wordmatch;a_can_users_edit;a_can_users_email;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters', 'OR', 16, 1),
(17, 'other2', '', 'OR', 17, 1);


Sollte es nicht funktionieren, bitte wie immer den Fehler posten.
Es kann auch gut sein, dass noch weitere Tabellen hinsichtlich des Admin-Menüs fehlen oder unvollständig sind, Posting reicht.

Übrigens: Mit der obrigen Abfrage wird der Menüzustand nach der Installation wiederhergestellt. Weitere Menüpunkte müssten dann aus dem Backup wieder ergänzt werden!
Kolle_1
Danke erstmal das du mir helfen magst!

Habe das og ausgeführt und bekomme im ACP rechts nun folgende fehlermeldung und immernoch keine auswahl

SQL-DATABASE ERROR

Database error in WoltLab Burning Board (): Invalid SQL: SELECT * FROM bb1_acpmenuitems WHERE itemgroupid IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) AND acpmode<='2' ORDER BY itemgroupid ASC, showorder ASC
mysql error: Table 'db60289x571114.bb1_acpmenuitems' doesn't exist
mysql error number: 1146
mysql version: 5.0.41-community
php version: 4.4.2-Debian-0.1~sarge1
Date: 01.11.2007 @ 19:26
Script: /wbb2/acp/misc.php?action=menu&sid=
Referer: http://www.kolle-1.com/wbb2/acp/index.php?sid=&url=
Alexdo
Dann hier der Code für die acpmenuitems:

code:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
DROP TABLE IF EXISTS bb1_acpmenuitems;
CREATE TABLE bb1_acpmenuitems (
  itemid smallint(5) unsigned NOT NULL auto_increment,
  itemgroupid smallint(5) unsigned NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  languageitem varchar(255) NOT NULL default '',
  linkformat varchar(20) NOT NULL default '',
  `condition` varchar(255) NOT NULL default '',
  `conditiontype` enum('OR','AND') NOT NULL default 'OR',
  showorder smallint(5) unsigned NOT NULL default '0',
  acpmode tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;

INSERT INTO bb1_acpmenuitems VALUES (1, 1, 'board.php?action=add', 'BOARD_ADD', '', 'a_can_boards_add', 'OR', 1, 1),
(2, 1, 'board.php?action=view', 'BOARD_EDIT', '<b>%s</b>', 'a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit', 'OR', 2, 1),
(3, 2, 'users.php?action=add', 'USERS_ADD', '', 'a_can_users_add', 'OR', 1, 2),
(4, 2, 'users.php?action=find', 'USERS_FIND', '<b>%s</b>', 'a_can_users_edit;a_can_users_delete;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation', 'OR', 2, 1),
(5, 2, 'users.php?action=email&amp;userid=all', 'USERS_EMAIL_ALL', '', 'a_can_users_email', 'OR', 3, 2),
(6, 2, 'users.php?action=rate', 'USERS_RESET_RATING', '', 'a_can_users_other', 'OR', 4, 2),
(7, 3, 'threads.php?action=spinning', 'THREADS_EDIT', '<b>%s</b>', 'a_can_threads_edit', 'OR', 1, 1),
(8, 3, 'threads.php?action=moderate', 'THREADS_MODERATE', '', 'a_can_threads_moderate', 'OR', 2, 2),
(9, 3, 'threads.php?action=moderateposts', 'THREADS_MODERATE_POST', '', 'a_can_threads_moderate_posts', 'OR', 3, 2),
(10, 4, 'group.php?action=add', 'GROUP_ADD', '', 'a_can_groups_add', 'OR', 1, 2),
(11, 4, 'group.php?action=view', 'GROUP_EDIT', '<b>%s</b>', 'a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_add;a_can_boards_permissions;a_can_users_email', 'OR', 2, 1),
(12, 4, 'group.php?action=variablegroups_set_securitylevel', 'GROUP_SECURITYLEVEL', '', 'a_can_groups_variablegroups_set_securitylevel', 'OR', 3, 2),
(13, 5, 'style.php?action=add', 'STYLE_ADD', '', 'a_can_style_add', 'OR', 1, 2),
(14, 5, 'style.php?action=view', 'STYLE_EDIT', '', 'a_can_style_edit;a_can_style_del;a_can_style_export', 'OR', 2, 2),
(15, 5, 'style.php?action=import%2Fexport', 'STYLE_IMPORT_EXPORT', '<b>%s</b>', 'a_can_style_import;a_can_style_export', 'OR', 3, 2),
(16, 6, 'designpack.php?action=add', 'DESIGNPACK_ADD', '', 'a_can_designpack_add', 'OR', 1, 2),
(17, 6, 'designpack.php?action=view', 'DESIGNPACK_EDIT', '<b>%s</b>', 'a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del', 'OR', 2, 2),
(18, 7, 'template.php?action=add', 'TEMPLATE_ADD', '', 'a_can_template_add', 'OR', 1, 2),
(19, 7, 'template.php?action=view', 'TEMPLATE_EDIT', '<b>%s</b>', 'a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del', 'OR', 2, 1),
(20, 7, 'template.php?action=addpack', 'TEMPLATEPACK_ADD', '', 'a_can_templatepack_add', 'OR', 3, 2),
(21, 7, 'template.php?action=viewpack', 'TEMPLATEPACK_EDIT', '', 'a_can_templatepack_edit;a_can_templatepack_del', 'OR', 4, 2),
(22, 7, 'template.php?action=import%2Fexport', 'TEMPLATE_IMPORT_EXPORT', '<b>%s</b>', 'a_can_template_import;a_can_template_export', 'OR', 5, 1),
(23, 7, 'template.php?action=search', 'TEMPLATE_SEARCH_REPLACE', '', 'a_can_template_search', 'OR', 6, 2),
(24, 9, 'avatar.php?action=readfolder', 'AVATAR_READ', '', 'a_can_avatars_readfolder', 'OR', 1, 2),
(25, 9, 'avatar.php?action=add', 'AVATAR_ADD', '', 'a_can_avatars_add', 'OR', 2, 2),
(26, 9, 'avatar.php?action=view', 'AVATAR_EDIT', '', 'a_can_avatars_edit;a_can_avatars_del', 'OR', 3, 2),
(27, 9, 'avatar.php?action=backup', 'AVATAR_BACKUP', '', 'a_can_avatars_edit;a_can_avatars_del', 'OR', 3, 1),
(28, 10, 'ranks.php?action=add', 'RANKS_ADD', '', 'a_can_ranks_add', 'OR', 1, 2),
(29, 10, 'ranks.php?action=view', 'RANKS_EDIT', '', 'a_can_ranks_edit;a_can_ranks_del', 'OR', 2, 2),
(30, 11, 'smilie.php?action=add', 'SMILIE_ADD', '', 'a_can_smilie_add', 'OR', 1, 2),
(31, 11, 'smilie.php?action=view', 'SMILIE_EDIT', '', 'a_can_smilie_edit;a_can_smilie_del', 'OR', 2, 2),
(32, 12, 'icon.php?action=add', 'ICON_ADD', '', 'a_can_icon_add', 'OR', 1, 2),
(33, 12, 'icon.php?action=view', 'ICON_EDIT', '', 'a_can_icon_edit;a_can_icon_del', 'OR', 2, 2),
(34, 13, 'bbcodes.php?action=add', 'BBCODES_ADD', '', 'a_can_bbcodes_add', 'OR', 1, 2),
(35, 13, 'bbcodes.php?action=view', 'BBCODES_EDIT', '', 'a_can_bbcodes_edit;a_can_bbcodes_del', 'OR', 2, 2),
(36, 14, 'profilefield.php?action=add', 'PROFILEFIELD_ADD', '', 'a_can_profilefield_add', 'OR', 1, 2),
(37, 14, 'profilefield.php?action=view', 'PROFILEFIELD_EDIT', '', 'a_can_profilefield_edit;a_can_profilefield_del', 'OR', 2, 2),
(38, 15, 'database.php?action=backup', 'DATABASE_BACKUP', '<b>%s</b>', 'a_can_database_backup', 'OR', 1, 1),
(39, 15, 'database.php?action=query', 'DATABASE_QUERY', '', 'a_can_database_query;a_can_database_extra', 'OR', 2, 2),
(40, 16, 'otherstuff.php', 'OTHERSTUFF_UPDATEVIEW', '<b>%s</b>', 'a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_users_edit;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters', 'OR', 1, 1),
(41, 16, 'memberslist.php', 'MEMBERSLIST', '', 'a_can_memberslist', 'OR', 2, 2),
(42, 16, 'otherstuff.php?action=wordmatch', 'OTHERSTUFF_WORDMATCH', '', 'a_can_otherstuff_wordmatch', 'OR', 3, 2),
(43, 17, 'otherstuff.php?action=adminsessions', 'OTHERSTUFF_ADMINSESSIONS', '', 'a_can_otherstuff_adminsessions', 'OR', 1, 2),
(44, 17, 'otherstuff.php?action=selectstats', 'OTHERSTUFF_STATS', '', 'a_can_otherstuff_stats', 'OR', 2, 2),
(45, 17, 'otherstuff.php?action=acpsettings', 'OTHERSTUFF_ACPSETTINGS', '<b>%s</b>', '', 'OR', 3, 1),
(46, 8, 'languagepack.php?action=add', 'LANGUAGEPACK_ADD', '', 'a_can_languagepack_add', 'OR', 1, 2),
(47, 8, 'languagepack.php?action=view', 'LANGUAGEPACK_EDIT', '<b>%s</b>', 'a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_translate', 'OR', 2, 0),
(48, 8, 'languagepack.php?action=additem', 'LANGUAGEITEM_ADD', '', 'a_can_languagepack_additem', 'OR', 3, 2),
(49, 8, 'languagepack.php?action=addcategory', 'LANGUAGECAT_ADD', '', 'a_can_languagepack_addcategory', 'OR', 4, 2),
(50, 8, 'languagepack.php?action=import', 'LANGUAGEPACK_IMPORT', '<b>%s</b>', 'a_can_languagepack_import', 'OR', 6, 2),
(51, 8, 'languagepack.php?action=search', 'LANGUAGEPACK_SEARCH', '', 'a_can_languagepack_search', 'OR', 7, 2),
(52, 8, 'languagepack.php?action=sync', 'LANGUAGEPACK_SYNC', '', 'a_can_languagepack_sync', 'OR', 8, 2),
(53, 7, 'template.php?action=cache', 'TEMPLATE_CACHE', '', 'a_can_template_cache', 'OR', 7, 2),
(54, 3, 'threads.php?action=threads_mass_edit', 'THREADS_MASS_EDIT', '', 'a_can_threads_mass_edit', 'OR', 1, 2),
(55, 8, 'languagepack.php?action=delcategory', 'LANGUAGECAT_DEL', '', 'a_can_languagepack_delcategory', 'OR', 5, 2),
(56, 16, 'otherstuff.php?action=mailqueue', 'OTHERSTUFF_MAILQUEUE', '%s', 'a_can_users_email', 'OR', 4, 1);
Kolle_1
Super großes Grinsen
Nun ist es wieder da!
Hab Tausend Dank Alexdo!!!
Das Menü ist wieder da!
Echt super ,hätte ich ohne dich nie geschafft!
Alexdo
Kein Problem. Aber am Rande einen kleinen Tipp, wie man die defekten/nicht vorhandenen Tabellen wieder-/herstellt:
Im Archiv von WoltLab findet sich in wbb2/acp/lib/ eine structure.sql und eine inserts.sql. Wie der Name schon sagt, befinden sich in der structure.sql die Tabellenstrukturen. Dort stehen also die Abfragen drin, womit man eine Tabelle neu aufsetzen kann.
In der inserts.sql befinden sich selbstverständlich die SQL-Inserts für die neuen Tabellen. Sollten für eine Tabelle mal keine Inserts vorhanden sein, dann ist die Tabelle auch neu installiert standartmäßig leer. Augenzwinkern
Kolle_1
Alles klar, danke dir nochmal! großes Grinsen