oscmax to zencart convert, minor issue

hi all.

Last night I sucesfully moved the categores* and products* from an oscmax db into a zencart db. All categories and products are shown in both admin and in catalog view

I can turn on and off categories and products etc, however when I go to edit a product I get the following error (bnzen is the folder the zencart is installed into)

The requested URL /bnzen/admin/.php was not found on this server.

I can however edit the categories without any error, and from what I can see the rest of the functions outside of the products work as well.

Can anyone help me with this.

For the record. I hold a zip copy of zencart 1.3.020 and have used this same zip file (extracting it when I need to) for several shops that all function without error, so feel its not likely to be a file issue

The requested URL /bnzen/admin/.php was not found on this server.

Was .php with no file name a typo??

If not, many have had problems not specifically with the local files but with the FTP application used to upload...The free recommended app is filezilla and reported to be bulletproof.

You could try ftp'ing the admin files to your pc and using a file comparator, compare them to your original set. See if there was any corruption in the upload.

Did you make any changes to any of the settings in Admin->Catalog->Product Types ?
I'm guessing that you deleted the handler-name for the Product General product-type.

Either that, or when you imported all your products, you neglected to assign a product-type to them and thus they're all unassigned. If this is the case, you could run this statement in phpMyAdmin: ```
UPDATE products SET products_type=1 where products_type=0;

ok this is how it all went.

I use a db compare tool to compare all category and products fields from an oscmax installation with a zencart db

I managed to get them right so I culd simply import the data from the above oscmax tables into zencart.

I can an installation of zencart from scratch creating a new db at the same time.

The files I used came from the same zip file I have in the root of my host, I simply extract the zip file, rename the extracted folder to the new folder I want zzen installed into and thats it. I have used this zip file several times without issue, and have not replaced it at all (since it always worked)

After this was all done, I tested I could acess the admin no issues.

I then imported the new categories and products tables with the new scmax data into the new db for zencart.

In admin everything looks great (I just did customers and orders and they also look god except the £ is a ?)

But though I can click edit on a caegory and it works, If I click edit on a product it throws up the error above?

No file editing has been dne at al. The only thing thats different is the category and product tables came from a db compared file.

Im guessing thats where the issue lies.

I have replaced all admin files, and also noted some differences in the db which I am adjusting.

Like I said, your products have product_type=0 on them. Change them all to 1, and things should be fine (since they'll all be of the same type):

UPDATE products SET products_type=1 where products_type=0;

lol, yup I ran that, no change, then I realised I forot to import the product types into the db so there were none, lol, did that, and all is working.

I am extremely pleased to be able to confirm that oscmax db - custmers (all tables) products (all) categories (all) and orders (all) are now working 100% perfect in a standard zencart db .

lol not bad for an hours work

Anyne know how to get the admin to display £ instead of ? on the default admin page?

Fix your currencies in Admin->Localization->Currencies.

Chances are you lost special-characters due to filesystem translation when you imported your database contents.

Tried that but I can see that orders in the db also have <b>?5.99</b> so I need to figure out how to change that in the db without adjusting the values themselves in one hit?

ok, still not managed to fix the £ being a ? but the shop shows it as a £ so its not terribly urgent at this time.

I did also have the mouse over image error, but patched that, now I get the following when I click to view a product ( address is as follows)

http://www.spottedhaggis.com/bnzen

error is syntax error, and debugger points to this line of code, the only bit that confused me was where is has ('images//DiceBlue.jpg - should there be // or just/

I see your currency symbol just fine ... did you discover the solution to this?

sadly not yet, its only an issue in admin, and only when you enter admin and can see current orders, the values show with ? istead of £

I am pretty sure its something in the orders tables since I had to do a compare with oscmax and zrn cart to get them into zencart, I have not had a chance to look at it yet.

Am pleased as punch that it only took me less than an hour to get customers, orders, products and categories (ver 1400 products and 600 clients) into zencart from oscmax, thought it would be alot harder than it ws :-)

Do new orders work properly? Old ones will not ...

In admin I can view all orders from osc without issue, can edit, and invoice etc, except the pound sig is a question mark, lol.

Ahhhhhh, well would u look at trhat. heres an update

after the import, and some minor tweaking and removal of a few small non required table fields.

I can log into the shop ok under my oscmax user information, thats good
I can place an order, and get emails as a response from the order (customer and admin)
And

The new order displays the £ not the ? in admin

lol

can you tell me if you get an error on almost every page on the shop itself in IE? I do?

Could you be a tad more vague? :blink:

What kind of error are we looking for?

NOTE: I did notice you appear to have the peek-a-boo IE issue on your product_info pages ...

If you highlight from the top or run your mouse over where the prices should be they suddenly appear ...

k, sorry

I dont see the peek a boo thing, all prices are visible n any page? I am using IE 7, if that makes any difference.

The error is a runtime error on different lines.

The only way to see it is to add something to your cart, checkout, login using the following information and then after login you get the error.

user - [email protected]
pass - password

The error you're talking about is a javascript error happening in the Image Handler code, but "caused" by having invalid images set for several of your products.

You'll notice that it appears only when your "New Products" sidebox contains a product with a broken image.

The javascript in this case has no data, and is thus throwing an error.

bad:
onmouseover="showtrail('images//bng7.JPG','BNG07 : Large Red Chilli Pepper',,,,,this,0,0,,);"

vs good:
onmouseover="showtrail('bmz_cache/e/e94e23f3970963f7e575b049d694ee5c.image.150x112.JPG','Bead Reamer Set',100,75,150,112,this,0,0,100,75);"