| View previous topic :: View next topic |
| Author |
Message |
Sorcerer
Guest
|
 Posted: Sat Dec 27, 2003 7:07 pm Post subject: I can't login in as admin |
 |
|
Hi,
i have a problem. I can't login as admin in my guestbook.
Everything works for the visitors. I read in the install notes that the default user and passwd is: test, 123. But it is'n working... 
(I get: "Invalid username or password. Please try again")
Is there anyone who can help me to get my username and passwd???? |
|
| Back to top |
|
 |
Jam'n
Joined: 07 Jan 2003
Posts: 166
Location: Netherlands
|
| Posted: Sun Dec 28, 2003 9:42 am Post subject: |
|
|
Try reseting the password
You will need PHPadmin for this.
[Method 1]
Select the Guestbook database.
Select book_auth.
Now choose Browse.
You now see the admin username and password.
Select edit.
Now paste Code:
in the password field and click “GO”.
This will reset your account to:
Your admin name and the password will be: 123
Or do it like this.
[Method 2]
Select the Guestbook database
Now choose on the right side of screen select SQL
Now insert in the Data Entry Field the following lines:
| Code: |
delete from book_auth;
INSERT INTO book_auth VALUES (1, 'test', '773359240eb9a1d9', '7d8b85294e2e060b83f596a4fc5561ce', 1058460506); |
And click "GO"
This will reset your account to:
User name: test
Password: 123
_________________
Jam'n
------------------------------------------------
Only the man who's truly educated
understands that he knows very little...
------------------------------------------------ |
|
| Back to top |
|
|
Sorcerer
Guest
|
| Posted: Sun Dec 28, 2003 10:30 am Post subject: It is still not working... |
|
|
I did what you said and it is still not working.
And i checkt my sql database, it's all there.
Even that user 'test'.
Do you know anything else? |
|
| Back to top |
|
|
Jam'n
Joined: 07 Jan 2003
Posts: 166
Location: Netherlands
|
| Posted: Mon Dec 29, 2003 1:56 am Post subject: |
|
|
The only option I have left is delete all the cookies and temporary internet files and try again.
Do you have a link so I could give it a try?
_________________
Jam'n
------------------------------------------------
Only the man who's truly educated
understands that he knows very little...
------------------------------------------------ |
|
| Back to top |
|
|
Sorcerer
Guest
|
| Posted: Mon Dec 29, 2003 4:21 pm Post subject: |
|
|
I changed my guestbook in the same as this site uses (this forum).
So my problem is solved, but thanks anyway for your help... |
|
| Back to top |
|
|
BrendaJ
Joined: 14 Jan 2004
Posts: 3
|
| Posted: Wed Jan 14, 2004 6:58 pm Post subject: Same problem, can't log-in |
|
|
Hi,
I installed advanced GB 2.2 for a friend and it worked fine for months, now he (nor I) can login as admin, although I myself was able to before.
I tried both methods as you described and I still can't login.
Any thoughts?
I'm willing to try upgrading his gb to the new version but don't want to lose his entries.
I look forward to your response. Thanks.
Brenda |
|
| Back to top |
|
|
Jam'n
Joined: 07 Jan 2003
Posts: 166
Location: Netherlands
|
| Posted: Wed Jan 14, 2004 10:34 pm Post subject: |
|
|
Hello BrendaJ
I don't have any thoughts at the moment, but the upgrade should go like this.
First: are you sure you have version 2.2, the one with the smilies.
If you have the right version, then you can do this.
You will have to use PHPMYADMIN or something similar. Phpmyadmin is what most web server hosts use for their clients to access the database.
Replace all files (with the guestbook 2.3.1) and update your database with the SQL file.
| Code: |
# MySQL dump 8.16
#
# Host: localhost Database: gb23
#--------------------------------------------------------
# Server version 3.23.42
#
# Table structure for table 'book_pics'
#
CREATE TABLE book_pics (
msg_id int(11) NOT NULL default '0',
book_id int(11) NOT NULL default '0',
p_filename varchar(100) NOT NULL default '',
p_size int(11) unsigned NOT NULL default '0',
width int(11) unsigned NOT NULL default '0',
height int(11) unsigned NOT NULL default '0',
KEY msg_id (msg_id),
KEY book_id (book_id)
) TYPE=MyISAM;
ALTER TABLE `book_config` ADD `thumbnail` SMALLINT(1) NOT NULL, ADD `thumb_min_fsize` INT(10) NOT NULL; |
Ps. don't forget ta back up your database first. Just in case 
_________________
Jam'n
------------------------------------------------
Only the man who's truly educated
understands that he knows very little...
------------------------------------------------ |
|
| Back to top |
|
|
Jam'n
Joined: 07 Jan 2003
Posts: 166
Location: Netherlands
|
| Posted: Wed Jan 14, 2004 10:38 pm Post subject: |
|
|
Here are some pictures
Here is a tutorial how to import the tables to upgrade your guestbook 2.2 to version 2.3.1
I assume you already have phpMyAdmin and advance guestbook installed and running.
Login to phpMyAdmin.
And choose your guestbook database.
Now select on the right window SQL and browse to the file with the upgrade or paste it into the window and press GO.
You should now see the message that the SQL-query executed successfully.
You just need to copy all the files of the new guestbook and your done.
_________________
Jam'n
------------------------------------------------
Only the man who's truly educated
understands that he knows very little...
------------------------------------------------ |
|
| Back to top |
|
|
BrendaJ
Joined: 14 Jan 2004
Posts: 3
|
| Posted: Thu Jan 15, 2004 7:38 pm Post subject: |
|
|
Thank you for your reply and the time it took to do so!
Well, I'm not so sure it is version 2.2 with smilies, it says version 2.2 but there are no smilies. Here is the url: http://www.uspatriotsmc.com/guestbook/
I have this guestbook installed at my own site as well and I sometimes have to enter my username and password several times for it to let me in.
If I can't upgrade this version I may just install the new version and manually transfer the posts.
I really appreciate your help 
Brenda |
|
| Back to top |
|
|
Jam'n
Joined: 07 Jan 2003
Posts: 166
Location: Netherlands
|
| Posted: Sun Jan 18, 2004 9:56 pm Post subject: |
|
|
Hi Brenda,
I just looked at your version and you have indeed the 2.2 version.
You can see the smilies when you click on show legend.
So you can just upgrade, but make sure to backup first.
Just incase.
Good luck.
_________________
Jam'n
------------------------------------------------
Only the man who's truly educated
understands that he knows very little...
------------------------------------------------ |
|
| Back to top |
|
|
Digital Beat
Joined: 19 Jan 2004
Posts: 3
Location: Finland
|
| Posted: Mon Jan 19, 2004 4:05 pm Post subject: help does not help |
|
|
I also forget my password, tried everything and still it does not reset. What I am doing wrong?
_________________
///Digital Beat/// |
|
| Back to top |
|
|
jaliam
Joined: 27 May 2002
Posts: 5
|
| Posted: Tue Jan 20, 2004 6:31 am Post subject: Many Thanks! |
|
|
You just solved my problem, Jam'n! Thank you very much. :D
_________________
- jaliam |
|
| Back to top |
|
|
guest
Guest
|
| Posted: Tue Jan 20, 2004 6:59 am Post subject: |
|
|
| ok thanks, it works now |
|
| Back to top |
|
|
Trek
Guest
|
| Posted: Fri Jan 23, 2004 1:28 am Post subject: Guestbook username & password |
|
|
| Iam also havin problem, forgot my username and password, which file that hold username and password, so that I can see it?, thanks for any help. |
|
| Back to top |
|
|
BrendaJ
Joined: 14 Jan 2004
Posts: 3
|
| Posted: Fri Jan 23, 2004 4:48 pm Post subject: |
|
|
Jam'n,
I really appreciate your help, but I'm a little confused about the upgrade.
Do you ever upgrade for a fee? How much would you charge to upgrade my site and my friend's with the newest version?
Feel free to email me.
Thanks!
Brenda |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
