1
I recently upgraded to 2.2.1 and noticed that my blogs section and homepage are running really slow. So I ran a SQL debug and the pages take about 9 seconds to load. Also, I got these strange errors.
Can someone please help me interpret these? Thanks!
From Home Page SQL debug queries block:
Quote:
SELECT xoops_users.uname, xoops_users.uid FROM xoops_users inner join xoops_connections ON xoops_connections.userid = xoops_users.uid
Error number: 1016
Error message: Can't open file: 'xoops_connections.MYI'. (errno: 145)
( 0.000962)
and
Quote:
SELECT u.uid, u.name, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM xoops_groups_users_link l LEFT JOIN xoops_users u ON l.uid=u.uid LEFT JOIN xoops_groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid
Error number: 1054
Error message: Unknown column 'u.user_viewemail' in 'field list'
( 0.000709)
Also, should the system be querying all users in the dbase? Not to familiar with the SQL side of life, but the query below is executed against every registered member when the home page is called. Seems strange to me, but likely my ignorance on SQL:
Quote:
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '477' LIMIT 0, 1
( 0.00025)
