https://www.icyphoenix.com/viewtopic.php?f=35&t=5186
-----------------------------------
DARZ
Fri 19 Dec, 2008 03:37

Posts Cannot Display. SQL Error!
-----------------------------------
After I post something I cannot see the content of what I have typed. It gives an error like this;

[code linenumbers=false]General Error	
Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, u.user_trophies, u.ina_char_name, u.ct_miserable_user, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos FROM ip_posts p, ip_users u, ip_posts_text pt, ip_topics t WHERE p.topic_id = 8 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 1006
File : viewtopic.php[/code]

[u][b]Screen Shot.[/b][/u]
[img]http://www.icyphoenix.com/files/images/6277/error.jpg[/img]

[b]view topic.php has no problem, it is uploaded properly.[/b]
please tell me a solution.

many thanks!


-----------------------------------
New Player
Fri 19 Dec, 2008 10:22

Re: Posts Cannot Display. SQL Error!
-----------------------------------
[quote]SQL Error : 1054 Unknown column [b]'u.user_trophies'[/b] in 'field list' [/quote]

you have modified your icy phoenix? which modification?


-----------------------------------
Zuker
Fri 19 Dec, 2008 13:25

Re: Posts Cannot Display. SQL Error!
-----------------------------------
ACP -> Amod+ Admin -> DB Adjustments 

:)


