Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> SQLError:1054 Unknown column 'u.user custom title' in 'field

After I installed 'Custom Title' Mod downloaded from this site everything else is fine but the 'viewtopic.php' is causing problems. here the error goes...

-
General Error

Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_id, u.user_posts, u.user_custom_title, 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, 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 = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 434
File : /home/opusmord/public_html/testdrive/modules/Forums/viewtopic.php
-

Any idea how to fix it ?

ps: I am looking for a mod which can sort the modules in groups like this site has. Anyone knows how to ?

Thanks

that errors tells you that the sql is not installed. Please run the sql file assocaited with that mod and you also might want to take a look at this fix for the same mod
[ Register or login to view links on this board. ]

thanks very much for your reply. But I'm new in php. so please elaborate how to run that sql file ?

inside the modules folder that you downloaded is a sql file. you upload that along with all the other files in there and call it from your browser
[ Register or login to view links on this board. ]

replace the YOUR_SITE with the actual name of your site

I tried doing so and this error came up.

Fatal error: [] operator not supported for strings in /home/opusmord/public_html/testdrive/modules/Forums/title_install.php on line 116

When I try to view any topic it shows this general error

Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_id, u.user_posts, u.user_custom_title, 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, 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 = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 434
File : /home/opusmord/public_html/testdrive/modules/Forums/viewtopic.php

Originally posted by Taut @ Wed Jun 23, 2004 6:09 am:

inside the modules folder that you downloaded is a sql file. you upload that along with all the other files in there and call it from your browser
[ Register or login to view links on this board. ]

replace the YOUR_SITE with the actual name of your site

I did just that, and this is the message the showed up on the page:

Database type :: mysql
Aexoden's Custom Title Version:: 1.0.1

This installs the necessary database schema for Aexoden's Custom Title MOD. Currently, only the MySQL aspect has been tested. If you're using any other database, please report your results to Aexoden.

Fatal error: [] operator not supported for strings in /home/opusmord/public_html/testdrive/modules/Forums/title_install.php on line 116

When I tried to access the forum next, the same error as described by DirgeElucidatr again showed up (I'm his co-admin, btw), which I guess means that 'fatal error' bit is, well, a fatal error. Any suggestions as to what I should do now ? Help ? =\

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

This is because when you modded the file and added u.user_custom_title portion of the mod, there was a u.* already there. You didn't have to add the u.user_custom_title. Try and remove that bit and see if it doesn't work.

The u.* already looks for the u.user_custom_title and any other u. that may be added in the future.

Also try replacing all the u. entries with u.* That worked for me.

o_o Omg you're a genius. I love you. Thanks !

*EDIT: Er, actually, what Dauthus said just gets rid of all the errors when I try viewing the topic, but when I actually try calling the installataion file from my browser, I get the same error ...

Fatal error: [] operator not supported for strings in /home/opusmord/public_html/testdrive/modules/Forums/title_install.php on line 116

=| Halp ?

Can you post the code around and including the line in question on that file?

Also, now that I think about it, is there an install text with this mod so you can add the sql statements manually using PHPmyadmin? If all the install file does is add the sql database, try it by hand.

Second, is this mod ported to phpNuke? I checked the sql schema and it is for phpbb, not phpNuke.

I have done it by hand, just open the php file and file the sql statements and run it in PHPmyadmin.