ошибка с базой.

stin · 23 февраля 2009, 22:19:15

был smf 1.1.5 я поставил 1.1.8
стал восстанавливать базу выкидывает такие ошибки
Line #16: 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 '8,0,'87.250.253.242','?board=16.0;sort=replies;desc','8: Undefined index: custo' at line 2
Line #32: 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 '4994854,0,'67.195.37.171','?action=profile;u=236','8: Undefined index: custom_c' at line 2
Line #48: 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 '15440,0,'93.120.160.111','?action=search2','8: Undefined index: logo_not_show<b' at line 2
Line #80: 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 '79,0,'87.250.253.242','?action=profile;u=212;sa=showPosts','8: Undefined index: ' at line 2
Line #112: 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 '26,1225147104,0,'87.250.253.242','?topic=429.0','8: Undefined index: custom_cop' at line 2
Line #192: 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 '14,'213.186.102.253','?topic=460.120','8: Undefined index: custom_copyright<br ' at line 2
Line #224: 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 '0,1225467940,0,'72.30.79.23','?topic=567.msg15145','8: Undefined index: logo_no' at line 4
Line #240: 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 '5,'95.28.188.99','?action=unread','8: Undefined index: custom_copyright Р¤' at line 2
Line #272: 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 '07,1225539518,315,'85.175.27.207','?topic=799.msg15568;boardseen','8: Undefined ' at line 2
Line #304: 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 '7668,0,'66.249.72.176','?topic=43.0','8: Undefined index: logo_not_show Р¤' at line 3
Line #352: 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 '25754486,0,'74.6.8.105','?topic=782.msg13649','8: Undefined index: custom_copyr' at line 3
Line #368: 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 '23112,1225798837,0,'67.195.37.171','?topic=198.msg15685','8: Undefined index: c' at line 2
Line #384: 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 '025,0,'87.250.253.242','?topic=699.0','8: Undefined index: logo_not_show Р' at line 3
Line #416: 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 '5563,0,'195.151.175.163','?topic=821.0','8: Undefined index: custom_copyright<b' at line 5
Line #432: 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 '825,0,'79.111.10.144','?board=6.0','8: Undefined index: logo_not_show Р¤Р°' at line 4
Line #448: 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 '56,1225968097,288,'194.186.51.67','?board=8.0','8: Undefined index: logo_not_sh' at line 4
Line #480: 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 '6462,0,'77.88.57.202','?topic=892.0','8: Undefined index: logo_not_show Р¤' at line 2
Line #528: 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 '1,1226160748,0,'81.19.66.90','?topic=618.msg6433','8: Undefined index: logo_not' at line 2
Line #560: 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 '26299750,0,'216.69.181.131','?action=login2','8: Undefined index: custom_copyri' at line 2
Line #640: 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 '56,123,'194.126.169.9','','8: Undefined index: custom_copyright Р¤Р°Р№Р»: ' at line 2
Line #656: 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 '94670,7,'90.188.221.204','?topic=935.new','8: Undefined index: logo_not_show<br' at line 2
Line #672: 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 '151,0,'81.19.66.90','?topic=410.msg4351','8: Undefined index: custom_copyright<' at line 2
Line #720: 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 '26606021,0,'87.250.253.242','?action=profile;u=167;sa=showPosts;start=60','8: Un' at line 3
Line #736: 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 '776,0,'77.88.57.202','?topic=291.0','8: Undefined index: logo_not_show Р¤Р' at line 3
Line #800: 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 '6770079,0,'67.195.37.171','?action=unread;board=43.0','8: Undefined index: logo' at line 2
Line #816: 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 '226822499,0,'89.41.86.146','?board=3.0','8: Undefined index: logo_not_show<br /' at line 2
Line #832: 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 '36,'89.223.126.134','?action=unreadreplies','8: Undefined index: logo_not_show<' at line 2
Line #864: 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 '048292,1226932426,0,'72.30.161.223','?topic=189.20','8: Undefined index: custom' at line 2
Line #871: 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 ''?topic=935.msg16046' at line 1
Line #880: 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 'topicseen','8: Undefined index: custom_copyright Р¤Р°Р№Р»: /home/allene/ww' at line 1
Line #912: 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 '72,1227021644,0,'74.6.22.91','?topic=288.40','8: Undefined index: logo_not_show' at line 2
Line #928: 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 '53,1227045430,0,'81.19.66.90','?topic=783.msg11614','8: Undefined index: custom' at line 3
Line #960: 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 '7123435,0,'81.19.66.90','?topic=850.msg14562','8: Undefined index: custom_copyr' at line 3
Line #976: 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 '30,406,'80.250.224.85','?topic=977.0','8: Undefined index: custom_copyright<br ' at line 3
Line #983: 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 ''?action=viewmembers' at line 1
Line #992: 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 'sa=all','8: Undefined index: custom_copyright Р¤Р°Р№Р»: /home/allene/www/s' at line 1
Line #1008: 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 '282081,0,'81.19.66.90','?topic=902.msg15243','8: Undefined index: logo_not_show' at line 2
Line #1040: 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 '3,1227298484,0,'94.100.181.243','?topic=878.msg14591','8: Undefined index: cust' at line 2
Line #1056: 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 '350,1227309727,0,'94.100.181.243','?topic=81.0;prev_next=next','8: Undefined ind' at line 2
Line #1072: 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 '387821,0,'77.88.57.202','?topic=244.0','8: Undefined index: logo_not_show ' at line 2
Line #1088: 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 '101505,1227391458,0,'87.250.253.242','?topic=92.0','8: Undefined index: logo_no' at line 2
Line #1104: 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 '3,0,'216.69.181.131','?action=login2','8: Undefined index: logo_not_show Р' at line 2
Line #1120: 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 '3,3,'92.255.64.20','?action=viewmembers','8: Undefined index: custom_copyright<' at line 3
Line #1152: 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 '7295,2,'92.255.64.20','','8: Undefined index: logo_not_show Р¤Р°Р№Р»: /hom' at line 2
Line #1184: 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 '125667,1227628675,0,'79.111.237.83','?board=11.0','8: Undefined index: custom_c' at line 2
Line #1216: 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 '732262,0,'79.111.237.83','?board=11.0','8: Undefined index: custom_copyright<br' at line 3
Line #1248: 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 '27807044,0,'66.50.127.14','?topic=http://64.15.67.17/~calebsbi/logo.jpg?','8: Un' at line 3
Line #1280: 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 '151347,1227887870,0,'66.249.72.176','?topic=794.msg15779','8: Undefined index: ' at line 2
Line #1296: 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 '917951,0,'87.250.253.242','?board=12.0;sort=last_post;desc','8: Undefined index:' at line 2
Line #1328: 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 '27945508,0,'194.165.42.35','?board=11.0;sort=last_post;desc','8: Undefined index' at line 2
Line #1344: 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 '6923,2,'92.255.64.19','?board=18.0','8: Undefined index: custom_copyright ' at line 2
Line #1360: 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 '056930,0,'77.88.57.202','?topic=639.120','8: Undefined index: custom_copyright<' at line 2
Line #1392: 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 '5,1228133009,0,'77.88.57.202','?topic=349.0','8: Undefined index: logo_not_show' at line 2
Line #1408: 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 '932,0,'87.250.253.242','?action=profile;u=36;sa=statPanel','8: Undefined index: ' at line 2
Line #1424: 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 '8205870,0,'77.88.57.202','?topic=173.20','8: Undefined index: custom_copyright<' at line 4
Line #1440: 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 '36,1228213627,0,'77.88.57.227','?topic=1005.msg16634;topicseen','8: Undefined in' at line 2
Line #1456: 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 '1419,0,'194.67.18.219','?board=33.0;sort=replies','8: Undefined index: custom_c' at line 3
Line #1488: 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 '374753,0,'72.30.87.82','?topic=345.msg2541','8: Undefined index: logo_not_show<' at line 3
Line #1504: 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 '06326,1228417395,0,'72.30.142.88','?topic=646.20','8: Undefined index: custom_c' at line 2
Line #1520: 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 '211303,1228473913,0,'72.30.142.93','?topic=683.msg15182;topicseen','8: Undefined' at line 4
Line #1552: 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 '6,1228535461,0,'74.6.8.98','?topic=250.msg5322','8: Undefined index: logo_not_s' at line 2
Line #1568: 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 '595817,0,'72.30.161.233','?action=profile;u=65;sa=showPosts','8: Undefined index' at line 2
Line #1600: 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 '3,1228669502,0,'89.149.227.193','?board=51.0','8: Undefined index: custom_copyr' at line 2
Line #1680: 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 '17486,0,'77.88.57.202','?topic=539.0','8: Undefined index: custom_copyright<br ' at line 2
Line #1696: 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 '8939559,0,'66.249.71.79','?topic=918.msg16711','8: Undefined index: logo_not_sh' at line 2
Line #1744: 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 '092790,3,'92.255.64.19','?topic=1020.0','8: Undefined index: custom_copyright<b' at line 2
Line #1760: 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 '2989,0,'72.30.142.219','?topic=913.msg15439;topicseen','8: Undefined index: cus' at line 2
Line #1776: 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 '3549,1229241210,0,'71.199.134.244','?board=2.0;sort=last_post','8: Undefined ind' at line 2
Line #1808: 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 '245,0,'174.36.207.234','?action=unread;board=12.0','8: Undefined index: logo_no' at line 3
Line #1840: 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 '411614,0,'87.118.120.23','?topic=16.msg149','8: Undefined index: logo_not_show<' at line 3
Line #1856: 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 '0544,0,'87.118.120.23','?topic=402.msg8214','8: Undefined index: custom_copyrig' at line 3
Line #1872: 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 '3,0,'66.249.71.79','?board=13.0','8: Undefined index: logo_not_show Р¤Р°Р№' at line 2
Line #1888: 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 '57,1229481890,0,'195.46.102.138','?topic=202.0','8: Undefined index: custom_cop' at line 3
Line #1904: 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 '547030,0,'81.19.66.90','?topic=257.0','8: Undefined index: custom_copyright<br ' at line 2
Line #1920: 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 '0,1229581391,0,'66.249.71.78','?topic=170.msg12167','8: Undefined index: logo_n' at line 2
Line #1936: 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 '29635418,0,'87.250.253.242','?action=profile;u=21;sa=showPosts;start=20','8: Und' at line 3
Line #1968: 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 '2141,1229730217,0,'72.30.87.84','?topic=264.0','8: Undefined index: logo_not_sh' at line 3
Line #1984: 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 '656,1229781342,0,'72.30.142.97','?topic=470.0','8: Undefined index: custom_copy' at line 2
Line #2016: 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 '970,0,'77.88.57.202','?action=profile;u=12;sa=showPosts;start=360','8: Undefined' at line 2
Line #2032: 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 '229929247,0,'78.106.32.67','?action=login2','Р'Р°С€Р° СѓС‡РµС,РЅР°СЏ Р·Р°РїРёСЃС' at line 2
Line #2080: 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 '0041863,0,'74.6.22.125','?topic=17.msg185','8: Undefined index: logo_not_show<b' at line 4
Line #2096: 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 '78,0,'74.6.22.125','?topic=1030.msg16924','8: Undefined index: custom_copyright' at line 2
Line #2112: 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 '6062,1230092948,0,'150.70.84.26','?action=profile;u=47','8: Undefined index: lo' at line 2
Line #2128: 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 '60341,1230121559,0,'85.141.153.194','?action=register2','8: Undefined index: cu' at line 3
Line #2144: 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 '19,1230147071,0,'81.19.66.90','?topic=574.msg5486;topicseen','8: Undefined index' at line 5
Line #2160: 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 '30180997,0,'89.178.236.220','?board=16.0','8: Undefined index: logo_not_show<br' at line 3
Line #2176: 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 '74159,1230218454,0,'77.88.57.227','?','8: Undefined index: logo_not_show Р' at line 2
Line #2208: 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 '13,123,'194.126.169.9','?topic=1065.new','8: Undefined index: logo_not_show<br ' at line 2
Line #2224: 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 '448,1230307067,0,'81.19.66.90','?topic=2.msg712','8: Undefined index: custom_co' at line 2
Line #2240: 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 '0,1230327607,0,'77.88.57.227','?topic=1067.msg0;topicseen','8: Undefined index: ' at line 2
Line #2256: 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 '394693,1230370321,0,'194.8.75.247','?action=register','8: Undefined index: logo' at line 3
Line #2272: 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 '230387006,0,'66.249.71.77','?topic=191.0','8: Undefined index: custom_copyright' at line 2
Line #2288: 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 '0405314,0,'77.88.57.202','?topic=669.0','8: Undefined index: logo_not_show<br /' at line 2
Line #2304: 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 '447969,0,'72.30.161.234','?topic=260.0;prev_next=prev','8: Undefined index: log' at line 2
Line #2320: 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 '77,1230463564,0,'81.19.66.90','?topic=599.msg5731;topicseen','8: Undefined index' at line 2
Line #2368: 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 '1724,0,'66.249.71.83','?board=24.0','8: Undefined index: logo_not_show Р¤Р' at line 2
Line #2384: 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 '838,0,'194.8.75.247','?action=register2','8: Undefined index: logo_not_show<br ' at line 2
Line #2400: 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 '9379,1230587296,0,'66.249.71.77','?board=13.0','8: Undefined index: custom_copy' at line 2
Line #2416: 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 '36,1230605208,0,'94.100.181.243','?topic=49.0;prev_next=prev','8: Undefined inde' at line 2
Line #2423: 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 '6809,1230612293,0,'194.8.75.247','?board=11.0','8: Undefined index: logo_not_sh' at line 2
Line #2432: 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 'topicseen','8: Undefined index: logo_not_show Р¤Р°Р№Р»: /home/allene/www/s' at line 1
Line #2480: 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 '5866,230,'95.28.99.185','','8: Undefined index: custom_copyright Р¤Р°Р№Р»:' at line 2
Line #2496: 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 '230674324,0,'87.250.253.242','?action=profile;u=54;sa=showPosts','8: Undefined i' at line 2
Line #2528: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne

что это такое, подскажите пожалуйста

Mavn · 23 февраля 2009, 22:24:20

проверь бд на ошибки например через phpmyadmin

stin · 23 февраля 2009, 22:35:59

пардон за тупой вопрос, но как?

я зашел в пхп май админ, а адльше?

stin · 23 февраля 2009, 22:36:34

вроде что то пошло

Mavn · 23 февраля 2009, 22:39:47

1. не флудим!
2. что именно не понятно?

для починки бд выделяем нужную таблицу а ниже выбираем что с ней делать

stin · 23 февраля 2009, 22:40:43

выкинул вроде как 3 ошибки

1. UNIQUE and INDEX keys should not both be set for column `ID_TOPIC`
2. UNIQUE and INDEX keys should not both be set for column `ID_MEMBER`
3. Больше одного INDEX ключа создано для колонки `ID_MEMBER`

stin · 23 февраля 2009, 22:44:49

это все "Проблемы с индексами таблицы `smf_messages`"

stin · 23 февраля 2009, 22:47:05

ПЫТАЛСЯ ЧИНИТЬ ВСЕРАВНО ТА ЖА ЛАЖА. ТЕ ЖЕ ОШИБКИ.

stin · 24 февраля 2009, 01:26:42

вопрос решен спасибо