Jump to content
Sign in to follow this  
chimerique

Froogle feeder UH OH!

Recommended Posts

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-

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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?


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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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://forums.oscommerce.com" 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>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×