Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> More Errors :cry:

I i am installing the mod points v 1.1.1
when i run the mood install i get a blank screen
and after editing the files is now giving me this error when i click in membership

General Error

Could not query users

DEBUG MODE

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

SELECT username, user_idd, 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, user_points FROM nuke_users WHERE user_id <> 1 ORDER BY user_regdate ASC LIMIT 0, 50

Change the user_idd to user_id

i try that and it it says

General Error

Could not query users

DEBUG MODE

SQL Error : 1054 Unknown column 'user' 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, user_points FROM nuke_users WHERE user_id <> 1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 214
File : /nuke/modules/Members_List/index.php

nope you edited it wrong look at the email

user,email

should be user_email

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, user_points FROM nuke_users WHERE user_id <> 1 ORDER BY user_regdate ASC LIMIT 0, 50

try that and more errors.

SQL Error : 1054 Unknown column 'name' in 'where clause'

SELECT custom_title from nuke_modules where name='Members_List'

Line : 211
www/modules/Members_List/index.php

i am ataching the
modules/Members_List/index.php file so if you can have a look what is wrong with it.

Also is giving this error on the membershiip.php

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_points' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = 35 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 433
File : /modules/Forums/viewtopic.php

I give up

Molly go to your phpmyadmin and "Browse" the table nuke_users do you see a filed called user_points?

no is not there telli.

i try running the updates again and when i run the uptade to 2.6 agaim
it tell me this

Database type :: mysql
Your Current forum version is .0.7 This upgrade script requires PHP-Nuke 6.5 and BBtoNuke .0.5

If you are running PHP-Nuke 6.5 or newer maybe you have not installed BBtoNuke 2.0.5,
if that is the case get it here then try upgrading again once the patch has been applied.

BBtoNuke Update Failed