Помогите срочно! Проблема после миграции на 1.9

 
Посетитель
small user social cms
МедальАвторитет форумаКубок зрительских симпатий
Сообщений: 1208
Только что смигрировал с 1.8 на 1.9.
Внизу страницы вылазит вот такая бяка:

Код PHP:
  1. Время генерации страницы: 0.0500 сек.
  2. Запросы к базе: 68
  3. SET NAMES cp1251
  4. SELECT * FROM cms_menu ORDER BY id ASC
  5. SELECT id, title, link, config, internal, published, version, system FROM cms_components
  6. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id
  7. SELECT u.*, g.is_admin is_admin, p.imageurl as imageurl
  8. FROM cms_users u
  9. INNER JOIN cms_user_groups g ON g.id = u.group_id
  10. INNER JOIN cms_user_profiles p ON p.user_id = u.id
  11. WHERE u.id='1' AND u.is_deleted = 0 AND u.is_locked = 0 LIMIT 1
  12. SELECT 1 FROM cms_banlist WHERE ip = '178.214.34.164' AND status=1
  13. DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)
  14. SELECT id as getfield FROM cms_online WHERE sess_id = 'e8b619e23bd3bf0606874fd0035decee' AND ip = '178.214.34.164' LIMIT 1
  15. UPDATE cms_online
  16. SET lastdate = NOW(),
  17. user_id = '1',
  18. viewurl = '/'
  19. WHERE (sess_id = 'e8b619e23bd3bf0606874fd0035decee' AND ip = '178.214.34.164')
  20. SELECT id FROM cms_stats WHERE (ip = '178.214.34.164' AND page = '/')
  21. SELECT m.access_list
  22. FROM cms_modules m, cms_modules_bind mb
  23. WHERE mb.position = 'top' AND
  24. m.published = 1 AND
  25. m.id = mb.module_id AND
  26. (mb.menu_id = '1' OR mb.menu_id = 0)
  27. SELECT m.access_list
  28. FROM cms_modules m, cms_modules_bind mb
  29. WHERE mb.position = 'sidebar' AND
  30. m.published = 1 AND
  31. m.id = mb.module_id AND
  32. (mb.menu_id = '1' OR mb.menu_id = 0)
  33. SELECT m.access_list
  34. FROM cms_modules m, cms_modules_bind mb
  35. WHERE mb.position = 'l_sidebar' AND
  36. m.published = 1 AND
  37. m.id = mb.module_id AND
  38. (mb.menu_id = '1' OR mb.menu_id = 0)
  39. SELECT *, m.id as mid, m.template as tpl
  40. FROM cms_modules m, cms_modules_bind mb
  41. WHERE (mb.position = 'header') AND
  42. m.published = 1 AND
  43. m.id = mb.module_id AND
  44. (mb.menu_id = '1' OR mb.menu_id = 0)
  45.  
  46. ORDER BY m.ordering ASC
  47. SELECT id FROM cms_user_msg WHERE to_id = '1' AND to_del = 0 AND is_new = 1
  48. SELECT id, seolink FROM cms_blogs WHERE owner="user" AND user_id = 1 ORDER BY owner LIMIT 1
  49. SELECT c.id as id
  50. FROM cms_users u
  51. LEFT JOIN cms_user_groups g ON g.id = u.group_id
  52. LEFT JOIN cms_category c ON c.modgrp_id = g.id
  53. WHERE u.id = '1'
  54. LIMIT 1
  55. SELECT *, m.id as mid, m.template as tpl
  56. FROM cms_modules m, cms_modules_bind mb
  57. WHERE (mb.position = 'topmenu') AND
  58. m.published = 1 AND
  59. m.id = mb.module_id AND
  60. (mb.menu_id = '1' OR mb.menu_id = 0)
  61.  
  62. ORDER BY m.ordering ASC
  63. SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '1' ORDER BY id ASC LIMIT 1
  64. SELECT id as getfield FROM cms_menu WHERE parent_id=0 LIMIT 1
  65. SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = ''
  66. SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 60 AND NSDiffer = '' ORDER BY NSLeft,ordering
  67. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  68. SELECT * FROM cms_filter_rules
  69. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  70. SELECT *, m.id as mid, m.template as tpl
  71. FROM cms_modules m, cms_modules_bind mb
  72. WHERE (mb.position = 'maintop1') AND
  73. m.published = 1 AND
  74. m.id = mb.module_id AND
  75. (mb.menu_id = '1' OR mb.menu_id = 0)
  76.  
  77. ORDER BY m.ordering ASC
  78. SELECT * FROM cms_board_cats WHERE parent_id=0 ORDER BY id ASC LIMIT 1
  79. UPDATE cms_board_items SET is_vip=0 WHERE DATE(vipdate) <= CURRENT_DATE
  80. SELECT i.*, u.login, u.nickname, cat.title as cat_title, cat.obtypes
  81.  
  82. FROM cms_board_items i
  83. LEFT JOIN cms_users u ON u.id = i.user_id
  84. INNER JOIN cms_board_cats cat ON cat.id = i.category_id
  85. WHERE i.published = 1
  86. AND (i.category_id = '10')
  87.  
  88.  
  89.  
  90.  
  91. ORDER BY is_vip DESC, pubdate DESC
  92. LIMIT 0, 15
  93. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  94. SELECT * FROM cms_filter_rules
  95. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  96. SELECT p.title as title,
  97. p.id as id,
  98. p.seolink as seolink,
  99. b.title as blog,
  100. b.owner as owner,
  101. b.id as blog_id,
  102. b.seolink as bloglink,
  103. p.pubdate as fpubdate,
  104. b.user_id as uid,
  105. IFNULL(r.total_rating, 0) as rating,
  106. b.ownertype as ownertype,
  107. u.id as author_id,
  108. u.nickname as author,
  109. up.imageurl as author_image,
  110. u.is_deleted as author_deleted
  111. FROM cms_blog_posts p
  112. LEFT JOIN cms_blogs b ON b.id = p.blog_id
  113. LEFT JOIN cms_users u ON u.id = p.user_id
  114. LEFT JOIN cms_user_profiles up ON up.user_id = p.user_id
  115. LEFT JOIN cms_ratings_total r ON r.item_id=p.id AND r.target='blogpost'
  116. WHERE p.published = 1 AND b.allow_who = 'all'
  117. ORDER BY p.id DESC
  118. LIMIT 30
  119. SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '59' AND published = 1
  120. SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '58' AND published = 1
  121. SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '57' AND published = 1
  122. SELECT id FROM cms_comments WHERE target = 'blog' AND target_id = '56' AND published = 1
  123. SELECT *, m.id as mid, m.template as tpl
  124. FROM cms_modules m, cms_modules_bind mb
  125. WHERE (mb.position = 'maintop2') AND
  126. m.published = 1 AND
  127. m.id = mb.module_id AND
  128. (mb.menu_id = '1' OR mb.menu_id = 0)
  129.  
  130. ORDER BY m.ordering ASC
  131. SELECT * FROM cms_board_cats WHERE parent_id=0 ORDER BY id ASC LIMIT 1
  132. UPDATE cms_board_items SET is_vip=0 WHERE DATE(vipdate) <= CURRENT_DATE
  133. SELECT i.*, u.login, u.nickname, cat.title as cat_title, cat.obtypes
  134.  
  135. FROM cms_board_items i
  136. LEFT JOIN cms_users u ON u.id = i.user_id
  137. INNER JOIN cms_board_cats cat ON cat.id = i.category_id
  138. WHERE i.published = 1
  139. AND (i.category_id = '9')
  140.  
  141.  
  142.  
  143.  
  144. ORDER BY is_vip DESC, pubdate DESC
  145. LIMIT 0, 12
  146. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  147. SELECT * FROM cms_filter_rules
  148. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  149. SELECT c.id as id,
  150. c.target as target,
  151. c.target_id as target_id,
  152. c.target_link as target_link,
  153. c.target_title,
  154. c.content as content,
  155. c.guestname,
  156. c.pubdate as fpubdate,
  157. IFNULL(c.user_id, 0) as user_id,
  158. IFNULL(u.nickname, '') as author,
  159. IFNULL(u.login, '') as author_login,
  160. IFNULL(v.total_rating, 0) as rating
  161. FROM cms_comments c
  162. INNER JOIN cms_users u ON u.id = c.user_id OR c.guestname<>''
  163. LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
  164. WHERE c.published=1 AND c.target IN ('blog')
  165. GROUP BY c.id
  166. ORDER BY c.id DESC
  167. LIMIT 70
  168. SELECT *, m.id as mid, m.template as tpl
  169. FROM cms_modules m, cms_modules_bind mb
  170. WHERE (mb.position = 'l_sidebar') AND
  171. m.published = 1 AND
  172. m.id = mb.module_id AND
  173. (mb.menu_id = '1' OR mb.menu_id = 0)
  174.  
  175. ORDER BY m.ordering ASC
  176. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  177. SELECT * FROM cms_filter_rules
  178. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  179. SELECT u.id, u.login, u.nickname, u.rating as rating, u.is_deleted, p.karma as karma, p.user_id, p.imageurl, u.status
  180. FROM cms_users u
  181. LEFT JOIN cms_user_profiles p ON p.user_id = u.id
  182. WHERE u.is_deleted = 0 AND u.is_locked = 0
  183. ORDER BY rating DESC
  184. LIMIT 7
  185. SELECT *, m.id as mid, m.template as tpl
  186. FROM cms_modules m, cms_modules_bind mb
  187. WHERE (mb.position = 'maintop') AND
  188. m.published = 1 AND
  189. m.id = mb.module_id AND
  190. (mb.menu_id = '1' OR mb.menu_id = 0)
  191.  
  192. ORDER BY m.ordering ASC
  193. SELECT *, m.id as mid, m.template as tpl
  194. FROM cms_modules m, cms_modules_bind mb
  195. WHERE (mb.position = 'mainbottom') AND
  196. m.published = 1 AND
  197. m.id = mb.module_id AND
  198. (mb.menu_id = '1' OR mb.menu_id = 0)
  199.  
  200. ORDER BY m.ordering ASC
  201. SELECT f.*, f.pubdate as pubdate, u.login as login, u.nickname as nickname
  202. FROM cms_users u, cms_user_photos f
  203. WHERE f.allow_who = 'all' AND f.user_id = u.id
  204. ORDER BY pubdate DESC
  205. LIMIT 24
  206. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  207. SELECT * FROM cms_filter_rules
  208. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  209. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  210. SELECT * FROM cms_filter_rules
  211. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  212. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC
  213. SELECT * FROM cms_filter_rules
  214. SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1
  215. SELECT *, m.id as mid, m.template as tpl
  216. FROM cms_modules m, cms_modules_bind mb
  217. WHERE (mb.position = 'sidebar') AND
  218. m.published = 1 AND
  219. m.id = mb.module_id AND
  220. (mb.menu_id = '1' OR mb.menu_id = 0)
  221.  
  222. ORDER BY m.ordering ASC
  223. SELECT u.*, p.imageurl
  224. FROM cms_users u
  225. INNER JOIN cms_user_profiles p ON p.user_id = u.id
  226. WHERE u.is_deleted = 0 AND u.is_locked=0
  227. ORDER BY u.regdate DESC
  228. LIMIT 6
  229. SELECT c.*
  230. FROM cms_clubs c
  231. WHERE c.published = 1
  232. ORDER BY c.id DESC
  233. LIMIT 3
  234. SELECT 1
  235. FROM cms_user_clubs c
  236. WHERE c.club_id = '25'
  237. SELECT 1
  238. FROM cms_user_clubs c
  239. WHERE c.club_id = '24'
  240. SELECT 1
  241. FROM cms_user_clubs c
  242. WHERE c.club_id = '23'
  243.  
Что это может быть и как с этим бороться?
На машину и квартиру я заработал тут!
Модератор
small user social cms
МедальКубок зрительских симпатийПочетный донор проекта
Сообщений: 964
отключите в админке отладку мускул...
Хватит париться, живи как нравится!
Реклама
cms
Посетитель
small user social cms
МедальАвторитет форумаКубок зрительских симпатий
Сообщений: 1868
Режим отладки в админке включен.
Отключите в настройках сайта.
Дополнения для InstantCMS
Посетитель
small user social cms
МедальАвторитет форумаКубок зрительских симпатий
Сообщений: 1208
Да! Помогло!
Спасибо!
На машину и квартиру я заработал тут!
В начало страницы
Предыдущая темаСледующая тема Перейти на форум: