Wrong value type sent to the database.

[DisturbedGoddess]

Every time some one tries to register at my forums it is giving them this error message

Wrong value type sent to the database. Array of integers expected. (comment_ids)

[mashby]

Any mods installed that would affect registration? Does comment_ids ring a bell with you?

[DisturbedGoddess]

I am not sure there is any thing installed. And no it does now. Whats weird is when i went in to my plug in's it said NOTHING was installed. Some thing or some one installed all of my plugins. Buts only me and 1 other admin. And she wouldnt have a reason to. I just now noticed the two messages about the security updates from 2.0 to 2.0.1 then to 2.0.2. I now have the 2.0.2 installed. I've been trying to reinstall, then uninstall all my plugins to remove any coding. Then go back over one by one to see what it is causing it but so far i havent found any thing.


EDIT***

Btw when trying to install/uninstall most of my plugins give me htis error

Error in Package Installation
At least one error was encountered during a test installation of this package. It is strongly recommended that you do not continue with installation unless you know what you are doing, and have made a backup very recently. This error may be caused by a conflict between the package you're trying to install and another package you have already installed, an error in the package, a package which requires another package that you don't have installed yet, or a package designed for another version of SMF.

[mashby]

What site is this happening on?

[DisturbedGoddess]

Btw i updated my post
Its happening on this site
http://forums.disturbedzone.com/

EDIT***

Btw when trying to install/uninstall most of my plugins give me htis error

Error in Package Installation
At least one error was encountered during a test installation of this package. It is strongly recommended that you do not continue with installation unless you know what you are doing, and have made a backup very recently. This error may be caused by a conflict between the package you're trying to install and another package you have already installed, an error in the package, a package which requires another package that you don't have installed yet, or a package designed for another version of SMF.

[mashby]

See if this helps, specifically:

Seems like if u enable  Verification Questions and don't put a question in and leave the fields blank it causes that error when users try to register on the forums.

http://www.simplemachines.org/community/index.php?topic=352395.0
Topic is a bit old, but could be relevant.

[DisturbedGoddess]

Acutally its doing it on this one too

http://bendraimanstreetteam.fanfusion.org/index.php

And this site too

http://tombraiderlair.fanfusion.org/forums

[DisturbedGoddess]

See if this helps, specifically:

Seems like if u enable  Verification Questions and don't put a question in and leave the fields blank it causes that error when users try to register on the forums.

http://www.simplemachines.org/community/index.php?topic=352395.0
Topic is a bit old, but could be relevant.

Okay ill check it out

[DisturbedGoddess]

OKay i know i had that mod installed at one point. But now its not even showing it in my plugin packages area. I had it when i was on the 1.0 series, then i moved to the 2.0 and had to get rid of alot of my plugins cause they didnt work. I don't know if that was one of the ones i got rid of. Is there a possibility its some thing else?

[Oldiesmann]

Go to Admin -> Maintenance -> Logs.

What file and line is that error being generated from?

[mashby]

Which mod did you have installed? You have mods installed now from what I can tell in your footer as well as your URLs (pretty URLs?) Do you have registration questions established (not a mod)?

[DisturbedGoddess]

Which mod did you have installed? You have mods installed now from what I can tell in your footer as well as your URLs (pretty URLs?) Do you have registration questions established (not a mod)?

But see thats the thing when i go to the packages page. Its saying THEIR NOT installed, but yet the code is. Which is odd. I've tried reinstalling, and it gives me an error like i posted above.

These are all the plugins i have listed on the plugin manager. Only the 2 in bold show that they are installed. The rest show as they are not. But yet some how the code still is. Some thing went wrong all the plugins are uninstalled but the codes were never removed. But i never unistalled them.

Permission for Website Url Of Users

Hide Images from Guests
Referrals System

Remember Position After Login/Logout v1.0.3
'Read the Rules' Link Above Post Button
Simple Audio Video Embedder
Ad Managment
Hide Signatures from Guests
Users Online Today
Spoiler Tag
Pretty URLs
Hide Avatars from Guests
Buddies List
Registered Links
Remove Re From Post Title
MessagePreviewOnHover
Hide User Names from Guests
More Spiders
Separated Birthdays from Events
Board Viewers Mod
Profile Comments
Word Count Limits
Birthday on Profile Summary v2
Personal Twitter on User Profile
Remove Index.Php From URL
Country Flags
New Manual Look
SMF 2.0.2 Update
Auto Refresh Who Index
SimpleColorizer
PM to New Members
Fake Online Time | S-Ace
PM Sent Notification
Bookmarks
SA Affiliates
Social Bookmarks
Top 10 Posters and Topic Starters Stats (Today, Week, Month, and Year)
Activity_Bar
Password Protect Boards
SMF 2.0.1 Update
Simple Audio Video Embedder

[Oldiesmann]

Go to Admin -> Maintenance -> Logs.

What file and line is that error being generated from?

If you answer that question, we can probably figure out what mod is causing this.

[DisturbedGoddess]

Go to Admin -> Maintenance -> Logs.

What file and line is that error being generated from?

If you answer that question, we can probably figure out what mod is causing this.

Oh sorry i must have missed that post my bad

It says its coming from this file
/forums/Sources/Subs-Editor.php

[mashby]

Also, do you have any registration questions established? Based on the link I provided earlier, it could be related to those.

[Oldiesmann]

Go to Admin -> Maintenance -> Logs.

What file and line is that error being generated from?

If you answer that question, we can probably figure out what mod is causing this.

Oh sorry i must have missed that post my bad

It says its coming from this file
/forums/Sources/Subs-Editor.php

That's odd, as that file usually isn't loaded at registration. Can you attach Register.php and Subs-Editor.php?

[DisturbedGoddess]

Sure

[mashby]

OK, please, do you have registration questions? It is apparently related to that.

Code Select Expand

if ($thisVerification['number_questions'])
{
// Get the answers and see if they are all right!
$request = $smcFunc['db_query']('', '
SELECT id_comment, recipient_name AS answer
FROM {db_prefix}log_comments
WHERE comment_type = {string:ver_test}
AND id_comment IN ({array_int:comment_ids})',
array(
'ver_test' => 'ver_test',
'comment_ids' => $_SESSION[$verificationOptions['id'] . '_vv']['q'],
)
);
$incorrectQuestions = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
if (empty($_REQUEST[$verificationOptions['id'] . '_vv']['q'][$row['id_comment']]) || trim($smcFunc['htmlspecialchars'](strtolower($_REQUEST[$verificationOptions['id'] . '_vv']['q'][$row['id_comment']]))) != strtolower($row['answer']))
$incorrectQuestions[] = $row['id_comment'];
}
$smcFunc['db_free_result']($request);

if (!empty($incorrectQuestions))
$verification_errors[] = 'wrong_verification_answer';
}


[DisturbedGoddess]

i know i had it installed but now NO WHERE in my smf admin panel is it showing the settings for it. I don't even remember what questions I was using for it. Would just removing that code fix the issue? And then i can reinstall the plug in later if i need it? Cause the files for the plugin for some reason are not even on my sites server any more.

[mashby]

It's a Core feature, not a mod.
Admin > Configuration > Security and Moderation > Anti-Spam

[DisturbedGoddess]

It's a Core feature, not a mod.
Admin > Configuration > Security and Moderation > Anti-Spam

OHHH DUH!!! Thank you! That fixed it i reentered in the question.

[mashby]

Your other two sites are having the same issue. What exactly did it look like before? The topic I linked to earlier suggested there was a bug report filed, but I cannot access it.
http://dev.simplemachines.org/mantis/view.php?id=4066
Maybe someone will come along and have a looksie.

[DisturbedGoddess]

well all 3 sites were giving the same error message when you went to register. So i fixed the questions on all of the sites. And all of them are working now