Quote:
Originally Posted by akoj
(Post 1650870)
I see this has been asked several times by other members but there has not been an answer posted yet as to what could be the issue here. Everything worked great on my forum for over a year now until today when I got a "You do not have access to this area" message. Nothing has been changed on the forum so I am not sure what could have caused this. Reinstalled and still do not have access.
|
OK, I fixed this. I am going to attempt to explain how I did it. I am sure that there is a much easier way but I am not very good at db stuff so it was a lot of trial and error for me.
I dropped the table la_admin
Rebuilt it manually using the MYSQL operatons to recreate the table using 3 fields. Using MYSQL insert I recreated the field values using the info that I found in the install.php file.
Code:
$DB->query("CREATE TABLE " . TABLE_PREFIX . "admins (
userid TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
username VARCHAR(64) NOT NULL DEFAULT '',
email VARCHAR(64) NOT NULL DEFAULT '',
PRIMARY KEY (userid)
) " );
Then I just inserted myself and the other admins in the values. I had to go about creating the table manually because I kept getting syntax errors with the code above.
Anyway, I now have access back and I hope that helps someone else out with the same problem |
More Information