Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » mysql error: You have an error in your SQL syntax
 
Thread actions
PDF Print this page
  • Print all pages

    • mysql error: You have an error in your SQL syntax

    Posted by mcp posts: 3

    Hi everyone.

    I have a TikiWiki installation with the following version numbers:

    TikiWiki - 1.8
    PHP - 4.3.3
    MySQL - 4.0.18-standard

    Everything looked good until I tried to add some users. I turned off access without registration. The users that are members of the registered group can't log in at all. They just get redirected to the login page.

    When I allow people to come in without registration the users can properly log in again. This is unfortunately not acceptible because we need to have the wiki site secured for only appropriate people.

    I also tried logging into TikiWiki as admin (which works) and then switching to another user that was previously created.

    When I do I get the following message:

    Warning: mysql error: 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 in query:
    select `email` from `users_users` where binary `login` = ?
    in /xxxxxxxxx/xxxxxxx/xxxxxx/lib/tikidblib.php on line 125
    Values:
    Array ( 0 => )
    $result is false
    $result is empty

    Any thoughts on why? Or if I can tweak something to make it work?

    Thanks.

    mcp

    Reads: 1219
    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    Which version of 1.8 are you using?

    Login names are case-sensative so maybe thats stopping them, also have you setup the appropriate permissions for the registered group in Admin->Groups

    Damian

    Link
    Posted by mcp posts: 3

    > Which version of 1.8 are you using?

    It just says "1.8 -Polaris-" at the top of the wiki.

    Is there a page I can get a more specific version number?

    > Login names are case-sensative so maybe thats stopping them, also have you setup the appropriate permissions for the registered group in Admin->Groups

    I have verified the case of the users and they still can't get it (all lower case is what I was using to test).

    All of the users were in the registered group which should have access to the site (especially with the "registered users only" set).

    I think that there is something wrong with the installation or php settings due to the MySQL error coming up. Does anyone know why it would be happening?

    Thanks.

    mcp

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > mcp:
    > > Which version of 1.8 are you using?
    >
    > It just says "1.8 -Polaris-" at the top of the wiki.
    >

    Well firstly upgrade! 1.8.3 is the latest release with a LOAD of bugfixes see ReleaseProcess181 ReleaseProcess182 and ReleaseProcess183 for the lists.

    Damian

    Link
    Posted by mcp posts: 3

    I'll see what I can do about upgrading. It is the package that was supported by my hosting solution.

    Is there anyone that can provide some guidance if I can't get the new version installed?

    Thanks!

    mcp

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > mcp:
    > I'll see what I can do about upgrading. It is the package that was supported by my hosting solution.
    >
    > Is there anyone that can provide some guidance if I can't get the new version installed?
    >
    > Thanks!
    >
    > mcp

    You will want to upgrade to 1.8.2 or later anyway, as that version fixed some major security issues, that could kill your site and also compromise the server your running on.

    Damian

    Link

    Posted by mcp posts: 3

    > Which version of 1.8 are you using?

    It just says "1.8 -Polaris-" at the top of the wiki.

    Is there a page I can get a more specific version number?

    > Login names are case-sensative so maybe thats stopping them, also have you setup the appropriate permissions for the registered group in Admin->Groups

    I have verified the case of the users and they still can't get it (all lower case is what I was using to test).

    All of the users were in the registered group which should have access to the site (especially with the "registered users only" set).

    I think that there is something wrong with the installation or php settings due to the MySQL error coming up. Does anyone know why it would be happening?

    Thanks.

    mcp

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > mcp:
    > > Which version of 1.8 are you using?
    >
    > It just says "1.8 -Polaris-" at the top of the wiki.
    >

    Well firstly upgrade! 1.8.3 is the latest release with a LOAD of bugfixes see ReleaseProcess181 ReleaseProcess182 and ReleaseProcess183 for the lists.

    Damian

    Link
    Posted by mcp posts: 3

    I'll see what I can do about upgrading. It is the package that was supported by my hosting solution.

    Is there anyone that can provide some guidance if I can't get the new version installed?

    Thanks!

    mcp

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > mcp:
    > I'll see what I can do about upgrading. It is the package that was supported by my hosting solution.
    >
    > Is there anyone that can provide some guidance if I can't get the new version installed?
    >
    > Thanks!
    >
    > mcp

    You will want to upgrade to 1.8.2 or later anyway, as that version fixed some major security issues, that could kill your site and also compromise the server your running on.

    Damian

    Link