Guest Posted July 18, 2007 Share Posted July 18, 2007 Well, after several successful minor adjustments and fixes to the site, I got cocky and now I can't access my admin panel. When trying to install Froogle Feeder contrib. After running the feed.sql file in my phpadmin control panel I get the following error message: Error SQL query: INSERT INTO `configuration_group` VALUES ( 62, 'Feed Settings', 'Info for data feeds', 62, 1 ) ; MySQL said: #1062 - Duplicate entry '62' for key 1 I now have no idea what to do. Any help would be greatly appreciated, as I can't access my admin at all. Cheers, -Angel- Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2007 Share Posted July 18, 2007 Well, after several successful minor adjustments and fixes to the site, I got cocky and now I can't access my admin panel. When trying to install Froogle Feeder contrib. After running the feed.sql file in my phpadmin control panel I get the following error message: Error SQL query: INSERT INTO `configuration_group` VALUES ( 62, 'Feed Settings', 'Info for data feeds', 62, 1 ) ; MySQL said: #1062 - Duplicate entry '62' for key 1 I now have no idea what to do. Any help would be greatly appreciated, as I can't access my admin at all. Cheers, -Angel- You say you can't access admin - what error message do you get when you try? Davin Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted July 18, 2007 Share Posted July 18, 2007 That error above is a SQL error not a OSC error. It just simply states you already that entry in your DB. You probably got that error because your ran the SQL twice for that contribution and it is already in there. Like was asked above, what OSC errors are you getting when you try to log in to your admin panel? Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2007 Share Posted July 18, 2007 absolutely zilch. just a blank page. ?? I was backing up as I went with every other change, so I know it is related to this install. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2007 Share Posted July 18, 2007 Compare your current admin/index.php with the last known working one and post up the differences. Davin Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2007 Share Posted July 19, 2007 Thats the weird thing The admin was working ok yesterday morning. I didn't edit the file at all. When I am working, I only back up the files that I am changing, so that I can see exactly what and where I have made changes each day for each edit/contrib. I didn't touch the admin folder at all yesterday other than to upload the froogle feed files (which I have now removed.) Could the feed.sql have automatically edited the admin/index.php ? It is the first time I have run sql on my site myself. Here is the file as it is now: <?php /* $Id: index.php,v 1.19 2003/06/27 09:38:31 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2006 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $cat = array(array('title' => BOX_HEADING_CONFIGURATION, 'image' => 'configuration.gif', 'href' => tep_href_link(FILENAME_CONFIGURATION, 'selected_box=configuration&gID=1'), 'children' => array(array('title' => BOX_CONFIGURATION_MYSTORE, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'selected_box=configuration&gID=1')), array('title' => BOX_CONFIGURATION_LOGGING, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'selected_box=configuration&gID=10')), array('title' => BOX_CONFIGURATION_CACHE, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'selected_box=configuration&gID=11')))), array('title' => BOX_HEADING_MODULES, 'image' => 'modules.gif', 'href' => tep_href_link(FILENAME_MODULES, 'selected_box=modules&set=payment'), 'children' => array(array('title' => BOX_MODULES_PAYMENT, 'link' => tep_href_link(FILENAME_MODULES, 'selected_box=modules&set=payment')), array('title' => BOX_MODULES_SHIPPING, 'link' => tep_href_link(FILENAME_MODULES, 'selected_box=modules&set=shipping')))), array('title' => BOX_HEADING_CATALOG, 'image' => 'catalog.gif', 'href' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog'), 'children' => array(array('title' => CATALOG_CONTENTS, 'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog')), array('title' => BOX_CATALOG_MANUFACTURERS, 'link' => tep_href_link(FILENAME_MANUFACTURERS, 'selected_box=catalog')))), array('title' => BOX_HEADING_LOCATION_AND_TAXES, 'image' => 'location.gif', 'href' => tep_href_link(FILENAME_COUNTRIES, 'selected_box=taxes'), 'children' => array(array('title' => BOX_TAXES_COUNTRIES, 'link' => tep_href_link(FILENAME_COUNTRIES, 'selected_box=taxes')), array('title' => BOX_TAXES_GEO_ZONES, 'link' => tep_href_link(FILENAME_GEO_ZONES, 'selected_box=taxes')))), array('title' => BOX_HEADING_CUSTOMERS, 'image' => 'customers.gif', 'href' => tep_href_link(FILENAME_CUSTOMERS, 'selected_box=customers'), 'children' => array(array('title' => BOX_CUSTOMERS_CUSTOMERS, 'link' => tep_href_link(FILENAME_CUSTOMERS, 'selected_box=customers')), array('title' => BOX_CUSTOMERS_ORDERS, 'link' => tep_href_link(FILENAME_ORDERS, 'selected_box=customers')))), array('title' => BOX_HEADING_LOCALIZATION, 'image' => 'localization.gif', 'href' => tep_href_link(FILENAME_CURRENCIES, 'selected_box=localization'), 'children' => array(array('title' => BOX_LOCALIZATION_CURRENCIES, 'link' => tep_href_link(FILENAME_CURRENCIES, 'selected_box=localization')), array('title' => BOX_LOCALIZATION_LANGUAGES, 'link' => tep_href_link(FILENAME_LANGUAGES, 'selected_box=localization')))), array('title' => BOX_HEADING_REPORTS, 'image' => 'reports.gif', 'href' => tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, 'selected_box=reports'), 'children' => array(array('title' => REPORTS_PRODUCTS, 'link' => tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, 'selected_box=reports')), array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))), array('title' => BOX_HEADING_TOOLS, 'image' => 'tools.gif', 'href' => tep_href_link(FILENAME_BACKUP, 'selected_box=tools'), 'children' => array(array('title' => TOOLS_BACKUP, 'link' => tep_href_link(FILENAME_BACKUP, 'selected_box=tools')), array('title' => TOOLS_BANNERS, 'link' => tep_href_link(FILENAME_BANNER_MANAGER, 'selected_box=tools')), array('title' => TOOLS_FILES, 'link' => tep_href_link(FILENAME_FILE_MANAGER, 'selected_box=tools'))))); $languages = tep_get_languages(); $languages_array = array(); $languages_selected = DEFAULT_LANGUAGE; for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $languages_array[] = array('id' => $languages[$i]['code'], 'text' => $languages[$i]['name']); if ($languages[$i]['directory'] == $language) { $languages_selected = $languages[$i]['code']; } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <style type="text/css"><!-- a { color:#080381; text-decoration:none; } a:hover { color:#aabbdd; text-decoration:underline; } a.text:link, a.text:visited { color: #000000; text-decoration: none; } a:text:hover { color: #000000; text-decoration: underline; } a.main:link, a.main:visited { color: #ffffff; text-decoration: none; } A.main:hover { color: #ffffff; text-decoration: underline; } a.sub:link, a.sub:visited { color: #dddddd; text-decoration: none; } A.sub:hover { color: #dddddd; text-decoration: underline; } .heading { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 20px; font-weight: bold; line-height: 1.5; color: #D3DBFF; } .main { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 17px; font-weight: bold; line-height: 1.5; color: #ffffff; } .sub { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; line-height: 1.5; color: #dddddd; } .text { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; line-height: 1.5; color: #000000; } .menuBoxHeading { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #ffffff; font-weight: bold; background-color: #7187bb; border-color: #7187bb; border-style: solid; border-width: 1px; } .infoBox { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #080381; background-color: #f2f4ff; border-color: #7187bb; border-style: solid; border-width: 1px; } .smallText { font-family: Verdana, Arial, sans-serif; font-size: 10px; } //--></style> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <table border="0" width="600" height="100%" cellspacing="0" cellpadding="0" align="center" valign="middle"> <tr> <td><table border="0" width="600" height="440" cellspacing="0" cellpadding="1" align="center" valign="middle"> <tr bgcolor="#000000"> <td><table border="0" width="600" height="440" cellspacing="0" cellpadding="0"> <tr bgcolor="#ffffff" height="50"> <td height="50"><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td> <td align="right" class="text" nowrap><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . HEADER_TITLE_ADMINISTRATION . '</a> | <a href="' . tep_catalog_href_link() . '">' . HEADER_TITLE_ONLINE_CATALOG . '</a> | <a href="http://www.oscommerce.com" target="_blank">' . HEADER_TITLE_SUPPORT_SITE . '</a>'; ?> </td> </tr> <tr bgcolor="#080381"> <td colspan="2"><table border="0" width="460" height="390" cellspacing="0" cellpadding="2"> <tr valign="top"> <td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2"> <tr> <td valign="top"><br> <?php $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => 'osCommerce'); $contents[] = array('params' => 'class="infoBox"', 'text' => '<a href="http://www.oscommerce.com" target="_blank">' . BOX_ENTRY_SUPPORT_SITE . '</a><br>' . '<a href="http://www.oscommerce.com/forums" target="_blank">' . BOX_ENTRY_SUPPORT_FORUMS . '</a><br>' . '<a href="http://www.oscommerce.com/community/contributions" target="_blank">' . BOX_ENTRY_CONTRIBUTIONS . '</a>'); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; $orders_contents = ''; $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'"); $orders_pending = tep_db_fetch_array($orders_pending_query); $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>'; } $orders_contents = substr($orders_contents, 0, -4); $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_ORDERS); $contents[] = array('params' => 'class="infoBox"', 'text' => $orders_contents); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS); $customers = tep_db_fetch_array($customers_query); $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'"); $products = tep_db_fetch_array($products_query); $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS); $reviews = tep_db_fetch_array($reviews_query); $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_STATISTICS); $contents[] = array('params' => 'class="infoBox"', 'text' => BOX_ENTRY_CUSTOMERS . ' ' . $customers['count'] . '<br>' . BOX_ENTRY_PRODUCTS . ' ' . $products['count'] . '<br>' . BOX_ENTRY_REVIEWS . ' ' . $reviews['count']); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; $contents = array(); if (getenv('HTTPS') == 'on') { $size = ((getenv('SSL_CIPHER_ALGKEYSIZE')) ? getenv('SSL_CIPHER_ALGKEYSIZE') . '-bit' : '<i>' . BOX_CONNECTION_UNKNOWN . '</i>'); $contents[] = array('params' => 'class="infoBox"', 'text' => tep_image(DIR_WS_ICONS . 'locked.gif', ICON_LOCKED, '', '', 'align="right"') . sprintf(BOX_CONNECTION_PROTECTED, $size)); } else { $contents[] = array('params' => 'class="infoBox"', 'text' => tep_image(DIR_WS_ICONS . 'unlocked.gif', ICON_UNLOCKED, '', '', 'align="right"') . BOX_CONNECTION_UNPROTECTED); } $box = new box; echo $box->tableBlock($contents); ?> </td> </tr> </table></td> <td width="460"><table border="0" width="460" height="390" cellspacing="0" cellpadding="2"> <tr> <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr><?php echo tep_draw_form('languages', 'index.php', '', 'get'); ?> <td class="heading"><?php echo HEADING_TITLE; ?></td> <td align="right"><?php echo tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"'); ?></td> </form></tr> </table></td> </tr> <?php $col = 2; $counter = 0; for ($i = 0, $n = sizeof($cat); $i < $n; $i++) { $counter++; if ($counter < $col) { echo ' <tr>' . "\n"; } echo ' <td><table border="0" cellspacing="0" cellpadding="2">' . "\n" . ' <tr>' . "\n" . ' <td><a href="' . $cat[$i]['href'] . '">' . tep_image(DIR_WS_IMAGES . 'categories/' . $cat[$i]['image'], $cat[$i]['title'], '32', '32') . '</a></td>' . "\n" . ' <td><table border="0" cellspacing="0" cellpadding="2">' . "\n" . ' <tr>' . "\n" . ' <td class="main"><a href="' . $cat[$i]['href'] . '" class="main">' . $cat[$i]['title'] . '</a></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="sub">'; $children = ''; for ($j = 0, $k = sizeof($cat[$i]['children']); $j < $k; $j++) { $children .= '<a href="' . $cat[$i]['children'][$j]['link'] . '" class="sub">' . $cat[$i]['children'][$j]['title'] . '</a>, '; } echo substr($children, 0, -2); echo '</td> ' . "\n" . ' </tr>' . "\n" . ' </table></td>' . "\n" . ' </tr>' . "\n" . ' </table></td>' . "\n"; if ($counter >= $col) { echo ' </tr>' . "\n"; $counter = 0; } } ?> </table></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php require(DIR_WS_INCLUDES . 'footer.php'); ?></td> </tr> </table></td> </tr> </table> </body> </html> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.