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

Greg Thomas







PHP Programmer - interactivetools.com