 | [Solved] looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation |  |
 Posted: 03/23/2007 5:10 PM |
 |
|
|
|
|
| Crow |
| Posts |
60 |
| Word Cnt. |
2,411 |
| BDay |
May 25 |
| Sign |
Gemini |
|
|
|
|
|
Joined: Mar 23, 2007
Local time: 3:00 PM
|
|
|
|
|
 |
I have EasyMOD installed for my forum but some road I have made two tables that are extra. These are the errors I am getting for the mods that I have installed.
spellphpbb
| Quote:
|
Critical Error
FIND FAILED: In file [templates/subSilver/posting_body.tpl] could not find:
<input type="submit" tabindex="4"
MOD script line #90 :: FAQ :: Report
|
Birthdays
| Quote:
|
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
ALTER TABLE phpbb_users ADD user_birthday INTEGER( NOT NULL DEFAULT 0;;
SQL ERROR: 1060
Duplicate column name 'user_birthday'
|
Textual Confirmation
| Quote:
|
Quote:
Quote: ‹ Select › ‹ Contract ›
Critical Error
FIND FAILED: In file [includes/usercp_register.php] could not find:
$template->assign_vars(array(
'USERNAME' => isset($username) ? $username : '',
'CUR_PASSWORD' => isset($cur_password) ? $cur_password : '',
MOD script line #119 :: FAQ :: Report
|
Although this has been an ongoing problem, I think that it's the reason why I'm getting spam bots still posting although I have got rid of alot of them, I'm hoping that I will be able to get back to normal, and I still haven't managed to update it to .22 either, some how I managed to install it back to .19 but it looks okay apart from it going back to its original state apart from keeping the new post, which is a miracle fo me - I usually loose them  |
|
|
|
|
| Back to Top |
|
|
| Re: looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/23/2007 5:30 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 11:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Welcome to RCF, moon2fire!!! 
I'll be heading out the door here in a bit, but I can give you enough to get going again...
| moon2fire wrote:
|
spellphpbb
| Quote:
|
Critical Error
FIND FAILED: In file [templates/subSilver/posting_body.tpl] could not find:
<input type="submit" tabindex="4"
MOD script line #90 :: FAQ :: Report
|
|
Ok, try this:
OPEN
phpbb_install.txt
FIND
| Code:
|
#
#-----[ INLINE FIND ]------------------------------------------
#
<input type="submit" tabindex="4"
#
#-----[ BEFORE, ADD ]------------------------------------------
#
<tr><td colspan="9" align="right">
<input type="button" class="mainoption" value="SpellCheck" name="button" onclick="openspell();">
</td></tr>
|
REPLACE WITH
| Code:
|
#
#-----[ INLINE FIND ]------------------------------------------
#
{S_HIDDEN_FORM_FIELDS}
#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr><td colspan="9" align="right">
<input type="button" class="mainoption" value="SpellCheck" name="button" onclick="openspell();">
</td></tr>
|
Save, upload, and try again using EM...
| moon2fire wrote:
|
Birthdays
| Quote:
|
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
ALTER TABLE phpbb_users ADD user_birthday INTEGER( NOT NULL DEFAULT 0;;
SQL ERROR: 1060
Duplicate column name 'user_birthday'
|
|
If you have installed a different Birthday MOD or are reinstalling this one, then some, if not all, of the database changes have been made. Since you cannot successfully create duplicate tables, fields (columns), or keyed records in SQL, then you would expect to see an error message when attempting to do so...
If the MOD author included a SQL Update file with the MOD, it would be good to run it from your browser after uploading the file to your phpBB forum folder. If you can successfully run the file, then you can ignore this error message and complete the MOD install...
If the MOD author did not include a DB Update file with the MOD and there are more than one SQL query that needs to be run, you can press the Back button in your browser when you see the SQL Processing error, then unselect the top selected SQL query. Then try again. You can repeat this process one by one as long as the error is a duplicate table, field, or keyed record until EM is able to complete the remaining queries or until all of the queries have been unchecked...
If you know that the SQL queries for this MOD have been successfully applied once before, you can safely ignore the SQL Processing error and complete the MOD install...
| moon2fire wrote:
|
|
Textual Confirmation
|
I don't think I have this MOD so could you provide a link to the MOD download???
Welcome to RCF moon2fire!!!
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/25/2007 11:28 AM |
|
|
|
|
|
| Crow |
| Posts |
60 |
| Word Cnt. |
2,411 |
| BDay |
May 25 |
| Sign |
Gemini |
|
|
|
|
|
Joined: Mar 23, 2007
Local time: 3:00 PM
|
|
|
|
|
|
phpbbspell changes worked like a dream
I found the SQL part and I repaired the table, but I think I have had this error before
| Quote:
|
Critical Error
IN-LINE FIND FAILED: In file [includes/usercp_register.php] could not find:
,user_icq
MOD script line #486 :: FAQ :: Report
|
I had to go scouting for this!
http://www.phpbb.com/community/viewtopic.php?&t=472940
....oh, and thank you for the welcome  |
|
|
|
|
| Back to Top |
|
|
| Re: looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/25/2007 3:13 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Unfortunately, the download link to the Textual Confirmation MOD does not work in phpBB.com at this time. Could you make your copy available for me to look at???
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/25/2007 5:12 PM |
|
|
|
|
|
| Crow |
| Posts |
60 |
| Word Cnt. |
2,411 |
| BDay |
May 25 |
| Sign |
Gemini |
|
|
|
|
|
Joined: Mar 23, 2007
Local time: 3:00 PM
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/25/2007 5:26 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, try this:
OPEN
Textual Confirmation/install.txt
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
$template->assign_vars(array(
'USERNAME' => isset($username) ? $username : '',
'CUR_PASSWORD' => isset($cur_password) ? $cur_password : '',
#
#-----[ REPLACE WITH ]------------------------------------------
#
tc_hook_template($mode, $template, $s_hidden_fields, $tc_question);
$template->assign_vars(array(
'TEXTUAL_CONFIRMATION_QUESTION' => isset($tc_question) ? $tc_question : '',
'L_TEXTUAL_CONFIRMATION_EXPLAIN' => isset($lang['tc_explain']) ? $lang['tc_explain'] : '',
'USERNAME' => isset($username) ? $username : '',
'CUR_PASSWORD' => isset($cur_password) ? $cur_password : '',
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
$template->assign_vars(array(
'USERNAME' =>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
tc_hook_template($mode, $template, $s_hidden_fields, $tc_question);
#
#-----[ FIND ]------------------------------------------
#
'CUR_PASSWORD' =>
#
#-----[ AFTER, ADD ]------------------------------------------
#
'TEXTUAL_CONFIRMATION_QUESTION' => isset($tc_question) ? $tc_question : '',
'L_TEXTUAL_CONFIRMATION_EXPLAIN' => isset($lang['tc_explain']) ? $lang['tc_explain'] : '',
|
Save, upload, and try again using EM...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/25/2007 6:25 PM |
|
|
|
|
|
| Crow |
| Posts |
60 |
| Word Cnt. |
2,411 |
| BDay |
May 25 |
| Sign |
Gemini |
|
|
|
|
|
Joined: Mar 23, 2007
Local time: 3:00 PM
|
|
|
|
|
|
After I changed the script, I had another error message but it was my bad I forgot to upload the textual_confirmation.tpl file.
This is more a question rather than a 'fix it', but it says now:
| Quote:
|
'Do it yourself' instructions need to be executed by you manually, EasyMOD can not perform these actions
* After installation of Textual Confirmation is completed, go to
* the control panel and change the set of questions. Also, switch
* off Visual Confirmation, because it isn't required anymore.
* If you've installed additional forum templates, then, for each template:
* * modify the file "profile_add_body.tpl", and
* * create the file "admin/textual_confirmation.tpl".
|
Surely it is okay to have both the visual confirmation and the Textual confirmation running on your board for added security? |
|
|
|
|
| Back to Top |
|
|
| Re: looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/26/2007 2:27 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:00 AM
Location: St Pete, FL
|
|
|
|
|
|
Yeah, I don't imagine that it will cause a problem with the Visual Confirmation turned on along with the Textual Confirmation. Not knowing how this looks after it is installed, I can't see why the MOD author would think that Visual Confirmation is no longer necessary. It sounds like either way is fine though...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/26/2007 6:41 AM |
|
|
|
|
|
| Crow |
| Posts |
60 |
| Word Cnt. |
2,411 |
| BDay |
May 25 |
| Sign |
Gemini |
|
|
|
|
|
Joined: Mar 23, 2007
Local time: 3:00 PM
|
|
|
|
|
|
Installed now, it looks pretty cool, you even get space on the ACP to change the question, which is quite handy, I won't have to spend my life deleting posts for pharmacies and all that 
 |
|
|
|
|
| Back to Top |
|
|
| Re: looking for a way to solve this EM problem - spellphpbb, birthdays and textual confirmation | |
| Posted: 03/26/2007 8:20 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:00 AM
Location: St Pete, FL
|
|
|
|
|
|
I hope that makes a difference...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
