I'm sorry if this has been posted before.. but the search was disabled and I couldn't find anything for it. I get the following errors whenever someone registers for an account on my site. Any idea what could be wrong with it?
I'm using: Joomla 1.0.8, SMF 1.1RC2, and the bridge from Orstio (1.1.3).
2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
File: /xxx/components/com_smf/smf.php
Line: 941
2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
File: /xxx/components/com_smf/smf.php
Line: 929
8: Undefined index: memberName
File: /xxx/components/com_smf/smf.php
Line: 927
8: Undefined index: emailAddress
File: /xxx/components/com_smf/smf.php
Line: 922
8: Undefined index: memberName
File: /xxx/components/com_smf/smf.php
Line: 922
8: Undefined index: memberName
File: /xxx/components/com_smf/smf.php
Line: 917
Does your SMF database user have access to your Joomla database?
yes, it does. joomla & smf are installed on the same database
Just FYI - it left the same errors when you registered on the site. I have them in a word document if you want me to send them to you for some reason.
Try an experiment?
In the integrate_register function in smf.php, can you change every $Options to $r_Options ?
done. sorry about the delay
i had a chance to test it out as well.. a new user registered. it did not fix anything, and added the following error as well:
8: Undefined variable: Options
File: /xxx/components/com_smf/smf.php
Line: 917
If it comes down to it, I can use bridged registration and not worry about it.. but I would prefer the SMF one since its easier to customize. If you'd like, I can download ICQ so we can work it out in real time -- just let me know. I really appreciate it, Orstio :)
Quote8: Undefined variable: Options
File: /xxx/components/com_smf/smf.php
Line: 917
How are you getting that if you have changed every $Options to $r_Options?
Quote from: Orstio on April 13, 2006, 12:08:31 AM
Quote8: Undefined variable: Options
File: /xxx/components/com_smf/smf.php
Line: 917
How are you getting that if you have changed every $Options to $r_Options?
I looked over it again.. and I had missed one :(. Sorry about that :P I'll register a new user right now to see if the error occurs again
okay, I just registered another user and I still get the same errors (except for the Options one)
Hi I'm getting a similar error to paki.
http://www.simplemachines.org/community/index.php?topic=81676.msg543569#msg543569 (http://www.simplemachines.org/community/index.php?topic=81676.msg543569#msg543569)
I don't know if they are related but if it helps figure out the problem for both of us I'll describe my situation. I was trying to get the mod Custom Profile working. I have Joomla 1.0.8 + SMF 1.1RC2 with bridge 1.1.3 . With it set to use bridge registration the custom fields were not appearing. If I set it to use SMF registration then the custom fields appeared on the registration form. When someone registered though I got this error.
Quote8: Undefined index: memberName
File: /home/xxx/public_html/joomla/components/com_smf/smf.php
Line: 917
This is line 917
Quote$Options['realName'] = $Options['memberName'];
which is part of this
Quote//What if the realName field isn't being used?
if (!isset($Options['realName']) || $Options['realName']=='')
$Options['realName'] = $Options['memberName'];
The maker of the Custom Profile mod just released a 2.11 version but it didn't change anything for me.
The custom profile mod is just for SMF.. if you want it on bridge registration as well you have to edit the file for that. I think its called smf_registration.html.php, and it would be located in the components/com_smf_registration folder in your Joomla directory
Orstio, in which file is integrate_register called? I get the feeling that the arrays aren't matching up correctly. The field "passwrd1" is passing through correctly, but the other two aren't. Discrepency in field names, maybe?
Quote from: Orstio on April 12, 2006, 08:58:33 PM
Try an experiment?
In the integrate_register function in smf.php, can you change every $Options to $r_Options ?
I have a similar issue to the original poster. When anyone tries to register they get a page with the Undefined index: memberName, Line: 917 Database Error. As with the original poster I am using Joomla 1.08, SMF 1.1 RC2 and Bridge 1.1.3.
8: Undefined index: memberName
File: /xxx/public_html/components/com_smf/smf.php
Line: 917Database Error: Table xxx.smf_sessions' doesn't exist
File: /xxx/public_html/smf/Sources/Load.php
Line: 1902
Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
any updates on this? thanks!
In smf.php, can you change every $Options to $Options['register_vars'],
except for this line:
function integrate_register($Options, $theme_vars)
(I'll release this soon. This is the last of the unique bug reports since 1.1.3.)
Quote from: Orstio on April 14, 2006, 07:40:04 PM
In smf.php, can you change every $Options to $Options['register_vars'],
except for this line:
function integrate_register($Options, $theme_vars)
(I'll release this soon. This is the last of the unique bug reports since 1.1.3.)
Orstio, that did it :) Just registered a new user, and not one error has shown up (so far). Thanks man
I did the same and have had 2 successful registrations. Thanks very much :D
Hi There,
I had this problem aswell. I applied the changes and I am not getting that error anymore, although registration does not seem to be working. I am however getting the following error at the bottom of the page:
Database Error: Table 'amabutho_joomla.smf_sessions' doesn't exist
File: /home/amabutho/public_html/forum/Sources/Load.php
Line: 1886
Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
Warning: Unknown: A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
Any help with this would be appreciated.
Thanks in advance
Dill
ok sorry for that, just read the reame again and noticed this at the bottom:
With some Joomla templates, you may end up with this error appearing at the bottom of the page:
Database Error: Table 'db_joomla.smf_sessions' doesn't exist
File: /home/user/public_html/joomla/forum/Sources/Load.php
Line: 1886
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
If that happens, please add this to the bottom of your Joomla template:
<?php mysql_select_db($GLOBALS['db_name']); ?>
sorry again, will give that a try first
Quote from: paki on April 14, 2006, 07:48:10 PM
Quote from: Orstio on April 14, 2006, 07:40:04 PM
In smf.php, can you change every $Options to $Options['register_vars'],
except for this line:
function integrate_register($Options, $theme_vars)
(I'll release this soon. This is the last of the unique bug reports since 1.1.3.)
Orstio, that did it :) Just registered a new user, and not one error has shown up (so far). Thanks man
Experiencing the SAME problem...blank page after registration!
My smf.php is quite small? ..only reference to $options is below:
Using Joomla 1.0.7, SMF 1.1RC2, CB 1.0RC2, Bridge 1.1 RC2 patch1-3
global $options;
$req_action = (isset($_REQUEST['action']) ? $_REQUEST['action'] : '');
if ((!empty($options['display_quick_reply']) && strcmp($req_action,"quotefast") == 0)
Orstio, please help!
what bridge is this: Bridge 1.1 RC2 patch1-3 ?
there is no bridge labeled bridge 1.1rc2patch1-3
have you tried v1.1.4 of the bridge?
sorry, I assume my bridge is 1.1.3 (version listed above is via "Installed Components")
In 1.1.4 forum, it states not to use 1.1.4 if you already have 1.1.3... I should note that I also have Community Builder 1.0RC2 installed, and use CB's registration process in conjunction with SMF 1.1 + bridge.
NOTE: Wow, I apologize. I didn't realize that the bridge I am using is not from SMF...it's from a third party site (joomlahacks)
I wonder if the SMF version works with Community Builder 1.0 RC2?
where does it state not to use 1.1.4 if you have 1.1.3? ???
in my compnents list, it lists 1.1.3 as the version, so I still have no idea what version of the bridge you actually have installed...
I have a bridge from joomlahacks.com ...
http://www.joomlahacks.com/content/view/80/95/ (I think)
As for the quote,
see: http://www.simplemachines.org/community/index.php?topic=83665.0
Orstio
Quote... If you have 1.1.3, and it is working, you do not need to upgrade. ...
Looks like this bridge works with community builder, so I will give 1.1.4 a whirl.
EDIT:Wow, this is SO much better...I can't believe the entire time I've been using a third party bridge, when I could have used direct from SMF! You guys rock.
PS
I haven't confirmed whether I'm still receiving the registration bug, but nevertheless this bridge is functioning MUCH better!
I was getting the same error message as Hamsterpants:
Database Error: Table 'db_joomla.smf_sessions' doesn't exist
File: /home/user/public_html/joomla/forum/Sources/Load.php
Line: 1886
I have Joomla 1.0.8, SMF RC2, and bridge 1.1.4. The site template is sample_longgray (for Mambo 4.5.1). I have two databases, but only one user, who is the only user in each database. Joomla and SMF admins are the same person with the same login details. Currently I've set to Bridge Registration.
I fixed this message by adding the code at top and bottom of the template that it says not to add for Joomla.
However, I'm still getting strange login problems. One of my forum members has posted since I did the site update, so they've been able to log in (unless they remained logged in since the previous visit). But as the admoin, I can't log in to SMF! I managed to set up a new user and through phpMyAdmin set that to an admin to wind back the SMF template from longgray (with no login boxes) to the default so I could try unwrapping the forum. I logged in once to do this, but can't re-login! I get:
An Error Has Occurred!
You were unable to login. Please check your cookie settings.
This was similar to my test site when I hadn't put the SMF dbUser into Mambo and the other way around too. But here there is only one user.
The forum member who posted didn't get migrated to Joomla. The unsuccessful logins to SMF do see me getting logged in to Joomla though.
Live (broken) site is: http://www.simuser.com/joomla (http://www.simuser.com/joomla), and the test site (where I can log in) is: http://www.wsdos.org/joomla (http://www.wsdos.org/joomla)
Any ideas?
Regards
Mike
UPDATE: I'm using Mozilla Firefox on Windows because IE gives me problems with the required text entry in the editor - the optional is OK!? Just tried the login with IE 7 and I can log in direct to SMF and via the bridge! So this looks like a Mozilla issue. I daren't swap the SMF template to longgray again just yet though in case I get locked out again!
Mike
Quote from: readme.htmlWith some Joomla templates, you may end up with this error appearing at the bottom of the page:
Database Error: Table 'db_joomla.smf_sessions' doesn't exist
File: /home/user/public_html/joomla/forum/Sources/Load.php
Line: 1886
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
If that happens, please add this to the bottom of your Joomla template:
<?php mysql_select_db($GLOBALS['db_name']); ?>
Quote from: mpetrieI fixed this message by adding the code at top and bottom of the template that it says not to add for Joomla.
That would be why you are getting this:
Quote from: mpetrieAn Error Has Occurred!
You were unable to login. Please check your cookie settings.
Thanks Oristo - misunderstanding - I thought the top and bottom bits of code went together. I've stripped out the top block and left the line at the bottom. However, I still can't log in.
What I've discovered is that I can log in using IE 6 or 7 but not using Mozilla Firefox 1.5.0.3! If I log in using IE, I remain logged in in Firefox - picked up from the Cookie file?
I'm currently getting the following error: "You were unable to login. Please check your cookie settings." when I try to log in using Firefox.
Any ideas?
Cheers
Mike
QuoteWhat I've discovered is that I can log in using IE 6 or 7 but not using Mozilla Firefox 1.5.0.3! If I log in using IE, I remain logged in in Firefox - picked up from the Cookie file?
I'm currently getting the following error: "You were unable to login. Please check your cookie settings." when I try to log in using Firefox.
Go to your SMF admin panel. Click on Server Settings. Click on Feature Configuration.
Make sure that local cookies are off.
QuoteGo to your SMF admin panel. Click on Server Settings. Click on Feature Configuration.
Make sure that local cookies are off
"Enable local storage of cookies" is unchecked.
Just installed Opera, and I can login with that too - it's just Mozilla that's giving this problem.
Cheers
Mike