Pagina 1 van 1

SQL errors, krijg MOD niet live

Geplaatst: 14 feb 2008, 21:32
door rickieizfazt
Na met succes de lastRSS aggregator in mijn testsite te hebben geinstalleerd - die alleen in een bepaald forum zichtbaar is - http://tjoogledotcom.freeweb7.com/viewtopic.php?t=3&f=2 en ergens anders op het board in een forum niet http://tjoogledotcom.freeweb7.com/viewforum.php?f=3 probeerde ik dezelfde MOD live te installeren.

Helaas krijg ik een verzameling SQL errors in een fraai roodwit scherm en is het board onbereikbaar. De errors zeiden mij weinig en ik heb de wijzigingen in de 4 php files zeer snel even ongedaan gemaakt waardoor ik in ieder geval up ben met de site. In ACP heb ik de mods uitgezet.

In afwijking op de MOD heb ik de RSS alleen aan staan in de topics van forum 73 (viewtopic_body) en nergens anders. De hogere gedachte hier achter is dat 73 grappige youtube videos laat zien en juist deze bezoekers misschien ook wel geinteresseerd zijn in mijn eigen RSS feed over grappige foto's en grappig nieuws.

In het live forum heb ik meer rechten van de host dan in het testforum dus het is voor mij een volledig raadsel wat er verkeerd gaat. Alle files staan (nog steeds) op de goede plaats, in ACP kunnen de mods worden aangezet (staan al op de goede feed, als ie dat heeft vastgehouden) en met phpMyadmin kan in de database worden gekeken. Dat heb ik gedaan en het ziet er daar prachtig uit met geweldig veel mogelijkheden maar wat er mis is kan ik helaas niet zien.

Dus alleen deze code gaat - in afwijking van de MOD - in viewtopic_body en niets in index_body en niets in viewforum_body. Maar daar zit vanzelfsprekend het probleem niet.

Code: Selecteer alles

<!-- IF FORUM_ID == '73' -->
  <!-- IF LASTRSS_ENABLED -->
  <!-- INCLUDE lastrss.html -->
  <!-- ENDIF --> 
<!-- ENDIF -->
dit is de MOD, de schrijver ervan geeft geen support meer sinds de laatste aanpassing voor 4 maanden, zo valt ergens, ik meen op startrek, te lezen

Code: Selecteer alles

Installation Instructions for 'lastRSS agregator' Version 2.0.BETA2
Select Language:  English  
About this MOD
Title:
lastRSS agregator

Description:
This mod allows to show news from other websites through their RSS channel on index, viewforum and viewtopic.

Version:
2.0.BETA2

Installation Level:
Easy

Installation Time:
~10minutes


Files to Edit
includes/constants.php, 
index.php, 
viewforum.php, 
viewtopic.php 
Included Files
root/adm/style/acp_lastrss.html, 
root/adm/style/acp_lastrss_feeds.html, 
root/includes/class_lastrss.php, 
root/includes/functions_lastrss.php, 
root/includes/acp/acp_lastrss.php, 
root/includes/acp/info/acp_lastrss.php, 
root/images/lastrss.png, 
root/language/en/mods/lastrss.php, 
root/language/en/mods/info_acp_lastrss.php 

--------------------------------------------------------------------------------

Disclaimer
For security purposes, please check: http://www.phpbb.com/mods/ for the latest version of this MOD. Downloading this MOD from other sites could cause malicious code to enter into your phpBB Forum. As such, phpBB will not offer support for MODs not offered in our MODs database, located at: http://www.phpbb.com/mods/

Author Notes
This mod requires for downloading data at least FOPEN or CURL php functions enabled on your server. You can choose which one to use through ACP. LastRSS agregator is RSS parser class originally written by Vojtech Semecky http://lastrss.oslab.net 

MOD History
2007-11-27- Version 2.0.BETA2

Minor bugfixes (like problems with Safari, fopen and curl settings and errors showing, iconv unavailibility and some more).

2007-11-13- Version 2.0.BETA1

Almost totaly rewrited code.

Both FOPEN and CURL functions are supported now

Feeds data are stored in database

Added ACP management

Added support for templating

Added support for language files

2007-02-09- Version 1.0.1

Some minor changes for phpBB3 coding guidelines

2007-02-08- Version 1.0.0

Initial phpBB3 release

License
This MOD has been licensed under the following license:

http://opensource.org/licenses/gpl-license.php GNU General Public License v2

Other Notes
Before adding this MOD to your forum, you should back up all files related to this MOD

This MOD was designed for phpBB3.0.0and may not function as stated on other phpBB versions. MODs for phpBB3.0 will not work on phpBB2.0 and vice versa.

English Support
English support can be obtained at http://www.phpbb.com/mods/ for released MODs.

 
--------------------------------------------------------------------------------
File Copy

Copy: root/adm/style/acp_lastrss.html 
To: adm/style/acp_lastrss.html 

Copy: root/adm/style/acp_lastrss_feeds.html 
To: adm/style/acp_lastrss_feeds.html 

Copy: root/includes/class_lastrss.php 
To: includes/class_lastrss.php 

Copy: root/includes/functions_lastrss.php 
To: includes/functions_lastrss.php 

Copy: root/includes/acp/acp_lastrss.php 
To: includes/acp/acp_lastrss.php 

Copy: root/includes/acp/info/acp_lastrss.php 
To: includes/acp/info/acp_lastrss.php 

Copy: root/images/lastrss.png 
To: images/lastrss.png 

Copy: root/language/en/mods/lastrss.php 
To: language/en/mods/lastrss.php 

Copy: root/language/en/mods/info_acp_lastrss.php 
To: language/en/mods/info_acp_lastrss.php 
Edits
s↑↓
Use your keyboard to navigate the code boxes. You may also hit 's' on your keyboard to go to the first code box.

Open: includes/constants.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
// Additional tables
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
//lastrss mod begin
define('LASTRSS_RSSLIST_TABLE',	   $table_prefix . 'lastrss_rsslist');
define('LASTRSS_RSSCONTENT_TABLE', $table_prefix . 'lastrss_rsscontent');
//lastrss mod end 
Open: index.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('viewforum');
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
//lastrss mod begin
include ($phpbb_root_path . 'includes/functions_lastrss.'.$phpEx);
//lastrss mod end
        
Open: viewforum.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
// Not postable forum or showing active topics?
if (!($forum_data['forum_type'] == FORUM_POST || (($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) && $forum_data['forum_type'] == FORUM_CAT)))
{
	page_footer();
} 
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.

Code: Select All
//lastrss mod begin
include ($phpbb_root_path . 'includes/functions_lastrss.'.$phpEx);
//lastrss mod end
        
Open: viewtopic.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
page_footer();
        
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.

Code: Select All
//lastrss mod begin
include ($phpbb_root_path . 'includes/functions_lastrss.'.$phpEx);
//lastrss mod end
        
DIY Instructions
These are manual instructions that cannot be performed automatically. You should follow these instructions carefully.

Code: Select All
    After editing all templates, copy file contrib/install.php to contrib/install.php.
    After running the install.php script you can delete the contrib directory.
    It´s possible that you´ll need to refresh your templates manually from ACP.
    
    Navigate to:
    Administration Control Panel > System > Module Management :: Administration Control Panel > .MODs
    Select “lastRSS configuration” from the Module drop-down menu and click “Go”.
    Then click “Enable” on the Module.
    Select “lastRSS management” from the Module drop-down menu and click “Go”.
    Then click “Enable” on the Module.
    Browse to ACP > .MODs and manage the lastRSS agregator feeds and enable lastRSS agregator 

--------------------------------------------------------------------------------

Save all files. End of MOD.
You have finished the installation for this MOD. Upload all changed files to your website. If the installation went bad, simply restore your backed up files.
 
MOD UA XSLT File Copyright © 2007 The phpBB Group, this MOD is copyright to the authors listed above.

Re: SQL errors, krijg MOD niet live

Geplaatst: 15 feb 2008, 13:31
door Derky
Heb je dit ook opnieuw gedaan op de database van het live forum? ;)

Code: Selecteer alles

After editing all templates, copy file contrib/install.php to contrib/install.php.
    After running the install.php script you can delete the contrib directory.
    It´s possible that you´ll need to refresh your templates manually from ACP.
Verplaatst van phpBB.nl Service
- Derky

Re: SQL errors, krijg MOD niet live

Geplaatst: 15 feb 2008, 19:01
door rickieizfazt
Derky schreef:Heb je dit ook opnieuw gedaan op de database van het live forum? ;)

Code: Selecteer alles

After editing all templates, copy file contrib/install.php to contrib/install.php.
    After running the install.php script you can delete the contrib directory.
    It´s possible that you´ll need to refresh your templates manually from ACP.
Yes I did, ik heb de complete mod daar opnieuw uitgevoerd. Als ik iets wijzig voer ik het uit op test en nummer ik de wijzigingen in de uitdraai van de MOD. Vervolgens voer ik dezelfde stappen uit live en dezelfde volgorde met twee oogkleppen voor en zonder verder iets te wijzigen.