Newsgator Forums / Technical Support and Requests / TopStyle / Database fails to upgrade on install / Latest Posts

RE: Database fails to upgrade on install

Lirria — Thu, 07 Aug 2008 10:47:06 GMT

sorry about posting in the wrong place - I keep doing that unfortunately - I get in too much of a hurry.

Any way - it actually was a problem with the build.07.Procedures.sql file - there were 4 characters missing from one line (who know g. in front of 2 different words would make such a differece)

But we added that in (yes it should have been in there from all the upgrades but it wasn't)

So it's all fixed now.

Thank you!

Lirria

RE: Database fails to upgrade on install

Louise — Wed, 06 Aug 2008 17:01:07 GMT

This is unlikely to be problems with the migration of the database and its tables.

It is a common error when handling db selections where joins are used. Where the join is to be made on fields where those field names are the same in both tables, the sql can reply with this error.

e.g. Problematic

SELECT thisfield
FROM table1
JOIN table2
ON table1.thisfield = table2.thisfield

e.g. Better

SELECT thisfield=t1.thisfield
FROM table1 t1
JOIN table2 t2
ON t1.thisfield = t2.thisfield

Louise

RE: Database fails to upgrade on install

Jonathon McDougall — Wed, 06 Aug 2008 13:59:53 GMT

Also, what company do you work for ;) It'll help us look into your case

RE: Database fails to upgrade on install

Jonathon McDougall — Wed, 06 Aug 2008 13:54:46 GMT

Hi Lirria,

You've actually posted in our TopStyle forum (it's an HTML, xHTML and CSS editor), but it sounds like you are talking about NewsGator Enterprise Server.

The NGES Support guys don't hang out here since we don't offer forum support to enterprise customers. However, if you can give me the name of the support guy you normally work with, I'll make sure someone contacts you!

Database fails to upgrade on install

Lirria — Tue, 05 Aug 2008 15:40:42 GMT

Hey all -

I'm hoping somebody out there can help - been waiting for a call back from tech support but haven't received one yet, hope they aren't too insanely busy!

So here's the deal. I have a Newsgator server in NY running a down level version of the software - we are upgrading to new hardware, the new Newsgator and SQL 2005 at a location in Colorado. I backed up the current database and copied it Colorado, restored it to the new SQL database and that seemed all fine. So I then go to do the install and it wants to upgrade the database version 1.4.2.185 to 3.0.0.679, but it fails with the following:

Problem creating procedures: ambiguous column name 'CreateDate'. Ambiguous column name 'GroupID'

So I'm stuck - anybody out there have a solution?

thank you!!

Lirria