Nuke Resources » Forums » Upgrading PHP-Nuke » 7.5 to 7.8Platinum

waverider · Resource Seeker

Hi,
Have upgraded from 7.5 to 7.8 Platinum and members list module doesn't seem to read the database correctly. Error message is as below

Hopefully someone can help?

Thanks

Could not query users

DEBUG MODE

SQL Error : 1054 Unknown column 'custom10' in 'field list'

SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, custom1, custom2, custom3, custom4, custom5, custom6, custom7, custom8, custom9, custom10, custom11, custom12, custom13, custom14, custom15, custom16, custom17, custom18, custom19, custom20, custom21, custom22, custom23, custom24, user_show_custom1, user_show_custom2, user_show_custom3, user_show_custom4, user_show_custom5, user_show_custom6, user_show_custom7, user_show_custom8, user_show_custom9, user_show_custom10, user_show_custom11, user_show_custom12, user_show_custom13, user_show_custom14, user_show_custom15, user_show_custom16, user_show_custom17, user_show_custom18, user_show_custom19, user_show_custom20, user_show_custom21, user_show_custom22, user_show_custom23, user_show_custom24 FROM nuke_users WHERE user_id <> 1 ORDER BY user_id ASC LIMIT 0, 50

Line : 414
File : index.php

Evaders99 · Resource Master

I don't use Platinum, but I'm guessing you're missing some table changes. Did you have to run an upgrade script?

Check that your users table does have a field named 'custom10'

waverider · Resource Seeker

Hello,
Thanks for the reply.

I have checked the database and columns custom10 to custom24 requested by the script are missing. user_show_custom10 to user_show_custom24 are also missing

I have redone the table and everything works OK now. Perhaps there was some sort of interuption when I transferred the database

Thanks for the help