Adding fields in a existing table

[rafaelmr]

Hi OJSers,

I would like to add in the table users the fields "city", "state", "zipcode" and "country". I created the fields in MySQL and I tried to update the follow files:
classes/user/User.inc.php
classes/user/UserDAO.inc.php

I begin doing this to add the functions and others things referring to the new fields, but after this, I can't loggin the OJS. After login the display was empty.
I updated the file dbscripts/xml/ojs_schema.xml and executed php tools/upgrade.php upgrade

What files I need to change to add this fields?

Thanks.

[asmecher]

Hi Rafael,

When you say you can't log in, what specifically do you see? Is it a blank page (which is often caused by a PHP typo), a login failure message, or some other error message?

Regards,
Alec Smecher
Open Journal Systems Team

[rafaelmr]

Hi Alec,

It's a blank page...

Regards.

[asmecher]

Hi Rafael,

In my experience, blank pages are almost always caused by PHP typos. Check your server's error log to see if there's any information there, and then try backing out your modified versions of UserDAO.inc.php and User.inc.php and re-adding your changes step by step until you find out what causes the problem.

Regards,
Alec Smecher
Open Journal Systems Team

[rafaelmr]

Thank you Alec, I checked my server's log and I found an error and it was correct. But I change the news fields in respectives templates too, but they don't write the datas of them in the table.

Regards.

[asmecher]

Hi Rafael,

You'll need to change the appropriate form class, too -- see classes/user/form/ProfileForm.inc.php.

Regards,
Alec Smecher
Open Journal Systems Team

[rafaelmr]

Thank you Alec, I can insert datas in fields now.

Regards.

[rafaelmr]

Hi Alec,

I create 4 new fields (state, zipcode, city, country). I change the classes/pages/templates that were necessary, but when I create a new user, those fields don't record. But if manager or new user edit theirs profiles, the fields are recorded. Can you help me?

Regards.

[asmecher]

Hi Rafael,

Do you mean the registration form? See classes/user/form/RegistrationForm.inc.php.

Regards,
Alec Smecher
Open Journal Systems Team

[rafaelmr]

Hi Alec,

Yes, I updated the RegistrationForm.inc.php (we want those fields like required):

Code: Select all

function RegistrationForm() {
...
    if ($this->existingUser) {
        ...
    } else {
        ...
        $this->addCheck(new FormValidator($this, 'city', 'required', 'user.profile.form.cityRequired'));
   $this->addCheck(new FormValidator($this, 'state', 'required', 'user.profile.form.stateRequired'));
   $this->addCheck(new FormValidator($this, 'zipCode', 'required', 'user.profile.form.zipCodeRequired'));
   $this->addCheck(new FormValidator($this, 'country', 'required', 'user.profile.form.countryRequired'));
    }
}

function readInputData() {
    $this->readUserVars(
         array(
            'username', 'password', 'password2',
            'firstName', 'middleName', 'lastName', 'initials',
            'affiliation', 'email', 'phone', 'fax',
            'mailingAddress', 'city', 'state', 'zipCode', 'country',
            'biography', 'interests', 'userLocales',
            'registerAsReader', 'registerAsAuthor',
                                'registerAsReviewer', 'existingUser'
         )
      );

function execute() {
   if ($this->existingUser) {
                ...
        } else {
             $user->setCity($this->getData('city'));
      $user->setState($this->getData('state'));
      $user->setZipCode($this->getData('zipCode'));
      $user->setCountry($this->getData('country'));
                ...
        }

Regards,

[asmecher]

Hi Rafael,

Check your additions to ProfileForm again -- that last change should be:

Code: Select all

} else {
        // New user
        $user = &new User();

        $user->setCity($this->getData('city'));
        $user->setState($this->getData('state'));
        $user->setZipCode($this->getData('zipCode'));
        $user->setCountry($this->getData('country'));
        ...

Regards,
Alec Smecher
Open Journal Systems Team

[rafaelmr]

Hi Alec,

I checked the ProfileForm and I can't find any error. I changed the follow files:

classes/user/User.inc.php
classes/user/UserDAO.inc.php
classes/user/form/ProfileForm.inc.php
classes/user/form/RegistrationForm.inc.php
classes/user/form/UserManagementForm.inc.php

pages/manager/PeopleHandler.inc.php

templates/user/register.tpl
templates/user/profile.tpl
templates/manager/people/userProfile.tpl
templates/manager/people/userProfileForm.tpl

When I update a user that exists (Edit Profile) or with the manager, the fields are updated without problems. But when I register a new user, those fields don't record.

Regards,

[rafaelmr]

Hi Alec,

I re-made the actions classes of register and now they are recording. I can't understand yet what was happening, but thank you for your help.

Regards,

[asmecher]

Hi Rafael,

Glad to hear it's working.

Regards,
Alec Smecher
Open Journal Systems Team