 | Re: a big thing but not required |  |
 Posted: 08/08/2007 2:58 AM |
 |
|
|
|
|
| Sparrow |
| Posts |
33 |
| Word Cnt. |
951 |
| BDay |
N/A |
| Sign |
N/A |
| Sex |
 |
|
|
|
Joined: Apr 29, 2007
Local time: 6:50 PM
|
|
|
|
|
 |
and lol shop mod (easymod version) hates me
| Code:
|
FIND FAILED: In file [templates/subSilver/viewtopic_body.tpl] could not find:
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}<br />{postrow.CASH}</span><br /></td>
|
|
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 3:59 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:50 PM
Location: St Pete, FL
|
|
|
|
|
|
No I don't think it hates you. Which version of the Shop MOD are you attempting to install???
Unfortunately, this MOD author included far too much information in the FIND command for the MOD to install cleanly in most forums without a need for alteration to the MOD script. This happens far more often than it should...
This is how you reduce the MOD script so that it will install cleanly more often than not:
OPEN
ShopMod/mod_install.txt
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}<br />{postrow.CASH}</span><br /></td>
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
{postrow.POSTER_FROM}
|
Save, upload, and try again using EM...
The Shop MOD should install cleanly after making this one adjustment to the MOD script...
 |
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 3:04 PM |
|
|
|
|
|
| Sparrow |
| Posts |
33 |
| Word Cnt. |
951 |
| BDay |
N/A |
| Sign |
N/A |
| Sex |
|
|
|
|
Joined: Apr 29, 2007
Local time: 6:50 PM
|
|
|
|
|
|
| Well when I copy the new tables they will be missing some of the user fields right? |
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 3:10 PM |
|
|
|
|
|
| Sparrow |
| Posts |
33 |
| Word Cnt. |
951 |
| BDay |
N/A |
| Sign |
N/A |
| Sex |
|
|
|
|
Joined: Apr 29, 2007
Local time: 6:50 PM
|
|
|
|
|
|
Oh noes! Sql error!
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Invalid index name "KEY id", statement: 4, table: "phpbb_user_items"
SQL:
CREATE TABLE aotfc_user_items(id int(20) NOT NULL auto_increment,user_id int(10) NOT NULL default '0',item_id int(10) NOT NULL default '0',item_name varchar(32) NOT NULL default '',item_l_desc text NOT NULL,item_s_desc varchar(100) NOT NULL default '',worn tinyint(1) NOT NULL default '0',die_time int(10) NOT NULL default '0',special text NOT NULL,PRIMARY KEY(id),UNIQUE KEY id(id),KEY item_id(item_id),KEY user_id(user_id)) |
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 3:59 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:50 PM
Location: St Pete, FL
|
|
|
|
|
|
| Jasso wrote:
|
|
Well when I copy the new tables they will be missing some of the user fields right?
|
If you are importing data into modified tables, then you won't lose the structure of the destination table. It is possible that the records from the source database may be missing data. If that occurs, then we can update the records that require more information if need be...
 |
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 4:05 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:50 PM
Location: St Pete, FL
|
|
|
|
|
|
| Jasso wrote:
|
Oh noes! Sql error!
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Invalid index name "KEY id", statement: 4, table: "phpbb_user_items"
SQL:
CREATE TABLE aotfc_user_items(id int(20) NOT NULL auto_increment,user_id int(10) NOT NULL default '0',item_id int(10) NOT NULL default '0',item_name varchar(32) NOT NULL default '',item_l_desc text NOT NULL,item_s_desc varchar(100) NOT NULL default '',worn tinyint(1) NOT NULL default '0',die_time int(10) NOT NULL default '0',special text NOT NULL,PRIMARY KEY(id),UNIQUE KEY id(id),KEY item_id(item_id),KEY user_id(user_id))
|
The Shop MOD comes with a sql_install.php file that you can upload to the root of your forum folder and run from your browser. Go ahead and run it now, then delete it from your FTP Server. Then you can go ahead and ignore this SQL Processing error and complete the MOD install...
The path to the sql_install.php could look something like this in your browser:
| Code:
|
|
http://yourdomain.com/phpBB2/sql_install.php
|
|
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 4:42 PM |
|
|
|
|
|
| Sparrow |
| Posts |
33 |
| Word Cnt. |
951 |
| BDay |
N/A |
| Sign |
N/A |
| Sex |
|
|
|
|
Joined: Apr 29, 2007
Local time: 6:50 PM
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/08/2007 5:25 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:50 PM
Location: St Pete, FL
|
|
|
|
|
|
You're quite welcome. Did you successfully install the Shop MOD now???
 |
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/09/2007 3:02 PM |
|
|
|
|
|
| Sparrow |
| Posts |
33 |
| Word Cnt. |
951 |
| BDay |
N/A |
| Sign |
N/A |
| Sex |
|
|
|
|
Joined: Apr 29, 2007
Local time: 6:50 PM
|
|
|
|
|
|
yea i did
Effects Shop hates me though,
| Code:
|
FIND FAILED: In file [templates/subSilver/viewtopic_body.tpl] could not find:
<td colspan="2"><span class="postbody">{postrow.MESSAGE}{postrow.SIGNATURE}</span><span class="gensmall">{postrow.EDITED_MESSAGE}</span></td>
|
|
|
|
|
|
| Back to Top |
|
|
| Re: a big thing but not required | |
| Posted: 08/12/2007 1:12 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:50 PM
Location: St Pete, FL
|
|
|
|
|
|
I'm sorry it took so long to respond to this Jasso. I've been swamped with huge time-consuming tech problems. I'm still not caught up...
OPEN
Effects Store 201/install.txt
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
# This line may be different in some templates.
#
<td colspan="2"><span class="postbody">{postrow.MESSAGE}{postrow.SIGNATURE}</span><span class="gensmall">{postrow.EDITED_MESSAGE}</span></td>
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
# This line may be different in some templates.
#
{postrow.MESSAGE}
|
Save, upload, and try again using EM...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
