| Author |
 Topic  |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
 Posted - 14 December 2004 : 14:58:04
|
I have implemented a couple of sites based on my current oxle code, and I run in to the simple problem that even though I empty the DB (existing db with all apropriate tables etc), the autoincrease values are still saved.
So, for instance ; I use the db of oxle of today. The last member_id is 341, the last topic_id is 2241 etc.
Now I start a new forum, with no members except for admin, and no topics, and only 1 forum.
The first topic I start as admin is topic 2242...the first member that registers is member 342...the first forum I create is forum 94....
Where can I reset those values, so they start over? |
portfolio - linkshrinker - oxle - twitter |
|
|
-gary
Development Team Member
406 Posts |
Posted - 14 December 2004 : 15:18:42
|
| If you're using Access, then you have to do a "compact and repair". |
KawiForums.com
 |
 |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 14 December 2004 : 15:39:02
|
mmm..I've done that already...
since deleting the topics from the db didn't make it any smaller, and I didn't want to upload a 15 Mb empty db, I did that already...but unfortunately it didn't seem to work... |
portfolio - linkshrinker - oxle - twitter |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 14 December 2004 : 15:55:30
|
the size did go down...but the autoreset values didn't...
I used Access 2003 for this operation (on an initially Access 2000 created DB) |
portfolio - linkshrinker - oxle - twitter |
|
|
|
-gary
Development Team Member
406 Posts |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 14 December 2004 : 16:22:59
|
| Just curious: Why would you want to reset them for a new forum? |
eXtremeGossip  |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 14 December 2004 : 16:48:05
|
-gary ; thanks! Will try the provided workaround as soon as possible!
Jorrit ; because it would be ridiculous to have the first topic in a completely empty forum to be topic number 3178...or the first member to be member number 188.
I know it doesn't make any real difference, but it isn't logical. |
portfolio - linkshrinker - oxle - twitter |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 December 2004 : 17:27:49
|
You can run an ALTER TABLE query, in SQL View mode, for each table where you have the problem. The syntax is this:
ALTER TABLE FORUM_REPLY ALTER COLUMN REPLY_ID COUNTER (1, 1)
Just change the code to adapt to the table/Column, paste it to a new query in SQL view mode, execute the query and you're done, for that table.
The blue value is the new value for the autoincrement column. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 14 December 2004 17:29:34 |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
| |
Topic |
|
Topic Locked
