Store hangs when showing a new product

[enzo-ita]

Hi,
I moved form 1.38 italian version to 1.39d original + translation.
To do this I had to dwld each single old db table, empty the new tables and upload each single table in the new db with the old data.
Everytihing seems to work. I have reorganized the products in the categories linking them in a different way without problems.
Now I want to add a new category and it works too. The category is displayed correctly and if there are no products in it, clicking on it I get the page that says that there are no products in the category.
So far so good.

If I add a product to this new category when I click on the category name zen cart hangs showing a blank page.
If I add a new product in a old category the product is shown without problems.
So in few words I can add new catogories, but I can not add new or copy old products in new categories and I can add products to the old catgories.

I tend to believe that this is due to some problem with the db, but....which one?
Thanks for your help.
enzo

[DrByte]

The correct procedure for upgrading the database is to run zc_install and choose "Database Upgrade" so that it can properly upgrade the old data and structure to the new format.
By manually extracting individual pieces and skipping the upgrade steps you're likely to leave your database in bad shape, resulting in all kinds of unexpected and undesirable results.

[enzo-ita]

Thanks for your answer.
I probably was not clear enough.

As you probably recall, I had a problem upggrading with zc_install the 1.38 db with 1.39 version, and you told me that was because I was using a non original (italian) version of the db.

Therefore I made a fresh installation with 1.39d original software, and imported the data only in the various tables.

In this way I had my site updated and working and the db structure was untouched.

But then I found this problem for which I can add new categories, but I can not add new or copy old products in new categories just created, while I can add products to the old categories.

I agree that this sounds to be a db problem, but I would like to have some clue on were to look in order to understand were the problem is.

ciao

enzo

[DrByte]

But, merely copying data from an OLD database, in its OLD structure, into a NEW database which has a NEW structure, is dangerous.
You should ONLY copy data from SAME version to SAME version. So, you should have either upgraded the OLD database FIRST, before importing into the new, OR import the OLD into the NEW and then run the scripted upgrade.

Unfortunately there's no way to know from here what's wrong with your database. It could be hundreds of things, including broken autoincrements, broken indexes, wrong structure, missing data that would only be properly set by running the upgrade correctly, incorrect field types, damaged records, relationships out of sync, and the list goes on.

[enzo-ita]

Ok, but I had no chances.
It was impossible to upgrade from 1.38 to 1.39 using the zc_install scripts.
Now how can I solve this problem? If there is a solution?
Thanks
enzo

[DrByte]

Start with the list of things I mentioned above.

[enzo-ita]

OK!!!! Thanks!!!

I have already checked what I could and:

Autoincrements are ok; categories and products are numbered progressively without duplication of ID.
The table "categories to product" is compiled correctly so I think that the relationship is correct.

I do not know the difference between indexing and auto increment.

I do not think I have a wrong structure because what I did was: Install the db version 1.39 without the sample data,
Dwld the data only from the db 1.38 table by table.
Upload the data into the db 1.39, table by table without touching the data already in the tables of the 1.39 db with two exceptions:

I had to add in the table address_book two fields: entry_vat and entry_cf because the italian version of the db had these two added fields.
I had to load the data from 1.38 on the zones table because the data of the 1.39 did not include the italian zones.

However what shpuld I check to confirm that I do not have wrong structure?

I wait for you instructions on the next step to check.
In the mean time I want to activate the debug and see if some clue comes out. I will let you know.

Thanks
enzo

[enzo-ita]

This is what the dubug says

[30-Sep-2010 09:51:57] PHP Warning: Cannot modify header information - headers already sent by (output started at /home7/acquatua/public_html/includes/languages/italian/classic_mio/index.php:98) in /home7/acquatua/public_html/includes/functions/functions_general.php on line 45

Does it tell you something?
Thanks

[DrByte]

[30-Sep-2010 09:51:57] PHP Warning: Cannot modify header information - headers already sent by (output started at /home7/acquatua/public_html/includes/languages/italian/classic_mio/index.php:98) in ...

https://www.zen-cart.com/tutorials/index.php?article=87

[enzo-ita]

That solved the problem!

I deleted a blank line in the php file and that did the magic.
Thanks a lot.

I do not understand, however, how it is possible that this problem came out only with new products created in new or old categories.

enzo