Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Some SQL-Errors After Converting Orion To IP 
 
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   ) and apologize for my bad english.
 



 
k0m4 - View user's profileSend private message 
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Some SQL-Errors After Converting Orion To IP 
 
Try these:
Code: [Download] [Hide] [Select]
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`;

 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty Gorgon - View user's profileSend private messageVisit poster's websitePersonal Gallery 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Some SQL-Errors After Converting Orion To IP 
 
Works fine now. Can't believe it  

You're great, man!

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



 
k0m4 - View user's profileSend private message 
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
Xerus - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Some SQL-Errors After Converting Orion To IP 
 
Optimize and repair the Data Base.
 




____________
www.JanuWeb.Com - Webmaster
www.phpBB-Es.Com - Administrador
 
JANU1535 - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post Re: Some SQL-Errors After Converting Orion To IP 
 
Try to have a look here as well:

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




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty Gorgon - View user's profileSend private messageVisit poster's websitePersonal Gallery 
Back to topPage bottom
Reply with quote Download Post 
Post 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  
 



 
Xerus - View user's profileSend private messageVisit poster's website 
Back to topPage bottom
Reply with quote Download Post 
Post 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.

Enjoy Icy Phoenix.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty Gorgon - View user's profileSend private messageVisit poster's websitePersonal Gallery 
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events