Imported new table in CSV format into database... error
3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 22, 2013 (RSS)
By dnevels - May 21, 2013
I imported some data as a table into the database. I tried to match all of the columns with the columns in admin. I got this error:
MySQL Error: 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 ',,,,,,,,,,,,,,,,,,,,,,,) ORDER BY `order`, num' at line 3 (at old_alias_functions.php line 142 in function mysql_select_query)
Can anyone help me with what I need to do?
By gregThomas - May 22, 2013
Hi,
Where are you getting this error, is it in the front end of the site or when you edit the section? Does the section that you imported the data into have any list fields which are connected to other sections using this method:
http://www.interactivetools.com/kb/article.php?Populate-a-list-field-from-another-section-15
Thanks!
Greg
PHP Programmer - interactivetools.com
By dnevels - May 22, 2013
Thanks for replying Greg! I have gotten the problem fixed. I purchased the CSV import Add On and after consulting with the folks in the office, I removed/renamed columns that were named reserved names.