[geeklog-devel] MS SQL Upgrade

Dirk Haun dirk at haun-online.de
Fri May 23 14:10:46 EDT 2008

Randy Kolenko wrote:

>The issue in the upgrade is that the qid column is a primary key and it
>cannot be null..
>Problem with the query is that its missing the qid value.
>Question becomes: whats the qid value then?

In 1.4.1, polls only had one question. So during the upgrade they are
transferred over and the qid for all of them becomes 0.

That bit looks okay to me and it worked with the old polls on geeklog.info.

In the MySQL db schema, the primary key is

  PRIMARY KEY (qid, pid)

whereas in the MS SQL schema, only qid is the primary key. That looks
like the problem to me.

bye, Dirk


More information about the geeklog-devel mailing list