https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 01:50:51 +0000 Fri, 20 May 2005 14:05:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15140 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83531.html#83531 Author: sfd19
Subject: 15140
Posted: 20 May 2005 at 2:05pm

No, do not remove relationships or change fields!

You are using a wrong query, it must be:

UPDATE tblThread set Author_ID=100 WHERE Author_ID=2

The query you are using is trying to update the Author_ID in tblAuthor, that is not possible. Also it is not required.

Run a similar query against all tables where Author_ID gets used(except for tblAuthor), remind you that it does not always have thename 'Author_ID'.
For example in tblPMMessage the 'From_ID' stores Author_ID's.
]]> Fri, 20 May 2005 14:05:30 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83531.html#83531 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83506.html#83506 Author: PhGp
Subject: 15140
Posted: 20 May 2005 at 10:58am

Should I temporarily remove relationships, and change auto number to number, run the statement then return to previous state?]]> Fri, 20 May 2005 10:58:08 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83506.html#83506 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83503.html#83503 Author: PhGp
Subject: 15140
Posted: 20 May 2005 at 9:50am

Hi sfd19 & Gullanian,

Please disregard my previous statement re: syntax error. I am using AQL statement in access and getting this:

Cannot update <field name>; field not updatable. (Error 3113)
]]> Fri, 20 May 2005 09:50:23 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83503.html#83503 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83491.html#83491 Author: Gullanian
Subject: 15140
Posted: 20 May 2005 at 1:29am

Nothing wrong with that SQL statement...  Where exactly are you entering it?]]> Fri, 20 May 2005 01:29:19 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83491.html#83491 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83487.html#83487 Author: PhGp
Subject: 15140
Posted: 19 May 2005 at 8:04pm

sfd19,

I have: UPDATE tblAuthor set Author_ID=39 WHERE Author_ID=2 in theUpdate to: row.... keeps throwing syntax error "you may have entered anoperand without an operator"
]]> Thu, 19 May 2005 20:04:50 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83487.html#83487 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83485.html#83485 Author: sfd19
Subject: 15140
Posted: 19 May 2005 at 6:52pm

It is the query I posted above:

UPDATE tblThread set Author_ID=100 WHERE Author_ID=2

Remind you that you have to use similar queries for all tables where the Author_ID gets used.
]]> Thu, 19 May 2005 18:52:55 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83485.html#83485 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83483.html#83483 Author: PhGp
Subject: 15140
Posted: 19 May 2005 at 6:29pm

Thanks again sfd19,

I think you have the answer... however, I need help in the constructionof query ... tried several times ... keep getting syntax error. Yousaid  "Now run an update query against the local database tochange allmessage entries from Author_ID=2 (your assistant admin's ID) toAuthor_ID=100:" If you could help with construction of this query, Iwill then extrapulate to other tables.

Really feeling like a dummy.
]]> Thu, 19 May 2005 18:29:14 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83483.html#83483 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83469.html#83469 Author: sfd19
Subject: 15140
Posted: 19 May 2005 at 10:08am

Best, download the database, make a backup, and then create a new member and notice the Author_ID, e.g. 100

Now run an update query against the local database to change allmessage entries from Author_ID=2 (your assistant admin's ID) toAuthor_ID=100:

UPDATE tblThread set Author_ID=100 WHERE Author_ID=2


Apply similar update queries against all the tables that have theAuthor_ID included, e.g. tblPoll, tblAuthor, tblTopic,tblPMMessage,...,...

Make sure that you also take care of other ID's, like the From_ID in tblPMMessage!

When you have applied all changes then make the proper changes to the profiles of ID=2 (now the 'guest') and ID=100 (now AA)

Re-upload the DB and test it.


Edited by sfd19 - 19 May 2005 at 1:20pm]]> Thu, 19 May 2005 10:08:03 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83469.html#83469 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83461.html#83461 Author: PhGp
Subject: 15140
Posted: 19 May 2005 at 8:44am

Thanks for your quick reply sfd19,

Unfortunately, I don't know how to code SQL query to do that, but Ithink I can accomplish same through mass "Find and Replace". However ifI understand your suggestion, wouldn't your query bring "Guest alongwith it, as Guest has ID=2 as well as assistant admin? The code thataffects ID=2 is extensive. Not only ID=2, but ID <2> as anexample. I obviously need help or at least understanding of all thevariations. BTW, I understand my way (Find and Replace) is laborintensive, but have no choice unless someone has suggestion.
]]> Thu, 19 May 2005 08:44:31 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83461.html#83461 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83449.html#83449 Author: sfd19
Subject: 15140
Posted: 19 May 2005 at 3:28am

Why don't you simply assign another ID (X) to your assistant admin andrun a SQL query that changes all database references from ID=2 to ID=X ?

Edited by sfd19 - 19 May 2005 at 5:37am]]> Thu, 19 May 2005 03:28:31 +0000 https://forums.webwiz.net/importing-members-from-snitz-forum_topic15140_post83449.html#83449