Random stuff about serendipity. Discussion, Questions, Paraphernalia.
garvinhicking
Core Developer
Posts: 30022 Joined: Tue Sep 16, 2003 9:45 pmLocation: Cologne, Germany
Contact:
Post
by garvinhicking Thu Jan 18, 2007 3:59 pm
Hi!
Okay, that's good. Now we know that it's not a problem of the right_publish column.
Then I suppose you have removed yourself from usergroups.
Please alter the code in fixright.php to be like this:
Code: Select all
<?php
include 'serendipity_config.inc.php';
echo '<pre>';
print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}authorgroups AS ag LEFT OUTER JOIN {$serendipity['dbPrefix']}groupconfig AS gc ON ag.groupid = gc.id WHERE ag.authorid = 1"));
print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}groups"));
print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}config WHERE authorid = 1"));
echo '</pre>';
Then tell me the output, please. With this I can see of which groups you are a member of and if these groups contain any problematic settings.
We're near the solution, I'm sure
Best regards,
Garvin
kavo
Regular
Posts: 28 Joined: Tue Jan 16, 2007 4:02 pm
Post
by kavo Fri Jan 19, 2007 7:27 am
i get this long screen.
thank again garvin for your patience
Code: Select all
Array
(
[0] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminCategories
[property] => adminCategories
[4] => true
[value] => true
)
[1] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminCategoriesDelete
[property] => adminCategoriesDelete
[4] => true
[value] => true
)
[2] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminCategoriesMaintainOthers
[property] => adminCategoriesMaintainOthers
[4] => true
[value] => true
)
[3] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminComments
[property] => adminComments
[4] => true
[value] => true
)
[4] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminEntries
[property] => adminEntries
[4] => true
[value] => true
)
[5] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminEntriesMaintainOthers
[property] => adminEntriesMaintainOthers
[4] => true
[value] => true
)
[6] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImages
[property] => adminImages
[4] => true
[value] => true
)
[7] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesAdd
[property] => adminImagesAdd
[4] => true
[value] => true
)
[8] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesDelete
[property] => adminImagesDelete
[4] => true
[value] => true
)
[9] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesDirectories
[property] => adminImagesDirectories
[4] => true
[value] => true
)
[10] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesMaintainOthers
[property] => adminImagesMaintainOthers
[4] => true
[value] => true
)
[11] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesSync
[property] => adminImagesSync
[4] => true
[value] => true
)
[12] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesView
[property] => adminImagesView
[4] => true
[value] => true
)
[13] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImagesViewOthers
[property] => adminImagesViewOthers
[4] => true
[value] => true
)
[14] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminImport
[property] => adminImport
[4] => true
[value] => true
)
[15] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminPlugins
[property] => adminPlugins
[4] => true
[value] => true
)
[16] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminPluginsMaintainOthers
[property] => adminPluginsMaintainOthers
[4] => true
[value] => true
)
[17] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminTemplates
[property] => adminTemplates
[4] => true
[value] => true
)
[18] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsers
[property] => adminUsers
[4] => true
[value] => true
)
[19] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersCreateNew
[property] => adminUsersCreateNew
[4] => true
[value] => true
)
[20] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersDelete
[property] => adminUsersDelete
[4] => true
[value] => true
)
[21] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersEditUserlevel
[property] => adminUsersEditUserlevel
[4] => true
[value] => true
)
[22] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersGroups
[property] => adminUsersGroups
[4] => true
[value] => true
)
[23] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersMaintainOthers
[property] => adminUsersMaintainOthers
[4] => true
[value] => true
)
[24] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => adminUsersMaintainSame
[property] => adminUsersMaintainSame
[4] => true
[value] => true
)
[25] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => blogConfiguration
[property] => blogConfiguration
[4] => true
[value] => true
)
[26] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => personalConfiguration
[property] => personalConfiguration
[4] => true
[value] => true
)
[27] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => personalConfigurationNoCreate
[property] => personalConfigurationNoCreate
[4] => true
[value] => true
)
[28] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => personalConfigurationRightPublish
[property] => personalConfigurationRightPublish
[4] => true
[value] => true
)
[29] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => personalConfigurationUserlevel
[property] => personalConfigurationUserlevel
[4] => true
[value] => true
)
[30] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => siteConfiguration
[property] => siteConfiguration
[4] => true
[value] => true
)
[31] => Array
(
[0] => 3
[groupid] => 3
[1] => 1
[authorid] => 1
[2] => 3
[id] => 3
[3] => userlevel
[property] => userlevel
[4] => 255
[value] => 255
)
)
Array
(
[0] => Array
(
[0] => 1
[id] => 1
[1] => USERLEVEL_EDITOR_DESC
[name] => USERLEVEL_EDITOR_DESC
)
[1] => Array
(
[0] => 2
[id] => 2
[1] => USERLEVEL_CHIEF_DESC
[name] => USERLEVEL_CHIEF_DESC
)
[2] => Array
(
[0] => 3
[id] => 3
[1] => USERLEVEL_ADMIN_DESC
[name] => USERLEVEL_ADMIN_DESC
)
)
Array
(
[0] => Array
(
[0] => userlevel
[name] => userlevel
[1] => 255
[value] => 255
[2] => 1
[authorid] => 1
)
[1] => Array
(
[0] => email
[name] => email
[1] => ....
[value] => ....
[2] => 1
[authorid] => 1
)
[2] => Array
(
[0] => lang
[name] => lang
[1] => en
[value] => en
[2] => 1
[authorid] => 1
)
[3] => Array
(
[0] => wysiwyg
[name] => wysiwyg
[1] => false
[value] => false
[2] => 1
[authorid] => 1
)
[4] => Array
(
[0] => mail_comments
[name] => mail_comments
[1] => true
[value] => true
[2] => 1
[authorid] => 1
)
[5] => Array
(
[0] => mail_trackbacks
[name] => mail_trackbacks
[1] => true
[value] => true
[2] => 1
[authorid] => 1
)
[6] => Array
(
[0] => no_create
[name] => no_create
[1] => true
[value] => true
[2] => 1
[authorid] => 1
)
[7] => Array
(
[0] => right_publish
[name] => right_publish
[1] => true
[value] => true
[2] => 1
[authorid] => 1
)
[8] => Array
(
[0] => moderateCommentsDefault
[name] => moderateCommentsDefault
[1] => false
[value] => false
[2] => 1
[authorid] => 1
)
[9] => Array
(
[0] => allowCommentsDefault
[name] => allowCommentsDefault
[1] => true
[value] => true
[2] => 1
[authorid] => 1
)
[10] => Array
(
[0] => publishDefault
[name] => publishDefault
[1] => publish
[value] => publish
[2] => 1
[authorid] => 1
)
[11] => Array
(
[0] => password
[name] => password
[1] =>
[value] =>
[2] => 1
[authorid] => 1
)
[12] => Array
(
[0] => check_password
[name] => check_password
[1] =>
[value] =>
[2] => 1
[authorid] => 1
)
[13] => Array
(
[0] => realname
[name] => realname
[1] => Kavo
[value] => Kavo
[2] => 1
[authorid] => 1
)
[14] => Array
(
[0] => username
[name] => username
[1] => Kavo
[value] => Kavo
[2] => 1
[authorid] => 1
)
)
Last edited by
kavo on Fri Jan 26, 2007 1:27 pm, edited 1 time in total.
garvinhicking
Core Developer
Posts: 30022 Joined: Tue Sep 16, 2003 9:45 pmLocation: Cologne, Germany
Contact:
Post
by garvinhicking Fri Jan 19, 2007 10:18 am
Hi!
Okay, now we should have it. Try this code and insert it into your fixright.php:
Code: Select all
<?php
include 'serendipity_confing.inc.php';
serendipity_db_query("UPDATE {$serendipity['dbPrefix']}config SET value='false' WHERE name='no_create' AND authorid = 1");
I was looking at the wrong thing; "right_publish" was not responsible for hiding it, but the "no_create" option was. I'm sorry, I mixed up those two i nyesterdays haste.
HTH,
Garvin
kavo
Regular
Posts: 28 Joined: Tue Jan 16, 2007 4:02 pm
Post
by kavo Fri Jan 19, 2007 10:45 am
i did it.
when i call fixright.php the IE screen is clear.
then i try to login, but still the same
garvinhicking
Core Developer
Posts: 30022 Joined: Tue Sep 16, 2003 9:45 pmLocation: Cologne, Germany
Contact:
Post
by garvinhicking Fri Jan 19, 2007 10:52 am
Hi!
Grr, I hate this.
Try this code please:
Code: Select all
<?php
include 'serendipity_config.inc.php';
echo '<pre>';
serendipity_db_query("UPDATE {$serendipity['dbPrefix']}config SET value='false' WHERE name='no_create' AND authorid = 1");
print_r(serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}config WHERE authorid = 1", false, 'assoc'));
echo '</pre>';
I suppose I misspelled "serendipity_confing" in the first code
Regards,
Garvin
kavo
Regular
Posts: 28 Joined: Tue Jan 16, 2007 4:02 pm
Post
by kavo Fri Jan 19, 2007 11:07 am
great!
now it works. many thanks garvin, you make my day
