Forums / Setting Up Categories, Products, Attributes / After 150 install/upgade my products are missing in Categories

After 150 install/upgade my products are missing in Categories

Views: 1,249

Results 1 to 11 of 11
7 Jan 2012, 1:36 PM
#1
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

After 150 install/upgade my products are missing in Categories

My products are missing in the Admin Categories Products. And they consequently are not visable in the online catalog.

Which files can I and which will have to transfer via FTP?

With 150 now in place, is it proper way to do to simply transfer all language and includes files or?

I havent found any information in the docs folder telling me which folders and files I should transfer.

Does this instead mean I will have to manually once again add my products in the Categories?

Thanks in advance
Stefan

7 Jan 2012, 2:23 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: After 150 install/upgade my products are missing in Categories

Categories and products are stored in the database, not in files. Did you import your previous database to the 1.5 installation ?

7 Jan 2012, 2:27 PM
#3
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Hi,

I only transfered all files and folder locally via FTP to the online server. And the in browser used the ZC Install. to install it. Nothing else.

How do I do what you suggested?

7 Jan 2012, 7:31 PM
#4
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: After 150 install/upgade my products are missing in Categories

stefanl:

Hi,

I only transfered all files and folder locally via FTP to the online server. And the in browser used the ZC Install. to install it. Nothing else.

How do I do what you suggested?

First you need to export the old database to your local PC. How you do that depends on your host's specific setup. If your host provides cPanel you would go in to phpMyAdmin and use the export function, Save the file to a local folder. Then you would do the process in reverse for your new database by importing it from your local PC.

Note: If the database is large, you may run in to issues importing it. If that's the case you would need to use a script that parses it in to small chunks during the import. I use Bigdump.

The best way to learn is to try stuff. But, back it up first.

7 Jan 2012, 7:45 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: After 150 install/upgade my products are missing in Categories

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Jan 2012, 9:54 PM
#6
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Hi,

Please bare with me.

I understand I used INSTALL and not upgrade of 150.
When suggestion is told me to export Database=139 and then Import the same Database to my Database=150, I understand I am not wholly understanding the procedure.

The thing I am wondering over is this:

My shop address for Zencart 139 was https://www.mywebsite.com/shop

My Shop address for zencart 150 is still www.mywebsite/shop

Am I still supposed to export to my local harddrive the Database, and then import it again to the very SAME database? I just exported it from?

  1. Am I supposed to create an entire new database, meaning deleting the database?

I checked phpmyadmin and saw all products and so forth. Only it doesnt show in my admin page when I log in to my shop admin.

Just for the record i DO read the tutorials and tips from you all, only I might not always wholly understand the ins and outs that may be obvious, due to my profession is illustration and design and not programming PHP.

Allways thanks in advance
Stefan

8 Jan 2012, 9:59 PM
#7
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Just got unsure. I belive I did select INSTALL and not Upgrade.
But I do remember that I was asked to fill in my password and database name so forth.

Does that mean I might have chosen Upgrade just the same?

Thanks in advance
Stefan

9 Jan 2012, 12:05 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: After 150 install/upgade my products are missing in Categories

Your TEST site is a whole new folder and new database. That's IN ADDITION TO what you've already got for your live site.

The idea is to set up an ADDITIONAL completely separate site for doing all your testing, so that your old site can stay "live" and making sales while you prepare your upgrade.

If you don't know how to create an ADDITIONAL (that's what we mean by "new") database, then talk to your hosting company for help.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

9 Jan 2012, 12:44 AM
#9
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Hi Dr Byte,

Okey, I think I understand what you mean.
I did the classic misstake of running zc_install by FTP-it directly to my server/host and from there running it via the browser as supposed to when going live/test, this way installing/upgrading to the LIVE store right away.

So now what has happen is that I can see basically everything except my products/categories. Online or in the admin.

  1. Now I have my database as per 139 and 150 zc_install via FTP online.

When going LIVE do I need to re-install the entire Database?

And I get gibberish fonts/letters to my Swedish language page, which isnt seen in the English selected page.

The Gibberish is seen like this, but dont know how to fix this. I made a question about it here http://www.zen-cart.com/forum/showthread.php?p=1092718#post1092718

Quote:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="sv"> <head> English Page Quote: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en"> <head>
9 Jan 2012, 12:47 AM
#10
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Hi again,

My webshop is https://www.canvas.nu/shop

9 Jan 2012, 10:51 PM
#11
stefanl avatar

stefanl

Zen Follower

Join Date:
Aug 2009
Location:
SWEDEN
Posts:
198
Plugin Contributions:
0

Re: After 150 install/upgade my products are missing in Categories

Hi again,

I have a live site, no additional test site. Just the live site.
Now, the live site after installing 150 via zc_install, and having done nothing with the database, the categories and products show "0" both in admin and online cataloge.

I thought, right or wrong, that did not have to do anything with the database, because I installed 150 via zc_install onto the same server/folder what have you as the "old site" which was 139h.

Will I be able to activate the products/categores now, or will I have to re-register my products again?

I can live wit that, having to add my products again, only if there is something I must do to activate my products once again, then I like to do so.

but I dont now where to start.

Ps. I didnt touch the database, and not saved it locally or anything. I thought/hoped I could leave as is due to me zc_installing 150 on top of or what its called/upgrade/install.

I need to say that part form not seeing any products /categories, I can still view all modules and custom define pages and eveything, basically.

Thanks in advance
Stefan