Re: Migrating issues [message #36298 is a reply to message #36254] |
Thu, 15 March 2007 04:37 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) |
brianjmurray
![United States United States](/forum/images/flags/us.png) Messages: 7 Registered: March 2007
Karma: 0
|
Junior Member |
|
|
The last issue was caused by using the older fudforum/##########/include/GLOBALS.php. The $WWW_ROOT_DISK was set to /usr/share/egroupware where Ubuntu (or the guy who was working on this before me) installed it. I changed that to point at the new directory /var/www/html/egroupware/fudforum/##########. Now I'm back to being able to see the forum topics but if I try enter one to see the threads I get:
Quote: | Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /var/www/html/egroupware/fudforum/2509859217/index.php on line 71
|
The mysql.log contains this message:
Quote: | 070315 0:34:43 68 Connect egroupware@localhost on
68 Query select version()
68 Init DB egroupware
68 Query SELECT COUNT(config_name) FROM egw_config
68 Query SELECT config_value FROM egw_config WHERE config_app='phpgwapi' AND config_name='system_charset'
68 Query SELECT * FROM egw_config WHERE config_app='phpgwapi'
68 Query SELECT hook_appname,hook_location,hook_filename FROM egw_hooks
68 Query SELECT * FROM egw_config WHERE config_app='phpgwapi'
68 Query SELECT account_id,account_type FROM egw_accounts WHERE account_lid='murrayb'
68 Query SELECT * FROM egw_accounts WHERE account_id=37
68 Query SELECT acl_location,acl_rights FROM egw_acl WHERE acl_appname='phpgw_group' AND acl_account=37
68 Query SELECT * FROM egw_acl WHERE acl_account IN (37,0,-15)
68 Query SELECT * FROM egw_preferences WHERE preference_owner IN (-1,-2,37)
68 Query SELECT account_lid,account_firstname,account_lastname FROM egw_accounts WHERE account_id=37
68 Query SELECT account_email FROM egw_accounts WHERE account_id=37
68 Query SELECT message_id,content FROM egw_lang WHERE lang='en' AND app_name='common'
68 Query SELECT message_id,content FROM egw_lang WHERE lang='en' AND app_name='fudforum'
68 Query SELECT * FROM egw_applications WHERE app_enabled != 0 ORDER BY app_order ASC
68 Query SELECT acl_location,acl_rights FROM egw_acl WHERE acl_appname='phpgw_group' AND acl_account=37
68 Query SELECT account_lid FROM egw_accounts WHERE account_id=15
68 Query SELECT acl_appname,acl_rights FROM egw_acl WHERE acl_location='run' AND acl_account IN (37,-15)
68 Query SELECT hook_appname,hook_location,hook_filename FROM egw_hooks
68 Query SELECT * FROM egw_applications WHERE app_enabled != 0 ORDER BY app_order ASC
68 Query SELECT acl_location,acl_rights FROM egw_acl WHERE acl_appname='phpgw_group' AND acl_account=37
68 Query SELECT * FROM egw_acl WHERE acl_account IN (37,0,-15)
68 Query SELECT * FROM egw_preferences WHERE preference_owner IN (-1,-2,37)
68 Query SELECT acl_appname,acl_rights FROM egw_acl WHERE acl_location='run' AND acl_account IN (37,-15)
68 Query SELECT hook_appname,hook_location,hook_filename FROM egw_hooks
69 Connect egroupware@localhost on
69 Init DB egroupware
69 Query SELECT u.users_opt, t.name FROM phpgw_fud_users u INNER JOIN phpgw_fud_themes t ON t.id=u.theme WHERE u.id!=1 AND u.egw_id=37
69 Query SELECT
s.id AS sid, s.data, s.returnto,
t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt,
u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_lis
t, u.email, u.login
FROM phpgw_fud_ses s
INNER JOIN phpgw_fud_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END)
INNER JOIN phpgw_fud_themes t ON t.id=u.theme WHERE s.ses_id='3b7bec8ea2a9c3365e550a4dcb5b608a'
69 Query UPDATE phpgw_fud_users SET last_visit=1173933283 WHERE id=25
69 Query SELECT thread_id FROM phpgw_fud_msg WHERE id=391
69 Query SELECT count(*) FROM phpgw_fud_msg WHERE thread_id=164 AND id<=391 AND apr=1
69 Query SELECT
c.name AS cat_name,
f.name AS frm_name,
m.subject,
t.id, t.forum_id, t.replies, t.rating, t.n_rating, t.root_msg_id, t.moved_to, t.thread_opt,
tn.thread_id AS subscribed,
mo.forum_id AS md,
tr.thread_id AS cant_rate,
r.last_view,
r2.last_view AS last_forum_view,
r.msg_id,
tv.pos AS th_pos, tv.page AS th_page,
m2.thread_id AS last_thread,
(CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS group_cache_opt
FROM phpgw_fud_thread t
INNER JOIN phpgw_fud_msg m ON m.id=t.root_msg_id
INNER JOIN phpgw_fud_forum f ON f.id=t.forum_id
INNER JOIN phpgw_fud_cat c ON f.cat_id=c.id
INNER JOIN phpgw_fud_thread_view tv ON tv.forum_id=t.forum_id AND tv.thread_id=t.id
INNER JOIN phpgw_fud_msg m2 ON f.last_post_id=m2.id
LEFT JOIN phpgw_fud_thread_notify tn ON tn.user_id=25 AND tn.thread_id=164
LEFT JOIN phpgw_fud_mod mo ON mo.user_id=25 AND mo.forum_id=t.forum_id
LEFT JOIN phpgw_fud_thread_rate_track tr ON tr.thread_id=164 AND tr.user_id=25
LEFT JOIN phpgw_fud_read r ON r.thread_id=t.id AND r.user_id=25
LEFT JOIN phpgw_fud_forum_read r2 ON r2.forum_id=t.forum_id AND r2.user_id=25
INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=25 AND g2.resource_id=f.id
WHERE t.id=164
69 Query UPDATE phpgw_fud_ses SET forum_id=13, time_sec=1173933283, action='Browsing topic <a class=\"GenLink\" href=\"/egroupware/fudforum/2509859217/index.php?t=msg&
;th=164\">Knowledge Base</a>', returnto='t=msg&goto=391&' WHERE id=1578
69 Query SELECT f.id, f.name, c.name, c.id, CASE WHEN 0 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads
FROM phpgw_fud_fc_view v
INNER JOIN phpgw_fud_forum f ON f.id=v.f
INNER JOIN phpgw_fud_cat c ON c.id=v.c
LEFT JOIN phpgw_fud_msg m ON m.id=f.last_post_id
LEFT JOIN phpgw_fud_mod mm ON mm.user_id=25 AND mm.forum_id=f.id INNER JOIN phpgw_fud_group_cache g1 ON g1.resource_id=f.id AND g1.user_id=2147483647 LEFT JOIN phpgw_fud_gro
up_cache g2 ON g2.resource_id=f.id AND g2.user_id=25
LEFT JOIN phpgw_fud_forum_read fr ON fr.forum_id=f.id AND fr.user_id=25
WHERE mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NULL THEN g1.group_cache_opt ELSE g2.group_cache_opt END) & 1) > 0
ORDER BY v.id
69 Query SELECT VERSION()
68 Query SELECT * FROM egw_async WHERE async_id='##last-check-run##'
68 Query REPLACE INTO egw_async (async_next,async_times,async_method,async_data,async_account_id,async_id) VALUES (0,'a:0:{}','none','a:3:{s:6:\"run_by\";s:8:\"fallback\"
;s:5:\"start\";i:1173933283;s:3:\"end\";i:0;}',0,'##last-check-run##')
68 Query SELECT * FROM egw_async WHERE async_next <= 1173933283 AND async_id != '##last-check-run##'
68 Query SELECT * FROM egw_async WHERE async_id='##last-check-run##'
68 Query REPLACE INTO egw_async (async_next,async_times,async_method,async_data,async_account_id,async_id) VALUES (0,'a:0:{}','none','a:3:{s:6:\"run_by\";s:8:\"fallback\"
;s:5:\"start\";i:1173933283;s:3:\"end\";i:1173933283;}',0,'##last-check-run##')
|
|
|
|