cant log in

[SteveD3]

Im unable to acces the admin area, and manage payouts.
I looked at the DB and the admin table is empty, how can I go about and repopulate it.

Will I have to reinstall? If so I can backup the rest of the data and insert it later.

Thanks for any help.

-Steve

[mark]

I'm not sure if you mean free or commercial version.

In free version you can recreate the admin by running this SQL command:

INSERT INTO admin VALUES ( 'admin', 'pass456');


In commercial version it should not happen that table pa_merchants is empty. You can reset the username/password back to merchant/merchant by running:

update pa_merchants set username='merchant',password='4c94e3115c1eeb9bd1e5 e4bcb0bcab4e' where merchantid=1


regards,

mark

[SteveD3]

Sorry, Free version

I did as you said, now it shows this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mp3qhost/public_html/affsyst/user/admin/index.php on line 19
If you need the URL PM me

[culti]

i tried to reset my password (for the commercial version) with the SQL command but still can't login. What else can i do?

[mark]

Hello,

there may be login protection in effect. By default if you entered incorrect username/password for 3 times, it will block you to log in for some time.
Login protection is set in Settings in merchant control panel.

Try to log in again after some time, or close the browser and open it again. This should help against the protection.

If you reset the username/password using SQL command in this forum it has to work.

Contact me if you still have problem with it.

regards,

Mark