forum.lissyara.su

Добавлено: **2008-02-26 4:55:39**

Вот какие грабли словил на переходе!

ERROR:
No query specified

ERROR 1064 (42000): 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 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w' at line 1
ERROR 1064 (42000): 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 '}

    //-->
    </script>

        <meta name="OBGZip" content="tru' at line 1
ERROR 1064 (42000): 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 ':&nbsp' at line 1
ERROR 1064 (42000): 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 '</p>
<p>
    <span class="syntax"><span class="syntax_alpha syntax_alpha_reserve' at line 1
ERROR 1064 (42000): 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 '&middot' at line 1
ERROR 1064 (42000): 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 '&nbsp' at line 1
ERROR 1064 (42000): 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 '[<a href="db_details_export.php?lang=ru-win1251&server=1&db=als-krsn&amp' at line 1
ERROR 1064 (42000): 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 'parent.frames.queryframe.querywindow.document.querywindow.query_history_latest.v' at line 1
ERROR 1064 (42000): 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 'parent.frames.queryframe.querywindow.document.querywindow.submit()' at line 1
ERROR 1064 (42000): 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 'parent.frames.queryframe.querywindow.focus()' at line 1
ERROR 1064 (42000): 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 '} else {
                parent.frames.queryframe.querywindow.focus()' at line 1
ERROR 1064 (42000): 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 '}

            return false' at line 1
ERROR 1064 (42000): 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 '} else if (parent.frames.queryframe) {
            new_win_url = 'querywindow.ph' at line 1
ERROR 1064 (42000): 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 'parent.frames.queryframe.querywindow=window.open(new_win_url, '','toolbar=0,loca' at line 1
ERROR 1064 (42000): 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 'if (!parent.frames.queryframe.querywindow.opener) {
               parent.frames' at line 1
ERROR 1064 (42000): 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 '}

            // reload_querywindow()' at line 1
ERROR 1064 (42000): 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 'return false' at line 1
ERROR 1064 (42000): 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 '}
    }

    reload_querywindow()' at line 1
ERROR 1064 (42000): 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 '//-->
</script>

</body>

</html>' at line 1

Подробнее что делал: Сделал дамп с версии 5,0,27 и попытался загрузить в 5,1,23 результат вы видете! Посоветуйте что легче разобрать эти грабли или снести и вернуться к версии 5,0?

Добавлено: **2008-02-26 11:00:20**

Вот что на вскидку увидел в PhpMyAdmin

Код: Выделить всё

 Table 'als-krsn.jos_joomap' doesn't exist

Ошибка

SQL-запрос : 

SHOW KEYS FROM `jos_joomap`

Ответ MySQL:
#1146 - Table 'als-krsn.jos_joomap' doesn't exist

Причем когда просто делаю обзор, он показывает что таблица используется!

Добавлено: **2008-02-26 11:05:15**

подозреваю, создались не все файлы таблицы.
руками их с диска удали - все, и пробуй по новой

Добавлено: **2008-02-26 19:15:22**

В общем похоже что таблицы каким то образом заблокированы либо попорчены! Потому как другие базы переезжают без проблем! При этом сайт вроде работает! ХЗ капаем глубже!

Добавлено: **2008-02-26 19:23:54**

Код: Выделить всё

gate# mysqldump -u root -p als-krsn > alias.sql
Enter password:
mysqldump: Got error: 1146: Table 'als-krsn.jos_joomap' doesn't exist when using LOCK TABLES
gate#

forum.lissyara.su

MySQL 5.0.27 vs 5.1.23-rc

MySQL 5.0.27 vs 5.1.23-rc

Re: MySQL 5.0.27 vs 5.1.23-rc

Re: MySQL 5.0.27 vs 5.1.23-rc

Re: MySQL 5.0.27 vs 5.1.23-rc

Re: MySQL 5.0.27 vs 5.1.23-rc