Chi Kien Uong
Geranienstraße 30
71034 Böblingen
Deutschland / Germany
|
If you are not registered or logged in, you may still use these forums but with limited features.
Show recent topics
|
|
|
Author |
Message |
17/02/2006 00:20:05
|
fresco
Newbie
Joined: 16/02/2006 23:57:19
Messages: 2
Offline
|
Hi all,
I have a question about the advanced poll. Lately i wanted to login, but it was denied by telling its the wrong login name or password. I checked the config file, and there are the login and pass i've always used, so i'm sure i used the right login and pass. Everything is working fine, new votes are registered correctly. But, i cant enter the admin section anymore.
I read the stickies, but my problem isn't really discussed there. Is this a common problem, does anyone know a solution?
I use advanced poll 2.02 and the DB files, you can see it on http://www.meltdown.nl
thanx in advance!
fresco
|
|
18/02/2006 16:13:42
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
If you are using the database version, then doesn't the info in the config file refer to the database password and not the poll admin password?
Perhaps you should just reset the admin password.
http://proxy2.de/forum/viewtopic.php?t=3416
|
|
21/02/2006 16:58:26
|
fresco
Newbie
Joined: 16/02/2006 23:57:19
Messages: 2
Offline
|
Thanx Amber,
I tried the solution you linked, but it didn't work. Guess i deleted all of the pass and user data, because i cant browse anymore in both fields. And it didnt help to get logged in, well, guess i'm quite stucked and there's nothing left than reinstalling the poll. php rules
fresco
|
|
21/02/2006 21:03:11
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
If you are talking about the database table when you say you can't browse anymore, it must mean the table is empty. You can't browse data if it doesn't exist.
When the post says you should delete your password, it didn't mean delete everything in that table, just the password. The poll_user table consists of fields for user_id, username, userpass, session and last_visit. Each field contains data. If you only delete the password (value) that is contained in the userpass field, the other data remains intact and you can still browse the table.
Let's see if I can be a little clearer:
In PhpMyAdmin, open the poll database. In the left pane, locate the "poll_user" table and click on it. In the right pane, click on "browse" in the menu at the top. You should see your user info.
Click on the pencil icon to edit that entry.
Delete the value in the "userpass" field and click on "go." (Alternatively, you could just insert the original default values shown in the code below.) Then immediately go to your poll's admin panel and log in with your username but no password. Set a new password in Admin.
If you have deleted the entire contents of the "poll_user" table but you think everything else is okay with the poll, just insert new user info. You can use the default info from the poll script, which is:
username: admin
password: poll
An easy way to add it to your database is to save the following as poll.sql:
[list]
[/list]
The above assumes the table "poll_user" still exists but is empty. If the table does not exist, you will need to add instructions to create it in the poll.sql file:
[list]
[/list]
Once you have created the poll.sql file, follow the instructions in item number 3 in this post to add it to the database:
Export/Import MySQL Database
http://proxy2.de/forum/viewtopic.php?t=3580&highlight=sql
More posts with instructions for backing up and restoring database. (Although they refer to the Advanced Guestbook, they are just as helpful):
Guestbook MySQL database transfer:
http://proxy2.de/forum/viewtopic.php?p=5819&highlight=#5819
Where is the guestbook database?:
http://proxy2.de/forum/viewtopic.php?t=2761&highlight=sql
|
|
|
|
|
|
Based on the open source JForum
|