Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

os commerce


mountainski

Recommended Posts

Hi

 

I am not a technician. We had a web site created www.y-ola.com using os commerce with the admin accessible from a blue panel by y-ola.com/admin this has operated fine for about 5 years and was updated .

 

3 weeks ago we changed hosting companies to 1and1 and since then all Hell has been created having uploaded the complete back up for the site via ftp , the hosting company has only php/mysql which the site has never used before , suddenly the products no longer show !! all the stuff that was done simply from price changes to promotion none of it works !!

 

when we access there phpmysql , it lists 50 categories but the products n No , the customers No ! we can not even get as before a clients order with what he has ordered and the delivery address a s a invoice now !! So we have had to lay the delivery people off work , as not even the original designer can suss out what is wrong plus conference calls to 1and 1 tech services for over 15 hours .

 

 

So any one got any ideas how we can get the site to work simplistically as it did before !! from a admin control pannel so can Scrap the php myadmin !!!???

 

This how the site should look ; although products will have changed from then !!

 

http://web.archive.org/web/20090211152852/http://y-ola.com/?

Link to comment
Share on other sites

Kevin,

 

From personal experience, 1and1 is NOT the best hosting provider to deal with.

 

Having said that, you don't need to use phpmyadmin for ANYTHING except the setup of the database on the new hosting account. Because you are using such an old version of osCommerce, you may be experiencing some PHP compatibility issues. The version you described was written for PHP 4 and most hosting providers now use PHP 5.x.

 

 

If you could post the URL, we could see the problems and perhaps offer more suggestions to get the site working again.

 

 

 

Chris

Link to comment
Share on other sites

Hi Chris

 

today the site live looks like this : www.y-ola.com

 

when it should look similar to this: http://web.archive.org/web/20090211152852/http://y-ola.com/?

 

So no categories show and no products!!

 

it shows on there php mysql like this:

phpmyadmin.1and1.co.uk / db374777400.db.1and1.com | phpMyAdmin 2.6.4-pl3:

 

 

Browse: (0 Rows) action_recorder

Browse: (0 Rows) address_book

Browse: (5 Rows) address_format

Browse: (0 Rows) administrators

Browse: (1 Rows) banners

Browse: (0 Rows) banners_history

Browse: (0 Rows) categories

Browse: (0 Rows) categories_description

Browse: (246 Rows) configuration

Browse: (15 Rows) configuration_group

Browse: (1 Rows) counter

Browse: (0 Rows) counter_history

Browse: (239 Rows) countries

Browse: (2 Rows) currencies

Browse: (1 Rows) customers

Browse: (0 Rows) customers_basket

Browse: (0 Rows) customers_basket_attributes

Browse: (1 Rows) customers_info

Browse: (1 Rows) geo_zones

Browse: (1 Rows) languages

Browse: (10 Rows) manufacturers

Browse: (10 Rows) manufacturers_info

Browse: (0 Rows) newsletters

Browse: (0 Rows) orders

Browse: (0 Rows) orders_products

Browse: (0 Rows) orders_products_attributes

Browse: (0 Rows) orders_products_download

Browse: (4 Rows) orders_status

Browse: (0 Rows) orders_status_history

Browse: (0 Rows) orders_total

Browse: (28 Rows) products

Browse: (13 Rows) products_attributes

Browse: (1 Rows) products_attributes_download

Browse: (0 Rows) products_description

Browse: (4 Rows) products_images

Browse: (0 Rows) products_notifications

Browse: (5 Rows) products_options

Browse: (11 Rows) products_options_values

Browse: (11 Rows) products_options_values_to_products_options

Browse: (28 Rows) products_to_categories

Browse: (1 Rows) reviews

Browse: (1 Rows) reviews_description

Browse: (12 Rows) sec_directory_whitelist

Browse: (92 Rows) sessions

Browse: (4 Rows) specials

Browse: (1 Rows) tax_class

Browse: (1 Rows) tax_rates

Browse: (7 Rows) whos_online

Browse: (181 Rows) zones

Browse: (1 Rows) zones_to_geo_zones

Link to comment
Share on other sites

Kevin,

 

 

Did you attempt to update your osCommerce version to v2.3.1 during the the process of moving to the new host ? There are several tables in that listing that are NOT standard for the version of osCommerce you are using.

 

 

 

 

Chris

Link to comment
Share on other sites

Let's get the nomenclature straight, so you stop confusing yourself and others:

PHP: a web scripting language used by (among others) osCommerce

MySQL: an implementation of SQL Relational Database Management System (your "database")

phpMyAdmin: a GUI-driven tool popular for administering MySQL databases, offered by many hosts

You may have a problem with incompatible versions. Most up-to-date hosts have PHP 5.x, and an old version of osC written for earlier levels of 4.x will have problems. Either update to osC 2.3.1 (importing/upgrading your existing database and product pictures), or manually fix the code. Most hosts are now MySQL 5.x, and an old version of osC written for MySQL 4.x or older will have some problems ("1054" errors, for the most part).

 

From your description of using "admin", you're back somewhere in osC 2.2, possibly 2.2 MS2 or even older. There are many security fixes you'll need to make if you want to stay at that version without getting hacked daily. The only reason to stay at an old version is if you've put a lot of effort and/or money into customizing that version (e.g., bought an expensive template), and can't bear the thought of starting over (the store, that is -- the product data can always be brought over).

 

Your first assignment is to find

what version of osC you're using

what PHP version you were on before, and what your new host has

what MySQL version you were on before, and what your new host has

The current level of osCommerce is 2.3.1. You have some data in your database, but is it complete? You show 28 products -- did you have more?

Link to comment
Share on other sites

Well had some success we have managed to get the product to show on front page of website , and on the featured items , but on selecting the categories we get:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '156'

 

[TEP STOP]

 

 

Which is odd as the featured product works ok with all products showing in the promo section from the same data base !!

 

www.y-ola.com

Link to comment
Share on other sites

This is caused by your running on MySQL 5 now. It has an incompatibility with code written for earlier versions of MySQL. Look around for posts dealing with this specific item -- if it's in the base code, there is probably a patch/mod for it. You need to change the PHP code so that the query is

select count(p.products_id) as total from (products_description pd, products p left join manufacturers m on 
p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = 
s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id 
and pd.language_id = '1' and p2c.categories_id = '156'

If this is from an add-on/mod, you'll probably have to find the PHP code yourself and fix it. While you're at it, all "JOIN" queries have to be checked and fixed if necessary.

Link to comment
Share on other sites

Well we did what was suggested and the categories pages now works and the products data base operates.

 

How ever on selecting as example the flower section to display the selection we still are getting the text below now showing on the right of the page !!

 

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by pd.products_name

 

[TEP STOP]

Link to comment
Share on other sites

The SQL query (via PHP) will have to be changed to

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, 
p.products_price) as final_price 
from (products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) 
left join specials s on p.products_id = s.products_id 
where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' 
order by pd.products_name

Link to comment
Share on other sites

  • 1 month later...

Many servers no longer permit PHP settings to be made in .htaccess. You have to put things like that in a php.ini file (possibly named something else -- ask your host). Your system may also need an .htaccess entry pointing to php.ini -- again, your host can tell you.

 

It's possible that your new server doesn't even allow register globals to be "on". You really ought to upgrade to osC 2.3.1, which doesn't need them. If you insist on staying at 2.2, at least find the mod (add-on) that takes care of not needing register globals. If that requirement is from some other mod or template, you'll have to find it and edit the code by hand (use $_REQUEST['varname'] rather than $varname).

Link to comment
Share on other sites

What I said was that your host may tell you to take the php_value and php_flag lines out of your .htaccess and put these settings into php.ini (or the equivalent). You have to ask them what is the proper way to change PHP settings. Most don't permit them in .htaccess, some don't let you edit a php.ini file, and some require an entry in .htaccess to point to php.ini. Don't just copy something you found on the Web (or even this forum) and expect it to always work (particularly something to do with configuration settings).

Link to comment
Share on other sites

ok thanks the php_value and php_flag lines are not in those files anyway ! our web guy says just scrap the site and build another but avoid os commerce , so not sure about this due to the extra $ if its not really necessary. will have to decide soon as staff unable to work due to this.

Link to comment
Share on other sites

well managed to get front page to show at last , but when selecting category no products show even though the php mysql 5 has the data

 

______________________

 

 

but the today the featured products disappeared leaving:

 

1146 - Table 'yolacom.TABLE_FEATURED' doesn't exist

 

select * FROM TABLE_FEATURED

 

[TEP STOP]

 

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

Link to comment
Share on other sites

UPPER_CASE_ERRORS generally denote a "define" missing in a php file.

 

In this case TABLE_FEATURED isn't defined in /catalog/includes/database_tables.php

 

It's not a "standard" entry (not in a "vanilla" install).

 

Sounds like a template entry missing or a contribution not quite fully installed.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

<?php

 

 

if (($_SERVER["REQUEST_URI"]!="/")&&($_SERVER["REQUEST_URI"]!="/index.php")) {

 

// $listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '62' order by pd.products_name";

$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by pd.products_name";

Link to comment
Share on other sites

What do you mean by "they just do not [connect] properly"? Are you getting a message that the shop is unable to connect to the database? The code you gave in the previous post appears to be the same two queries, except that the second (active one) has a category restriction removed, so it should be more likely to get a match.

 

It sounds like your "web guy" is not very competent (if he just throws up his hands and says to get another shop). You really need someone there to look at the details of the errors and know enough about PHP and MySQL to diagnose the problem and fix it. You'll probably have to pay for that service.

Link to comment
Share on other sites

Hi thanks , unfortunately difficult to judge a web guy for this as we are on our third now trying to resolve the issues and being paid too.

 

the hosting company tech support says:

 

**when browsing to y-ola.com/admin this now redirects to another location which does not exist.

 

As this is a third party application we are unable to provide support for the product. I would recommend contacting OSCommerce Support for assistance with this issue. ***

 

so we are no further forward and shop closed now ! till can find a solution.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...