Can't open amended table

muzza4's profile image muzza4 posted 18 years ago in General Permalink
Hi all,

New member here.

I get the message SQL Error: Unknown column 'seasonStart' in 'where clause' when I select the Data tab for the club table.

According to the SQLlog HeidiSQL is running this query ...

SELECT * FROM `club` WHERE Id LIKE '%d14%' <snip> OR seasonStart LIKE '%d14%' <snip>

How do I clear this query so that I can look at this table once again under the Data tab.

By the way, I like HeidiSQL, but it has a number of irritating issues, is a new release planned shortly?

Regards
Muzza
ansgar's profile image ansgar posted 18 years ago Permalink

I get the message SQL Error: Unknown column 'seasonStart' in 'where clause' when I select the Data tab for the club table.



This bug should be fixed and gets included in the next release. And it was posted here as a bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1578471&group_id=164593&atid=832347

By the way, I like HeidiSQL, but it has a number of irritating issues, is a new release planned shortly?



Yes... we are on the way to plan the next release which will come shortly.
muzza4's profile image muzza4 posted 18 years ago Permalink
I searched the registry for "seasonstart" and deleted the 2 entries I found (2 because I have a test database and a live database).

Woohoo.

Thanks

Please login to leave a reply, or register at first.