Login Issue

[brijeshkeni]

hi Support,

i am not able to login and get the following error.

Database Error: 1054 - Unknown column 'parent_id' in 'where clause'
Query: select * from app_ext_ipages where parent_id=0 order by sort_order, name
Page: /rpm/index.php?module=dashboard/

When i access the login page; i can view the option to input the name and the password. on adding the credentials it gives me the above error highlighted in BOLD. i tried to restore the back up after which it works fine. when i reinstall the new version again i get the above error.

Best Regards,
Brijesh

[support]

You did not open next page to upgrade Extension tables in database

If you are using Extension then run /install/ext_autoupdate/from_1.4_to_1.5.php

that is why you have this error

[brijeshkeni]

hi Sergie,

I have already done that following your instructions. I tried it again with a fresh download after restoring my previous backup. Everything worked normally after i restored the old backup along with the database. i followed the instructions again and still got the same error.

Best Regards,
Brijesh

[support]

try to run next query manually using phpmyadmin

Code: Select all

ALTER TABLE `app_ext_ipages` ADD `parent_id` INT NOT NULL DEFAULT '0' AFTER `id`;

[brijeshkeni]

Hi Sergie,

Thank you very much. What could have been the possible issue earlier. it works now perfectly.

Best Regards,
Brijesh