CMS Made Simple Forums

Hi

I'm trying to import data from a csv into a LISE instance but something seem not working.

The import finish without errors but nothing appears in the item list...

Digging in the DB i noticed that the table cms_module_liseinstance_fieldval contains data BUT the table cms_module_liseinstance_item was empty...

I've tried with a csv exported from an old listit2 instance, and one from the same LISE instance, same behaviour.

I'm doing something wrong?

Thank you for your help

.nicola


----------------------------------------------

Cms Version: 2.1.3

Installed Modules:

AceEditor2: 1.05
AdminSearch: 1.0.1
CGExtensions: 1.52.2
CGSimpleSmarty: 2.0.5
CGUserDirectory: 1.5
CMSContentManager: 1.1
CMSMailer: 6.2.14
CustomGS: 2.2
DesignManager: 1.1.1
ECB2: 1.1
FileManager: 1.5.2
FormBuilder: 0.8.1.3
FrontEndUsers: 1.31.1
JMFilePicker: 1.0
LISE: 1.2.1.1
LISEgestionesoci: 1.2.1.1
MicroTiny: 2.0.3
ModuleManager: 2.0.2
Navigator: 1.0.3
News: 2.50.5
Search: 1.50.2
SelfRegistration: 1.9.6


Config Information:

php_memory_limit:
max_upload_size: 128000000
url_rewriting: none
page_extension:
query_var: pagina
auto_alias_content: true
locale:
set_names: true
timezone: Europe/Rome
permissive_smarty: false


Php Information:

phpversion: 5.6.15
md5_function: On (Vero)
json_function: On (Vero)
gd_version: 2
tempnam_function: On (Vero)
magic_quotes_runtime: Off (Falso)
E_ALL: 1
E_STRICT: 0
E_DEPRECATED: 0
test_file_timedifference: Nessuna differenza di tempo trovata
test_db_timedifference: Nessuna differenza di tempo trovata
create_dir_and_file: 1
memory_limit: 70M
max_execution_time: 240
register_globals: Off (Falso)
output_buffering: On
disable_functions: show_source, system, shell_exec, passthru, exec, popen, proc_open
open_basedir: /***/***/****/******/:/tmp:/var/lib/php/session
test_remote_url: Successo
file_uploads: On (Vero)
post_max_size: 128M
upload_max_filesize: 128M
session_save_path: Nessun controllo perchè open basedir è attivo
session_use_cookies: On (Vero)
xml_function: On (Vero)
xmlreader_class: On (Vero)
check_ini_set: On (Vero)
curl: On


Performance Information:

allow_browser_cache: Off (Falso)
browser_cache_expiry: 60
php_opcache: On (Vero)
smarty_cache: Off (Falso)
smarty_compilecheck: Off (Falso)
smarty_cache_udt: Off (Falso)
auto_clear_cache_age: On (Vero)

Server Information:

Server Software: Apache
Server Api: cgi-fcgi
Server Os: Linux 2.6.32-504.8.1.el6.x86_64 On x86_64
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.47
Server Db Grants: Ho trovato una dichiarazione "GRANT ALL" che sembra essere adatta


Permission Information:

tmp: /***/***/****/******/httpdocs/tmp (0755)
tmp_cache: /***/***/****/******/httpdocs/tmp/cache (0755)
templates_c: /***/***/****/******/httpdocs/tmp/templates_c (0755)
modules: /***/***/****/******/httpdocs/modules (0755)
uploads: /***/***/****/******/httpdocs/uploads (0755)
Maschera di creazione file (umask): /***/***/****/******/httpdocs/tmp/cache (0755)
config_file: 0444

----------------------------------------------

I need more details on every step you are taking to do the import.
For instance you should not set the item_id correspondence unless you are changing existing records. Are there any errors on the php error log?...

nikkio wrote:Digging in the DB i noticed that the table cms_module_liseinstance_fieldval contains data BUT the table cms_module_liseinstance_item was empty...

AFAIK that is unusual behavior... you need to dig in to the error logs and see if there is any clue about that.

Hi Jo Morg,


First I've added some records in the instance, then exported a csv file, deleted the records and imported again... nothing appears in the list.

So I've noticed the behaviour described before...

I've no entry in the error_log.

any ideas?

I've enabled "developer mode" in my PHP error log setting but still nothing appear in the log, the import return no entry in the item list...

Jo Morg wrote:For instance you should not set the item_id correspondence unless you are changing existing records

Did you? or did you not?...

Pardon... i've deselected the item_id and it works....

sorry for the misunderstanding...

.nicola