After considering different alternatives, I selected FUDForum 3.0 for my site because you support SQLite. Because this approach is memory friendly for hosting this small forum on a VPS and doesn't force me to run a standalone process for the database.
However, I am getting SQL errors when users log in or register (and possibly elsewhere too, but I haven't tested that yet). Here is the error message:
| Quote: | Server Version: 3.6.10<br />
[Referring Page] [removed]/index.php?t=register&rid=0&S=[removed]&re g_coppa=0 <br />
?3002 ?1255535142?(/srv/www/[removed]/html/index.php:106<br />
/srv/www/[removed]/html/index.php:175<br />
/srv/www/[removed]/html/theme/default/register.php:263<br />
/srv/www/[removed]/html/theme/default/register.php:2190<br />
/srv/www/[removed]/html/index.php:1223<br />
) near ",": syntax error: HY000<br />
Query: INSERT INTO
fud30_users (
login,
alias,
passwd,
name,
email,
icq,
aim,
yahoo,
msnm,
jabber,
affero,
google,
skype,
twitter,
posts_ppg,
time_zone,
bday,
last_visit,
conf_key,
user_image,
join_date,
location,
theme,
occupation,
interests,
referer_id,
last_read,
sig,
home_page,
bio,
users_opt,
reg_ip,
topics_per_page,
flag_cc,
flag_country
) VALUES (
'[removed]',
'[removed]',
'[removed]',
'[removed]',
'[removed]',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
0,
'Europe/Paris',
00000000,
1255535142,
'[removed]',
NULL,
1255535142,
'[removed]',
1,
'Self Employed',
NULL,
0,
1255535142,
NULL,
NULL,
NULL,
4226550,
,
40,
NULL,
NULL
)
<br />
|
It seems to me that comma with the empty value in "[...] 4226550, , 40 [...]" is to blame. The value that is supposed to be there is:
| Quote: | ".ip2long($reg_ip).",
|
but seems the result of the ip2long() function seems to be empty. I think, but haven't verified, that MySQL and PostgreSQL are probably more permissive with empty values than SQLite which is why this error hasn't popped up because I'm not sure if many people are using SQLite with FUDForum yet.
I have tried to fix this by adding quotes around the output of that function call, but this fix is only temporary as the templates keep getting overwritten somehow. I would be most obliged if someone could point me to the location of the files where I can permanently modify these templates (as the same problem is cropping up in some other places too) so I can fix this and supply a patch.
|
Calendar
Search
Help
Members
Register
Login
Home
]