Separate Pricing Per Customer (SPPC) Version 4.2.1a

[email protected] · May 12, 2008

I have installed Separate Pricing Per Customer (SPPC) Version 4.2.1a and ran the install script. When I go into the administration of the store area = now my products are not listed - nor are orders and customers - yet product attributes are still there

Yet the store is working - I can log in with my customer information - and see all the products - so it would seem the data is still there.

If anyone could please help me - even if it's to point me to an existing answer( I searched the forum with the term Separate Pricing Per Customer 4.2.1a) and I didn't see any solutions that discribed my issue.

many thanks in advance

grace

Jan Zonjee · May 12, 2008

I have installed Separate Pricing Per Customer (SPPC) Version 4.2.1a and ran the install script. When I go into the administration of the store area = now my products are not listed - nor are orders and customers - yet product attributes are still there

Yet the store is working - I can log in with my customer information - and see all the products - so it would seem the data is still there.

You don't give us much information do you? From what you write I think I can conclude you ran the sql script (which wouldn't cause any errors to existing scripts IMO) and then installed SPPC using the install instructions manually or by changing files? And then suddenly you find out you cannot get into certain pages in the admin? But you can in others? No errors printed to the screen, or do you see part of a page (do a view source to see if there is more info). In short, contrary to popular belief nobody here has crystal balls that can see in your files or your site to see what is wrong.

Of course installing such a large contribution on a live store is tricky. You should do that locally on your computer first, using a copy of your store.

SPPC has it's own thread by the way. Rather large also. Strange you didn't find it (it is mentioned in the install instructions).

[email protected] · May 12, 2008

You don't give us much information do you? From what you write I think I can conclude you ran the sql script (which wouldn't cause any errors to existing scripts IMO) and then installed SPPC using the install instructions manually or by changing files? And then suddenly you find out you cannot get into certain pages in the admin? But you can in others? No errors printed to the screen, or do you see part of a page (do a view source to see if there is more info). In short, contrary to popular belief nobody here has crystal balls that can see in your files or your site to see what is wrong.

Of course installing such a large contribution on a live store is tricky. You should do that locally on your computer first, using a copy of your store.

SPPC has it's own thread by the way. Rather large also. Strange you didn't find it (it is mentioned in the install instructions).

thank-you for replying to me, I did find the SPPC - but it is tied to version 3.5 from what I understood - I am new at posting, didn't mean to annoy anyone.

I have installed on a live store - I thought I understood what I was doing and the instructions did seem clear. I ran the .sql script and then ftp'ed all contribution files to the appropriate spots in the estore file.

the url of the store is http://luvubeauty.com/osCommerce1/catalog/index.php And on the most part this seems to be working, I can log in or create a new account - and I can see all the products. When I try to check-out I get a blank page http://luvubeauty.com/osCommerce1/catalog/...ut_shipping.php and when I did a view source the following is the result.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

not sure what else you need ?

Jan Zonjee · May 13, 2008

thank-you for replying to me, I did find the SPPC - but it is tied to version 3.5 from what I understood

The thread dates from that version so that is why.

When I try to check-out I get a blank page and when I did a view source the following is the result.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>

<BODY></BODY></HTML>

not sure what else you need ?

Very likely there is a PHP error and most likely it originates from /includes/classes/shipping.php. I would suggest putting the backup or the original osC one back. Then it least your business can continue.

Important is to get the reported errors and then if you know the line on which the error is located some code of that page with lines above and below the "error line". Otherwise it is very hard to find the problem.

[email protected] · May 13, 2008

The thread dates from that version so that is why.

Very likely there is a PHP error and most likely it originates from /includes/classes/shipping.php. I would suggest putting the backup or the original osC one back. Then it least your business can continue.

Important is to get the reported errors and then if you know the line on which the error is located some code of that page with lines above and below the "error line". Otherwise it is very hard to find the problem.

I did try and replace /includes/classes/shipping.php with an original file and it doesn't appear to help. Thanks for suggestions I will try anything.

I do have access to myphpadmin and I've notice I have a customers_group_id smallint(5) UNSIGNED No 0 and am searching for the answer to this as I am sure I read it yesterday.

Jan Zonjee · May 13, 2008

I've notice I have a customers_group_id smallint(5) UNSIGNED No 0 and am searching for the answer to this as I am sure I read it yesterday.

There is no problem with that. There should be one group inserted in the table customers_groups (comes with the install sql) and that is the retail group (is and should stay customer_group_id zero).

[email protected] · May 13, 2008

There is no problem with that. There should be one group inserted in the table customers_groups (comes with the install sql) and that is the retail group (is and should stay customer_group_id zero).

ok thanks - I admit I am lost as what to do. I don't want to mess up this shop any worse than I have.

When I looked at the table customer_groups

Field Type Collation Attributes Null Default Extra Action

customers_group_id smallint(5) UNSIGNED No

customers_group_name varchar(32) latin1_swedish_ci No

customers_group_id smallint(5) doesn't have a collation file listing and default is blank and not zero

I copied customer_group_name to give an example of the collation that appears under all other files in that table.

[email protected] · May 13, 2008

ok thanks - I admit I am lost as what to do. I don't want to mess up this shop any worse than I have.

When I looked at the table customer_groups

Field Type Collation Attributes Null Default Extra Action

customers_group_id smallint(5) UNSIGNED No

customers_group_name varchar(32) latin1_swedish_ci No

customers_group_id smallint(5) doesn't have a collation file listing and default is blank and not zero

I copied customer_group_name to give an example of the collation that appears under all other files in that table.

okay I am desperate to get the store back to normal - if I use the uninstall sql that came with the SPPC module will it mess up the store further. Is anyone able to private message me so I could give admin login information to help me through the back end ? I've learned my lesson - never ever install on a live store.

Jan Zonjee · May 13, 2008

if I use the uninstall sql that came with the SPPC module will it mess up the store further.

Yes, then you are even worse off. It is no problem that the default is blank for customer_group_id in the table customers_groups. It should be default zero in the table customers (so when a new customer is inserted they end up in the retail group first).

No panic please. Have you asked your hosting provider where they have the error log for your site?

[email protected] · May 13, 2008

Yes, then you are even worse off. It is no problem that the default is blank for customer_group_id in the table customers_groups. It should be default zero in the table customers (so when a new customer is inserted they end up in the retail group first).

No panic please. Have you asked your hosting provider where they have the error log for your site?

Yes I have requested the location of the error files and hope to hear back soon. In the meantime - if I go into the store admin and select option

http://luvubeauty.com/osCommerce1/catalog/...n/customers.php

the page comes up - but no customer names appear

here is the exact code

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<title>osCommerce Online Merchant Administration Tool</title>

</head>

<tr>

<td align="right"><a href="http://www.oscommerce.com" target="_blank"><img src="images/header_support.gif" border="0" alt="Support Site" title=" Support Site " width="50" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/"><img'>http://luvubeauty.com/osCommerce1/catalog/"><img src="images/header_checkout.gif" border="0" alt="Online Catalog" title=" Online Catalog " width="53" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img'>http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img src="images/header_administration.gif" border="0" alt="Administration" title=" Administration " width="50" height="50"></a> </td>

</tr>

<td class="headerBarContent"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a></td>

<td class="headerBarContent" align="right"><a href="http://www.oscommerce.com" class="headerLink">Support Site</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/" class="headerLink">Online Catalog</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a> </td>

</tr>

</table>

<tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration" class="menuBoxHeadingLink">Configuration</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog" class="menuBoxHeadingLink">Catalog</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules" class="menuBoxHeadingLink">Modules</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers" class="menuBoxHeadingLink">Customers</a> </td>

</tr>

</table>

<tr>

<td class="menuBoxContent"><a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php" class="menuBoxContentLink">Customers</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/orders.php" class="menuBoxContentLink">Orders</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers_groups.php" class="menuBoxContentLink">Customers Groups</a></td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes" class="menuBoxHeadingLink">Locations / Taxes</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization" class="menuBoxHeadingLink">Localization</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports" class="menuBoxHeadingLink">Reports</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools" class="menuBoxHeadingLink">Tools</a> </td>

</tr>

</table>

</table>

</td>

</tr>

</table></td>

<tr>

<tr><form name="search" action="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php" method="get"> <td class="pageHeading">Customers</td>

<td class="smallText" align="right">Search: <input type="text" name="search"></td>

Same thing if I open up orders under the admin section the page appears - but no orders show

the exact code is

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<title>osCommerce Online Merchant Administration Tool</title>

</head>

<tr>

<td align="right"><a href="http://www.oscommerce.com" target="_blank"><img src="images/header_support.gif" border="0" alt="Support Site" title=" Support Site " width="50" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/"><img'>http://luvubeauty.com/osCommerce1/catalog/"><img src="images/header_checkout.gif" border="0" alt="Online Catalog" title=" Online Catalog " width="53" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img'>http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img src="images/header_administration.gif" border="0" alt="Administration" title=" Administration " width="50" height="50"></a> </td>

</tr>

<td class="headerBarContent"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a></td>

<td class="headerBarContent" align="right"><a href="http://www.oscommerce.com" class="headerLink">Support Site</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/" class="headerLink">Online Catalog</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a> </td>

</tr>

</table>

<tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration" class="menuBoxHeadingLink">Configuration</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog" class="menuBoxHeadingLink">Catalog</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules" class="menuBoxHeadingLink">Modules</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers" class="menuBoxHeadingLink">Customers</a> </td>

</tr>

</table>

<tr>

<td class="menuBoxContent"><a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php" class="menuBoxContentLink">Customers</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/orders.php" class="menuBoxContentLink">Orders</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers_groups.php" class="menuBoxContentLink">Customers Groups</a></td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes" class="menuBoxHeadingLink">Locations / Taxes</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization" class="menuBoxHeadingLink">Localization</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports" class="menuBoxHeadingLink">Reports</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools" class="menuBoxHeadingLink">Tools</a> </td>

</tr>

</table>

</table>

</td>

</tr>

</table></td>

<tr>

<tr>

<td class="pageHeading">Orders</td>

<tr><form name="orders" action="http://luvubeauty.com/osCommerce1/catalog/admin/orders.php" method="get"> <td class="smallText" align="right">Order ID: <input type="text" name="oID" size="12"><input type="hidden" name="action" value="edit"></td>

When I try to view http://luvubeauty.com/osCommerce1/catalog/.../categories.php

the page comes up but no data or products listed.

here is the exact code

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<title>osCommerce Online Merchant Administration Tool</title>

</head>

<tr>

<td align="right"><a href="http://www.oscommerce.com" target="_blank"><img src="images/header_support.gif" border="0" alt="Support Site" title=" Support Site " width="50" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/"><img'>http://luvubeauty.com/osCommerce1/catalog/"><img src="images/header_checkout.gif" border="0" alt="Online Catalog" title=" Online Catalog " width="53" height="50"></a> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img'>http://luvubeauty.com/osCommerce1/catalog/admin/index.php"><img src="images/header_administration.gif" border="0" alt="Administration" title=" Administration " width="50" height="50"></a> </td>

</tr>

<td class="headerBarContent"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a></td>

<td class="headerBarContent" align="right"><a href="http://www.oscommerce.com" class="headerLink">Support Site</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/" class="headerLink">Online Catalog</a> | <a href="http://luvubeauty.com/osCommerce1/catalog/admin/index.php" class="headerLink">Administration</a> </td>

</tr>

</table>

<tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/configuration.php?gID=1&selected_box=configuration" class="menuBoxHeadingLink">Configuration</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/categories.php?selected_box=catalog" class="menuBoxHeadingLink">Catalog</a> </td>

</tr>

</table>

<tr>

<td class="menuBoxContent"><a href="http://luvubeauty.com/osCommerce1/catalog/admin/categories.php" class="menuBoxContentLink">Categories/Products</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/products_attributes.php" class="menuBoxContentLink">Products Attributes</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/manufacturers.php" class="menuBoxContentLink">Manufacturers</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/reviews.php" class="menuBoxContentLink">Reviews</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/specials.php" class="menuBoxContentLink">Specials</a><br><a href="http://luvubeauty.com/osCommerce1/catalog/admin/products_expected.php" class="menuBoxContentLink">Products Expected</a></td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/modules.php?set=payment&selected_box=modules" class="menuBoxHeadingLink">Modules</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/customers.php?selected_box=customers" class="menuBoxHeadingLink">Customers</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/countries.php?selected_box=taxes" class="menuBoxHeadingLink">Locations / Taxes</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/currencies.php?selected_box=localization" class="menuBoxHeadingLink">Localization</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/stats_products_viewed.php?selected_box=reports" class="menuBoxHeadingLink">Reports</a> </td>

</tr>

</table>

</table>

</td>

</tr>

<tr>

<td>

<tr>

<td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools'"> <a href="http://luvubeauty.com/osCommerce1/catalog/admin/backup.php?selected_box=tools" class="menuBoxHeadingLink">Tools</a> </td>

</tr>

</table>

</table>

</td>

</tr>

</table></td>

<tr>

<tr>

<td class="pageHeading">Categories / Products</td>

<tr>

<form name="search" action="http://luvubeauty.com/osCommerce1/catalog/admin/categories.php" method="get">Search: <input type="text" name="search">

all other areas under the catalogue category such as product attributes, manufacturers, reviews - etc seem to work ok and have correct data

Jan Zonjee · May 13, 2008

Yes I have requested the location of the error files and hope to hear back soon. In the meantime - if I go into the store admin and select option

admin/customers.php

the page comes up - but no customer names appear

Where the code ends is where this PHP code is:

<?php echo tep_hide_session_id(); ?>

This is a common issue where you mix an old osC 2.2 (problem that hosting providers do not update the version of osC that their customers can install...) with files from a new version.

The function tep_hide_session can be found in catalog/includes/functions/html_output.php:

////
// Hide form elements
 function tep_hide_session_id() {
$string = '';

if (defined('SID') && tep_not_null(SID)) {
  $string = tep_draw_hidden_field(tep_session_name(), tep_session_id());
}

return $string;
 }

This function should be added to the admin file (admin/includes/functions/html_output.php) too.

Word of advice: you should change the name of directory admin to something less easy to guess (oeiuowgh perhaps? :) ).

A. It is the first place where would-be hackers are looking to test for vulnerabilities so make it harder for them.

B. Now that you posted the exact location it is even worse.

You will have to change DIR_FS_ADMIN and DIR_WS_ADMIN in oeiuowgh/includes/configure.php to reflect the change of admin->oeiuowgh

[email protected] · May 13, 2008

Where the code ends is where this PHP code is:
<?php echo tep_hide_session_id(); ?>
This is a common issue where you mix an old osC 2.2 (problem that hosting providers do not update the version of osC that their customers can install...) with files from a new version.

The function tep_hide_session can be found in catalog/includes/functions/html_output.php:
////
// Hide form elements
 function tep_hide_session_id() {
$string = '';

if (defined('SID') && tep_not_null(SID)) {
  $string = tep_draw_hidden_field(tep_session_name(), tep_session_id());
}

return $string;
 }
This function should be added to the admin file (admin/includes/functions/html_output.php) too.

The code exists but looks quite different from what you provided - here it is - making sure I replace the code you provided instead of what I've copied below ??

////

// Hide form elements

function tep_hide_session_id() {

global $session_started, $SID;

if (($session_started == true) && tep_not_null($SID)) {

return tep_draw_hidden_field(tep_session_name(), tep_session_id());

}

}

Word of advice: you should change the name of directory admin to something less easy to guess (oeiuowgh perhaps? :) ).

A. It is the first place where would-be hackers are looking to test for vulnerabilities so make it harder for them.

B. Now that you posted the exact location it is even worse.

You will have to change DIR_FS_ADMIN and DIR_WS_ADMIN in oeiuowgh/includes/configure.php to reflect the change of admin->oeiuowgh

Thank you I will make sure to take this step - as well as have all current customers change their passwords as soon as I have it fixed.

Jan Zonjee · May 13, 2008

as well as have all current customers change their passwords as soon as I have it fixed.

Huh?? Why?? Nobody should have been able to get into your admin and even then the passwords are saved encrypted...

[email protected] · May 14, 2008

Yes I have requested the location of the error files and hope to hear back soon. In the meantime - if I go into the store admin and select option

one of the last error in the file seems to indicate I can no longer use email addresses with @ ? Currently customers log in with email addy and password.

PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: The session id contains invalid characters, valid characters are only a-z, A-Z and 0-9 in /hermes/bosweb/web056/b568/sl.luvubeau/public_html/osCommerce1/catalog/includes/functions/sessions.php on line 68

[email protected] · May 14, 2008

Yes I have requested the location of the error files and hope to hear back soon.

one of the last errors in the file seems to indicate I can no longer use email addresses with @ ? Currently customers log in with email addy and password.

here is the error.

PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: The session id contains invalid characters, valid characters are only a-z, A-Z and 0-9 catalog/includes/functions/sessions.php on line 68

I get that I need to edit catalog/includes/functions/sessions.php on line 68

my question is should my code there look like a-z, A-Z,@,., and 0-9

so that email addresses would be accepted ?

thanks for any assistance

grace

Jan Zonjee · May 14, 2008

I get that I need to edit catalog/includes/functions/sessions.php on line 68

my question is should my code there look like a-z, A-Z,@,., and 0-9

so that email addresses would be accepted ?

I don't get it at all. Who gets that error and when and how? Following the links in your posts above I see a osC session_id that is perfectly normal, so I wouldn't start tinkering with that at the moment.

I think you are also missing the new function calculate_price in your classes/currencies.php. I think there is mention of it in the install.html.

Edited May 14, 2008 by Jan Zonjee

[email protected] · May 14, 2008

I don't get it at all. Who gets that error and when and how? Following the links in your posts above I see a osC session_id that is perfectly normal, so I wouldn't start tinkering with that at the moment.

I think you are also missing the new function calculate_price in your classes/currencies.php. I think there is mention of it in the install.html.

Ok I won't tinker - the error came from the error logs you recommended I look at. There were so many errors I didn't know which of them to post. I will go and look for calculate_price issue. thanks for hint (-:

[email protected] · May 14, 2008

Ok I won't tinker - the error came from the error logs you recommended I look at. There were so many errors I didn't know which of them to post. I will go and look for calculate_price issue. thanks for hint (-:

I've looked all the way through install.html and could find no mention of this. I am sure it's me - I've been looking till I am dizzy.

List of files that need to be changed:

catalog/admin/includes/boxes/customers.php

catalog/admin/includes/functions/general.php

catalog/admin/includes/languages/english/attributes_groups.php (upload)

catalog/admin/includes/languages/english/categories.php (German and Spanish versions in their respective directories)

catalog/admin/includes/languages/english/customers.php

catalog/admin/includes/languages/english/customers_groups.php (upload, German and Spanish versions in their respective directories)

catalog/admin/includes/languages/english/orders.php

catalog/admin/includes/languages/english/products_attributes.php

catalog/admin/includes/languages/english/specials.php

catalog/admin/includes/languages/english.php

catalog/admin/includes/database_tables.php

catalog/admin/includes/filenames.php

catalog/admin/attributes_groups.php (upload)

catalog/admin/customers_groups.php (upload)

catalog/admin/categories.php

catalog/admin/customers.php

catalog/admin/includes/classes/order.php (optional)

catalog/admin/orders.php (optional)

catalog/admin/product_attributes.php

catalog/admin/specials.php

catalog/includes/database_tables.php

catalog/includes/boxes/specials.php

catalog/includes/boxes/whats_new.php

catalog/includes/classes/order.php

catalog/includes/classes/order_total.php

catalog/includes/classes/payment.php

catalog/includes/classes/shipping.php

catalog/includes/classes/shopping_cart.php

catalog/includes/functions/database.php

catalog/includes/functions/general.php

catalog/includes/languages/english/login.php

catalog/includes/languages/english.php (for german.php and espanol.php see files)

catalog/includes/modules/new_products.php

catalog/includes/modules/product_listing.php

catalog/advanced_search_result.php

catalog/create_account.php

catalog/account_edit.php

catalog/checkout_process.php

catalog/index.php

catalog/login.php

catalog/logoff.php

catalog/product_info.php

catalog/product_reviews.php

catalog/product_reviews_info.php

catalog/product_reviews_write.php

catalog/products_new.php

catalog/specials.php

catalog/admin/includes/languages/english/mail.php (optional)

catalog/admin/includes/languages/english/newsletters.php (optional)

catalog/admin/mail.php (optional)

catalog/admin/newsletters.php (optional)

catalog/admin/includes/modules/newsletters/newsletter.php (optional)

catalog/admin/includes/modules/newsletters/product_notification.php (optional)

[email protected] · May 14, 2008

Ok I won't tinker - the error came from the error logs you recommended I look at. There were so many errors I didn't know which of them to post. I will go and look for calculate_price issue. thanks for hint (-:

Yippy thanks Jan - the store is working - at least a part that wasn't now is. and while I didn't find the solution in the install.html I did find it! Whew... maybe I've earned a lunch break. (-:

From elsewhere http://www.oscommerce.com/forums/index.php?showtopic=232870 came this answer....

--------------------------------------------------------------------

This post has been edited by nimz: Dec 16 2007, 09:19 PM

--------------------

Santa's little freelancer

function calculate_price() is missing from file catalog/admin/includes/classes/currencies.php included in the archive.

if you have done the manual installation then you are fine however if you copied the included files in the archive over your files then you will have a problem.

Not having the above function doesn't prevent the add-on from installing however as soon as you add aproduct to your cart things will get messy.

here's how to fix this issue:

open catalog/includes/classes/currencies.php

FIND:

CODE

function is_set($code) {

if (isset($this->currencies[$code]) && tep_not_null($this->currencies[$code])) {

return true;

} else {

return false;

}

ADD BEFORE:

CODE

function calculate_price($products_price, $products_tax, $quantity = 1) {

global $currency;

return tep_round(tep_add_tax($products_price, $products_tax), $this->currencies[$currency]['decimal_places']) * $quantity;

}

This post has been edited by nimz: Dec 16 2007, 09:19 PM

--------------------

Santa's little freelancer

[email protected] · May 14, 2008

Where the code ends is where this PHP code is:
<?php echo tep_hide_session_id(); ?>
This is a common issue where you mix an old osC 2.2 (problem that hosting providers do not update the version of osC that their customers can install...) with files from a new version.

The function tep_hide_session can be found in catalog/includes/functions/html_output.php:
////
// Hide form elements
 function tep_hide_session_id() {
$string = '';

if (defined('SID') && tep_not_null(SID)) {
  $string = tep_draw_hidden_field(tep_session_name(), tep_session_id());
}

return $string;
 }
This function should be added to the admin file (admin/includes/functions/html_output.php) too.

I tried adding this code to the files indicated and both the store and the admin section came up totally blank. I quickly uploaded a back up of the file and the site is back. Is there something I did wrong this is what I pasted - & I pasted just above the last ?>

////

// Hide form elements

function tep_hide_session_id() {

$string = '';

if (defined('SID') && tep_not_null(SID)) {

$string = tep_draw_hidden_field(tep_session_name(), tep_session_id());

}

return $string;

}

Jan Zonjee · May 14, 2008

and while I didn't find the solution in the install.html I did find it!

It was under the heading Support:

IMPORTANT: If you have an older installation of osC and start adding files from this contribution be aware that some things have been changed. You might get an error about includes/classes/currencies.php missing the function calculate_price (this was added in RC1, see a download of RC2a, folder extras for the instructions on how to update) and the function tep_hide_session that has always been present and only used on the catalog side was also added to the admin side in catalog/admin/includes/functions/html_output.php (RC1 again).

In RC2 a new function was added to includes/classes/payment.php: checkout_initialization_method.

You might be missing that last function too....

Jan Zonjee · May 14, 2008

I am sure it's me - I've been looking till I am dizzy.

I'm quite sure your webbrowser comes with the possibility to search for words in an open web page. That is what I use(d).

Jan Zonjee · May 14, 2008

I tried adding this code to the files indicated and both the store and the admin section came up totally blank.

I think I was clear: this function is already there on the catalog side (you will surely get an error when you add it twice) but the errors indicate you haven't added it to the admin side. Only the error can indicate what now went wrong on the admin side.

[email protected] · May 14, 2008

I think I was clear: this function is already there on the catalog side (you will surely get an error when you add it twice) but the errors indicate you haven't added it to the admin side. Only the error can indicate what now went wrong on the admin side.

I am sorry - you were clear, it's just I clearly am not a programmer and I am tired and trying very hard to get the store back to normal. I know your time is valuable and trust me I've appreciated your help.

I tried adding

////

// Hide form elements

function tep_hide_session_id() {

$string = '';

if (defined('SID') && tep_not_null(SID)) {

$string = tep_draw_hidden_field(tep_session_name(), tep_session_id());

}

return $string;

}

to just the admin area and it returns a blank admin area.

my existing html_output.php looks like this

<?php

/*

$Id: html_output.php,v 1.29 2003/06/25 20:32:44 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

////

// The HTML href link wrapper function

function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL') {

if ($page == '') {

die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>Function used:<br><br>tep_href_link('' . $page . '', '' . $parameters . '', '' . $connection . '')</b>');

}

if ($connection == 'NONSSL') {

$link = HTTP_SERVER . DIR_WS_ADMIN;

} elseif ($connection == 'SSL') {

if (ENABLE_SSL == 'true') {

$link = HTTPS_SERVER . DIR_WS_ADMIN;

} else {

$link = HTTP_SERVER . DIR_WS_ADMIN;

}

} else {

die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL<br><br>Function used:<br><br>tep_href_link('' . $page . '', '' . $parameters . '', '' . $connection . '')</b>');

}

if ($parameters == '') {

$link = $link . $page . '?' . SID;

} else {

$link = $link . $page . '?' . $parameters . '&' . SID;

}

while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);

return $link;

}

function tep_catalog_href_link($page = '', $parameters = '', $connection = 'NONSSL') {

if ($connection == 'NONSSL') {

$link = HTTP_CATALOG_SERVER . DIR_WS_CATALOG;

} elseif ($connection == 'SSL') {

if (ENABLE_SSL_CATALOG == 'true') {

$link = HTTPS_CATALOG_SERVER . DIR_WS_CATALOG;

} else {

$link = HTTP_CATALOG_SERVER . DIR_WS_CATALOG;

}

} else {

die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL<br><br>Function used:<br><br>tep_href_link('' . $page . '', '' . $parameters . '', '' . $connection . '')</b>');

}

if ($parameters == '') {

$link .= $page;

} else {

$link .= $page . '?' . $parameters;

}

while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);

return $link;

}

////

// The HTML image wrapper function

function tep_image($src, $alt = '', $width = '', $height = '', $params = '') {

$image = '<img src="' . $src . '" border="0" alt="' . $alt . '"';

if ($alt) {

$image .= ' title=" ' . $alt . ' "';

}

if ($width) {

$image .= ' width="' . $width . '"';

}

if ($height) {

$image .= ' height="' . $height . '"';

}

if ($params) {

$image .= ' ' . $params;

}

$image .= '>';

return $image;

}

////

// The HTML form submit button wrapper function

// Outputs a button in the selected language

function tep_image_submit($image, $alt = '', $parameters = '') {

global $language;

$image_submit = '<input type="image" src="' . tep_output_string(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image) . '" border="0" alt="' . tep_output_string($alt) . '"';

if (tep_not_null($alt)) $image_submit .= ' title=" ' . tep_output_string($alt) . ' "';

if (tep_not_null($parameters)) $image_submit .= ' ' . $parameters;

$image_submit .= '>';

return $image_submit;

}

////

// Draw a 1 pixel black line

function tep_black_line() {

return tep_image(DIR_WS_IMAGES . 'pixel_black.gif', '', '100%', '1');

}

////

// Output a separator either through whitespace, or with an image

function tep_draw_separator($image = 'pixel_black.gif', $width = '100%', $height = '1') {

return tep_image(DIR_WS_IMAGES . $image, '', $width, $height);

}

////

// Output a function button in the selected language

function tep_image_button($image, $alt = '', $params = '') {

global $language;

return tep_image(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image, $alt, '', '', $params);

}

////

// javascript to dynamically update the states/provinces list when the country is changed

// TABLES: zones

function tep_js_zone_list($country, $form, $field) {

$countries_query = tep_db_query("select distinct zone_country_id from " . TABLE_ZONES . " order by zone_country_id");

$num_country = 1;

$output_string = '';

while ($countries = tep_db_fetch_array($countries_query)) {

if ($num_country == 1) {

$output_string .= ' if (' . $country . ' == "' . $countries['zone_country_id'] . '") {' . "n";

} else {

$output_string .= ' } else if (' . $country . ' == "' . $countries['zone_country_id'] . '") {' . "n";

}

$states_query = tep_db_query("select zone_name, zone_id from " . TABLE_ZONES . " where zone_country_id = '" . $countries['zone_country_id'] . "' order by zone_name");

$num_state = 1;

while ($states = tep_db_fetch_array($states_query)) {

if ($num_state == '1') $output_string .= ' ' . $form . '.' . $field . '.options[0] = new Option("' . PLEASE_SELECT . '", "");' . "n";

$output_string .= ' ' . $form . '.' . $field . '.options[' . $num_state . '] = new Option("' . $states['zone_name'] . '", "' . $states['zone_id'] . '");' . "n";

$num_state++;

}

$num_country++;

}

$output_string .= ' } else {' . "n" .

' ' . $form . '.' . $field . '.options[0] = new Option("' . TYPE_BELOW . '", "");' . "n" .

' }' . "n";

return $output_string;

}

////

// Output a form

function tep_draw_form($name, $action, $parameters = '', $method = 'post', $params = '') {

$form = '<form name="' . tep_output_string($name) . '" action="';

if (tep_not_null($parameters)) {

$form .= tep_href_link($action, $parameters);

} else {

$form .= tep_href_link($action);

}

$form .= '" method="' . tep_output_string($method) . '"';

if (tep_not_null($params)) {

$form .= ' ' . $params;

}

$form .= '>';

return $form;

}

////

// Output a form input field

function tep_draw_input_field($name, $value = '', $parameters = '', $required = false, $type = 'text', $reinsert_value = true) {

$field = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

if (isset($GLOBALS[$name]) && ($reinsert_value == true) && is_string($GLOBALS[$name])) {

$field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';

} elseif (tep_not_null($value)) {

$field .= ' value="' . tep_output_string($value) . '"';

}

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

return $field;

}

////

// Output a form password field

function tep_draw_password_field($name, $value = '', $required = false) {

$field = tep_draw_input_field($name, $value, 'maxlength="40"', $required, 'password', false);

return $field;

}

////

// Output a form filefield

function tep_draw_file_field($name, $required = false) {

$field = tep_draw_input_field($name, '', '', $required, 'file');

return $field;

}

////

// Output a selection field - alias function for tep_draw_checkbox_field() and tep_draw_radio_field()

function tep_draw_selection_field($name, $type, $value = '', $checked = false, $compare = '') {

$selection = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

if (tep_not_null($value)) $selection .= ' value="' . tep_output_string($value) . '"';

if ( ($checked == true) || (isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ($GLOBALS[$name] == 'on')) || (isset($value) && isset($GLOBALS[$name]) && (stripslashes($GLOBALS[$name]) == $value)) || (tep_not_null($value) && tep_not_null($compare) && ($value == $compare)) ) {

$selection .= ' CHECKED';

}

$selection .= '>';

return $selection;

}

////

// Output a form checkbox field

function tep_draw_checkbox_field($name, $value = '', $checked = false, $compare = '') {

return tep_draw_selection_field($name, 'checkbox', $value, $checked, $compare);

}

////

// Output a form radio field

function tep_draw_radio_field($name, $value = '', $checked = false, $compare = '') {

return tep_draw_selection_field($name, 'radio', $value, $checked, $compare);

}

////

// Output a form textarea field

function tep_draw_textarea_field($name, $wrap, $width, $height, $text = '', $parameters = '', $reinsert_value = true) {

$field = '<textarea name="' . tep_output_string($name) . '" wrap="' . tep_output_string($wrap) . '" cols="' . tep_output_string($width) . '" rows="' . tep_output_string($height) . '"';

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if ( (isset($GLOBALS[$name])) && ($reinsert_value == true) ) {

$field .= stripslashes($GLOBALS[$name]);

} elseif (tep_not_null($text)) {

$field .= $text;

}

$field .= '</textarea>';

return $field;

}

////

// Output a form hidden field

function tep_draw_hidden_field($name, $value = '', $parameters = '') {

$field = '<input type="hidden" name="' . tep_output_string($name) . '"';

if (tep_not_null($value)) {

$field .= ' value="' . tep_output_string($value) . '"';

} elseif (isset($GLOBALS[$name]) && is_string($GLOBALS[$name])) {

$field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';

}

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

return $field;

}

////

// Output a form pull down menu

function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {

$field = '<select name="' . tep_output_string($name) . '"';

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

for ($i=0, $n=sizeof($values); $i<$n; $i++) {

$field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';

if ($default == $values[$i]['id']) {

$field .= ' SELECTED';

}

$field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', ''' => ''', '<' => '<', '>' => '>')) . '</option>';

}

$field .= '</select>';

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

return $field;

}

?>

and some of the errors seem to be

PHP Fatal error: Call to undefined function: tep_hide_session_id() in /catalog/admin/orders.php on line 341

PHP Fatal error: Call to undefined function: tep_hide_session_id() in /catalog/admin/customers.php on line 1127

PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /catalog/admin/includes/functions/html_output.php on line 17

PHP Fatal error: Call to undefined function: tep_hide_session_id() in/catalog/admin/categories.php on line 843

Jan Zonjee · May 14, 2008

I am sorry - you were clear, it's just I clearly am not a programmer and I am tired and trying very hard to get the store back to normal.

And I suspect that you are using admin/file_manager.php to edit those files?

Because line 17 is:

	  die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>Function used:<br><br>tep_href_link(\'' . $page . '\', \'' . $parameters . '\', \'' . $connection . '\')</b>');

and you have (not in bb code tags though):

	  die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>Function used:<br><br>tep_href_link('' . $page . '', '' . $parameters . '', '' . $connection . '')</b>');

(note that all the back slashes \ are gone).

Just download RC2a and upload that file instead of trying to repair that. Then it is repaired and you have the function.

If you did use file_manager: never ever do it again. More knowledgeable people than me even recommend to delete it from the server (or rename it to file_manager.txt if you don't want to remove it).

Always edit files with a text editor (there are many good ones, often free) after downloading it to your computer.

Separate Pricing Per Customer (SPPC) Version 4.2.1a

Recommended Posts

[email protected]

Jan Zonjee

[email protected]

Jan Zonjee

[email protected]

Jan Zonjee

[email protected]

[email protected]

Jan Zonjee

[email protected]

Jan Zonjee

[email protected]

Jan Zonjee

[email protected]

[email protected]

Jan Zonjee

[email protected]

[email protected]

[email protected]

[email protected]

Jan Zonjee

Jan Zonjee

Jan Zonjee

[email protected]

Jan Zonjee

Join the conversation

Browse

Activity