Joomla 1.5 Ошибка SQL

Тема в разделе "Перенос Joomla на хостинг и проблемы с хостингом", создана пользователем PastaleT, 19.01.2011.

  1. Offline

    PastaleT Недавно здесь

    Регистрация:
    17.01.2011
    Сообщения:
    11
    Симпатии:
    0
    Пол:
    Мужской
    При импорт базы данных на хостинг вылетает ошибка:
    Файл: /home/hoster/ukraine.com.ua/www/uploads/hosting_mysql_import/files/0047/53/site.sql
    ERROR 1064 (42000) at line 47: 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 'CREATE TABLE IF NOT EXISTS `jos_banner` ( `bid` int(11) NOT NULL AUTO_INCREMEN' at line 44 ERROR 1064 (42000) at line 302: 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 'CREATE TABLE IF NOT EXISTS `jos_ccnewsletter_subscribers` ( `id` int(11) NOT N' at line 11 ERROR 1064 (42000) at line 355: 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 'CREATE TABLE IF NOT EXISTS `jos_comprofiler` ( `id` int(11) NOT NULL DEFAULT '' at line 122 ERROR 1064 (42000) at line 611: 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 'CREATE TABLE IF NOT EXISTS `jos_comprofiler_field_values` ( `fieldvalueid` int' at line 77 ERROR 1064 (42000) at line 709: 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 'CREATE TABLE IF NOT EXISTS `jos_comprofiler_members` ( `referenceid` int(11) N' at line 75 ERROR 1064 (42000) at line 833: 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 'CREATE TABLE IF NOT EXISTS `jos_comprofiler_sessions` ( ' at line 47 ERROR 1064 (42000) at line 926: 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 'CREATE TABLE IF NOT EXISTS `jos_contact_details` ( `id` int(11) NOT NULL AUTO_' at line 153 ERROR 1146 (42S02) at line 1176: Table 'site_db.jos_content' doesn't exist ERROR 1064 (42000) at line 1277: 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 'CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` ( `id` int(11) NOT NULL A' at line 13 ERROR 1064 (42000) at line 1305: 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 'CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_map` ( `acl_id` int(11) NOT NULL ' at line 30 ERROR 1064 (42000) at line 1367: 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 'CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` ( `group_id` int(11) ' at line 11 ERROR 1146 (42S02) at line 1388: Table 'site_db.jos_core_acl_groups_aro_map' doesn't exist ERROR 1064 (42000) at line 1537: 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 '(2, 'Front End', 'Sample Group for Authors, Editors, Publishers', '', '19,20,21'' at line 38 ERROR 1064 (42000) at line 1669: 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 'CREATE TABLE IF NOT EXISTS `jos_jcomments_custom_bbcodes` ( `id` int(11) unsig' at line 80 ERROR 1146 (42S02) at line 1774: Table 'site_db.jos_jcomments_custom_bbcodes' doesn't exist ERROR 1064 (42000) at line 1792: 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 'CREATE TABLE IF NOT EXISTS `jos_jcomments_settings` ( `component` varchar(50) ' at line 32 ERROR 1146 (42S02) at line 1835: Table 'site_db.jos_jcomments_settings' doesn't exist ERROR 1064 (42000) at line 1967: 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 'CREATE TABLE IF NOT EXISTS `jos_jcomments_version` ( `version` varchar(16) NOT' at line 38 ERROR 1146 (42S02) at line 2016: Table 'site_db.jos_jcomments_version' doesn't exist ERROR 1064 (42000) at line 2025: 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 'CREATE TABLE IF NOT EXISTS `jos_jf_content` ( `id` int(10) unsigned NOT NULL A' at line 30 ERROR 1064 (42000) at line 2098: 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 'CREATE TABLE IF NOT EXISTS `jos_jp_exclusion` ( `id` bigint(20) NOT NULL AUTO_' at line 25 ERROR 1064 (42000) at line 2412: 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 'CREATE TABLE IF NOT EXISTS `jos_messages_cfg` ( CREATE TAB' at line 41 ERROR 1064 (42000) at line 2521: 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 'CREATE TABLE IF NOT EXISTS `jos_modules_menu` ( `moduleid` int(11) NOT NULL DE' at line 64 ERROR 1146 (42S02) at line 2594: Table 'site_db.jos_modules_menu' doesn't exist ERROR 1064 (42000) at line 3003: 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 'CREATE TABLE IF NOT EXISTS `jos_polls` ( `id` int(11) unsigned NOT NULL AUTO_I' at line 100 ERROR 1064 (42000) at line 3235: 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 'CREATE TABLE IF NOT EXISTS `jos_rd_sitemap_viewset` ( `id` int(11) unsigned NO' at line 19 ERROR 1146 (42S02) at line 3269: Table 'site_db.jos_rd_sitemap_viewset' doesn't exist ERROR 1064 (42000) at line 3346: 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 'CREATE TABLE IF NOT EXISTS `jos_sh404sef_aliases` ( `id` int(11) NOT NULL AUTO' at line 46
     
  2.  
  3. Asylum
    Offline

    Asylum специалист

    Регистрация:
    09.02.2007
    Сообщения:
    2 571
    Симпатии:
    152
    Пол:
    Мужской
    По всей видимости вы делали дамп в скуле 5.1 и пытаетесь залить более младшую версию. Попробуйте сделать дамп в режиме совместимости с вашей версией
    IF EXISTS должно идти перед именем базы данных ссылка
     

Поделиться этой страницей

Загрузка...