Unable to show list of campaigns - Database error 1064

DR2056 · February 9, 2020, 5:35pm

I’ve just upgraded from 3.2.4 to 3.5.1, it seemed to go okay, subscribers seem to be all there, but when I click Campaigns | List of campaigns I’m getting “Database error 1064 while doing query You have an error in your SQL syntax…at line 1”.

I’ve tried Verify the DB Structure and Rebuild DB Indexes but to no avail.

Any ideas - the thing is unusable at the moment.

Dave

duncanc · February 9, 2020, 8:24pm

@dr2056 does the phplist error message give any more information?

DR2056 · February 9, 2020, 8:58pm

This is all there is on the screen:

duncanc · February 9, 2020, 10:47pm

@DR2056 Did you run the database upgrade step? Also logout or close and reopen your browser in order to clear the php session.

DR2056 · February 10, 2020, 8:30am

Thanks very much Duncan, this morning I switched the computer on and it all seems to be working. I’ve not changed anything, I can only think that logging out or re-opening the browser has fixed it. I’ll try to remember that in future.