Skip to main content
Topic: Guest cannot register (Read 2312 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Guest cannot register

Hi, anyone can help me? Using Elk 1.1

When trying to register or opening existing member profile it will failed:
Code: [Select]
    Type of error: Database
    Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows, cols
    FROM elk_custom_fields
    WHERE active = 1 AND show_reg != 0
    OR' at line 3
what should i do to fix it?
192.MY.ID: Forum ISP Indonesia.

Re: Guest cannot register

Reply #1

I think the query is the one in Profile.subs.php at line 185.
Would you mind either put here the query or attach the whole file?
Bugs creator.
Features destroyer.
Template killer.

Re: Guest cannot register

Reply #2

I wonder if its due to MariaDB and the use of the column name "rows"

Re: Guest cannot register

Reply #3

thanks. attached the file.

my setup for this forum:
    256 MB NAT VPS (only using IPv6, no IPv4)
    Ubuntu 14.04
    Hiawatha Web Server 10.6
    PHP 7.0.23
    MariaDB 10.2.8

-

maybe not related. after recognizing a problem with the forum. i checked the admin and see the addons (i want to disable all first for troubleshooting). but on package>browse / installed. it says that none of my addons installed.  and i don't know why all saying [emulating 1.0].


Re: Guest cannot register

Reply #4

Yep, looks like Spuds idea is the right one.
@kucing would you mind trying to replace:
Code: [Select]
, rows, cols
with:
Code: [Select]
, "rows", cols
in both Profile.subs.php and ManageFeatures.subs.php?
Bugs creator.
Features destroyer.
Template killer.

Re: Guest cannot register

Reply #5

thanks! fixed.
192.MY.ID: Forum ISP Indonesia.

Re: Guest cannot register

Reply #6

add to 1.1.1 as well ?

Re: Guest cannot register

Reply #7

Yep, the report is for 1.1, I'm not sure if it affects 1.0 as well.
Bugs creator.
Features destroyer.
Template killer.

Re: Guest cannot register

Reply #8

I think MySQL needs to be in ANSI mode. Haven't checked for sure, though.
LiveGallery - Simple gallery addon for ElkArte

Re: Guest cannot register

Reply #9

Seems like that @live627 I'd go with the fully qualified, that should make everyone happy, YAY! :D (Hopefully :P)
Bugs creator.
Features destroyer.
Template killer.