Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL error when searching for "posts with this ip" #1061

Closed
Starpaul20 opened this issue Jul 27, 2014 · 1 comment · Fixed by #1062
Closed

SQL error when searching for "posts with this ip" #1061

Starpaul20 opened this issue Jul 27, 2014 · 1 comment · Fixed by #1062
Assignees
@Starpaul20
Labels
b:1.8 Branch: 1.8.x s:resolved Status: Resolved. Solution implemented or scheduled t:bug Type: Bug. An issue causing error / flaw / malfunction
Milestone
1.8.0

Comments

@Starpaul20
Copy link
Member

If I go to ModCP - IP Search, enter an IP, tick "Search Posts" and submit the search I get this SQL error:

Quote:1054 - Unknown column 'visibility' in 'where clause'

because a column "visibility" doesn't exits.
In modcp.php line 3580 and 3735 (Beta3) "visibility" has to be changed to "visible".

Original thread: SQL error when searching for "posts with this ip"
@Starpaul20 Starpaul20 added the 1.8 label Jul 27, 2014
@Starpaul20 Starpaul20 added this to the 1.8.0 milestone Jul 27, 2014
@Starpaul20 Starpaul20 self-assigned this Jul 27, 2014
@Starpaul20 Starpaul20 mentioned this issue Jul 27, 2014
Merged
@JN-Jones JN-Jones added fixed and removed confirmed labels Jul 30, 2014
Destroy666x added a commit that referenced this issue Aug 2, 2014
@Destroy666x
Merge pull request #1062 from PaulBender/fix-1061
4466e4d 
Fixes #1061 SQL error when searching for "posts with this ip"
@satdav
Copy link

satdav commented Aug 16, 2014

When will 1.8 be released

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Starpaul20 Starpaul20

Labels
b:1.8 Branch: 1.8.x s:resolved Status: Resolved. Solution implemented or scheduled t:bug Type: Bug. An issue causing error / flaw / malfunction
Projects
None yet
Milestone
1.8.0
Development

Successfully merging a pull request may close this issue.

Fixes #1061 SQL error when searching for "posts with this ip"
4 participants
@satdav @Starpaul20 @JN-Jones @Destroy666x