Hi i having problem with my gallery
every time i try to login i see the welcome page and after that im logout to the index page ;(
i been searching the forum all day and try all the solutions how to login to my forum
i try :
uploading file adminpass.php to the root I can't login
from phpMyAdmin to change the password I can't login
uss the "forgot my password" function (i receive the email with the new password but i still cant login)
delete cookies :-[
delete the browser cache :-[
i create new account and try to login but no success
i try to login with normal user account but no success
i try to login with FF and IE7
Windows/Linux
I don't know what else to try.
This is my test usser and password
ussername: test
password: 123654
link to the gallery (http://abroadbg.com)
Check the groups table in phpmyadmin.
admin is user_group 1 and the others are user_group 2
The cpg14x_usergroups table should have at least 4 groups numbered 1 to 4. Does it?
Quote from: Nibbler on January 05, 2009, 10:12:33 PM
The cpg14x_usergroups table should have at least 4 groups numbered 1 to 4. Does it?
can you explane me better please i have the table cpg14x_usergroups and is 0
Is the table empty? If so, run these queries to add back in the default groups.
INSERT INTO cpg14x_usergroups VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3);
INSERT INTO cpg14x_usergroups VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3);
INSERT INTO cpg14x_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
INSERT INTO cpg14x_usergroups VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
thank you for the help i try to run the queries but with no success
this is the result ;
Error
SQL query:
INSERT INTO cpg14x_usergroups
VALUES ( 1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3 ) ;
MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1
Try
DROP TABLE cpg14x_usergroups
and then
CREATE TABLE cpg14x_usergroups (
group_id int(11) NOT NULL auto_increment,
group_name varchar(255) NOT NULL default '',
group_quota int(11) NOT NULL default '0',
has_admin_access tinyint(4) NOT NULL default '0',
can_rate_pictures tinyint(4) NOT NULL default '0',
can_send_ecards tinyint(4) NOT NULL default '0',
can_post_comments tinyint(4) NOT NULL default '0',
can_upload_pictures tinyint(4) NOT NULL default '0',
can_create_albums tinyint(4) NOT NULL default '0',
pub_upl_need_approval tinyint(4) NOT NULL default '1',
priv_upl_need_approval tinyint(4) NOT NULL default '1',
upload_form_config tinyint(4) NOT NULL default '3',
custom_user_upload tinyint(4) NOT NULL default '0',
num_file_upload tinyint(4) NOT NULL default '5',
num_URI_upload tinyint(4) NOT NULL default '3',
PRIMARY KEY (group_id)
) TYPE=MyISAM COMMENT='Used to store user groups';
and then retry the queries in my previous post.
sorry for the double post i forget to upload the screenshots i made on my database :)
WOW this is it you really save my gallery
thank you Nibbler
perhabs how i sc*ew my usergroups without even to touch anything in PMA ?