 | Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/03/2007 6:01 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
Hi,
When uploading the EZLinks extracted folder to the Easymod folder, the mod does not show in the "Install Mods" view. And no installation manual is included.
Country Flags mod does install but does not work in my "guildwars" template, only with subsilver.
EZ site does no install.
Critical Error
FIND FAILED: In file [includes/page_tail.php] could not find:
'PHPBB_VERSION' => '2' . $board_config['version'],
'TRANSLATION_INFO' => ( isset($lang['TRANSLATION_INFO']) ) ? $lang['TRANSLATION_INFO'] : '',
'ADMIN_LINK' => $admin_link)
);
And last but not least, there a no icons before every link on my board. Only at downloads, chat and the album link there is an icon in front of it, the other don't have one.
thanks for helping this PHP noob  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/04/2007 12:19 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 3:52 PM
Location: St Pete, FL
|

|
|
|
|
 |
You must not have had the ezlinks.mod file in the root of the EZLinks folder. I just uploaded it to your admin/mods folder and it is displaying in EM's Unprocessed list...
The Country Flags MOD will install into all of your templates if subSilver is specified in the template OPEN command(s). EM will install the MOD code into all the templates if it can. Just don't ignore any Warning errors. Most can be corrected so that the MOD can be correctly installed into each template. When you ignore a Warning error, that code and all that follows for that template file is not added, meaning that you would need to finish the MOD install manually. It usually isn't necessary to make manual modifications because you can correct the MOD script instead...
There is a problem with the COPY commands in the Country Flags MOD though. You should make the following adjustment to the MOD script:
OPEN
Country Flags MOD/install_en.txt
FIND
| Code:
|
#
#-----[ COPY ]------------------------------------------
#
copy root/images/flags/*.gif to images/flags/
copy root/admin/*.php to admin/
copy root/templates/subSilver/admin/*.tpl to templates/subSilver/admin/
|
REPLACE WITH
| Code:
|
#
#-----[ COPY ]------------------------------------------
#
copy root/images/flags/*.gif to images/flags/*.gif
copy root/admin/*.php to admin/*.php
copy root/templates/subSilver/admin/*.tpl to templates/subSilver/admin/*.tpl
|
Save, upload, and try again using EM...
| Dha wrote:
|
EZ site does no install.
Critical Error
FIND FAILED: In file [includes/page_tail.php] could not find:
'PHPBB_VERSION' => '2' . $board_config['version'],
'TRANSLATION_INFO' => ( isset($lang['TRANSLATION_INFO']) ) ? $lang['TRANSLATION_INFO'] : '',
'ADMIN_LINK' => $admin_link)
);
|
The PHPBB_VERSION variable was removed from the page_tail.php file somewhere along the phpBB evolution. So to correct this problem, you can do this:
OPEN
EasySite (The phpBB Site MOD)/install_en.txt
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
'PHPBB_VERSION' => '2' . $board_config['version'],
'TRANSLATION_INFO' => ( isset($lang['TRANSLATION_INFO']) ) ? $lang['TRANSLATION_INFO'] : '',
'ADMIN_LINK' => $admin_link)
);
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
'TRANSLATION_INFO' =>
'ADMIN_LINK' =>
);
|
Since this is an old MOD designed for an earlier phpBB version, you will also have to make the following adjustments to the MOD script too:
OPEN
EasySite (The phpBB Site MOD)/install_en.txt
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
<!--
We request you retain the full copyright notice below including the link to www.phpbb.com.
This not only gives respect to the large amount of time given freely by the developers
but also helps build interest, traffic and use of phpBB 2.0. If you cannot (for good
reason) retain the full copyright we request you at least leave in place the
Powered by phpBB {PHPBB_VERSION} line, with phpBB linked to www.phpbb.com. If you refuse
to include even this then support on our forums may be affected.
The phpBB Group : 2002
// -->
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> {PHPBB_VERSION} © 2001, 2002 phpBB Group<br />{TRANSLATION_INFO}</span></div>
</td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
<!--
Please, I expect everyone uses this MOD to NOT remove the copyright notice on EasySite
that links to http://macphpbbmod.sourceforge.net/.
i.e. Website Powered by EasySite (The phpBB Site MOD) 1.x.x
Please do keep the EasySite and the phpBB declaration.
If you don't, you are refusing support from me and my support site.
I hope you can respect all open source developers by follow these simple instructions. Thank you
EasySite Author, YC Lin, 2004
// -->
Website Powered by <a href="http://macphpbbmod.sourceforge.net/" target="_blank" class="copyright">EasySite (The phpBB Site MOD)</a> {EASYSITE_VERSION}</div>
<div align="center">
<!--
We request you retain the full copyright notice below including the link to www.phpbb.com.
This not only gives respect to the large amount of time given freely by the developers
but also helps build interest, traffic and use of phpBB 2.0. If you cannot (for good
reason) retain the full copyright we request you at least leave in place the
Powered by phpBB {PHPBB_VERSION} line, with phpBB linked to www.phpbb.com. If you refuse
to include even this then support on our forums may be affected.
The phpBB Group : 2002
// -->
Forum Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> {PHPBB_VERSION} © 2001, 2002 phpBB Group<br />{TRANSLATION_INFO}</div>
<div align="center">{COPYRIGHT_TEXT}</div>
<!-- BEGIN switch_copyright_owner -->
<div align="center">{L_OWNED}: <a href="{U_CONTACT}" class="copyright">{COPYRIGHT_OWNER}</a></div>
<!-- END switch_copyright_owner -->
<br />
<div align="center"><a href="{U_TERMS}" class="copyright">{L_TERMS}</a> - <a href="{U_PRICACY}" class="copyright">{L_PRIVACY}</a></div>
</span></td>
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
<!--
We
This
but
reason
Powered
to
The
// -->
Powered by
</td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
Website Powered by <a href="http://macphpbbmod.sourceforge.net/" target="_blank" class="copyright">EasySite (The phpBB Site MOD)</a> {EASYSITE_VERSION}</div>
<div align="center">
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> © 2001, 2005 phpBB Group<br />{TRANSLATION_INFO}</span></div>
<div align="center">{COPYRIGHT_TEXT}</div>
<!-- BEGIN switch_copyright_owner -->
<div align="center">{L_OWNED}: <a href="{U_CONTACT}" class="copyright">{COPYRIGHT_OWNER}</a></div>
<!-- END switch_copyright_owner -->
<br />
<div align="center"><a href="{U_TERMS}" class="copyright">{L_TERMS}</a> - <a href="{U_PRICACY}" class="copyright">{L_PRIVACY}</a></div>
</span></td>
|
FIND
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
<!--
We request you retain the full copyright notice below including the link to www.phpbb.com.
This not only gives respect to the large amount of time given freely by the developers
but also helps build interest, traffic and use of phpBB 2.0. If you cannot (for good
reason) retain the full copyright we request you at least leave in place the
Powered by phpBB {PHPBB_VERSION} line, with phpBB linked to www.phpbb.com. If you refuse
to include even this then support on our forums may be affected.
The phpBB Group : 2002
// -->
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> {PHPBB_VERSION} © 2001,2002 phpBB Group</span></div>
</td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
<!--
Please, I expect everyone uses this MOD to NOT remove the copyright notice on EasySite
that links to http://macphpbbmod.sourceforge.net/.
i.e. Website Powered by EasySite (The phpBB Site MOD) 1.x.x
Please do keep the EasySite and the phpBB declaration.
If you don't, you are refusing support from me and my support site.
I hope you can respect all open source developers by follow these simple instructions. Thank you
EasySite Author, YC Lin, 2004
// -->
Website Powered by <a href="http://macphpbbmod.sourceforge.net/" target="_blank" class="copyright">EasySite (The phpBB Site MOD)</a> {EASYSITE_VERSION}</div>
<div align="center">
<!--
We request you retain the full copyright notice below including the link to www.phpbb.com.
This not only gives respect to the large amount of time given freely by the developers
but also helps build interest, traffic and use of phpBB 2.0. If you cannot (for good
reason) retain the full copyright we request you at least leave in place the
Powered by phpBB {PHPBB_VERSION} line, with phpBB linked to www.phpbb.com. If you refuse
to include even this then support on our forums may be affected.
The phpBB Group : 2002
// -->
Forum Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> {PHPBB_VERSION} © 2001,2002 phpBB Group</div>
<div align="center">{COPYRIGHT_TEXT}</div>
<!-- BEGIN switch_copyright_owner -->
<div align="center">{L_OWNED}: <a href="{U_CONTACT}" class="copyright">{COPYRIGHT_OWNER}</a></div>
<!-- END switch_copyright_owner -->
<br />
<div align="center"><a href="{U_TERMS}" class="copyright">{L_TERMS}</a> - <a href="{U_PRICACY}" class="copyright">{L_PRIVACY}</a></div>
</span></td>
|
REPLACE WITH
| Code:
|
#
#-----[ FIND ]------------------------------------------
#
<!--
We
This
but
reason
Powered
to
The
// -->
Powered by
</td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
Website Powered by <a href="http://macphpbbmod.sourceforge.net/" target="_blank" class="copyright">EasySite (The phpBB Site MOD)</a> {EASYSITE_VERSION}</div>
<div align="center">
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> © 2001, 2005 phpBB Group<br />{TRANSLATION_INFO}</span></div>
<div align="center">{COPYRIGHT_TEXT}</div>
<!-- BEGIN switch_copyright_owner -->
<div align="center">{L_OWNED}: <a href="{U_CONTACT}" class="copyright">{COPYRIGHT_OWNER}</a></div>
<!-- END switch_copyright_owner -->
<br />
<div align="center"><a href="{U_TERMS}" class="copyright">{L_TERMS}</a> - <a href="{U_PRICACY}" class="copyright">{L_PRIVACY}</a></div>
</span></td>
|
Save, upload, and try again using EM...
| Dha wrote:
|
|
And last but not least, there a no icons before every link on my board. Only at downloads, chat and the album link there is an icon in front of it, the other don't have one.
|
The default look for the main menu in the guildwars template is no icons. But if you want it to be more like the subSilver template, they all can be added. That might simplify future MOD installs that add menu options if the subSilver and guildwars template menus were standardized. Before I read this, I thought I was helping by removing the extra new icons. You might have actually wanted just the opposite. Let me know...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/04/2007 9:35 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
Hi Nightrider,
Links mod is ok
About the country flag mod: I've made the changes in the install_en.txt file but there is one more issue. I should Copy root/install/db_update_en.php to install/db_update_en.php. Execute and delete after it has been run. In the 'root' file of the country mod files there is no db_update_en.php file but there is one in Country Flags MOD\contrib\install. I assume that i can take that one. It is asked to copy it to install/. So do i have to create a folder named 'install' into the root dir and copy the file there and afterwards to execute it i run http://www.guildwars.be/install/db_update_en.php?
The other onez, EZSite, i will try later on.
best regards,
Didier |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/04/2007 9:47 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
I just did as you said with the easy site mode and site messed up again.
Mod ran without any problems but after that i went to the index of the board and tried to return to the admin page and i get the error:
phpBB : Critical Error
Could not query site config information
DEBUG MODE
SQL Error : 1146 Table 'guildwars_be.phpbb_site_config' doesn't exist
SELECT * FROM phpbb_site_config
Line : 236
File : common.php
I have now taken the backed-up common.php file and replaced it with the one in the root folder and board is ok again. I still have a copy of the common.php file that has been modified by the easysite mod. |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/05/2007 3:22 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 3:52 PM
Location: St Pete, FL
|

|
|
|
|
 |
| Dha wrote:
|
|
So do i have to create a folder named 'install' into the root dir and copy the file there and afterwards to execute it i run http://www.guildwars.be/install/db_update_en.php?
|
Yes, you can create an install folder in the root of the forum folder, then upload the db_update_en.php file to it. Then you would run it from your browser using the path that you listed above. Your forum will be offline as long as the install folder is present, so you would want to delete the install folder immediately after running the file...
Another option would be to upload the db_update_en.txt file to the admin/mods/Country Flags MOD folder and install it using EM like any other MOD. All it will do is modify your database and not alter any additional forum files. This method avoids ever taking your site offline like the previous method does...
This second method is the least disruptive. However if you are prepared to run and delete the install/db_update_en.php from your browser as soon as it is uploadedt, your forum wouldn't be offline all that long, so the choice is up to you which works best for your community...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/05/2007 3:30 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 3:52 PM
Location: St Pete, FL
|

|
|
|
|
 |
| Dha wrote:
|
DEBUG MODE
SQL Error : 1146 Table 'guildwars_be.phpbb_site_config' doesn't exist
|
This is the key to understanding the nature of the problem. This MOD also modifies the database, like many others do. So before this MOD will work, the database needs to be updated. Many MOD authors include a DB Update file that can be run to update the database while others include it in the MOD script. Some MOD authors choose both methods to cover all bases...
If the MOD requires a DB Update and the SQL code is not included in the MOD script so that EM can update your database for you, it is best to run the included DB Update file first before installing the MOD. So it is good practice to read the MOD Author's notes, readme files, and DIY INSTRUCTIONS sections before installing any MOD so you can try to avoid disruptions after the MOD is installed...
So for the EasySite (The phpBB Site MOD) MOD, upload the db_update.php stored in the MOD's root folder to the root of your forum and run it from your browser. Unlike the Country Flags MOD, the db_update.php does not have to be in an install folder, so it will not disrupt your community while waiting to run it from your browser. The path to the file will look like this once it is uploaded to your forum root...
| Code:
|
|
http://www.guildwars.be/db_update.php
|
Once the database has been successfully updated, you can delete the db_update.php file from your forum root...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/07/2007 1:56 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
[quote="Nightrider"][quote="Dha"]So do i have to create a folder named 'install' into the root dir and copy the file there and afterwards to execute it i run http://www.guildwars.be/install/db_update_en.php?[/quote]
Yes, you can create an install folder in the root of the forum folder, then upload the db_update_en.php file to it. Then you would run it from your browser using the path that you listed above. Your forum will be offline as long as the install folder is present, so you would want to delete the install folder immediately after running the file...
Another option would be to upload the db_update_en.txt file to the admin/mods/Country Flags MOD folder and install it using EM like any other MOD. All it will do is modify your database and not alter any additional forum files. This method avoids ever taking your site offline like the previous method does...
This second method is the least disruptive. However if you are prepared to run and delete the install/db_update_en.php from your browser as soon as it is uploadedt, your forum wouldn't be offline all that long, so the choice is up to you which works best for your community...
[/quote]
Hi,
I tried this and the result was:
S;
Error: 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 'S' at line 1
E;
Error: 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 'E' at line 1
L;
Error: 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 'L' at line 1
E;
Error: 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 'E' at line 1
C;
Error: 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 'C' at line 1
T;
Error: 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 'T' at line 1
;
Error: Query was empty
(this is only a part of it, there were like 100 more ) |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/07/2007 2:14 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
[quote="Nightrider"]So for the EasySite (The phpBB Site MOD) MOD, upload the db_update.php stored in the MOD's root folder to the root of your forum and run it from your browser. Unlike the Country Flags MOD, the db_update.php does not have to be in an install folder, so it will not disrupt your community while waiting to run it from your browser. The path to the file will look like this once it is uploaded to your forum root...
[code]http://www.guildwars.be/db_update.php[/code]
Once the database has been successfully updated, you can delete the db_update.php file from your forum root...
[/quote]
This worked out fine, without any errors but the mod does not show up. It completed succesfully and i can see it in the installed mods (em history) but nothing in the admin panel. |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/07/2007 6:41 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 3:52 PM
Location: St Pete, FL
|

|
|
|
|
 |
Ok, I don't know what happened for you but I just reinstalled it along with using EM to update the database and it seems to be working correctly. I set a flag in Profile and can now view it in my View Profile page...
Unfortunately, when trying to view a topic, it causes mismatch collation problems ...
| Code:
|
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, ft.flag_name FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_flags ft WHERE p.topic_id = 713 AND pt.post_id = p.post_id AND u.user_id = p.poster_id AND ft.flag_image = u.user_from_flag ORDER BY p.post_time ASC LIMIT 0, 15
Line : 401
File : viewtopic.php
|
Since I have never seen this error before, I had to go searching for answers. It is late and I don't have time to read this now, but someone suggested that the answer is on this page somewhere:
http://www.datutorials.com/mysql/mysql_ref_manual_Charset.php
Here are more links on this error:
http://search.yahoo.com/search?p=illegal+mix+of+collations&sm=Yahoo%21 +Search&fr=FP-tab-web-t-297&toggle=1&cop=&ei=UTF-8
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Some problems installing mods (Country Flags, EZLinks and EZSite) |  |
Posted: 08/07/2007 7:00 AM |
|
|
|
|
|
| Sparrow |
| Posts |
18 |
| Word Cnt. |
1,912 |
| BDay |
Oct 25 |
| Sign |
Scorpio |
|
|
|
|
|
Joined: May 12, 2007
Local time: 7:52 PM
|

|
|
|
|
 |
omg didn't realise that i needed to be able to read chinese before i could install this mod
It is just not my knowledge area, i am a systems administrator but all of this is new for me  |
|
|
 |
 |
| Back to Top |
|
|
 | Information |  |
|