 | [solved] Error w/EM install |  |
 Posted: 05/19/2007 10:24 AM |
 |
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
 |
Hi Nightrider, I helped someone get the custom profile fields mod installed on their forum last night through easyMOD. They had it on their server already, there were just some basic template error's that needed to be addressed to get the mod installed and so I did that for her. I thought all had installed well but it seems there is a problem. This is the error given when trying to register.
| Code:
|
Could not update custom profile fields
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id = 354' at line 3
UPDATE swirlweddings_users SE WHERE user_id = 354
Line : 864
File : usercp_register.php
|
There is also a few errors up top the page when trying to register.
| Code:
|
Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/swirlwed/public_html/includes/usercp_register.php on line 348
Warning: Cannot modify header information - headers already sent by (output started at /home/swirlwed/public_html/includes/usercp_register.php:348) in /home/swirlwed/public_html/includes/page_header.php on line 503
|
As far as I know the SQL was run successfully by easyMOD, and I didn't have to alter the edits of includes/usercp_register.php so I am not sure what went wrong where.
Let me know if you need anymore info.  |
|
Last edited by FTM on 05/22/2007 7:17 AM; edited 1 time in total |
|
|
|
| Back to Top |
|
|
| Re: Error w/EM install | |
| Posted: 05/19/2007 5:54 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 11:36 PM
Location: St Pete, FL
|
|
|
|
|
|
I'm going to need to see a text link to the usercp_register.php file. The SE in that UPDATE query doesn't belong there and part of the query is missing. I imagine that SE should actually say SET and the part that is supposed to be set/assigned has been accidentally removed...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [solved] Error w/EM install | |
| Posted: 05/19/2007 6:15 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: Error w/EM install | |
| Posted: 05/19/2007 7:06 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:36 PM
Location: St Pete, FL
|
|
|
|
|
|
Would you happen to have a link to the Custom Proflile Fields MOD? The version I have doesn't modify the usercp_register.php file...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [solved] Error w/EM install | |
| Posted: 05/19/2007 7:14 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: Error w/EM install | |
| Posted: 05/20/2007 1:00 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:36 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, after a bit of a battle, I finally managed to install this on our Test board and it is working properly. So I'm guessing that the MOD is not installed correctly. One place in particular where it replaced the colspan setting with {NUMCOLS} might cause some problems if the colspan on the board was set to something other than 8. If so, you would also need to adjust the following line in the MOD script, changing 8 to the actual column span number from the memberlist_body.tpl file. I had to change it to 9 on our Test board...
| Code:
|
|
$template->assign_var('NUMCOLS',count($profile_data)+8);
|
I had to make many other changes to the MOD script to get it to work with our Test board code and templates. I can't replicate your problem though during registration. I went through the usercp_register.php file that you provided and it appears that all the edits were made correctly...
Were the SQL queries run successfully? Do you have a new phpbb_profile_fields table in the database? When you add a new field, is it correctly added to the phpbb_profile_fields table???
|
|
|
|
|
| Back to Top |
|
|
| Re: [solved] Error w/EM install | |
| Posted: 05/20/2007 7:30 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
|
Yes, the colspan was the first error I needed to fix to install the mod.
| Code:
|
#
#-----[ FIND ]----------------------
#
<td class="catBottom" colspan="9" height="28"> </td>
#
#-----[ REPLACE WITH ]-----------------
#
<!-- Custom Profile Fields MOD start -->
<td class="catBottom" colspan="{NUMCOLS}" height="28"> </td>
<!-- Custom Profile Fields MOD finish -->
|
The original find was for that line with the colspan of 8. I changed the install file to find the colspan of 9. So that most definitely could be the problem.
Yes, the SQL was run correctly through easyMOD, with no errors. Yes, we have that table in the database, and yes it does work correctly when we add a new field.  |
|
|
|
|
| Back to Top |
|
|
| Re: [solved] Error w/EM install | |
| Posted: 05/20/2007 7:41 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
|
I just fixed the colspan spot you referenced above. It did help the memberlist look correct, thank you.
I tested a new registration again and got the same errors. I did notice that after I did my test register, it did in fact register my account (it's showing up on the newest member spot) but the admin don't get the registration email (she has it set to admin aproval)
Not sure if that helps you or not.
When I researched this error sometimes people got it from the SQL being run incorrectly. Should I delete the SQL created by the mod install, and re-run the SQL by hand and see if that helps? |
|
|
|
|
| Back to Top |
|
|
| Re: Error w/EM install | |
| Posted: 05/20/2007 6:20 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:36 PM
Location: St Pete, FL
|
|
|
|
|
|
The following line is what's causing your htmlspecialchars() warning error. So try fixing this and see if it gets rid of the problem without creating any new ones:
OPEN
includes/usercp_register.php
FIND
| Code:
|
|
$temp = (isset($HTTP_POST_VARS[$name])) ? $HTTP_POST_VARS[$name] : array();
|
REPLACE WITH
| Code:
|
|
$temp = (isset($HTTP_POST_VARS[$name])) ? $HTTP_POST_VARS[$name] : '';
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [solved] Error w/EM install | |
| Posted: 05/20/2007 9:54 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:36 PM
Location: Denver, PA
|
|
|
|
|
|
After that change is made I get the following errors.
| Code:
|
Warning: Invalid argument supplied for foreach() in /home/swirlwed/public_html/includes/usercp_register.php on line 341
Warning: Cannot modify header information - headers already sent by (output started at /home/swirlwed/public_html/includes/usercp_register.php:341) in /home/swirlwed/public_html/includes/page_header.php on line 503
|
| Code:
|
Could not update custom profile fields
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id = 362' at line 3
UPDATE swirlweddings_users SE WHERE user_id = 362
Line : 864
File : usercp_register.php
|
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
