10 years ago
4
Topic
I have successfully added 5 test entries to the table using the importer tool, the success message comes up to tell me so but when i look at the SQL table just one of the columns ven_address has been added to the intro text instead of its own column. I have checked there are no extra spaces in the column name and even tried moving the position of the column in the csv file but it is always this column that fails. The intro text looks like this ::cck::305::/cck::
::ven_address::Medway Valley Leisure Park::/ven_address::
Can anyone offer any solution or idea of what to try next? Thanks
::ven_address::Medway Valley Leisure Park::/ven_address::
Can anyone offer any solution or idea of what to try next? Thanks
10 years ago
0
Level 1
I have also tried renaming the column in mysql and changing it in the csv file and on first run I get this error
1060 Duplicate column name 'address1' SQL=ALTER IGNORE TABLE gold3n2_cck_store_form_venue ADD address1 TEXT NOT NULL
What is the ignore table? and is that what is causing me problems?
1060 Duplicate column name 'address1' SQL=ALTER IGNORE TABLE gold3n2_cck_store_form_venue ADD address1 TEXT NOT NULL
What is the ignore table? and is that what is causing me problems?
10 years ago
1
Level 1
Hi MarcT,
SQL=ALTER IGNORE TABLE "table" ADD "field" TEXT NOT NULL
Have you find a solution ?
Best Regards
SexyViking
10 years ago
0
Level 2
No, unfortunately not. I gave up and had to do it manually.
85 Posts
10 years ago
0
Level 1
Hi,
There are a mistake in the describe of this add-on.
You will need to naming your columns with the name of your field (for standard storage ie) not the name of the storage field.
Best Regards
Jpeg