| Author |
 Topic  |
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
 Posted - 22 October 2006 : 09:30:51
|
hi guys, made a major balls up
coz i have two admin sections, (one to the forum, one to the main site), i did something really stupid.
i deleted my user profile from my main site, which in turn deleted my user profile from my forum site.
so i have now lost all my posts in the forum, (theyve all dissapeared) and I cant access the admin pages anymore!!
i have created a new user, change the config.asp to my new member id:
Const intAdminMemberID = 297
but that doesnt seem to get me up and running, i still cant access admin site!!
and any chance of getting my posts back or is it all over? :( lol |
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 09:52:25
|
| the problem, i believe, is that i dont have any other admins! I deleted the only admin and superadmin! help?! lol |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 10:50:06
|
| ive tried fiddling with all the codes to get me acces to admin_members.asp but am struggling to create anther admin. any ideas? this is a tricky situation |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 October 2006 : 11:18:10
|
| you will need to open your database and set the value of the M_LEVEL column to 3 for the new user you have created, this will make them an admin |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 11:21:47
|
| how do i open my database? :) do i need a particular software? |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 October 2006 : 11:37:17
|
| what database are you using ? access,mysql or mssql ? |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 11:51:21
|
| mssql |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 11:53:53
|
| is it possible to use admin_mod_dbsetup2 ? |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 14:11:56
|
yes i did it! that was a close one. managed to work out how to get nto enterprise manager, then managed to find my tables. i was unable to edit the users there (i didnt know how to) so i added a user to the forum_member database with a level of 3.
i then went back and deleted my other user and rechanged my intadmin number in the config from 297 to 300. everything back to normal..except...
i lost all my posts :( any ideas? or should i jsut start reposting lol. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 15:21:52
|
hi thanks for the reply. yes i know my initial id was 4 (the author of all the posts). the id is now 300.
I have 53 posts that I lost.
So are you saying the actual post has not been deleted, but the the uthor of the post has.
Therefore I need to find my old posts, and change the number from 4 to 300.
A few questions:
Where do I look for the posts (i have just worked out how to login to enterprise manager and stupidly can play with things without knowing hwat im doing lol)
And secondly, I couldnt work out how to actually edit the tables. There was a query button, an insert button.
When I use quesry, the table loads up the values but I do now know how to edit the values from then.
Any help? :) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 October 2006 : 16:02:55
|
You will need to execute two queries in the server. You will have to execute Query Analizer to do it.
Here are the queries:
UPDATE FORUM_TOPICS SET T_AUTHOR=300 WHERE T_AUTHOR=4
UPDATE FORUM_REPLY SET R_AUTHOR=300 WHERE R_AUTHOR=4
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 18:06:32
|
that is awesome! im back like i was never gone! that is amazing, all my posts recovered!!! just updated my post count manually and im there. thanks very much all, thats a big relief! remind me not to delete my only admin again! i have learnt so much in one day re mssql and snitz, improving all the time.
i akso had to run:
UPDATE FORUM_TOPICS SET T_LAST_POST_AUTHOR=300 WHERE T_LAST_POST_AUTHOR=4
there is one other that i xcant find. the last post does not seem to be showing up. for example, if you goto members.asp where it says my name the last post bit is blank. any ideas? |
|
|
|
ScrubUp
Starting Member
United Kingdom
45 Posts |
Posted - 22 October 2006 : 18:12:12
|
also: F_LAST_POST_AUTHOR
hehe. done :) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
