HELP! upgrade problem

ok guys I am going crazy here!

made new test folder 'midtest'

upload 1.3.8 files, set up new DB, imported old DB, upgraded successfully, changed config files to 444 and deleted zc_install, but still getting this: thanks for loading zen cart page...

http://midwestapplianceparts.com/midtest/index.php

I have tried everything with me and my host and neither of can get this!

please help!

thanks,

Eric

upload 1.3.8 files, set up new DB, imported old DB, upgraded successfully, changed config files to 444 and deleted zc_install, but still getting this: thanks for loading zen cart page...
Did you?
upload 1.3.8 files, set up new DB, install Zen Cart 1.3.8 first, then:import old DB, upgraded successfully, changed config files to 444 and deleted zc_install, but still getting this: thanks for loading zen cart page...

oops....

Yeah, install...import DB, re-run zc_install and upgrade DB only etc

I don't see anywhere on this page that says to install the new version first, then upgrade,,, https://www.zen-cart.com/tutorials/index.php?article=108

made new test folder 'midtest'
That is for upgrading an existing install - from the quote above you are starting fresh or am I incorrect?

kobra:

Yeah, install...import DB, re-run zc_install and upgrade DB only etc

hi

if the sequence is: upload v1.38 files, install it, then import v1.37 database

can this work?

cos can't use phpmyAdmin to import database, i'm using backup my sql tools to do the backup/restore.

any other option i can follow?

thanks,
natalia

cos can't use phpmyAdmin to import database, i'm using backup my sql tools to do the backup/restore.

any other option i can follow?
None that I am aware of???

Do you just not have access to phpmyadmin?

Won't your backup my sql tools import the DB?

Looking it appears that you sorted something?

And actually - reviewing what is suggested and what I posted - I believe what you did nets the same thing

kobra:

That is for upgrading an existing install - from the quote above you are starting fresh or am I incorrect?

No was trying to upgrade to 1.3.8 - so from my understanding, I had to make a new dummy folder install 1.3.8, then import my 1.3.7 db...

are you telling me now that I could have just upgraded my 1.3.7 directly?

in anycase, I have a dummy folder, installed 1.3.8, imported DB and then upgraded with zc_install

now I am getting my dummy folder up to par with my real site and testing... once it is ready... I am going to have to figure out how to move it over to the root folder

I am having an upgrade problem with my database also.
I was building my zen cart using 1.3.x, then upgraded to 1.3.8, but I did it wrong and was getting an error about needing patches. So, I started from a new upgrade, this time on my local machine. Everything is working, but now I cannot import my database to the new version on my local machine. When I create a new database it will import. The error I was getting before is:
Error

SQL query:

--
-- Database: littles4_zc1

--
-- Table structure for table zen_products

CREATE TABLE zen_products (
products_id int( 11 ) NOT NULL AUTO_INCREMENT ,
products_type int( 11 ) NOT NULL default '1',
products_quantity float NOT NULL default '0',
products_model varchar( 32 ) default NULL ,
products_image varchar( 64 ) default NULL ,
products_price decimal( 15, 4 ) NOT NULL default '0.0000',
products_virtual tinyint( 1 ) NOT NULL default '0',
products_date_added datetime NOT NULL default '0001-01-01 00:00:00',
products_last_modified datetime default NULL ,
products_date_available datetime default NULL ,
products_weight float NOT NULL default '0',
products_status tinyint( 1 ) NOT NULL default '0',
products_tax_class_id int( 11 ) NOT NULL default '0',
manufacturers_id int( 11 ) default NULL ,
products_ordered float NOT NULL default '0',
products_quantity_order_min float NOT NULL default '1',
products_quantity_order_units float NOT NULL default '1',
products_priced_by_attribute tinyint( 1 ) NOT NULL default '0',
product_is_free tinyint( 1 ) NOT NULL default '0',
product_is_call tinyint( 1 ) NOT NULL default '0',
products_quantity_mixed tinyint( 1 ) NOT NULL default '0',
product_is_always_free_shipping tinyint( 1 ) NOT NULL default '0',
products_qty_box_status tinyint( 1 ) NOT NULL default '1',
products_quantity_order_max float NOT NULL default '0',
products_sort_order int( 11 ) NOT NULL default '0',
products_discount_type tinyint( 1 ) NOT NULL default '0',
products_discount_type_from tinyint( 1 ) NOT NULL default '0',
products_price_sorter decimal( 15, 4 ) NOT NULL default '0.0000',
master_categories_id int( 11 ) NOT NULL default '0',
products_mixed_discount_quantity tinyint( 1 ) NOT NULL default '1',
metatags_title_status tinyint( 1 ) NOT NULL default '0',
metatags_products_name_status tinyint( 1 ) NOT NULL default '0',
metatags_model_status tinyint( 1 ) NOT NULL default '0',
metatags_price_status tinyint( 1 ) NOT NULL default '0',
metatags_title_tagline_status tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( products_id ) ,
KEY idx_products_date_added_zen ( products_date_added ) ,
KEY idx_products_status_zen ( products_status ) ,
KEY idx_products_date_available_zen ( products_date_available ) ,
KEY idx_products_ordered_zen ( products_ordered ) ,
KEY idx_products_model_zen ( products_model ) ,
KEY idx_products_price_sorter_zen ( products_price_sorter ) ,
KEY idx_master_categories_id_zen ( master_categories_id ) ,
KEY idx_products_sort_order_zen ( products_sort_order ) ,
KEY idx_manufacturers_id_zen ( manufacturers_id )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =147

MySQL said: Documentation

What am I doing wrong? This is my first time of trying a shopping cart like this. I am not a computer person, so it is all pretty much new to me.