# HILFE !!! Tabelle 's\_core\_menu' in der DB gelöscht!!! **URL:** \ **Category:** Shopware 3.5\ **Tags:** general\ **Created:** [17. Januar 2012 um 12:52 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845 "2012-01-17T12:52:27Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 12:52 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/1 "2012-01-17T12:52:27Z")
habe eben versehendlich die gesamte s\_core\_menu gelöscht. HILFE!!! Was kann ich tun um das wieder Rückgängig zu machen!!! ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 12:56 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/2 "2012-01-17T12:56:00Z")
hast du vorher kein datenbank backup gemacht? ---
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 12:59 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/3 "2012-01-17T12:59:06Z")
ja, aber nur über das Update-Plugin. ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 13:01 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/4 "2012-01-17T13:01:33Z")
der macht ja auch datenbank update dan versuch einmal den wieder herzustellen ---
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 13:05 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/5 "2012-01-17T13:05:38Z")
Leider komme ich nicht mehr an Backend ran. Folgende Fehlermeldung erscheint: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. SQLSTATE[42S02]: Base table or view not found: 1146 Table ‚db33157\_24.s\_core\_menu‘ doesn’t exist in Vendor/Zend/library/Zend/Db/Statement/Pdo.php on line 234 Stack trace: Komme ich über FTP an das Backup? Wenn ja, wo?? ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 13:06 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/6 "2012-01-17T13:06:01Z")
falls das über plugin nicht mehr möglich ist muss du es manuell machen die backups befinden sich files/backups/ ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 13:06 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/7 "2012-01-17T13:06:58Z")
mach aber vorher eine manuelle backup von datenbank unter exportieren ---
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 13:07 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/8 "2012-01-17T13:07:20Z")
kann mir denn vielleicht jemend seine ‚s\_core\_menu‘ Tabelle zur Verfügung stellen?? ---
**Author:** ![Stefan\_Hamann](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@Stefan\_Hamann](https://forum.shopware.com/u/Stefan_Hamann)\ **Post date:** [17. Januar 2012 um 13:08 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/9 "2012-01-17T13:08:12Z")
Alternativ hier die notwendigen SQL-Befehle um die Standard-Version der Tabelle wiederherzustellen. Dann kommst du zumindest wieder in das Backend und kannst das Backup über das Update-Plugin wiederherstellen. `-- phpMyAdmin SQL Dump -- version 3.4.8deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 17. Jan 2012 um 11:57 -- Server Version: 5.1.58 -- PHP-Version: 5.3.8-1+b1 SET SQL\_MODE="NO\_AUTO\_VALUE\_ON\_ZERO"; SET time\_zone = "+00:00"; -- -- Datenbank: `sw356` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `s_core_menu` -- CREATE TABLE IF NOT EXISTS `s_core_menu` ( `id` int(11) NOT NULL AUTO\_INCREMENT, `parent` int(11) NOT NULL DEFAULT '0', `hyperlink` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `onclick` varchar(255) NOT NULL, `style` varchar(255) NOT NULL, `class` varchar(255) NOT NULL, `position` int(11) NOT NULL DEFAULT '0', `active` int(1) NOT NULL DEFAULT '0', `pluginID` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`parent`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO\_INCREMENT=104 ; -- -- Daten für Tabelle `s_core_menu` -- INSERT INTO `s_core_menu` (`id`, `parent`, `hyperlink`, `name`, `onclick`, `style`, `class`, `position`, `active`, `pluginID`) VALUES (1, 0, '', 'Artikel', '', '', 'ico package\_green', 0, 1, NULL), (2, 1, '', 'Neu', 'loadSkeleton(''articles'');', 'background-position: 5px 5px;', 'ico2 package\_add', -3, 1, NULL), (4, 1, '', 'Kategorien', 'loadSkeleton(''categories'');', 'background-position: 5px 5px;', 'ico2 folders\_stack', 0, 1, NULL), (6, 1, '', 'Hersteller', 'loadSkeleton(''supplier'');', 'background-position: 5px 5px;', 'ico2 lorry', 2, 1, NULL), (7, 0, '', 'Inhalte', '', '', 'ico2 note03', 0, 1, NULL), (8, 30, '', 'Banner', 'loadSkeleton(''imagepromo'');', 'background-position: 5px 5px;', 'ico2 image', 0, 1, NULL), (9, 30, '', 'Einkaufswelten', 'loadSkeleton(''promotion'')', 'background-position: 5px 5px;', 'ico2 pin', 1, 1, NULL), (10, 30, '', 'Gutscheine', 'loadSkeleton(''vouchers'');', 'background-position: 5px 5px;', 'ico2 email\_open\_image', 3, 1, NULL), (11, 30, '', 'Prämienartikel', 'loadSkeleton(''premiums'');', 'background-position: 5px 5px;', 'ico2 star', 2, 1, NULL), (12, 30, '', 'Produktexporte', 'loadSkeleton(''search\_price'');', 'background-position: 5px 5px;', 'ico2 folder\_open\_image', 5, 1, NULL), (15, 7, '', 'Shopseiten', 'loadSkeleton(''cmsstatic'');', 'background-position: 5px 5px;', 'ico2 documents', 0, 1, NULL), (16, 7, '', 'Feeds', 'loadSkeleton(''cms'');', 'background-position: 5px 5px;', 'ico2 layout1', 1, 1, NULL), (20, 0, '', 'Kunden', '', '', 'ico customer', 0, 1, NULL), (21, 20, '', 'Kundenliste', 'loadSkeleton(''user'');', 'background-position: 5px 5px;', 'ico2 card\_address', 0, 1, NULL), (22, 20, '', 'Bestellungen', 'loadSkeleton(''orderlist'');', 'background-position: 5px 5px;', 'ico2 sticky\_notes\_pin', 0, 1, NULL), (23, 0, '', 'Einstellungen', '', '', 'ico2 wrench\_screwdriver', 0, 1, NULL), (24, 23, '', 'Grundeinstellungen', 'loadSkeleton(''presetting'');', 'background-position: 5px 5px;', 'ico2 computer', -4, 1, NULL), (25, 23, '', 'Benutzerverwaltung', 'loadSkeleton(''auth'');', 'background-position: 5px 5px;', 'ico2 status\_online', -2, 1, NULL), (26, 23, '', 'Versandkosten', 'loadSkeleton(''shipping'');', 'background-position: 5px 5px;', 'ico2 envelope\_arrow ', 0, 1, NULL), (27, 23, '', 'Zahlungsarten', 'loadSkeleton(''payment'');', 'background-position: 5px 5px;', 'ico2 creditcards', 0, 1, NULL), (28, 23, '', 'eMail-Vorlagen', 'loadSkeleton(''mails'');', 'background-position: 5px 5px;', 'ico2 mail\_pencil', 0, 1, NULL), (29, 23, '', 'Shopcache leeren', 'openAction(''cache'');', 'background-position: 5px 5px;', 'ico2 bin', -5, 1, NULL), (30, 0, '', 'Marketing', '', '', 'ico2 chart\_bar01', 0, 1, NULL), (31, 69, '', 'Übersicht', 'loadSkeleton(''overview'');', 'background-position: 5px 5px;', 'ico2 table\_arrow', -5, 1, NULL), (32, 69, '', 'Statistiken / Diagramme', 'loadSkeleton(''statistics'');', 'background-position: 5px 5px;', 'ico2 chart\_curve1', -4, 1, NULL), (58, 30, '', 'Newsletter (Campaigns)', 'loadSkeleton(''mailcampaigns'')', 'background-position: 5px 5px;', 'ico2 mails\_stack', 7, 1, NULL), (34, 0, '', 'Fenster', '', '', 'ico window', 0, 1, NULL), (71, 23, '', 'Textbausteine', '', 'background-position: 5px 5px;', 'ico2 plugin', 0, 1, NULL), (86, 71, '', 'Neue Templatebasis', 'openAction(''snippet'')', 'background-position: 5px 5px', 'ico2 plugin', 0, 1, NULL), (36, 34, '', 'Nebeneinander', 'sWindows.\_groupHorizontal();', 'background-position: 5px 5px;', 'ico2 application\_tile\_horizontal', 0, 1, NULL), (37, 34, '', 'Untereinander', 'sWindows.\_groupVertical();', 'background-position: 5px 5px;', 'ico2 application\_tile\_vertical', 0, 1, NULL), (38, 34, '', 'Alle schliessen', 'sWindows.\_closeAll();', 'background-position: 5px 5px;', 'ico2 schliessen', 0, 1, NULL), (39, 34, '', 'Alle minimie.', 'sWindows.\_minAll();', 'background-position: 5px 5px;', 'ico2 minimieren', 0, 1, NULL), (40, 0, '', 'Hilfe', '', '', 'ico question\_frame', 0, 1, NULL), (41, 40, '', 'Onlinehilfe aufrufen', 'window.open(''http://www.shopware.de/wiki'',''Shopware'',''width=800,height=550,scrollbars=yes'')', 'background-position: 5px 5px;', 'ico2 book\_open', 0, 1, NULL), (63, 23, '', 'Systeminfo', 'openAction(''check'');', 'background-position: 5px 5px;', 'ico2 information\_frame', -3, 1, 40), (42, 40, '', 'Shopware Account', 'openAccount();', 'background-position: 5px 5px;', 'ico2 shopware', 0, 1, NULL), (43, 40, '', 'Lizenz', 'loadSkeleton(''lizenz'')', 'background-position: 5px 5px;', 'ico2 key', 0, 1, NULL), (44, 40, '', 'Über Shopware', 'window.Growl(''{release} (c)2010-2011 shopware AG'');', 'background-position: 5px 5px;', 'ico2 information\_frame', 0, 1, NULL), (45, 23, '', 'Templateauswahl', 'loadSkeleton(''templates'')', 'background-position: 5px 5px;', 'ico2 layout\_header\_footer\_2', 0, 1, NULL), (46, 7, '', 'Import/Export', 'loadSkeleton(''import'');', 'background-position: 5px 5px;', 'ico2 arrow\_circle\_double\_135', 3, 1, NULL), (50, 1, '', 'Bewertungen', 'loadSkeleton(''vote'');', 'background-position: 5px 5px;', 'ico2 bubble01', 3, 1, NULL), (51, 30, '', 'Aktionen', 'loadSkeleton(''salescampaigns'')', 'background-position: 5px 5px;', 'ico2 aktion', 4, 1, NULL), (62, 23, '', 'Riskmanagement', 'loadSkeleton(''risk'')', 'background-position: 5px 5px;', 'ico2 bulb\_off', 0, 1, NULL), (56, 30, '', 'Partnerprogramm', 'loadSkeleton(''partner'')', 'background-position: 5px 5px;', 'ico2 arrow\_leftright\_blue', 6, 1, NULL), (57, 7, '', 'Formulare', 'loadSkeleton(''support'');', 'background-position: 5px 5px;', 'ico2 table02', 2, 1, NULL), (59, 69, '', 'Abbruch-Analyse', 'loadSkeleton(''orderscanceled'');', 'background-position: 5px 5px;', 'cross', 0, 1, NULL), (72, 1, '', 'Eigenschaften', 'loadSkeleton(''filter'');', 'background-position: 5px 5px;', 'ico2 databases\_pencil', 0, 1, NULL), (64, 7, '', 'Datei-Archiv', 'loadSkeleton(''browser'')', 'background-position: 5px 5px;', 'ico2 disc', 4, 1, NULL), (65, 20, '', 'Zahlungen', '', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, NULL), (66, 1, '', 'Übersicht', 'loadSkeleton(''articlesfast'');', 'background-position: 5px 5px;', 'ico2 table\_plus', -2, 1, NULL), (68, 23, '', 'Logfile', 'loadSkeleton(''authlog'');', 'background-position: 5px 5px;', 'ico2 cards', -2, 1, NULL), (69, 30, '', 'Auswertungen', '', 'background-position: 5px 5px;', 'ico2 chart\_pie1', -1, 1, NULL), (75, 20, '', 'Anlegen', 'loadSkeleton(''useradd'');', 'background-position: 5px 5px;', 'ico2 user\_add', -1, 1, NULL), (77, 65, '', 'Paypal', 'loadSkeleton(''paypalreserveorder'');', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, NULL), (78, 65, '', 'Saferpay', 'loadSkeleton(''saferpayreserveorder'');', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, NULL), (79, 20, '', 'Ticket-System', 'loadSkeleton(''ticket\_system'');', 'background-position: 5px 5px;', 'ico2 sticky\_notes\_pin', 1, 1, NULL), (88, 40, '', 'Zum Forum', 'window.open(''http://www.shopware-community.de'',''Shopware'',''width=800,height=550,scrollbars=yes'')', 'background-position: 5px 5px', 'ico2 book\_open', -1, 1, NULL), (81, 65, '', 'ClickPay', 'loadSkeleton(''clickpay'');', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, NULL), (82, 20, '', 'ClickPay Bonitätsüberprüfung', 'loadSkeleton(''clickpay\_rating'');', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, NULL), (83, 20, '', 'Kundenspezifische Preise', 'loadSkeleton(''userprice'');', 'background-position: 5px 5px;', 'ico2 card\_address', 0, 1, NULL), (84, 69, '', 'E-Mail Benachrichtigung', 'loadSkeleton(''notificationStat'');', 'background-position: 5px 5px;', 'ico2 table\_arrow', 4, 1, NULL), (85, 7, '', 'Blog', 'loadSkeleton(''blog'');', 'background-position: 5px 5px;', 'ico2 layout1', 1, 1, NULL), (87, 71, '', 'Alte Templatebasis', 'loadSkeleton(''snippets'')', 'background-position: 5px 5px', 'ico2 plugin', 1, 1, NULL), (90, 23, '', 'Plugins', 'openAction(''plugin'');', 'background-position: 5px 5px;', 'ico2 bricks', -4, 1, NULL), (91, 29, '', 'Textbausteine', 'deleteCache(''snippets'');', 'background-position: 5px 5px;', 'ico2 bin', 1, 1, NULL), (97, 29, '', 'Artikel + Kategorien', 'deleteCache(''articles'');', 'background-position: 5px 5px;', 'ico2 bin', 1, 1, NULL), (98, 29, '', 'Konfiguration', 'deleteCache(''config'');', 'background-position: 5px 5px;', 'ico2 bin', 1, 1, NULL), (99, 23, '', 'Business Essentials', 'openAction(''business\_essentials'');', 'background-position: 5px 5px;', 'ico2 suit', -1, 1, 41), (100, 30, '', 'Slider Komponenten', 'openAction(''RecommendationAdmin'');', 'background-position: 5px 5px;', 'ico2 layout', 0, 1, 32), (101, 23, '', 'Adminer', 'openAction(''Adminer'');', 'background-position: 5px 5px;', 'ico2 server', 0, 1, NULL), (102, 30, '', 'Bonus-System', 'openAction(''BonusSystem'');', '', 'ico2 bonus', 30, 1, 49), (103, 65, '', 'BillSAFE', 'openAction(''payment\_billsafe'');', 'background-position: 5px 5px;', 'ico2 date2', 0, 1, 47); ` ---
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 13:10 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/10 "2012-01-17T13:10:38Z")
unter files/backups finde ich aber nur eine Datei database\_3.5.5\_2012-01-03\_10-45-08.php. Was mache ich denn nun damit. HAbe da leider keine Erfahrung… ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 13:14 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/11 "2012-01-17T13:14:28Z")
kopier einfach von stefan die inhalte und füge das in die datenbank in der datebnak auf SQL klicken dann SQL-Befehl(e) auf Server „localhost“ ausführen: hier gibst du einfach den sql befehl von stefan ein und dann auf OK ---
**Author:** ![plasmatixx](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@plasmatixx](https://forum.shopware.com/u/plasmatixx)\ **Post date:** [17. Januar 2012 um 13:22 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/12 "2012-01-17T13:22:29Z")
DANKE! läuft wieder!!! ---
**Author:** ![MINALO](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@MINALO](https://forum.shopware.com/u/MINALO)\ **Post date:** [17. Januar 2012 um 13:24 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/13 "2012-01-17T13:24:29Z")
besser ist auf eigene festplatte ein datenbank backup zu ziehen bevor du überhaupt welche änderungen machst oder plugins installieren tust lg ---
**Author:** ![Sammy123](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Sammy123](https://forum.shopware.com/u/Sammy123)\ **Post date:** [17. Januar 2012 um 15:23 UTC](https://forum.shopware.com/t/hilfe-tabelle-s-core-menu-in-der-db-geloscht/5845/14 "2012-01-17T15:23:50Z")
Kann dir da nur folgendes ans Herz legen: [http://www.mysqldumper.de/](http://www.mysqldumper.de/) Macht bei uns 2x am Tag per Cronjob ein Backup und sichert es bei zwei verschiedenen Hostern.