Мод репутации для IPB 2.3.3 - Дизайн и модификация Invision Power Board

Время: Fri, 21 Mar 2008 22:55:20 +0300 Код ошибки: 1064 Сообщение сервера: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* FROM ibf_posts p LEFT JOIN ibf_members m ON (m.id=p.author_id) ' at line 4 IP-адрес клиента: ????????????????? Страница: /index.php?showtopic=41&pid=1519&st=0& Запрос: SELECT p.*, pp.*, m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title,m.hide_email, m.warn_level, m.warn_lastwarn, me.msnname,me.aim_name,me.icq_number,me.signature, me.website,me.yahoo,me.location, me.avatar_location, me.avatar_type, me.avatar_size, m.members_display_name, m.reputation pc.* FROM ibf_posts p LEFT JOIN ibf_members m ON (m.id=p.author_id) LEFT JOIN ibf_member_extra me ON (me.id=m.id) LEFT JOIN ibf_pfields_content pc ON (pc.member_id=p.author_id) LEFT JOIN ibf_profile_portal pp ON (m.id=pp.pp_member_id) WHERE p.pid IN(60,136,213,221,247,483,1222,1226,1259,1351,1367,1436,1519) ORDER BY pid asc

m.reputation pc.*

m.reputation, pc.*

===================================================
 Время: Tue, 25 Mar 2008 04:07:20 +0300
 Код ошибки: 1064
 Сообщение сервера: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default 0' at line 1
 IP-адрес клиента:
 Страница: /admin/index.php?adsess=960766c01ba9d901fa6bc1e84b9f3987&section=components&act=umi&code=work&mod=thx_avanced&step=4&st=0
 Запрос: ALTER TABLE ibf_members ADD thanks_point int(11) NOT default 0
===================================================
 Время: Tue, 25 Mar 2008 04:39:30 +0300
 Код ошибки: 1054
 Сообщение сервера: Unknown column 'm.thanks_point' in 'field list'
 IP-адрес клиента: 
 Страница: /index.php?showtopic=326&pid=2980&st=0&
 Запрос: SELECT p.*, pp.*,
				m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title,m.hide_email, m.warn_level, m.warn_lastwarn,
				me.msnname,me.aim_name,me.icq_number,me.signature, me.website,me.yahoo,me.location, me.avatar_location, me.avatar_type, me.avatar_size, m.members_display_name,
				pc.*,m.thanks_point
					FROM ibf_posts p
						  LEFT JOIN ibf_members m ON (m.id=p.author_id)
						  LEFT JOIN ibf_member_extra me ON (me.id=m.id)
						  LEFT JOIN ibf_pfields_content pc ON (pc.member_id=p.author_id)
						LEFT JOIN ibf_profile_portal pp ON (m.id=pp.pp_member_id)
					WHERE p.pid IN(2980) 
					ORDER BY pid asc
===================================================
 Время: Tue, 25 Mar 2008 04:39:39 +0300
 Код ошибки: 1054
 Сообщение сервера: Unknown column 'm.thanks_point' in 'field list'
 IP-адрес клиента: !!!!!!!!!!!!!!!!
 Страница: /index.php?showtopic=286&pid=2826&st=0&
 Запрос: SELECT p.*, pp.*,
				m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title,m.hide_email, m.warn_level, m.warn_lastwarn,
				me.msnname,me.aim_name,me.icq_number,me.signature, me.website,me.yahoo,me.location, me.avatar_location, me.avatar_type, me.avatar_size, m.members_display_name,
				pc.*,m.thanks_point
					FROM ibf_posts p
						  LEFT JOIN ibf_members m ON (m.id=p.author_id)
						  LEFT JOIN ibf_member_extra me ON (me.id=m.id)
						  LEFT JOIN ibf_pfields_content pc ON (pc.member_id=p.author_id)
						LEFT JOIN ibf_profile_portal pp ON (m.id=pp.pp_member_id)
					WHERE p.pid IN(2767,2774,2796,2803,2814,2823,2826) 
					ORDER BY pid asc
===================================================