https://www.icyphoenix.com/viewtopic.php?f=35&t=2681
-----------------------------------
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.


-----------------------------------
Mighty Gorgon
Sat 25 Aug, 2007 18:39

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
Try these:
[code linenumbers=false]ALTER TABLE `orion_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`;
ALTER TABLE `orion_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`;[/code]


-----------------------------------
k0m4
Sat 25 Aug, 2007 19:01

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
Works fine now. Can't believe it :shock: 

[size=14][b]You're great, man![/b][/size]

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


-----------------------------------
Xerus
Sun 26 Aug, 2007 01:58

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
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


-----------------------------------
JANU1535
Mon 27 Aug, 2007 00:21

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
Optimize and repair the Data Base.


-----------------------------------
Mighty Gorgon
Mon 27 Aug, 2007 20:52

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
Try to have a look here as well:

http://www.icyphoenix.com/viewtopic.php?t=155&highlight=phpbbsessions


-----------------------------------
Xerus
Tue 28 Aug, 2007 20:48

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
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:


-----------------------------------
Mighty Gorgon
Wed 29 Aug, 2007 01:13

Re: Some SQL-Errors After Converting Orion To IP
-----------------------------------
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.


