Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help!!! General Served html page problem.


Guest

Recommended Posts

I've screwed around this for some time and finally got osCommerce working.

 

Had osCommerce working once before with all products in but then decided to add some contributions which screwed up the package. Went back to basics, installed 2.2 on win machine (database but no products) got everything working and transferred it over to my server.

 

Everything fine and dandy!

 

Backed up original database and imported it into my current database.

 

You can see the results http://ozhunting.info/catalog:

 

Is someone able to help me rectify this problem. As you can see, it's not just on the index page and has altered the text size in some of the boxes. Doesn't happen on all pages either.

 

Any help appreciated.

 

ChrisM

Link to comment
Share on other sites

1054 - Unknown column 'p.products_ordered' in 'field list'

 

means the column products_ordered does not exist.

You probably have installed a newer snapshot on your EXISTING database?

 

If it is the bestsellers box you can get an older version in CVS.

 

Mattice

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

Is this in the database or somewhere in the catalog files php.

 

In other words, What exactly is it I have to do?

 

Thanks in anticipation

 

 

ChrisM

Link to comment
Share on other sites

You have to make sure your DATABASE is compatible with your SNAPSHOT. Because it is not final yet things change, including database tables.

 

Backup your db.

Backup your db.

Then backup your db :)

 

Delete your db.

 

Install the oscommerce.sql that was in your snapshot.

 

Install your backup.

 

HTH

Mattice

Mattice

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

OK! Tried all that but when I went to overwrite the data in the osCommerce.sql, I kept getting errors.

 

Tried just data and then structure and data. None of that worked, it kept telling me "duplicate" entries.

 

What I did do was:

 

created "mydatabase", imported the "structure and data" from old database. Went to the "new snapshot" database and compared the two structures. Had a look at "Products" table and saw that row "products_ordered" was missing. Created row "products_ordered" and "wella", it worked.

 

However, it was a rather tedious way of going about it, but it did work.

 

Are you able to tell me the best way of importing data from a current database into a new snapshot without going through the above?

 

IS there a simpler way?

 

Thanks for your help and input!

 

ChrisM

Link to comment
Share on other sites

Don't know if that's so tedious...

At least you didn't have to backup 3 times :)

 

I assume you have phpMyAdmin?

If not, get it. It helps.

 

Furthermore there is a mysql diff file in the extra's folder of the snapshots that will check for differences... (linux only think)

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...