Help!!! General Served html page problem.

[Guest]

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

[mattice]

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

[Guest]

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

[mattice]

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

[Guest]

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

[mattice]

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)

[Guest]

Yes, I have phpMyAdmin

 

All this is trial and error as I have no great knowledge of PHP or MySQL.

 

Once again, thanks for your help.

 

ChrisM