[solved] Link to Register user doesn't work

angel777

Hi!, i have a big prob..after this:
i moved my df site to my home site and udated df.
Ps. All works but no activation email link, that gives a white page and after says no users has that name in database.
to try:
the old site was pesmagazine.net
the new:
http://www.angel777.com/pesmagazine
Seem that only the generated activation link results broken or not correct

Thanks!

angel777

now i installed accountPluss and it's very good, i think i relved, but now the activation link it's not clickable i don't know why, lol

Dizfunkshunal · Last edited by Dizfunkshunal on Mon Oct 10, 2011 4:50 pm; edited 1 time in total

Try this modules/you_account/registerphp

Change line 400

PHP:

$message .= _TOFINISHUSER."\n\n $finishlink\n\n"; //<- Is the activation link in email. DJMaze

to

PHP:

$message .= _TOFINISHUSER."<br /><a href=\"$finishlink\">$finishlink</a>"; //<- Is the activation link in email. DJMaze

let me know if it works

angel777

Not yet make that mod, but now
I received many mail erros like this:
(note: i tried to register myself and maybe works)

On /pesmagazine/index.php?name=Your_Account&file=register&reactivate=****&check_num=****************************
While executing query "DELETE FROM cms_users_pass
WHERE time < 1318169860"

the following error occured: Table '********.cms_users_pass' doesn't exist

In: /web/htdocs/www.angel777.com/home/pesmagazine/modules/Your_Account/register.php on line: 499

i put **** for censure numbers =)

Dizfunkshunal · Last edited by Dizfunkshunal on Mon Oct 10, 2011 5:07 pm; edited 1 time in total

Your missing a table in the database. after you uploaded the files for accountplus did you got to you module admin and click on Your account module edit and click the upgrade link?

If you did the table aint there regardless run this sql query to add it

Code::

CREATE TABLE `YOUTABLEPREFIX_users_pass` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_password` varchar(40) NOT NULL,
  `time` int(11) NOT NULL default '0',
  `new_username` varchar(50) NOT NULL,
  `new_email` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Change YOUTABLEPREFIX to your table prefix

angel777

mmm maybe no?! Very Happy

edit and save the My account module?

angel777

i will try thanks..if already done maybe i can broke something?xD

Dizfunkshunal

if the table is there do not run that query! im editing the query to remove the drop statement. Your getting the error can no find table the table is not there but make sure its not there just for giggles us phpmyadmin

angel777

now i have this from error email reports:

On /pesmagazine/index.php?name=Your_Account
While executing query "INSERT INTO cms_users_pass
(id, user_id, username, user_email, user_password, time)
VALUES
(DEFAULT, '8036', '***users name***', '***users mail*****', '***************', '***********')"

the following error occured: Table '*********.cms_users_pass' doesn't exist

In: /web/htdocs/www.angel777.com/home/pesmagazine/modules/Your_Account/index.php on line: 105

angel777

This error come out on lost password request also

Dizfunkshunal

then the table is not there
need to add it run the query i put in above i edited it. it wont do no damage just add the table if its not there.

Dizfunkshunal

I just noticed something you using DF 9.2. if you just downloaded accountplus it may be for DF 9.3 you should upgrade DF Core before adding already upgraded modules.

angel777

Sorry but i have 9.3 but no update in sign

i have the same error..example
the table i think exist..but not works?
www.angel777.com/pesma...=pass_lost

Return the error, Sad

angel777

Dizfunkshunal wrote:

Your missing a table in the database. after you uploaded the files for accountplus did you got to you module admin and click on Your account module edit and click the upgrade link?

If you did the table aint there regardless run this sql query to add it

Code::

CREATE TABLE `YOUTABLEPREFIX_users_pass` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_password` varchar(40) NOT NULL,
  `time` int(11) NOT NULL default '0',
  `new_username` varchar(50) NOT NULL,
  `new_email` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Change YOUTABLEPREFIX to your table prefix

i think i fixed the prob..xD thanks!!!

Phoenix

If you did not upgrade Your Account you will still have further problems.

If you click the edit link in admin.php?op=modules your version should be 2.0.1

Quote::

Editor's Note:
Installation notes:

* upload all directories and the two single files to root
* also advisable to upload the theme files to your current theme(s)
* upgrade the Your_Account module through admin modules to add table cms_users_pass and a couple of config flags