Icy Phoenix

Hello there,

now we finally got our database converted to Icy Phoenix, using update_to_ip.php. 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

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

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

I expect some more to come (hope not :wink: ) and apologize for my bad english.

Try these:

Works fine now. Can't believe it :shock:

You're great, man!

I'm a lucky guy now - hope I may come back on next error. Thank you very much! :mrorange:

The next error
Computerguard.de

Critical Error

Error creating new session

DEBUG MODE

INSERT INTO orion_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_user_agent, session_page, session_logged_in, session_admin) VALUES ('4017a0faeaf938d51823bd67f9901973', 2, 1188084300, 1188084300, '4fd65fd6', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)', -13, 1, 0)

Line : 233
File : sessions.php

Optimize and repair the Data Base.

Try to have a look here as well:

http://www.icyphoenix.com/viewtopic...t=phpbbsessions

Thank :)

http://www.computerguard.de is new orional Icy no more Orion cback

Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'ip_sessions' is full

INSERT INTO ip_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_user_agent, session_page, session_logged_in, session_admin) VALUES ('83d624243a94cdf215924f808aaceec1', -1, 1188305904, 1188305904, '4fd65ff6', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)', -13, 0, 0)

Line : 208
File : sessions.php


I have manuel cleaned the Icy is back


Thank for Help :loveit:

Great you solved and you have been able to convert.

I have modified update_to_ip.php file and since next version upgrades from Orion should be easiest. :wink:

Enjoy Icy Phoenix.