https://www.icyphoenix.com/viewtopic.php?f=35&t=2681&p=18927#p18927 ----------------------------------- k0m4 Sat 25 Aug, 2007 15:20 Some SQL-Errors After Converting Orion To IP ----------------------------------- Hello there, now we finally got our database converted to Icy Phoenix, using [i]update_to_ip.php[/i]. All users, passwords, threads, postings an stuff came over and the board is running. But there are still some SQL-Errors. 1. When clicking a username in the forum, instead of showing the profile an error appears, saying: [quote]Could not query recent pics information DEBUG MODE SQL Error : 1054 Unknown column 'c.cat_user_id' in 'where clause' SELECT * FROM orion_album AS p, orion_album_cat AS c WHERE c.cat_user_id = 40 AND p.pic_cat_id = c.cat_id AND p.pic_approval = 1 ORDER BY pic_time DESC Line : 151 File : usercp_viewprofile.php[/quote] 2. Photoalbum in ACP -> only Configuration works perfectly. The rest says: [quote]Couldn't access list of Album Categories DEBUG MODE SQL Error : 1054 Unknown column 'c.cat_user_id' in 'where clause' SELECT c.*, COUNT(p.pic_id) AS count, '' AS username FROM orion_album_cat AS c LEFT JOIN orion_album AS p ON c.cat_id = p.pic_cat_id WHERE cat_id <> 0 AND c.cat_user_id = 0 GROUP BY cat_id ORDER BY cat_order ASC Line : 135 File : album_hierarchy_sql.php [/quote] or [quote]Could not get Category information DEBUG MODE SQL Error : 1054 Unknown column 'cat_parent' in 'where clause' SELECT cat_id, cat_title, cat_view_groups, cat_upload_groups, cat_rate_groups, cat_comment_groups, cat_edit_groups, cat_delete_groups, cat_moderator_groups FROM orion_album_cat WHERE cat_parent = 0 and cat_user_id != 0 LIMIT 1 Line : 85 File : admin_album_personal.php[/quote] I expect some more to come (hope not :wink: ) and apologize for my bad english.