https://www.icyphoenix.com/viewtopic.php?f=35&t=7678&p=51848#p51848
-----------------------------------
batman
Mon 28 Feb, 2011 03:30

Re: Some Errors After Upgrade?
-----------------------------------
I have 2 version installed on different test sites now lol
The one upgraded to the latest IP phpBB2 >> 1.3.0.53a were I'm having trouble inserting the text.

The second is  phpbb2 >> 1.2.0.27c all looks good other than the error below, Id say I need to drop a few bits? but the posts are there just cant access them due to the error.

[spoiler]Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_sig_bbcode_uid' 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.ct_miserable_user, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 4890 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, 30

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

Mort I can send the original no problem, Ive been in and out of so many things I thought that was the original I sent, but just checked and is in fact the DB for the upgraded phpBB2 >> 1.3.0.53a.

I may be interested in paying to have this sorted but depends on price mate as this is a free site I run, pm me a price and we can go from there.
I don't mind doing the hard work or putting the time in its just a case of knowing exactly what I need to do, I'm on my 3rd sleepless night now trying to sort this  :roll:  :)

[b]EDIT:[/b]
Just remembered on integra there is a little feature called drop all user signatures within the general configuration, I'm going to try see if that sorts anything  :roll:


