Forums / Upgrading from 1.2 to 1.3.x / Running a DB upgrade script w/o install wiz?

Running a DB upgrade script w/o install wiz?

Locked

Started by ecobunz on 18 Mar 2007, 4:58 AM · Views: 3,065

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
18 Mar 2007, 4:58 AM
#1
ecobunz avatar

ecobunz

New Zenner

Join Date:
Mar 2007
Posts:
10
Plugin Contributions:
0

Running a DB upgrade script w/o install wiz?

I just upgraded my 1.2.6 cart to 1.3.7 yet sever info is telling me that my db patch level is still 1.2.6 - just wondering how I might be able to fix this. I've tried to re-run it from the install eiz but it tells me everyting is OK?

18 Mar 2007, 5:09 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Running a DB upgrade script w/o install wiz?

Did you upload all files from Zen Cart v1.3.7?

Did you then run the /zc_install and say upgrade database?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

18 Mar 2007, 5:33 AM
#3
ecobunz avatar

ecobunz

New Zenner

Join Date:
Mar 2007
Posts:
10
Plugin Contributions:
0

Re: Running a DB upgrade script w/o install wiz?

yes, thats EXACTLY what I did :)

Ajeh:

Did you upload all files from Zen Cart v1.3.7?

Did you then run the /zc_install and say upgrade database?

19 Mar 2007, 4:08 AM
#4
ecobunz avatar

ecobunz

New Zenner

Join Date:
Mar 2007
Posts:
10
Plugin Contributions:
0

Re: Running a DB upgrade script w/o install wiz?

I decided to do a fresh install - works fine now :). Fortunately I don't have that many products to set up. I had modules back from OS Commerce that I shoe horned in by hand countless eons ago. Glad to be rid of the extra tables in the db too!`

19 Mar 2007, 7:30 AM
#5
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Running a DB upgrade script w/o install wiz?

I just move from one host to another and now when I got to our home page I am getting this error:

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']

I also when I tried to do a database upgrade my screen is just blank. I can login into admin but after I login my screen is just blank and then I have to manually change to adminfolder/index.php to see the list of files?

Help please!

20 Mar 2007, 2:28 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Running a DB upgrade script w/o install wiz?

You may wish to try reloading your files ... sounds like a bad FTP session ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

20 Mar 2007, 2:30 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Running a DB upgrade script w/o install wiz?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

25 Mar 2007, 4:49 AM
#8
ecobunz avatar

ecobunz

New Zenner

Join Date:
Mar 2007
Posts:
10
Plugin Contributions:
0

Re: Running a DB upgrade script w/o install wiz?

So am I to assume everyone using the FroogleGoogle mod is doing the uploads manually or via the website? My file is generated fine, but I had to manually upload it to have it even register.