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.
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@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/ ]
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@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/ ]
On Saturday 20 May 2006 04:09, dominick dreiser wrote:
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);
For that table and column, that is normal. That first field is the user id, and there can be more than one entry per user.
Is there any specific tool for drupal that can rebuild and import fields from a dump properly.
I don't know about that. Check the modules[0] and handbook[1]&[2] areas online.
Using mysql or phpmyadmin just gives me "duplicate entries found".
For the history table? Can you just ignore or remove the duplicates?
[0] http://drupal.org/project/Modules [1] http://drupal.org/node/258 [2] http://drupal.org/upgrade/
Thanx for the reply,
I manually INSERTED all the whooping 10K lines of the dump myself. However now I have a funnier problem ... Plus none of the content for the frontpage , forum and such are showing anymore. They are in a moderation queue ..... all forum/content entries seem to be issued under the new username. And when I tried to edit the fields in content/queue list I get access denied you have no permissions... is there a way to reset all my premissions for all users. Creating and new permissions table does not seem to work.
best regards.
Jason Flatt wrote:
On Saturday 20 May 2006 04:09, dominick dreiser wrote:
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);
For that table and column, that is normal. That first field is the user id, and there can be more than one entry per user.
Is there any specific tool for drupal that can rebuild and import fields from a dump properly.
I don't know about that. Check the modules[0] and handbook[1]&[2] areas online.
Using mysql or phpmyadmin just gives me "duplicate entries found".
For the history table? Can you just ignore or remove the duplicates?
[0] http://drupal.org/project/Modules [1] http://drupal.org/node/258 [2] http://drupal.org/upgrade/
Another interesting matter if you look at the following url http://gw.mypartybase.net/dr/?q=forum/11
All content has ... Topic has been moved.
Best regards.
Jason Flatt wrote:
On Saturday 20 May 2006 04:09, dominick dreiser wrote:
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);
For that table and column, that is normal. That first field is the user id, and there can be more than one entry per user.
Is there any specific tool for drupal that can rebuild and import fields from a dump properly.
I don't know about that. Check the modules[0] and handbook[1]&[2] areas online.
Using mysql or phpmyadmin just gives me "duplicate entries found".
For the history table? Can you just ignore or remove the duplicates?
[0] http://drupal.org/project/Modules [1] http://drupal.org/node/258 [2] http://drupal.org/upgrade/
-
dominick dreiser -
Jason Flatt -
Victor Trac