CMS Made Simple Forums

Hi,
i have prepared a csv-file to import in LISE.
All Fields are there and recognised by LISE.

When i start the import i get the following error:
Error 1146: Table 'c6glinkpaed.temp_lise_csv_import_data' doesn't exist

It seems the temporary table is not generated, is there a fix for that?

Regards,
Jan

I have come across that once, but can't really remember what it was that triggered it, but let's try to go by exclusion of parts.
- In case those are all new records you are importing, are you removing the item_id from the selected fields to be imported? that may cause an error as that triggers edit for each and every item on the list and they MUST exist with the given item_id. If all are new records to be added exclude the item_id from the selection before importing.

If it still triggers the same error, we'll have to look somewhere else for the cause of the issue.

Thanks Jomorg,

i first tried to import by leaving item_id - No entry (keine Vorgaben) - that did not work
then i removed the item_id from the importfile (csv) that did not work either.

The error i get is:

Error 1146: Table 'c6glinkpaed.temp_lise_csv_import_data' doesn't exist

SQL: SELECT alias,title,url,position,active,start_time,end_time,owner,key1,key2,key3,name,adresse,breitengrad,laengengrad,telefon,fax,kontakt-e-mail,webseite,status,kategorie,hierarchie,details,bild,unternehmenslogo,facharzt,klinik_oder_praxis,adressenzusatz,stadt,postleitzahl,schwerpunkte,mitglied FROM temp_lise_csv_import_data

It seems the table to import the data is not created (?).
Regards,
Jan

Ok what is your mySQL version by the way? It may be related...

an extra question:
if i create this missing table by hand, all textfields" and fill it with INFILE, willl that work?

The Database is Mariadb 10.3.39.
The Version of CMSMS is (stil) 2.2.16
PHP 7.4 is used

We are in the process to upgrade - so all "CG-Modules" will be changed to the newest "non-cg-modules".
Googlemaps is changed to OpenStreetMap.

This LISE-Instance is an old Compagny-Directory, i have made a CSV-File that LISE could handle better then the export from Company-Directory.
Regards,
Jan

Hi,

here is the PHP-error-log (the last lines)
...
[Tue Jul 22 14:20:01.829110 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Notice: ob_flush(): failed to flush buffer. No buffer to flush in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 51', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.829132 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Notice: ob_flush(): failed to flush buffer. No buffer to flush in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 28', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.829146 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Notice: ob_flush(): failed to flush buffer. No buffer to flush in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 51', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.846611 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Notice: ob_flush(): failed to flush buffer. No buffer to flush in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 51', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.846665 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Notice: ob_flush(): failed to flush buffer. No buffer to flush in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 63', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.923304 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Warning: Invalid argument supplied for foreach() in /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php on line 165PHP message: PHP Notice: ob_end_clean(): failed to delete buffer. No buffer to delete in /var/www/clients/client6/web98/paed/modules/LISE/lib/class.LISEInstance.php on line 534', referer: https://paed.gerdalink.top/
[Tue Jul 22 14:20:01.923395 2025] [proxy_fcgi:error] [pid 101485] [client 212.95.5.23:59090] AH01071: Got error 'PHP message: PHP Warning: Cannot modify header information - headers already sent by (output started at /var/www/clients/client6/web98/paed/modules/LISE/framework/action.cvs_import_step_1.php:47) in /var/www/clients/client6/web98/paed/lib/include.php on line 101', referer: https://paed.gerdalink.top/


Regards,
Jan

Sorry, I didn't forget about this, just didn't have time yet to test a theory I have about the possibility that the SQL query may be failing because of some new restriction on the Mariadb version. Will do asap!

Thanks for the reply,

there is no hurry, i have done manual data-entry for this 70 records.

I guess that it needs to be looked at and i will test it with the different servers i run, all with PHP 5.6 to 8.4 - all with mariadb, different versions.
So when you have time please ask me to test, produce logfiles, php-error messages, whatever you need.

i image that a documented test, with not to much fields, and some small CSV-files might help.
The coming week i will produce something.

Regards,
Jan