Registration not possible!

[oasiscritter]

hey, i have a problem with my board.


I cant register there. If i click on "registration", i get the following error:



I think it´s a database problem.

So have anybody a idea, or can anybody tell me, which database-tables are required for the registration, to check them. I searched but didnt find.




thx

[niko]

Any mods installed?

Also Error Log should have Line and Function.

[oasiscritter]

Only this update is installed:

SMF 1.0.13 / 1.1.5 / 2.0 b3.1 Update


I use SMF 2 beta 3

[H]

Does the problem occur with the default theme?

Please also check the error log as Niko^ suggested as this can often help us solve the problem quickest

[oasiscritter]

Error:

Wrong value type sent to the database. Array of integers expected.
Function: create_control_verification

Line: 1484

Code Select Expand


1464:  }
1465: else
1466: {
1467: // Same questions as before.
1468:  $questionIDs = !empty($_SESSION[$verificationOptions['id'] . '_vv']['q']) ? $_SESSION[$verificationOptions['id'] . '_vv']['q'] : array();
1469: $thisVerification['text_value'] = !empty($_REQUEST[$verificationOptions['id'] . '_vv']['code']) ? $smcFunc['htmlspecialchars']($_REQUEST[$verificationOptions['id'] . '_vv']['code']) : '';
1470: }
1471:
1472: // Have we got some questions to load?
1473: if (!empty($questionIDs))
1474: {
1475: $request = $smcFunc['db_query']('', '
1476: SELECT id_comment, body AS question
1477: FROM {db_prefix}log_comments
1478: WHERE comment_type = {string:ver_test}
1479: AND id_comment IN ({array_int:comment_ids})',
1480: array(
1481: 'ver_test' => 'ver_test',
1482: 'comment_ids' => $questionIDs,
1483: )
==>1484: );
1485: $_SESSION[$verificationOptions['id'] . '_vv']['q'] = array();
1486: while ($row = $smcFunc['db_fetch_assoc']($request))
1487: {
1488: $thisVerification['questions'][] = array(
1489: 'id' => $row['id_comment'],
1490: 'q' => parse_bbc($row['question']),
1491: 'is_error' => !empty($incorrectQuestions) && in_array($row['id_comment'], $incorrectQuestions),
1492: // Remember a previous submission?
1493: 'a' => isset($_REQUEST[$verificationOptions['id'] . '_vv'], $_REQUEST[$verificationOptions['id'] . '_vv']['q'], $_REQUEST[$verificationOptions['id'] . '_vv']['q'][$row['id_comment']]) ? $smcFunc['htmlspecialchars']($_REQUEST[$verificationOptions['id'] . '_vv']['q'][$row['id_comment']]) : '',

1494: );
1495: $_SESSION[$verificationOptions['id'] . '_vv']['q'][] = $row['id_comment'];
1496: }
1497:           $smcFunc['db_free_result']($request);
1498:      }
1499: 
1500: $_SESSION[$verificationOptions['id'] . '_vv']['count'] = empty($_SESSION[$verificationOptions['id'] . '_vv']['count']) ? 1 : $_SESSION[$verificationOptions['id'] . '_vv']['count'] + 1;
1501:
1502: // Return errors if we have them.
1503: if (!empty($verification_errors))
1504: return $verification_errors;



I hope it can help you to help me

[oasiscritter]

I need help pls, have nobody a idea?

[青山 素子]

Have you tried this?

Does the problem occur with the default theme?

[oasiscritter]

yes, the same message appear.

[H]

As you have no mods installed you can try uploading clean files to the Sources/ and Themes/ directories from an install archive

[oasiscritter]

As you have no mods installed you can try uploading clean files to the Sources/ and Themes/ directories from an install archive

Sry but i dont understand, can you pls explain me that?




thx

[SwapsRulez]

Download the SMF 2.0 Beta 3 Package. Extract it to a folder. Upload all the files and folders from Sources & Themes directories to your ftp replacing your old files. This will make your board to have clean files from the source without any errors.

H wants to say this. If you need any more help to describe in more details, ask here.

[oasiscritter]

ok, but as i said i have the update beta3.1 instaled. Should i upload the files from the new full installation-package which is 3.1 including or the old beta3, from what i installed my board?



thx

[H]

Just the Sources/ and Themes/ files from the 3.1 install archive

[oasiscritter]

I did it but i get the same error as before, equal what theme i use.



The only explanation is that the problem is in the database. I think the forum was previously in a other directory but I did it to another folder and have changed the links in the database. Could it be that I've forgotten change a link? I am also not sure whether I do it with this board or with my previous one.




MfG

[SwapsRulez]

Which links you've changed in your database ? Have you moved your forum from one directory to another directory ? Have you applied repair_settings.php after moving your forum ?

AFAIK, the forum path is stored in the settings.php and not in the database.

Also, have your installed pretty URL's ?

[oasiscritter]

1. I changed in :

smf_settings:
	attachmentUploadDir
	smileys_dir
	smileys_url
	avatar_directory
	avatar_url
	avatar_url

2. Yes, i think so

3. I cant find the file "repair_settings.php"

4. What do you mean with "pretty Url´s"?

Sorry im from Germany and I cant understand the colloquial language^^


thx for your help

[青山 素子]

3. I cant find the file "repair_settings.php"

It's on this site, under the downloads area in the tools section. It doesn't come with SMF directly. This script is made to ensure all the important settings get changed.

4. What do you mean with "pretty Url´s"?

It's the name of a modification for SMF. If you were using it, you would probably recognize the name.

[oasiscritter]

ok, i used the repair_setting.php and used always the recommended options, but i also not work =(

and i dont have installed "pretty_urls", should I?



thx

[oasiscritter]

I installed the forum new, but on the same DB, so i used the old tables but that havent any effekt =(

[Rumbaar]

The current public Repair Settings tool is only for 1.1.x.

Try the file I've attached in this thread:
Moving smf2.x between servers (localhost - domain)

[oasiscritter]

hmm, your tool dind´t work, but...

1. i installed the board comlete new and everything work fine now.

2. I need to copy only some tables of my old forum to my new one. But i cant find the content of my old topics. The Board shows only that there was any topics, if i enter i cant find them. What table includes the content of the topics?
And what sense have the table "sessions"?

3. The following tables im unsure to copy:

themes
settings
session
scheduled_tasks

4. How can i copy and rename some tables to make a live-backup of them?

Im very near to handle this, i need help pls


thx

[oasiscritter]

I can enter registration now,  only the images dont was shown. I mean the images which you have to enter to comlete the registartion.

Type the letters shown in the picture

[Rumbaar]

When you say you installed again completely from fresh did the registration work then correctly on a blank install?

[oasiscritter]

When you say you installed again completely from fresh did the registration work then correctly on a blank install?

Well, i dont tested it, i have to install it again to test this, because i deleted replaced some tables of the new forum. But i havent replaced a table, which you can say that this have any effekt about the registration images. Can you tell me pls, where the images are saved on the webspace, or are they read from "simplemachines"?. Im very noob on this thing.


thx

[Rumbaar]

I'm not sure what you mean be replaced a table, if you've mixed and matched table from different databases then you can/will run into issues.

All images are stored locally.  The registration image is generated on the fly based on random letters, background image and fonts stored in your default theme folder.  Index.{language}.php has a baring on it's generation as well.

[oasiscritter]

I made the following things:

1.
I had the old tables from my old forum, which was full of topics and posts.
And i had the new one, which was empty.

2.
Now i deleted for example the "boards-table" from the empty forum and renamed the "boards-table" from the old forum in the new ones name!

3.
I made this with every table i needed, only settings, sessions and themes i was unsure.

4.
Now the new Forum was filled, and like my old one, also i can enter registration now, which i cant before. Only the reg-images are empty

thx

[Rumbaar]

Well it would have been to import the whole 'old' db, than work with limited tables from the old one.  But if it's worked for you, then that's great.

As for images you might have to run repair_settings.php to make sure all paths are correct.  Or check to make sure the images are actually on your server.  What happens when you try to access them directly, or right-click and choose properties for their path.

[oasiscritter]

Or check to make sure the images are actually on your server.  What happens when you try to access them directly, or right-click and choose properties for their path.

Yes i would Check this, but i dont know their Path

The registration image is generated on the fly based on random letters

I understood it, but where are the images stored?


OMG, it work on the default theme only the "su-theme" isnt working. But i can remember that it worked with it, too. Do you have any idea?


thx

[Rumbaar]

Is that theme fully compatible with SMF 2.x series?

[oasiscritter]

I think yes, here is it:

http://www.simplemachines.org/community/index.php?topic=230893.0



MfG

[Rumbaar]

Okay have you made any changes to the templates?  Or if installed certain mods, have you made the manual changes to that theme to make sure it's got all required code.

But 'we' are not sure if it ever worked?  But the fact the default works, indicates and issue somewhere with the theme.  Does it work in other themes (Babylon)?

[oasiscritter]

Okay have you made any changes to the templates?  Or if installed certain mods, have you made the manual changes to that theme to make sure it's got all required code.

But 'we' are not sure if it ever worked?  But the fact the default works, indicates and issue somewhere with the theme.  Does it work in other themes (Babylon)?

Yes it works in all standard-themes:

default
classic
babylon

And i havent any mod installed.

[oasiscritter]

Now i know what the problem was. The "settings-table" was the problem, if i replace it, i get the same error as before.

Could i delete another "Admin-Account" just from the database, because during the forum it´s not allowed?

Another problem is that, the old topics are always shown as new topics, equal if i enter them or not. So i forgot to replace the table which include this option and i dont know what table it is.


thx

[Rumbaar]

Well you can try deleting that theme and re-installing it?

I don't understand what you mean or trying to do by wanting to delete an Admin account?  That wont affect settings.

[oasiscritter]

Well you can try deleting that theme and re-installing it?

I don't understand what you mean or trying to do by wanting to delete an Admin account?  That wont affect settings.

I reinstalled it, but it dont work, i use classic now, it´s good aswell.

The Administration-Account is another question incidentally, in another contex.


thx

[Rumbaar]

Well it looks like an issue with that theme then, and I'd take it up with the author or try the support/comment thread.  Other might having similar issue and/or have solutions.

You don't have to delete Admin accounts, just take away Admin membergroup and they'll be normal users.

Now the nature of how you've done the mixing and merging of two databases I'm not sure what to suggest.

[oasiscritter]

Well, it works fine now, only the language settings of the board will reset every login, but thx for your help. I made this because i had to do this. Before that i installed the forum a few times and filled it with every topics and settings. Then i got every time another problem with the board. And so i reinstalled and fullfilled it with everything, so i got crazy. Now i am a bit wiser than before. I know now that i had only to replace the settings-table^^. And i know more now about the working between the Board and the database.

thx

[Rumbaar]

Well if the language 'resets' each login, you need to change that in the accounts language settings.  Probably doesn't mate the forum wide language settings.  Or just disable everyone's ability to set their own language will fix it as well.

[oasiscritter]

thx, in my profile the setting was "english"^^

[Rumbaar]

Do you have English and English-utf8 installed?  But did that fix your issue?

[oasiscritter]

yes, i changed the setting.




thx