Quote Originally Posted by Trademagic View Post
Been reading for hours and trying to catch up. Hate asking questions which have been answered. I have 1.5.1 store and installed 1.2.5.7d, which I guess isn't even this product. I also have no luck with sql statement but was able to load basics, just don't have the config menu items yet. Basic question, should I get on 1.2.5.7 some other support link, or should I download 4.0 on Gitwhatever? Can someone send advice, and the proper link if I should go with 4.0?

I have downloaded the empty database file, and could not download my products yet. Should I go, 4.0?
Quote Originally Posted by Trademagic View Post
Just so nobody needs to do a long post about it, I deleted 1.2.5.7, and came onboard this thread. Installed the program, no sql, and worked immediately. I downloaded a copy of my database, and while it may be right, it is not particularly pretty, especially in excel, and I have downloaded OO for use Why no pictures, or do you only get the .jpg information? Much other stuff is there as well. Why so many 1s and 0s?

So, you are correct 1.2.5.7 is a different product having it's own forum in which to ask questions (which I suggest if you are going to continue using that product). This particular version, while quoted as version 4, is not a linear upgrade from 1.2.5.7, but a variation of EP. That said there are probably differences in the way the data is populated/managed between the two "versions". EP4 requires each product to have a unique model number designation. As for the difficulty of running the SQL statements, what do your various error logs say?
I thought there were a few suggestions posted in this forum related to the SQL, but it's been a long time since I have installed it. To that end, the download location is provided in post 1 of this forum (select arrow at top or bottom of page that says "first" and will be taken straight there), until an official ZC version is provided.
Was there uninstall SQL to 1.2.5.7? Could it be interfering with installation of this version?

So related to your other questions and I know that you are still learning about some of the details of ZC, what you are seeing/working with is the raw data that is used to present information in the store. So, showing things like pictures and sometimes the word true instead of 1 are all things handled by ZC code based on the data provided. So a majority of the ones and zeros in the column. Are because they relate to statements such as, is on sale or display or don't display meta tags, etc.

Be sure that you make a backup of everthing before you use this, I know that you wouldn't want to have to rebuild either the code of the store or the database again.