Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: oasiscritter on August 07, 2008, 02:53:44 PM

Title: Registration not possible!
Post by: oasiscritter on August 07, 2008, 02:53:44 PM
hey, i have a problem with my board.


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

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.imgimg.de%2Fuploads%2Freg9360329bJPG.jpg&hash=0e147e40ce4908aa4b3e9ca4029fab45)

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
Title: Re: Registration not possible!
Post by: niko on August 07, 2008, 03:00:47 PM
Any mods installed?

Also Error Log should have Line and Function.
Title: Re: Registration not possible!
Post by: oasiscritter on August 08, 2008, 09:16:42 AM
Only this update is installed:

SMF 1.0.13 / 1.1.5 / 2.0 b3.1 Update


I use SMF 2 beta 3


Title: Re: Registration not possible!
Post by: H on August 08, 2008, 03:29:59 PM
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 :)
Title: Re: Registration not possible!
Post by: oasiscritter on August 11, 2008, 01:30:19 PM
Error:
Quote
Wrong value type sent to the database. Array of integers expected.
Function: create_control_verification

Line: 1484


Code: [Select]
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 ;)
Title: Re: Registration not possible!
Post by: oasiscritter on August 15, 2008, 10:24:02 AM
I need help pls, have nobody a idea?
Title: Re: Registration not possible!
Post by: 青山 素子 on August 16, 2008, 02:12:11 PM
Have you tried this?

Does the problem occur with the default theme?
Title: Re: Registration not possible!
Post by: oasiscritter on August 17, 2008, 06:05:44 AM
yes, the same message appear.
Title: Re: Registration not possible!
Post by: H on August 17, 2008, 06:58:03 AM
As you have no mods installed you can try uploading clean files to the Sources/ and Themes/ directories from an install archive :)
Title: Re: Registration not possible!
Post by: oasiscritter on August 17, 2008, 01:00:29 PM
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
Title: Re: Registration not possible!
Post by: SwapsRulez on August 17, 2008, 02:09:07 PM
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. :)
Title: Re: Registration not possible!
Post by: oasiscritter on August 18, 2008, 12:35:18 PM
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
Title: Re: Registration not possible!
Post by: H on August 18, 2008, 01:32:03 PM
Just the Sources/ and Themes/ files from the 3.1 install archive :)
Title: Re: Registration not possible!
Post by: oasiscritter on August 18, 2008, 01:57:48 PM
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

Title: Re: Registration not possible!
Post by: SwapsRulez on August 19, 2008, 12:33:47 AM
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 ?
Title: Re: Registration not possible!
Post by: oasiscritter on August 19, 2008, 10:57:00 AM
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
Title: Re: Registration not possible!
Post by: 青山 素子 on August 19, 2008, 11:11:35 AM
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.
Title: Re: Registration not possible!
Post by: oasiscritter on August 19, 2008, 12:37:26 PM
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
Title: Re: Registration not possible!
Post by: oasiscritter on August 23, 2008, 12:23:31 PM
I installed the forum new, but on the same DB, so i used the old tables but that havent any effekt =(
Title: Re: Registration not possible!
Post by: Rumbaar on September 04, 2008, 05:55:31 PM
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) (http://www.simplemachines.org/community/index.php?topic=240779.0)
Title: Re: Registration not possible!
Post by: oasiscritter on September 05, 2008, 10:09:28 AM
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:
Quote
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
Title: Re: Registration not possible!
Post by: oasiscritter on September 05, 2008, 02:05:04 PM
I can enter registration now,  only the images dont was shown. I mean the images which you have to enter to comlete the registartion.

Quote
Type the letters shown in the picture
Title: Re: Registration not possible!
Post by: Rumbaar on September 05, 2008, 06:00:39 PM
When you say you installed again completely from fresh did the registration work then correctly on a blank install?
Title: Re: Registration not possible!
Post by: oasiscritter on September 06, 2008, 05:33:42 AM
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 06, 2008, 05:52:19 AM
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.
Title: Re: Registration not possible!
Post by: oasiscritter on September 06, 2008, 02:53:52 PM
I made the following things:

Quote
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.

Quote
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!

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

Quote
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 06, 2008, 09:19:53 PM
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 (http://docs.simplemachines.org/index.php?topic=663) 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.
Title: Re: Registration not possible!
Post by: oasiscritter on September 07, 2008, 07:58:27 AM
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
Quote
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 07, 2008, 08:45:25 AM
Is that theme fully compatible with SMF 2.x series?
Title: Re: Registration not possible!
Post by: oasiscritter on September 07, 2008, 09:12:16 AM
I think yes, here is it:

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



MfG
Title: Re: Registration not possible!
Post by: Rumbaar on September 07, 2008, 06:11:55 PM
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)?
Title: Re: Registration not possible!
Post by: oasiscritter on September 08, 2008, 07:57:38 AM
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:
Quote
default
classic
babylon

And i havent any mod installed.
Title: Re: Registration not possible!
Post by: oasiscritter on September 08, 2008, 08:44:25 AM
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 08, 2008, 08:54:50 AM
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.
Title: Re: Registration not possible!
Post by: oasiscritter on September 08, 2008, 03:38:20 PM
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 08, 2008, 05:51:27 PM
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.
Title: Re: Registration not possible!
Post by: oasiscritter on September 09, 2008, 01:56:00 PM
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
Title: Re: Registration not possible!
Post by: Rumbaar on September 09, 2008, 06:13:55 PM
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.
Title: Re: Registration not possible!
Post by: oasiscritter on September 10, 2008, 01:33:09 PM
thx, in my profile the setting was "english"^^



Title: Re: Registration not possible!
Post by: Rumbaar on September 10, 2008, 07:45:31 PM
Do you have English and English-utf8 installed?  But did that fix your issue?
Title: Re: Registration not possible!
Post by: oasiscritter on September 11, 2008, 07:37:33 AM
yes, i changed the setting.




thx