Hallo liebe Community,
ich habe ein Problem und zwar gelange ich leider nicht mehr in unseren Admin bereich. Ich kann mich zwar einloggen aber sobald ich den Bereich betreten möchte erhalte ich eine Fehlermeldung. (USER ERROR(256): "SQL Error")
Ich habe bereits versucht das Update noch einmal zu installieren, allerdings erhalte ich dann ebenfalls eine Fehlermeldung. (siehe unten)
Query: DESCRIBE `admin_access` 'admin_javascript'
Error message: Table 'usr_web1151_1.admin_access' doesn't exist
Query: ALTER TABLE `admin_access` ADD `admin_javascript` INT( 1 ) NOT NULL DEFAULT '0'
Error message: Table 'usr_web1151_1.admin_access' doesn't exist
Query: UPDATE `admin_access` SET `admin_javascript` = 1 WHERE `customers_id` = '1' OR `customers_id` = 'groups'
Error message: Table 'usr_web1151_1.admin_access' doesn't exist
Ich hoffe, dass mir jemand helfen kann das Problem zu beseitigen.
VIELEN DANK
MFG
In dem Musterupdate wird die Tabelle auch garnicht angelegt. Leg sie mal an:
DROP TABLE IF EXISTS `admin_access`;
CREATE TABLE `admin_access` (
`customers_id` varchar(32) NOT NULL default '0',
`configuration` int(1) NOT NULL default '0',
`modules` int(1) NOT NULL default '0',
`countries` int(1) NOT NULL default '0',
`currencies` int(1) NOT NULL default '0',
`zones` int(1) NOT NULL default '0',
`geo_zones` int(1) NOT NULL default '0',
`tax_classes` int(1) NOT NULL default '0',
`tax_rates` int(1) NOT NULL default '0',
`accounting` int(1) NOT NULL default '0',
`backup` int(1) NOT NULL default '0',
`cache` int(1) NOT NULL default '0',
`server_info` int(1) NOT NULL default '0',
`whos_online` int(1) NOT NULL default '0',
`languages` int(1) NOT NULL default '0',
`define_language` int(1) NOT NULL default '0',
`orders_status` int(1) NOT NULL default '0',
`shipping_status` int(1) NOT NULL default '0',
`module_export` int(1) NOT NULL default '0',
`customers` int(1) NOT NULL default '0',
`create_account` int(1) NOT NULL default '0',
`customers_status` int(1) NOT NULL default '0',
`orders` int(1) NOT NULL default '0',
`campaigns` int(1) NOT NULL default '0',
`print_packingslip` int(1) NOT NULL default '0',
`print_order` int(1) NOT NULL default '0',
`popup_memo` int(1) NOT NULL default '0',
`coupon_admin` int(1) NOT NULL default '0',
`listcategories` int(1) NOT NULL default '0',
`gv_queue` int(1) NOT NULL default '0',
`gv_mail` int(1) NOT NULL default '0',
`gv_sent` int(1) NOT NULL default '0',
`validproducts` int(1) NOT NULL default '0',
`validcategories` int(1) NOT NULL default '0',
`mail` int(1) NOT NULL default '0',
`categories` int(1) NOT NULL default '0',
`new_attributes` int(1) NOT NULL default '0',
`products_attributes` int(1) NOT NULL default '0',
`manufacturers` int(1) NOT NULL default '0',
`reviews` int(1) NOT NULL default '0',
`specials` int(1) NOT NULL default '0',
`stats_products_expected` int(1) NOT NULL default '0',
`stats_products_viewed` int(1) NOT NULL default '0',
`stats_products_purchased` int(1) NOT NULL default '0',
`stats_customers` int(1) NOT NULL default '0',
`stats_sales_report` int(1) NOT NULL default '0',
`stats_campaigns` int(1) NOT NULL default '0',
`banner_manager` int(1) NOT NULL default '0',
`banner_statistics` int(1) NOT NULL default '0',
`module_newsletter` int(1) NOT NULL default '0',
`start` int(1) NOT NULL default '0',
`content_manager` int(1) NOT NULL default '0',
`content_preview` int(1) NOT NULL default '0',
`credits` int(1) NOT NULL default '0',
`blacklist` int(1) NOT NULL default '0',
`orders_edit` int(1) NOT NULL default '0',
`popup_image` int(1) NOT NULL default '0',
`csv_backend` int(1) NOT NULL default '0',
`products_vpe` int(1) NOT NULL default '0',
`cross_sell_groups` int(1) NOT NULL default '0',
`econda` int(1) NOT NULL default '0',
`listproducts` int(1) NOT NULL default '0',
`gm_scroller` int(1) NOT NULL default '0',
`gm_pdf` int(1) NOT NULL default '0',
`gm_id_starts` int(1) NOT NULL default '0',
`gm_pdf_order` int(1) NOT NULL default '0',
`gm_pdf_action` int(1) NOT NULL default '0',
`gm_emails` int(1) NOT NULL default '0',
`gm_emails_preview` int(1) NOT NULL default '0',
`gm_guestbook` int(1) NOT NULL default '0',
`gm_counter` int(1) NOT NULL default '0',
`gm_counter_action` int(1) NOT NULL default '0',
`gm_meta` int(1) NOT NULL default '0',
`gm_meta_action` int(1) NOT NULL default '0',
`gm_analytics` int(1) NOT NULL default '0',
`gm_bookmarks` int(1) NOT NULL default '0',
`gm_bookmarks_action` int(1) NOT NULL default '0',
`gm_logo` int(1) NOT NULL default '0',
`gm_security` int(1) NOT NULL default '0',
`gm_style_edit` int(1) NOT NULL default '0',
`gm_send_order` int(1) NOT NULL default '0',
`gm_order_menu` int(1) NOT NULL default '0',
`gm_miscellaneous` int(1) NOT NULL default '0',
`gm_lang_edit` int(1) NOT NULL default '0',
`gm_sitemap` int(1) NOT NULL default '0',
`gm_sitemap_creator` int(1) NOT NULL default '0',
`gm_sql` int(1) NOT NULL default '0',
`gm_offline` int(1) NOT NULL default '0',
`gm_lightbox` int(1) NOT NULL default '0',
`gm_seo_boost` int(1) NOT NULL default '0',
`gm_trusted_shop_id` int(1) NOT NULL default '0',
`gm_opensearch` int(1) NOT NULL default '0',
`gm_opensearch_action` int(1) NOT NULL default '0',
`gm_module_export` int(1) NOT NULL default '0',
`gm_backup_files_zip` int(1) NOT NULL default '0',
`gm_janolaw` int(1) NOT NULL default '0',
`gm_module_part_export` int(1) NOT NULL default '0',
`gm_product_export` int(1) NOT NULL default '0',
`gm_gprint` int(1) NOT NULL default '0',
`gm_gprint_download` int(1) NOT NULL default '0',
`gm_gmotion` int(1) NOT NULL default '0',
`xml_export` int(1) NOT NULL default '0',
`gm_feature_control` int(1) NOT NULL default '0',
`properties` int(1) NOT NULL default '0',
`properties_combis` int(1) NOT NULL default '0',
`request_port` int(1) NOT NULL default '0',
`gm_slider` int(1) NOT NULL default '0',
`template_configuration` int(1) NOT NULL default '0',
`quantity_units` int(1) NOT NULL default '0',
`show_logs` int(1) NOT NULL default '0',
`robots_download` int(1) NOT NULL default '0',
`clear_cache` int(1) NOT NULL default '0',
`directory_scan` int(1) NOT NULL default '0',
`yoochoose` int(1) NOT NULL default '0',
`yatego` int(1) NOT NULL default '0',
`gm_invoicing` int(1) NOT NULL default '0',
`brickfox` int(1) NOT NULL default '0',
`phpminiadmin` int(1) NOT NULL default '0',
`minisql` int(1) NOT NULL default '0',
`ekomi` int(1) NOT NULL default '0',
`magnalister` int(1) NOT NULL default '0',
`mobile` int(1) NOT NULL default '0',
`shopgate` int(1) NOT NULL default '0',
`mediafinanz` int(1) NOT NULL default '0',
`lettr_de` int(1) NOT NULL default '0',
`admin_javascript` int(1) NOT NULL default '0',
`hermes_collection` int(1) NOT NULL default '0',
`hermes_list` int(1) NOT NULL default '0',
`hermes_info` int(1) NOT NULL default '0',
`hermes_order` int(1) NOT NULL default '0',
`hermes_config` int(1) NOT NULL default '0',
`iloxx` int(1) NOT NULL default '0',
`orders_iloxx` int(1) NOT NULL default '0',
`affiliprint_module` int(1) NOT NULL DEFAULT '0',
`csv` int(1) NOT NULL default '0',
`paypal_config` int(1) NOT NULL default '0',
`paypal_logs` int(1) NOT NULL default '0',
`print_intraship_label` int(1) NOT NULL default '0',
`intraship` int(1) NOT NULL default '0',
`klarna_config` int(1) NOT NULL default '0',
`protectedshops` int(1) NOT NULL default '0',
`itrecht_config` int(1) NOT NULL default '0',
`withdrawals` int(1) NOT NULL DEFAULT '0',
`findologic_config` int(1) NOT NULL default '0',
`amazonadvpay` int(1) NOT NULL DEFAULT '0',
`payone_config` int(1) NOT NULL DEFAULT '0',
`payone_logs` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`customers_id`)
) ENGINE=MyISAM;
Powered by vBulletin® Version 4.2.2 Copyright ©2024 Adduco Digital e.K. und vBulletin Solutions, Inc. Alle Rechte vorbehalten.