Welcome to Geeklog, Anonymous Friday, May 03 2024 @ 11:59 pm EDT

Geeklog Forums

SQL problem

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: Dirk[/u][p][QUOTE][u]Quote by: jerry[/u][p]Sat Mar  3 14:11:04 2007 - 1064: 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 ')' at line 1. SQL in question: SELECT DISTINCT ft_name FROM access,features WHERE ft_id = acc_ft_id AND acc_grp_id IN () [/p][/QUOTE]
The user you are trying to log in as is not a member of any groups. I wish I knew why that is happening for some people ...

Which Geeklog version are you using?

If you have another user with User Admin permissions, you can try logging in as that user and fix the other user. Every user in Geeklog has to be in at least the "Logged-in Users" and "All Users" groups.

If you don't have another Admin account that you can use, follow [url=http://www.geeklog.net/forum/viewtopic.php?showtopic=21017]these instructions[/url] on how to create a new one.

Note: You will probably have to delete the cookies for your site before you attempt any of the above measures. Or use another browser (one you've never used to log into your site before).

bye, Dirk[/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks