Форум пользователей MySQL

vasya · 21.10.2009 07:41:34

Сохранить в каком-нибудь нормальном редакторе. Гугл говорит, что Notepad++, например, умеет это делать.

crazybox · 22.10.2009 15:44:26

Пытаюсь загрузить дамп (файл .sql из архива) в базу phpmyadmin 2.11.9.6
При установленной кодировке utf-8 выдает:

Код:

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\ob.lib.php on line 83

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\header_http.inc.php on line 22

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\header_http.inc.php on line 23

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\header_http.inc.php on line 24

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\header_http.inc.php on line 25

Warning: Cannot modify header information - headers already sent by (output started at Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php:60) in Z:\home\localhost\www\Tools\phpmyadmin\libraries\header_http.inc.php on line 28
localhost - house

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60

Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in Z:\home\localhost\www\Tools\phpmyadmin\libraries\string_mb.lib.php on line 60
РћС€РёР±РєР°

Р’РµСЂРѕСЏС‚РЅРѕ, SQL-Р·Р°РїСЂРѕСЃ СЃРѕРґРµСЂР¶РёС‚ РѕС€РёР±РєСѓ. РџСЂРё РЅР°Р»РёС‡РёРё С‚Р°РєРѕРІРѕР№, РЅРёР¶Рµ Р±СѓРґРµС‚ РІС‹РІРµРґРµРЅР° РѕС€РёР±РєР° MySQL-СЃРµСЂРІРµСЂР°, РѕР±Р»РµРіС‡Р°СЋС‰Р°СЏ РґРёР°РіРЅРѕСЃС‚РёРєСѓ РїСЂРѕР±Р»РµРјС‹.

ERROR: РќРµР·Р°РєСЂС‹С‚Р°СЏ РєР°РІС‹С‡РєР° @ 246
STR: "
SQL: 


#
# Dumping data for table 'jos_categories' from CMS Joomla
#
INSERT INTO jos_categories VALUES("22","0","aaaa1","Научные","articles.jpg","lurm#4","left","","1","0","0000-00-00 00:00:00",NULL,"3","0","0","topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]");


SQL-Р·Р°РїСЂРѕСЃ:

# # Dumping data for table 'jos_categories' from CMS Joomla # INSERT INTO jos_categories VALUES("22","0","aaaa1","Научные","articles.jpg","lurm#4","left","","1","0","0000-00-00 00:00:00",NULL,"3","0","0","topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]");

РћС‚РІРµС‚ MySQL: Р”РѕРєСѓРјРµРЅС‚Р°С†РёСЏ
#1136 - Column count doesn't match value count at row 1

При кодировке windows-1251:

Код:

Ошибка
[b][/b]
SQL-запрос:

#
# Dumping data for table 'jos_categories' from CMS Joomla
#
INSERT INTO jos_categories
VALUES (
"22", "0", "aaaa1", "Научные", "articles.jpg", "lurm#4", "left", "", "1", "0", "0000-00-00 00:00:00", NULL , "3", "0", "0", "topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]"
);

Ответ MySQL: Документация
#1136 - Column count doesn't match value count at row 1

С чем это связано и как с этим бороться?

Отредактированно crazybox (22.10.2009 15:49:19)

kazyuka · 22.10.2009 19:25:57

Добрыйй Вечер помогите пожалуста у меня такая проблема когда я хочу изменить пользователю в главные редакторы или журналисты появляется вот такая ошибка

MySQL Error!
------------------------

The Error returned was:
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 ' land='zth', info='ztjhz', signature='', email='SamIgorXXX@mail.ru', fullname='t' at line 1

Error Number:
1064

UPDATE dle_users set user_group='3', banned='', r_freeze='', icq='', repa=, land='zth', info='ztjhz', signature='', email='SamIgorXXX@mail.ru', fullname='th', time_limit='', xfields='', restricted='0', restricted_days='0', restricted_date='' WHERE user_id='301'

помогите пожалуста

kazyuka · 22.10.2009 19:29:08

Добрыйй Вечер помогите пожалуста у меня такая проблема когда я хочу изменить пользователю в главные редакторы или журналисты появляется вот такая ошибка

MySQL Error!
------------------------

The Error returned was:
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 ' land='zth', info='ztjhz', signature='', email='SamIgorXXX@mail.ru', fullname='t' at line 1

Error Number:
1064

UPDATE dle_users set user_group='3', banned='', r_freeze='', icq='', repa=, land='zth', info='ztjhz', signature='', email='SamIgorXXX@mail.ru', fullname='th', time_limit='', xfields='', restricted='0', restricted_days='0', restricted_date='' WHERE user_id='301'

помогите пожалуста у меня стаит DataLife Engine 8.2

vasya · 22.10.2009 19:51:19

repa=,
После знака равенства должно идти какое-то значение.
Ищите в коде где идет формирование данного запроса и правте.

crazybox · 22.10.2009 19:57:44

А по моему вопросу, который про загрузку дампа, есть какие-то мысли?

vasya · 22.10.2009 20:20:40

crazybox написал:
Пытаюсь загрузить дамп (файл .sql из архива) в базу phpmyadmin 2.11.9.6

phpmyadmin - зло.

crazybox написал:
#
# Dumping data for table 'jos_categories' from CMS Joomla
#
INSERT INTO jos_categories
VALUES (
"22", "0", "aaaa1", "Научные", "articles.jpg", "lurm#4", "left", "", "1", "0", "0000-00-00 00:00:00", NULL , "3", "0", "0", "topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]"
);

Ответ MySQL: Документация
#1136 - Column count doesn't match value count at row 1

Ошибка происходит из-за того, что в таблице jos_categories количество колонок отлично от того сколько перечисленно в части VALUES().

crazybox написал:
С чем это связано и как с этим бороться?

Сделать нормальный дамп, например, с помощью mysqldump

crazybox · 22.10.2009 21:06:19

Дело в том что дамп скачан с интернета, идет в комплекте с модулем для Joomla 1.5...
Вот сам дамп, может быть подскажите что с ним можно сделать?

Код:

# LURM version 1.01 build 015


#
# Table structure for table 'jos_categories' from CMS Joomla
#

CREATE TABLE IF NOT EXISTS jos_categories (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL DEFAULT '0' ,
  `title` varchar(255) NOT NULL DEFAULT '' ,
  `name` varchar(255) NOT NULL DEFAULT '' ,
  `image` varchar(255) NOT NULL DEFAULT '' ,
  `section` varchar(50) NOT NULL DEFAULT '' ,
  `image_position` varchar(30) NOT NULL DEFAULT '' ,
  `description` text NOT NULL DEFAULT '' ,
  `published` tinyint(1) NOT NULL DEFAULT '0' ,
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0' ,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `editor` varchar(50) ,
  `ordering` int(11) NOT NULL DEFAULT '0' ,
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0' ,
  `count` int(11) NOT NULL DEFAULT '0' ,
  `params` text NOT NULL DEFAULT '' ,
  PRIMARY KEY (id),
  INDEX cat_idx (section,published,access),
  INDEX idx_section (section),
  INDEX idx_access (access),
  INDEX idx_checkout (checked_out)
);


#
# Dumping data for table 'jos_categories' from CMS Joomla
#
INSERT INTO jos_categories VALUES("22","0","aaaa1","Научные","articles.jpg","lurm#4","left","","1","0","0000-00-00 00:00:00",NULL,"3","0","0","topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]");
INSERT INTO jos_categories VALUES("21","0","bbb","Популярные","","lurm#4","left","","1","0","0000-00-00 00:00:00",NULL,"1","0","0","");
INSERT INTO jos_categories VALUES("23","0","sdfg","Nokia","","lurm#1","left","","1","0","0000-00-00 00:00:00",NULL,"2","0","0","topto=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]");


#
# Table structure for table 'jos_components' from CMS Joomla
#

CREATE TABLE IF NOT EXISTS jos_components (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL DEFAULT '' ,
  `link` varchar(255) NOT NULL DEFAULT '' ,
  `menuid` int(11) unsigned NOT NULL DEFAULT '0' ,
  `parent` int(11) unsigned NOT NULL DEFAULT '0' ,
  `admin_menu_link` varchar(255) NOT NULL DEFAULT '' ,
  `admin_menu_alt` varchar(255) NOT NULL DEFAULT '' ,
  `option` varchar(50) NOT NULL DEFAULT '' ,
  `ordering` int(11) NOT NULL DEFAULT '0' ,
  `admin_menu_img` varchar(255) NOT NULL DEFAULT '' ,
  `iscore` tinyint(4) NOT NULL DEFAULT '0' ,
  `params` text NOT NULL DEFAULT '' ,
  `enabled` tinyint(4) NOT NULL DEFAULT '1' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_components' from CMS Joomla
#
INSERT INTO jos_components VALUES("39","LURM","option=com_lurm","0","0","option=com_lurm","LURM","com_lurm","0","js/ThemeOffice/component.png","0","","1");


#
# Table structure for table 'jos_lurm_dicts'
#

DROP TABLE  IF EXISTS jos_lurm_dicts;
CREATE TABLE IF NOT EXISTS jos_lurm_dicts (
  id int(10) NOT NULL auto_increment,
  title varchar(50) NOT NULL DEFAULT '' ,
  name varchar(254) NOT NULL DEFAULT '' ,
  image varchar(100) NOT NULL DEFAULT '' ,
  image_position varchar(10) NOT NULL DEFAULT '0' ,
  descr text ,
  params text NOT NULL DEFAULT '' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  count int(10) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_dicts'
#
INSERT INTO jos_lurm_dicts VALUES("2","ЕдИзм","ЕдИзм","","0","","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]","1","4","0","4","0");
INSERT INTO jos_lurm_dicts VALUES("3","Валюта","Валюта","","0",NULL,"rating=hits[PNL]topto=0[PNL]catid=dasd[PNL]textarea=asdfsd[CR][NL]asdfasdasdf[PNL]htmlarea=asdfasdf[CR][NL]asdfasdf[PNL]","1","1","0","3","0");
INSERT INTO jos_lurm_dicts VALUES("4","CMS","CMS","","0",NULL,"topto=0[PNL]catid=qqq[PNL]","1","5","0","2","0");
INSERT INTO jos_lurm_dicts VALUES("5","Тип","Тип","","0","","topto=0[PNL]catid=www[PNL]textarea=asdfasf[CR][NL]asdfasdf[ES][SQ]dasd[ES][DQ]asdasd[PNL]htmlarea=<br>sdfsdf<b>sadas</b>[PNL]","1","3","0","2","0");


#
# Table structure for table 'jos_lurm_dictvol'
#

DROP TABLE  IF EXISTS jos_lurm_dictvol;
CREATE TABLE IF NOT EXISTS jos_lurm_dictvol (
  id int(10) NOT NULL auto_increment,
  master_id int(11) NOT NULL DEFAULT '0' ,
  parent_id int(11) NOT NULL DEFAULT '0' ,
  title varchar(50) NOT NULL DEFAULT '' ,
  name varchar(254) NOT NULL DEFAULT '' ,
  descr text NOT NULL DEFAULT '' ,
  image varchar(250) NOT NULL DEFAULT '' ,
  count int(10) NOT NULL DEFAULT '0' ,
  params text NOT NULL DEFAULT '' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_dictvol'
#
INSERT INTO jos_lurm_dictvol VALUES("10","3","0","EUR","EUR","","","0","","1","3","0","0");
INSERT INTO jos_lurm_dictvol VALUES("11","4","0","Mambo","Mambo","","","0","","1","2","0","0");
INSERT INTO jos_lurm_dictvol VALUES("12","4","0","Limbo","Limbo","","","0","","1","1","0","0");
INSERT INTO jos_lurm_dictvol VALUES("13","5","0","Готовый","Готовый","","","0","","1","2","0","0");
INSERT INTO jos_lurm_dictvol VALUES("14","5","0","Html-заготовка","Html-заготовка","","","0","","1","1","0","0");
INSERT INTO jos_lurm_dictvol VALUES("3","2","0","шт","шт","","","0","","1","4","0","0");
INSERT INTO jos_lurm_dictvol VALUES("5","2","0","кг","кг","","","0","","1","2","0","0");
INSERT INTO jos_lurm_dictvol VALUES("6","2","0","т","т","","","0","","1","1","0","0");
INSERT INTO jos_lurm_dictvol VALUES("7","2","0","уп","уп","","","0","","1","3","0","0");
INSERT INTO jos_lurm_dictvol VALUES("8","3","0","RUR","RUR","","","0","ShowAs=text[PNL]topto=hits[PNL]bool=0[PNL]catid=[PNL]moduleclass_sfx=[PNL]","1","1","0","0");
INSERT INTO jos_lurm_dictvol VALUES("9","3","0","USD","USD","","","0","","1","2","0","0");


#
# Table structure for table 'jos_lurm_samples'
#

DROP TABLE  IF EXISTS jos_lurm_samples;
CREATE TABLE IF NOT EXISTS jos_lurm_samples (
  id int(10) NOT NULL auto_increment,
  title varchar(50) NOT NULL DEFAULT '' ,
  name varchar(254) NOT NULL DEFAULT '' ,
  image varchar(100) NOT NULL DEFAULT '' ,
  image_position varchar(10) NOT NULL DEFAULT '0' ,
  description text ,
  params text NOT NULL DEFAULT '' ,
  generated varchar(20) NOT NULL DEFAULT '' ,
  modified varchar(20) NOT NULL DEFAULT '' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  count int(10) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_samples'
#
INSERT INTO jos_lurm_samples VALUES("1","образец Скачать","образец Скачать","","","","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1132409309","1132409307","1","1","0","11","0");
INSERT INTO jos_lurm_samples VALUES("2","образец Прайс","образец Прайс","","","","rating=post_count[PNL]topto=1[PNL]catid=1[PNL]textarea=2[PNL]htmlarea=[PNL]","1132517724","1132517721","1","2","1","8","0");
INSERT INTO jos_lurm_samples VALUES("3","Галерея","Галерея","","","1","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1132506664","1132506662","1","3","0","5","0");
INSERT INTO jos_lurm_samples VALUES("4","образец Ссылки","образец Ссылки","","","","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1132517796","1132517792","1","4","0","5","0");
INSERT INTO jos_lurm_samples VALUES("5","образец Контент","образец Контент","","","","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1132340277","1132337070","1","5","0","7","0");
INSERT INTO jos_lurm_samples VALUES("6","образец FAQ","образец FAQ","","","","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1132477774","1132477768","1","6","0","3","0");


#
# Table structure for table 'jos_lurm_samplvol'
#

DROP TABLE  IF EXISTS jos_lurm_samplvol;
CREATE TABLE IF NOT EXISTS jos_lurm_samplvol (
  id int(10) NOT NULL auto_increment,
  master_id int(11) NOT NULL DEFAULT '0' ,
  title varchar(50) NOT NULL DEFAULT '' ,
  name varchar(254) NOT NULL DEFAULT '' ,
  descr text NOT NULL DEFAULT '' ,
  type_usr varchar(25) NOT NULL DEFAULT '0' ,
  isadmtbl int(1) NOT NULL DEFAULT '0' ,
  isadmrequir int(1) NOT NULL DEFAULT '0' ,
  sort int(1) NOT NULL DEFAULT '0' ,
  filter int(1) NOT NULL DEFAULT '0' ,
  eip_admin int(1) NOT NULL DEFAULT '0' ,
  eip_front int(11) NOT NULL DEFAULT '0' ,
  showintable int(1) NOT NULL DEFAULT '0' ,
  showfield int(1) NOT NULL DEFAULT '0' ,
  showtitle int(1) NOT NULL DEFAULT '0' ,
  diffcells int(1) NOT NULL DEFAULT '0' ,
  position int(1) NOT NULL DEFAULT '0' ,
  colspan int(3) NOT NULL DEFAULT '0' ,
  rowspan int(3) NOT NULL DEFAULT '0' ,
  class_sfx_title varchar(50) NOT NULL DEFAULT '0' ,
  class_sfx_value varchar(50) NOT NULL DEFAULT '0' ,
  params text ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_samplvol'
#
INSERT INTO jos_lurm_samplvol VALUES("1","2","usr_article","Артикул","","textfield","0","0","1","0","0","0","1","0","0","0","1","0","1","fld1","","html_class=[PNL]html_text=[PNL]html_alt=[PNL]lurm_fld=[PNL]lurm_url=[PNL]","1","2","1","0");
INSERT INTO jos_lurm_samplvol VALUES("11","1","usr_hits","Скачено:","","hits","1","0","1","0","0","0","1","0","1","1","0","0","0","sectiontableentry2","sectiontableentry2","","1","5","0","0");
INSERT INTO jos_lurm_samplvol VALUES("12","1","usr_size","Размер:","","textfield","0","0","1","0","0","0","1","0","1","1","0","0","0","sectiontableentry1","sectiontableentry1","","1","4","0","0");
INSERT INTO jos_lurm_samplvol VALUES("13","1","usr_website","Сайт:","","url","0","0","0","0","0","0","1","0","1","1","0","0","0","sectiontableentry2","sectiontableentry2","","1","8","0","0");
INSERT INTO jos_lurm_samplvol VALUES("14","1","usr_author","Автор:","","textfield","0","0","1","0","0","0","1","0","1","1","0","0","0","sectiontableentry1","sectiontableentry1","","1","9","0","0");
INSERT INTO jos_lurm_samplvol VALUES("15","1","usr_descr","Описание:","","htmlarea","0","0","0","0","0","0","0","0","1","1","0","0","0","sectiontableentry1","sectiontableentry1","","1","10","0","0");
INSERT INTO jos_lurm_samplvol VALUES("16","1","usr_image","Скриншот:","","showimg","0","0","0","0","0","0","1","0","0","0","0","2","7","fld1","fld1","html_class=[ES][DQ]img[ES][DQ][PNL]html_text=[PNL]html_alt=[PNL]lurm_fld=[PNL]lurm_url=[PNL]","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("17","1","parent_id","Категория:","","category","1","0","1","1","0","0","0","0","1","1","0","0","0","sectiontableentry2","",NULL,"1","7","0","0");
INSERT INTO jos_lurm_samplvol VALUES("18","2","usr_num","#","","tonumber","0","0","0","0","0","0","1","0","0","0","0","0","1","fld1","","","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("19","3","usr_title","Наименование:","","textfield","1","1","1","0","0","0","1","0","1","1","1","0","0","fld3","fld4","","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("2","2","usr_title","Наименование","","textfield","1","0","1","0","0","0","1","0","0","0","1","0","0","fld2","","","1","3","0","0");
INSERT INTO jos_lurm_samplvol VALUES("22","3","usr_date","Дата:","","datefield","0","0","1","0","0","0","1","0","1","1","0","0","0","fld3","fld4","","1","2","0","0");
INSERT INTO jos_lurm_samplvol VALUES("25","3","usr_descr","Примечание:","","textarea","0","0","0","0","0","0","1","0","1","1","0","0","0","fld3","fld4","","1","9","0","0");
INSERT INTO jos_lurm_samplvol VALUES("26","3","usr_image","Скриншот:","","showimg","0","0","0","0","0","0","1","0","0","0","0","0","2","fld1","fld1","html_class=[ES][DQ]img[ES][DQ][PNL]","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("27","3","parent_id","Категория:","","category","1","0","0","1","0","0","0","0","0","1","0","0","0","sectiontableentry2","",NULL,"1","8","0","0");
INSERT INTO jos_lurm_samplvol VALUES("29","2","parent_id","Категория","","category","1","1","0","0","0","0","0","0","0","0","0","0","0","","",NULL,"1","8","0","0");
INSERT INTO jos_lurm_samplvol VALUES("3","2","usr_price","Цена","","textfield","0","0","1","0","0","0","1","0","0","0","1","0","1","fld1","","","1","6","0","0");
INSERT INTO jos_lurm_samplvol VALUES("30","5","usr_date","Дата","","datefield","0","0","0","0","0","0","1","0","0","0","0","0","0","","","","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("31","5","usr_title","Название","","textfield","1","0","0","0","0","0","0","0","0","0","1","0","0","","","","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("32","5","usr_author","Автор","","textfield","1","0","0","0","0","0","1","0","0","0","1","0","0","","","","1","4","0","0");
INSERT INTO jos_lurm_samplvol VALUES("33","5","parent_id","Категория","","category","1","0","0","0","0","0","0","0","0","0","1","0","0","","",NULL,"1","4","0","0");
INSERT INTO jos_lurm_samplvol VALUES("34","5","usr_text","Текст","","htmlarea","0","0","0","0","0","0","0","0","0","0","0","0","0","","","","1","6","0","0");
INSERT INTO jos_lurm_samplvol VALUES("35","5","usr_more","Читать","","view","0","0","0","0","0","0","1","0","0","0","1","0","0","fld2","","html_class=[PNL]html_text=[ES][DQ]$c[usr_title][ES][DQ][PNL]html_alt=[PNL]lurm_fld=[ES][DQ]usr_hits[ES][DQ][PNL]lurm_url=[PNL]","1","4","0","0");
INSERT INTO jos_lurm_samplvol VALUES("36","5","usr_hits","Просмотров","","hits","1","0","0","0","0","0","1","0","0","0","1","0","0","fld1","","","1","7","0","0");
INSERT INTO jos_lurm_samplvol VALUES("37","1","usr_moreinfo","Подробнее","","view","0","0","0","0","0","0","1","0","0","0","0","0","0","","","html_text=[ES][DQ][Подробнее][ES][DQ][PNL]","1","11","0","0");
INSERT INTO jos_lurm_samplvol VALUES("38","1","usr_date","Добавлено:","","datefield","0","0","0","0","0","0","1","0","1","1","0","0","0","sectiontableentry1","sectiontableentry1","","1","6","0","0");
INSERT INTO jos_lurm_samplvol VALUES("39","4","usr_title","Название","","textfield","1","0","0","0","0","0","0","0","0","0","0","0","0","","","","1","6","0","0");
INSERT INTO jos_lurm_samplvol VALUES("4","2","usr_descr","Описание","","textarea","0","0","0","0","0","0","1","0","0","0","0","3","0","fld2","","","1","7","0","0");
INSERT INTO jos_lurm_samplvol VALUES("40","4","usr_link","Сайт","","visit","1","0","0","0","0","0","1","0","0","0","0","0","0","fld2","fld2","lurm_fld=[ES][DQ]usr_hits[ES][DQ][PNL]html_text=[ES][DQ]$c[usr_title][ES][DQ][PNL]","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("41","4","parent_id","Категория","","category","1","0","0","0","0","0","0","0","0","0","1","0","0","","",NULL,"1","6","0","0");
INSERT INTO jos_lurm_samplvol VALUES("42","4","usr_descr","Описание","","textarea","0","0","0","0","0","0","1","0","0","0","0","0","0","","","","1","3","0","0");
INSERT INTO jos_lurm_samplvol VALUES("43","4","usr_hits","Посещений","","hits","0","0","0","0","0","0","1","0","0","0","1","0","1","fld1","","","1","2","0","0");
INSERT INTO jos_lurm_samplvol VALUES("44","6","usr_quest","Вопрос:","","textarea","1","1","0","0","0","0","1","0","1","1","0","0","0","","","","1","1","0","0");
INSERT INTO jos_lurm_samplvol VALUES("45","6","usr_answer","Ответ:","","textfield","0","0","0","0","0","0","1","0","0","0","0","0","0","","","html_class=[PNL]html_text=[PNL]html_alt=[PNL]lurm_fld=[PNL]lurm_url=[PNL]","1","3","0","0");
INSERT INTO jos_lurm_samplvol VALUES("46","6","parent_id","Категория","","category","1","1","0","0","0","0","0","0","0","0","0","0","0","","","html_class=[PNL]html_text=[PNL]html_alt=[PNL]lurm_fld=[PNL]lurm_url=[PNL]","1","2","0","0");
INSERT INTO jos_lurm_samplvol VALUES("6","2","usr_measure","ЕдИзм","","dict#2","0","0","0","1","0","0","1","0","0","0","1","0","0","fld1","","","1","5","0","0");
INSERT INTO jos_lurm_samplvol VALUES("7","2","usr_curr","Валюта","","dict#3","0","0","1","1","0","0","1","0","0","0","1","0","0","","","","1","4","0","0");
INSERT INTO jos_lurm_samplvol VALUES("8","1","usr_title","Наименование:","","textfield","1","1","1","0","0","0","1","0","0","0","1","4","0","filtername","filtername","","1","2","0","0");
INSERT INTO jos_lurm_samplvol VALUES("9","1","usr_file","Файл:","","visit","0","1","0","0","0","0","1","0","1","1","0","0","0","sectiontableentry2","fld2","html_class=[PNL]html_text=[ES][DQ][Скачать][ES][DQ][PNL]html_alt=[PNL]lurm_fld=[ES][DQ]usr_hits[ES][DQ][PNL]lurm_url=[PNL]","1","3","0","0");


#
# Table structure for table 'jos_lurm_sec1'
#

DROP TABLE  IF EXISTS jos_lurm_sec1;
CREATE TABLE IF NOT EXISTS jos_lurm_sec1 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_hits int(10) NOT NULL DEFAULT '0' ,
  usr_size varchar(254) NOT NULL DEFAULT '' ,
  usr_website varchar(254) NOT NULL DEFAULT '' ,
  usr_author varchar(254) NOT NULL DEFAULT '' ,
  usr_descr text ,
  usr_image varchar(254) NOT NULL DEFAULT '0' ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  usr_moreinfo varchar(100) NOT NULL DEFAULT '' ,
  usr_date varchar(20) NOT NULL DEFAULT '' ,
  usr_title varchar(254) NOT NULL DEFAULT '' ,
  usr_file varchar(254) NOT NULL DEFAULT '' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec1'
#
INSERT INTO jos_lurm_sec1 VALUES("1","2","3","34603","http://www.gnu.org/copyleft/gpl.html","GNU","<strong>Настоящий перевод</strong><strong> </strong><em>Стандартной Общественной Лицензии GNU</em> <u>на русский язык</u> не является официальным. Он не публикуется Free Software Foundation и не устанавливает имеющих юридическую силу условий для распространения программного обеспечения, которое распространяется на условиях Стандартной Общественной Лицензии GNU. Условия, имеющие юридическую силу, закреплены исключительно в аутентичном тексте Стандартной Общественной Лицензии GNU на английском языке. Я надеюсь, что настоящий перевод поможет русскоязычным пользователям лучше понять содержание Стандартной Общественной Лицензии GNU.","","0","","1132347600","Русский перевод GENERAL PUBLIC LICENSE GNU","docs/copying.ru.html","1","1","0","0");


#
# Table structure for table 'jos_lurm_sec2'
#

DROP TABLE  IF EXISTS jos_lurm_sec2;
CREATE TABLE IF NOT EXISTS jos_lurm_sec2 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_article varchar(254) NOT NULL DEFAULT '' ,
  usr_num varchar(10) NOT NULL DEFAULT '' ,
  usr_title varchar(254) NOT NULL DEFAULT '' ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  usr_price varchar(254) NOT NULL DEFAULT '' ,
  usr_descr text ,
  usr_measure int(10) NOT NULL DEFAULT '0' ,
  usr_curr int(10) NOT NULL DEFAULT '0' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec2'
#
INSERT INTO jos_lurm_sec2 VALUES("1","1","123","","SiemensCX65","0","100.00","Хороший телефон","4","10","1","1","0","0");
INSERT INTO jos_lurm_sec2 VALUES("2","1","321","","Nokia6230i","20","10000.00","Удобный телефон","4","10","1","1","0","0");


#
# Table structure for table 'jos_lurm_sec3'
#

DROP TABLE  IF EXISTS jos_lurm_sec3;
CREATE TABLE IF NOT EXISTS jos_lurm_sec3 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_title varchar(254) NOT NULL DEFAULT '' ,
  usr_date varchar(20) NOT NULL DEFAULT '' ,
  usr_descr text ,
  usr_image varchar(254) NOT NULL DEFAULT '0' ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec3'
#
INSERT INTO jos_lurm_sec3 VALUES("1","3","Деловой","1132261200","","153-b.jpg","0","1","2","0","0");
INSERT INTO jos_lurm_sec3 VALUES("2","3","Клубный","1132347600","","185-b.jpg","0","1","1","0","0");


#
# Table structure for table 'jos_lurm_sec4'
#

DROP TABLE  IF EXISTS jos_lurm_sec4;
CREATE TABLE IF NOT EXISTS jos_lurm_sec4 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_title varchar(254) NOT NULL DEFAULT '' ,
  usr_link varchar(254) NOT NULL DEFAULT '' ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  usr_descr text ,
  usr_hits int(10) NOT NULL DEFAULT '0' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec4'
#
INSERT INTO jos_lurm_sec4 VALUES("1","5","Limbo по-русски","http://limbo-cms.com.ru","0","Limbo CMS по-русски","3","1","1","0","0");


#
# Table structure for table 'jos_lurm_sec5'
#

DROP TABLE  IF EXISTS jos_lurm_sec5;
CREATE TABLE IF NOT EXISTS jos_lurm_sec5 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_date varchar(20) NOT NULL DEFAULT '' ,
  usr_title varchar(254) NOT NULL DEFAULT '' ,
  usr_author varchar(254) NOT NULL DEFAULT '' ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  usr_text text ,
  usr_more varchar(100) NOT NULL DEFAULT '' ,
  usr_hits int(10) NOT NULL DEFAULT '0' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec5'
#
INSERT INTO jos_lurm_sec5 VALUES("1","4","1132174800","Технический текст 1","Иванов","0","<p>Технический текст 1 Технический текст 1</p><p>Технический текст1 Техническийтекст1Техническийтекст1</p>","","5","1","1","0","0");
INSERT INTO jos_lurm_sec5 VALUES("2","4","1132261200","Текст общего плана","Петров","0","<p>Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана Текст общего плана </p> <ul> <li>Текст общего плана</li> <li>Текст общего плана </li> </ul>","","56","1","2","0","0");


#
# Table structure for table 'jos_lurm_sec6'
#

DROP TABLE  IF EXISTS jos_lurm_sec6;
CREATE TABLE IF NOT EXISTS jos_lurm_sec6 (
  id int(10) NOT NULL auto_increment,
  master_id int(10) ,
  usr_quest text ,
  usr_answer text ,
  parent_id int(10) NOT NULL DEFAULT '0' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  deleted int(11) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sec6'
#
INSERT INTO jos_lurm_sec6 VALUES("1","6","Для чего эта тема?","Для того, чтобы посмотреть работу этого раздела.<br />","0","1","1","0","0");
INSERT INTO jos_lurm_sec6 VALUES("2","6","Это полезный раздел?","Наверное да :)<br />","0","1","2","0","0");


#
# Table structure for table 'jos_lurm_sections'
#

DROP TABLE  IF EXISTS jos_lurm_sections;
CREATE TABLE IF NOT EXISTS jos_lurm_sections (
  id int(10) NOT NULL auto_increment,
  title varchar(50) NOT NULL DEFAULT '' ,
  name varchar(254) NOT NULL DEFAULT '' ,
  master_id int(10) NOT NULL DEFAULT '0' ,
  showtablehead int(1) NOT NULL DEFAULT '0' ,
  class_sfx varchar(50) NOT NULL DEFAULT '' ,
  show_count varchar(4) NOT NULL DEFAULT '' ,
  show_numstr int(1) NOT NULL DEFAULT '0' ,
  show_cat int(1) NOT NULL DEFAULT '1' ,
  show_filter int(1) NOT NULL DEFAULT '1' ,
  item_published int(1) NOT NULL DEFAULT '0' ,
  show_cat_count int(2) NOT NULL DEFAULT '1' ,
  show_cat_descr int(1) NOT NULL DEFAULT '1' ,
  show_cat_header int(1) NOT NULL DEFAULT '0' ,
  show_cat_cols int(2) NOT NULL DEFAULT '1' ,
  show_cat_style varchar(10) NOT NULL DEFAULT 'list' ,
  show_item_valign varchar(10) NOT NULL DEFAULT 'top' ,
  show_item_style varchar(10) NOT NULL DEFAULT 'list' ,
  show_item_cols int(2) NOT NULL DEFAULT '1' ,
  cat_columns int(1) NOT NULL DEFAULT '0' ,
  default_sort_field varchar(50) NOT NULL DEFAULT '' ,
  default_sort_direct varchar(20) NOT NULL DEFAULT '' ,
  link varchar(150) NOT NULL DEFAULT '' ,
  image varchar(150) NOT NULL DEFAULT '' ,
  image_position varchar(10) NOT NULL DEFAULT '' ,
  description text NOT NULL DEFAULT '' ,
  published int(1) NOT NULL DEFAULT '0' ,
  ordering int(10) NOT NULL DEFAULT '0' ,
  access int(3) NOT NULL DEFAULT '0' ,
  count int(10) NOT NULL DEFAULT '0' ,
  params text NOT NULL DEFAULT '' ,
  deleted int(1) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (id)
);


#
# Dumping data for table 'jos_lurm_sections'
#
INSERT INTO jos_lurm_sections VALUES("1","price","Прайс-лист","2","1","","15","0","1","1","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=price","","left","","1","1","0","0","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","0");
INSERT INTO jos_lurm_sections VALUES("2","down","Закачки","1","0","","5","0","1","1","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=down","","left","","1","2","0","0","","0");
INSERT INTO jos_lurm_sections VALUES("3","gallery","Галерея","3","0","","15","0","1","1","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=gallery","","left","","1","3","0","0","","0");
INSERT INTO jos_lurm_sections VALUES("4","content","Статьи","5","1","","20","0","1","0","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=content","topiceditorial.gif","left","","1","4","0","0","","0");
INSERT INTO jos_lurm_sections VALUES("5","links","Ссылки","4","1","","15","0","1","0","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=links","topicgeneral.gif","left","","1","5","0","0","","0");
INSERT INTO jos_lurm_sections VALUES("6","faq","ЧаВО","6","0","","15","0","1","1","0","1","1","0","1","list","top","list","1","0","","","index.php?option=com_lurm&sec=faq","","left","","1","6","0","0","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","0");
INSERT INTO jos_lurm_sections VALUES("12","1","1","0","0","","10","0","1","0","0","0","0","0","0","list","top","list","0","0","","","index.php?option=com_lurm&sec=1","","left","","0","7","0","0","rating=hits[PNL]topto=0[PNL]catid=[PNL]textarea=[PNL]htmlarea=[PNL]","1");

vasya · 22.10.2009 21:30:58

Например, у вас уже может существовать таблица `jos_categories`.

Тогда команда
CREATE TABLE IF NOT EXISTS jos_categories (
оставит старую таблицу и, соответственно, кол-во полей не будет совпадать.

Поищите/поспрашивайте на сайтах поддержки Joomla. Здесь вам, скорее всего, смогут подсказать только то, что касается MySQL, а может в вашем случае просто нужна другая версия модуля.

paulus · 22.10.2009 22:15:57

Неполенился и восстановил этот дамп через клиент mysql, все отработало. Скорее всего,
у Вас в этой базе была какая-то старая джумла, удалите старые таблицы и тогда этот дамп
должен восстановиться нормально. Разумеется, все старые данные при этом Вы потеряете.

kazyuka · 25.10.2009 20:03:29

Здраствуйте paulus

Я попробовал все документы с параметром Repa=, просмотрел и изменял он не находит параметр repa=, может дело не в нём ???

я просто ставил сразу модуль кто онлайн,Топ Кометтаторов, Топ Журналистов, Рейтинг Пользователей,и Репутация пользователей
также не могу забанить пользователя !!!

Отредактированно kazyuka (25.10.2009 20:04:23)

vasya · 25.10.2009 20:32:13

И все-таки прежнее предложение остается в силе. Запрос
UPDATE dle_users set user_group='3', banned='', r_freeze='', icq='', repa=, land='zth', info='ztjhz', signature='', email='SamIgorXXX@mail.ru', fullname='th', time_limit='', xfields='', restricted='0', restricted_days='0', restricted_date='' WHERE user_id='301'
ведь не придумывает сервер MySQL его отправляет один из скриптов вашей CMS.

Вам нужно найти какой скрипт его формирует и определить/исправить почему не происходит присвоения переменной repa.

kazyuka · 25.10.2009 20:50:49

Добрый вечер

при установки модуля Репутация пользователей
Откройте файл engine/ajax/js_edit.js (взять раскодированный файл из папки developer/uncompressed в дестрибутиве "Datalife Engine"):

но у шаблона стаит

В целях увеличения скорости загрузки страницы,
мы используем в движке зашифрованные и сжатые Javascript файлы,
если вы хотите их модифицировать, то используйте несжатые файлы.

у меня вопрос скажите где мне найти несжатые файлы ???
Или как сделать несжатые файлы

Отредактированно kazyuka (25.10.2009 20:51:36)

vasya · 25.10.2009 20:54:13

Ответ на этот вопрос надо искать на форуме поддержки "Datalife Engine" или в гугле. Здесь вам врядли ответят, если только кто-то из форумчан не работал с вашей CMS.

kazyuka · 25.10.2009 20:59:12

спасибо за помощь

blTb · 22.11.2009 19:04:05

Здраствуйте, подскажите пожалуста что нужно сделать?

ошибка

1064 you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the rigth syntax to use near '<Event ID="Medals Event" Active="24 Dec 2005-26 Dec 2020">
<Droplist>
<All' at line 7

сам скрипт
<Event ID="Medals Event" Active="24 Dec 2005-26 Dec 2020">
<Droplist>
<AllDrop Items="6392" Count="3,1" Chance="100%" />
<Droplist>
<AllDrop Items="6393" Count="2,1" Chance="10%" />
<Message Type="OnJoin" Msg="Эвент Glitterin Medals: Собирайте Event Medal, Event Glittering Medal и Обменивайте на ценные призы!" />
<EventEnd>
<Take From="AllPlayers">
<Item ItemID="6392-6393" />
</Take>
</EventEnd>
</Event>

paulus · 23.11.2009 08:41:15

Это не скрипт SQL

blTb · 23.11.2009 19:12:34

Григорийс · 30.11.2009 17:08:38

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

#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 'CREATE TABLE `admins` (
`id` tinyint(4) NOT NULL auto_increment,
`login` t' at line 8

Можете помочь? В чём проблема тут? Если что, могу скинуть сам файл, который хочу импортировать. Спасибо за внимание.

Отредактированно Григорийс (30.11.2009 17:27:16)

Прикрепленные файлы:

dump.sql, Размер: 4,891 байт, Скачано: 1,327

paulus · 02.12.2009 13:52:00

use h2795_lode;

Григорийс · 02.12.2009 15:18:20

Большое спасибо.)

Отредактированно Григорийс (02.12.2009 15:19:13)

Vlad-F · 11.12.2009 07:37:46

Здравствуйте

При добавлении новости скриптом в DLE пишет такую ошибку:

The Error returned was:
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 '-----//-----
-----//-----
-----//-----' at line 1

Error Number:
1064

INSERT INTO dle_post (date, autor, short_story, full_story, xfields, keywords, title, alt_name, allow_comm, approve, allow_main, fixed, allow_rate, allow_br, flag, category) values ('2008-4-13 2:38:31', 'admin', '<h2>-----//-----</h2><img src="/img/1026.jpg">', '<h2>-----//-----</h2><img src="/img/1026.jpg"> <img src="/img/1660.jpg"> <img src="/img/2665.jpg"> 
-----//-----
 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- 
-----//----------//----- ', '', '', '-----//-----', '-----//-----', '1', '1', '1', '0', '0', '1', '1', '0')

-----//----- понимать как текст новости
Не могли бы Вы сказать что это за ошибка и как с ней бороться?

Спасибо

paulus · 11.12.2009 12:26:22

Ну, если бы в запросе были бы -----//-----, то все было бы хорошо, а у вас
там текст с кавычками. Ну и FAQ#10.

kliper · 23.12.2009 07:50:18

Добрый день!
Пишу такой запрос:
SELECT phone FROM new_inf WHERE phone NOT IN (SELECT phone FROM an) AND WHERE phone NOT IN (SELECT phone FROM all_flat)
Получаю код ошибки:
#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 ''new_inf' WHERE 'phone' NOT IN (SELECT 'phone' FROM 'an') LIMIT 0, 30' at line 1
Подскажите, пожалуйста, как поправить запрос, и что я делаю не так? Спасибо

vasya · 23.12.2009 11:51:35

Второе WHERE после AND лишнее.

Форум пользователей MySQL

#76 21.10.2009 07:41:34

Re: Error 1064

#77 22.10.2009 15:44:26

Re: Error 1064

Код:

Код:

#78 22.10.2009 19:25:57

Re: Error 1064

#79 22.10.2009 19:29:08

Re: Error 1064

#80 22.10.2009 19:51:19

Re: Error 1064

#81 22.10.2009 19:57:44

Re: Error 1064

#82 22.10.2009 20:20:40

Re: Error 1064

crazybox написал:

crazybox написал:

crazybox написал:

#83 22.10.2009 21:06:19

Re: Error 1064

Код:

#84 22.10.2009 21:30:58

Re: Error 1064

#85 22.10.2009 22:15:57

Re: Error 1064

#86 25.10.2009 20:03:29

Re: Error 1064

#87 25.10.2009 20:32:13

Re: Error 1064

#88 25.10.2009 20:50:49

Re: Error 1064

#89 25.10.2009 20:54:13

Re: Error 1064

#90 25.10.2009 20:59:12

Re: Error 1064

#91 22.11.2009 19:04:05

Re: Error 1064

#92 23.11.2009 08:41:15

Re: Error 1064

#93 23.11.2009 19:12:34

Re: Error 1064

#94 30.11.2009 17:08:38

Re: Error 1064

#95 02.12.2009 13:52:00

Re: Error 1064

#96 02.12.2009 15:18:20

Re: Error 1064

#97 11.12.2009 07:37:46

Re: Error 1064

#98 11.12.2009 12:26:22

Re: Error 1064

#99 23.12.2009 07:50:18

Re: Error 1064

#100 23.12.2009 11:51:35

Re: Error 1064

Board footer