[support] db errors by me

[dominick dreiser]

ah thank you,

But now it would seem I have numberous problems importing the tables...
tables such as forum, history such would seme to have numberous 
duplicate entries
for the first fields of their tables.

example :

INSERT INTO `history` VALUES (3, 226, 1148071571);
INSERT INTO `history` VALUES (3, 217, 1147792290);
INSERT INTO `history` VALUES (3, 71, 1148072051);
INSERT INTO `history` VALUES (3, 26, 1147990553);
INSERT INTO `history` VALUES (3, 195, 1148049452);
INSERT INTO `history` VALUES (3, 95, 1148050061);

Is there any specific tool for drupal that can rebuild and import fields 
from a dump properly.
Using mysql or phpmyadmin just gives me "duplicate entries found".


Thank you again .




Victor Trac wrote:
> You need to change your UID to 1, not 0 (0 is for anonymous users),
> which will make you admin.
>
> -Victor
>
> On 5/20/06, dominick dreiser <dvd at corebsd.de> wrote:
>> I happen to have deleted permissions table off my db along with some
>> other tables that were invalid.
>> Due to a upgrade failure on my part to turn off simple_access. I have
>> now copied over a slighty broken
>> dump of my db and recreated the needed tables for the site.
>> Problem now is when I login with my account that used to be a admin, I
>> cant view any pages except
>> my profile. This would mean I have no permissions, being clueless to the
>> permissions table and what the
>> fields stand for, can someone point me into the right direction or
>> provide some advice on how to recreate
>> the permissions table to suit my wanted priviledges.
>> I have also tried to change my UID in user from 10 to 0, I did this
>> because uid 0 is suppose to be the first and default
>> admin account. However then I get "user does not exist" when I try to
>> login so this simple fix did nothing.
>>
>>
>> best regards and thank you in advance for any advice.
>>
>>
>> -- 
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>
>