Some SQL-Errors After Converting Orion To IP
Article |
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 [ 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.
|
|
Some SQL-Errors After Converting Orion To IP
Comments |
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`;
|
Mighty Gorgon [ Sat 25 Aug, 2007 18:39 ]
|
|
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 [ Sat 25 Aug, 2007 19:01 ]
|
|
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 [ Sun 26 Aug, 2007 01:58 ]
|
|
Re: Some SQL-Errors After Converting Orion To IP
|
Optimize and repair the Data Base.
|
JANU1535 [ Mon 27 Aug, 2007 00:21 ]
|
|
Re: Some SQL-Errors After Converting Orion To IP
|
|
Mighty Gorgon [ Mon 27 Aug, 2007 20:52 ]
|
|
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 [ Tue 28 Aug, 2007 20:48 ]
|
|
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.
|
Mighty Gorgon [ Wed 29 Aug, 2007 01:13 ]
|
|
|
Was this topic useful?
Was this topic useful?
|
Page 1 of 1
|
|
|