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

Автор stin, 23 февраля 2009, 22:19:15

« назад - далее »

0 Пользователи и 1 гость просматривают эту тему.

stin

был 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<br />Р¤' 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<br />Р¤' 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<br />Р' 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<br />Фа' 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<br />Р¤' 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<br />Файл: ' 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<br />Р¤Р' 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<br />Файл: /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<br />Файл: /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<br />' 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<br />Р' 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<br />Файл: /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<br />' 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<br />Фай' 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<br />Р' 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<br />Р¤Р' 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<br />Файл: /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<br />Файл:' 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

проверь бд на ошибки например через phpmyadmin
SimpleMachines Russian Community Team
п.1 Пройду курсы гадалок для определения исходного кода по скриншоту.

п.2 У вас нет желания читать правила раздела, у меня нет желания одобрять темы, которые не соответствуют этим правилам.

stin

пардон за тупой вопрос, но как???? я зашел в пхп май админ, а адльше?

stin


Mavn

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

для починки бд выделяем нужную таблицу а ниже выбираем что с ней делать
SimpleMachines Russian Community Team
п.1 Пройду курсы гадалок для определения исходного кода по скриншоту.

п.2 У вас нет желания читать правила раздела, у меня нет желания одобрять темы, которые не соответствуют этим правилам.

stin

выкинул вроде как 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

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

stin

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

stin

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