If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
login denial  XML
Forum Index » Support Forum
Author Message
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
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
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
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
  •  
    Forum Index » Support Forum
    Go to:   
    Based on the open source JForum