|
Page 1 of 1
|
k0m4
Joined: August 2007
Posts: 3
Location: Wismar, MV
|
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.
|
#1 Sat 25 Aug, 2007 15:20 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
Re: Some SQL-Errors After Converting Orion To IP
Try these:
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
|
#2 Sat 25 Aug, 2007 18:39 |
|
k0m4
Joined: August 2007
Posts: 3
Location: Wismar, MV
|
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!
|
#3 Sat 25 Aug, 2007 19:01 |
|
Xerus
Joined: August 2007
Posts: 7
Location: Bavaria
|
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
|
#4 Sun 26 Aug, 2007 01:58 |
|
JANU1535
Joined: August 2006
Posts: 248
Location: Girona
|
Re: Some SQL-Errors After Converting Orion To IP
Optimize and repair the Data Base.
____________ www.JanuWeb.Com - Webmaster
www.phpBB-Es.Com - Administrador
|
#5 Mon 27 Aug, 2007 00:21 |
|
Xerus
Joined: August 2007
Posts: 7
Location: Bavaria
|
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
|
#7 Tue 28 Aug, 2007 20:48 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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
|
#8 Wed 29 Aug, 2007 01:13 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
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
|
|
|
|