Database error 1064 while doing query. version 3.2.0

ℹ️ Support
1

I’m getting the following error when trying to add a new list on the “Import Subscribers From CSV File” page.

Database error 1064 while doing query 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
’(names,description,entered,listorder,owner,prefix,active,category)
values(’ at line 2

When I echo the query to the screen it looks like this:

insert into (names,description,entered,listorder,owner,prefix,active,category)
values(“Test Upload”,“Testing upload with attributes”,now(),6,1,"",0,"")

Apparently the table name is missing from the query. I think the lines of code in question are in editlist.php Line: 73 -77

$query = sprintf('insert into %s
  (names,description,entered,listorder,owner,prefix,active,category)
  values("%s","%s",now(),%d,%d,"%s",%d,"%s")',           
  $tables["list"],sql_escape($_POST["listname"]),sql_escape($_POST["description"]),
  $_POST["listorder"],$_POST["owner"],sql_escape($_POST["prefix"]),$_POST["active"],sql_escape($category));

Does anyone have any ideas on how to fix this?

Thanks in advance

2

@xXVGERXx A previous change has broken this.

You can try editing the editlist.php file
change $tables["list"] to $GLOBALS["tables"]["list"] in two places

3

That seems to have done the trick, Thank you very much!