Help - Search - Members - Calendar
Full Version: Registration Error
Invision Power Services > Community Forums > Community General Chat
lnewcomb
I have a question....

I have my board already set up and I tried to add a mod to it and now I cannot fix my board. The trouble lies in the database and I tried to fix it but cant.

I took the same board and installed it on a new database to start over by creating the same forums, etc. My problem is when I went to the admin area to put in my license it telles me:

The registration key you entered is not valid, this might be because of the following:
You incorrectly entered the registration key
You mistakenly used your customer center password instead of the registration key
Your registration licence is no longer valid

Is there a reason for this..Im not setting up a test board but starting a new one but I want to get it all finished the transfer it over to my other url.
Planet-Ed
I'd submit a support ticket. It looks like it thinks your license is still being used by the other install you had before .. IPS should be able to reset your license ..
lnewcomb
I really dont want to start over as I got about 50 new members..I know it dont sound like alot but for me it is..I worked hard to get those members and I dont want to lose them cause they might get annoyed that they will have to re-register again and they are going to lose all of their posts they made. I backed up my database and tried to add it to my new one but it justs transfers over the error I had on my other board.

Here is the error I am getting when trying to click on something someone has uploaded as an attachement

mySQL query error: SELECT atype_extension,atype_mimetype,atype_post,atype_photo,atype_img FROM ibf_attachments_type WHERE atype_photo=1 OR atype_post=1

mySQL error: Unknown column 'atype_extension' in 'field list'
mySQL error code:
Date: Thursday 10th of March 2005 09:52:45 PM

I checked it but dont see that unkown column
Planet-Ed
No I did not say that would cause members to re-register.

You said you installed a NEW database. If you do that and try to add the registration key for the board it will be invalid as it was already registered in the other database. To correct that if you send/open a ticket with IPS they can reset your boards registration key so it will work in your new database..


As for your modifications messing up your board what kind of modification was it? If all you did was edit the board files and did not change the database there was no reason to start over with a new database. All you should have needed to do was delete all the files and folders out of your boards directory except the clobal_config.php and re-upload all the origianl file from the download you got from IPS.

Or you could have just uploaded everything in the /upload folder except the config_global.php file to your server overwiting all the files.

Either of those should have reverted your board back to its orginal state as long as there were no modifications to the database itself.


As for moving members from the old databasse to the new one someone else will have to chime in on that ass its something I've never done before.
lnewcomb
QUOTE(Planet-Ed @ Mar 11 2005, 01:14 AM)
No I did not say that would cause members to re-register.

You said you installed a NEW database.  If you do that and try to add the registration key for the board it will be invalid as it was already registered in the other database.  To correct that if you send/open a ticket with IPS they can reset your boards registration key so it will work in your new database..
As for your modifications messing up your board what kind of modification was it?  If all you did was edit the board files and did not change the database there was no reason to start over with a new database.  All you should have needed to do was delete all the files and folders out of your boards directory except the clobal_config.php and re-upload all the origianl file from the download you got from IPS.

Or you could have just uploaded everything in the /upload folder except the config_global.php file to your server overwiting all the files.

Either of those should have reverted your board back to its orginal state as long as there were no modifications to the database itself.
As for moving members from the old databasse to the new one someone else will have to chime in on that ass its something I've never done before.
*


Here is the modification that I entered into the database..but then I went into it and deleted them..

QUOTE
alter table ibf_attachments add bt_info_hash blob;
alter table ibf_attachments add bt_name varchar(255);
alter table ibf_attachments add bt_size bigint;
alter table ibf_attachments add bt_tracker varchar(255);
alter table ibf_topics add bt_info_hash blob;
insert into ibf_attachments_type (atype_extension, atype_mimetype, atype_img) values ('torrent', 'application/x-bittorrent', 'folder_mime_types/zip.gif');
update ibf_skin_templates set section_content = '<!-- Begin Topic Entry {$data[''tid'']} --><tr> <td align="center" class="$class2">{$data[''folder_img'']}</td><td align="center" class="$class2">{$data[''topic_icon'']}</td><td class="$class2" valign="middle"><div>{$data[''go_new_post'']}{$data[''prefix'']} {$data[''attach_img'']}<a href="{ipb.script_url}showtopic={$data[''tid'']}" title="{ipb.lang[''topic_started_on'']} {$data[''start_date'']}">{$data[''title'']}</a> {$data[PAGES]}<div class="desc">{$data[''description'']}</div></div></td>    <td align="center" class="$class1">{$data[''seeders'']}</td>    <td align="center" class="$class1">{$data[''leechers'']}</td><td align=''center'' class="$classposts">    {$data[''posts'']}<if="data[''_hasqueued''] and inforum == 1">&nbsp;<a href="{ipb.script_url}showtopic={$data[''tid'']}&amp;modfilter=invisible_posts"><{BC_QUEUED_POSTS}></a></if>    </td><td align="center" class="$class1">{$data[''starter'']}</td><td align="center" class="$class1">{$data[''views'']}</td><td class="$class1"><span class="lastaction">{$data[''last_post'']}<br /><a href="{ipb.script_url}showtopic={$data[''tid'']}&amp;view=getlastpost">{$data[''last_text'']}</a> <b>{$data[''last_poster'']}</b></span></td><if="ipb.member[''is_mod''] and inforum == 1 and data[''tidon''] == 1"><td align="center" class="$class1"><a href="#" title="{ipb.lang[''click_for_mod'']}" onclick="forum_toggle_tid(''{$data[''real_tid'']}''); return false;"><img name="img{$data[''real_tid'']}" src="{ipb.vars[''img_url'']}/topic_selected.gif" /></a></td></if><if="ipb.member[''is_mod''] and inforum == 1 and data[''tidon''] == 0"><td align="center" class="$class1"><a href="#" title="{ipb.lang[''click_for_mod'']}" onclick="forum_toggle_tid(''{$data[''real_tid'']}''); return false;"><img name="img{$data[''real_tid'']}" src="{ipb.vars[''img_url'']}/topic_unselected.gif" /></a></td></if></tr>    <!-- End Topic Entry {$data[''tid'']} -->' where group_name = 'skin_forum' and func_name = 'render_forum_row';
update ibf_skin_templates set section_content = '<script language="javascript" type="text/javascript"><!--var unselectedbutton = "{ipb.vars[''img_url'']}/topic_unselected.gif";var selectedbutton  = "{ipb.vars[''img_url'']}/topic_selected.gif";var lang_gobutton    = "{ipb.lang[''f_go'']}";var lang_suredelete  = "{ipb.lang[''cp_js_delete'']}";//--></script><script type="text/javascript" src="jscripts/ipb_forum.js"></script>  <!--IBF.SUBFORUMS--><table cellspacing="0"><tr><td style=''padding-left:0px'' width="60%">{$data[''SHOW_PAGES'']}</td><td class=''nopad'' style=''padding:0px 0px 5px 0px'' align="right" nowrap="nowrap"><a href="{ipb.script_url}act=Post&amp;CODE=00&amp;f={$data[''id'']}"><{A_POST}></a>{$data[POLL_BUTTON]}</td></tr></table><div class="borderwrap"><div class="maintitle"><p class="expand"><a href="{ipb.script_url}act=Login&amp;CODE=04&amp;f={$data[''id'']}">{ipb.lang[''mark_as_read'']}</a> &middot; <a href="{ipb.script_url}act=Track&amp;f={$data[''id'']}&amp;type=forum">{ipb.lang[''ft_title'']}</a></p><p><{CAT_IMG}>&nbsp;{$data[''name'']}</p></div><table cellspacing="1"><tr> <th align="center">&nbsp;</th><th align="center">&nbsp;</th><th width="50%" nowrap="nowrap">{ipb.lang[''h_topic_title'']}</th><th align="center" nowrap="nowrap">S</th><th align="center" nowrap="nowrap">L</th><th align="center" nowrap="nowrap">R</th><th width="14%" align="center" nowrap="nowrap">{ipb.lang[''h_topic_starter'']}</th><th width="7%" align="center" nowrap="nowrap">{ipb.lang[''h_hits'']}</th><th width="22%" nowrap="nowrap">{ipb.lang[''h_last_action'']}</th><if="ipb.member[''is_mod'']"><th width="1%" align="center">&nbsp;</th></if></tr><!-- Forum page unique top --><!--IBF.ANNOUNCEMENTS-->' where group_name = 'skin_forum' and func_name = 'pagetop';
update ibf_skin_templates set section_content = '<tr><td colspan="10" class="darkrow1"><table cellspacing="0"><tr><td width="50%" class="nopad"><form action="{ipb.script_url}" method="post" name="search"><input type="hidden" name="forums" value="{$data[''id'']}" /><input type="hidden" name="cat_forum" value="forum" /><input type="hidden" name="act" value="Search" /><input type="hidden" name="joinname" value="1" /><input type="hidden" name="CODE" value="01" /><input type="text" size="30" name="keywords" value="{ipb.lang[''enter_keywords'']}" onfocus="this.value = '''';" /> <input type="submit" value="{ipb.lang[''search_forum'']}" class="button" /></form></td><if="ipb.member[''is_mod'']"><td width="50%" align="right" nowrap="nowrap" class="nopad"><form name="modform" method="post" action="{ipb.script_url}act=mod&CODE=topicchoice&f={$data[''id'']}" onsubmit="return checkdelete();"><input type="hidden" name="act" value="mod" /><input type="hidden" name="auth_key" value="{$auth_key}" /><input type="hidden" name="modfilter" value="{ipb.input[''modfilter'']}" /><input type="hidden" value="{ipb.input[''selectedtids'']}" name="selectedtids"" /><select name="tact"><option value="close">{ipb.lang[''cpt_close'']}</option><option value="open">{ipb.lang[''cpt_open'']}</option><option value="pin">{ipb.lang[''cpt_pin'']}</option><option value="unpin">{ipb.lang[''cpt_unpin'']}</option><option value="move">{ipb.lang[''cpt_move'']}</option><option value="merge">{ipb.lang[''cpt_merge'']}</option><option value="delete">{ipb.lang[''cpt_delete'']}</option><option value="approve">{ipb.lang[''cpt_approve'']}</option><option value="unapprove">{ipb.lang[''cpt_unapprove'']}</option><!--IBF.MMOD--></select>&nbsp;<input type="submit" name="gobutton" value="{ipb.lang[''f_go'']}" class="button" /></form></td></if></tr></table></td></tr><tr> <td class="catend" colspan="8"><!-- no content --></td></tr></table></div><table cellspacing="0"><tr><td style=''padding-left:0px'' width="50%" nowrap="nowrap">{$data[''SHOW_PAGES'']}</td><td class=''nopad'' style=''padding:5px 0px 5px 0px'' align="right" width="50%"><a href="{ipb.script_url}act=Post&amp;CODE=00&amp;f={$data[''id'']}"><{A_POST}></a>{$data[POLL_BUTTON]}</td></tr></table><!--IBF.FORUM_ACTIVE--><div class="activeusers"><div class="row2"><table cellspacing="0"><tr><td width="5%" nowrap="nowrap"><{B_NEW}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_open_new'']}</span><br /><{B_NORM}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_open_no'']}</span><br /><{B_HOT}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_hot_new'']}</span><br /><{B_HOT_NN}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_hot_no'']}</span>&nbsp;</td><td width="5%" nowrap="nowrap"><{B_POLL}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_poll'']}</span><br /><{B_POLL_NN}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_poll_no'']}</span><br /><{B_LOCKED}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_locked'']}</span><br /><{B_MOVED}>&nbsp;&nbsp;<span class="desc">{ipb.lang[''pm_moved'']}</span></td><td align="right" width="90%">{$data[FORUM_JUMP]}<br /><br /><form action="{ipb.script_url}act=SF&amp;f={$data[''id'']}&amp;st={ipb.input[''st'']}" method="post"><select name="sort_key">{$ibforums->show[''sort_by'']}</select><select name="sort_by">{$ibforums->show[''sort_order'']}</select><select name="prune_day">{$ibforums->show[''sort_prune'']}</select><select name="topicfilter">{$ibforums->show[''topic_filter'']}</select><input type="submit" value="{ipb.lang[''sort_submit'']}" class="button" /></form></td></tr></table></div></div><if="ipb.member[''is_mod'']"><br /><div align="center"><a href="{ipb.script_url}showforum={$data[''id'']}&amp;modfilter=invisible_topics">{ipb.lang[''mod_showallinvisible'']}</a>&middot;<a href="{ipb.script_url}showforum={$data[''id'']}&amp;modfilter=invisible_posts">{ipb.lang[''mod_showallposts'']}</a>&middot;<a href="{ipb.script_url}act=mod&amp;CODE=resync&amp;f={$data[''id'']}&amp;auth_key={$auth_key}">{ipb.lang[''mod_resync'']}</a>&middot;<a href="java script:PopUp(''{ipb.script_url}act=mod&amp;CODE=prune_start&amp;f={$data[''id'']}&amp;auth_key={$auth_key}'', ''PRUNE'', 600,500)">{ipb.lang[''mod_prune'']}</a></div></if><br clear="all" />' where group_name = 'skin_forum' and func_name = 'tableend';
update ibf_skin_templates set section_content = '<a href="{ipb.script_url}act=Attach&amp;type={$data[''method'']}&amp;id={$data[''id'']}" title="{ipb.lang[''attach_dl'']}" target="_blank"><img src="{ipb.vars[''mime_img'']}/{$data[''image'']}" alt="{ipb.lang[''attached_file'']}" /></a>&nbsp;<a href="{ipb.script_url}act=Attach&amp;type={$data[''method'']}&amp;id={$data[''id'']}" title="{ipb.lang[''attach_dl'']}" target="_blank">{$data[''name'']}</a> ( {$data[''size'']} )<span class="desc">{ipb.lang[''attach_hits'']}: {$data[''hits'']}</span> Seeders: {$data[''seeders'']} Leechers: {$data[''leechers'']}<br />' where group_name = 'skin_topic' and func_name = 'show_attachments';
Planet-Ed
Oh yea you modified your database. Not sure how you can fix that if possible.

Someone else will have to help you move your members over to the new database as I have no clue on how to do that.

Next time before you try a modifications you should set up a test board to use to test the modifications on before you attempt it on a live board. That way if it doesn't work or their are problems you'll find out before it can destroy your board. IPS does allow a development board to be installed in addition to your regular board just to test for these kinds of things.
lnewcomb
QUOTE(Planet-Ed @ Mar 11 2005, 01:46 AM)
Oh yea you modified your database.  Not sure how you can fix that if possible. 

Someone else will have to help you move your members over to the new database as I have no clue on how to do that.

Next time before you try a modifications you should set up a test board to use to test the modifications on before you attempt it on a live board.  That way if it doesn't work or their are problems you'll find out before it can destroy your board.  IPS does allow a development board to be installed in addition to your regular board just to test for these kinds of things.
*


ok thanks..I know that as I have other mods installed...this one just got me though..

I wish there was a way that I can save all my posts and replys on my board and transfer it over to the new board without transfering the error or any mods.. Im fine with that as I always can add them back later..
Grooverider
looks like all that script did was update your template and add a few bits to the database. If you replace your template that should solve a lot of the errors as extra data in the database shouldn't matter as long as it isn't being queried incorrectly.

All the database is doing is storing information. you only get errors if the php script is calling a field or entry that isn't recognised.

Did you make any changes to the php files? If so then have you removed them?

Try taking a backup of the html root folder and then replacing the default template for IPB. See what you get from that

My suggestion in the future is always backup the html root folder and your db before applying any mods. that way you can always restore your files and the previous version of the db

Grooverider

PS I'm sure IPS could write you a script to export the database based just on what should be there
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.