Portal XL Home

[patron]

i'dd download the sql table and update to the premod on a local tesdtsite (like xampp)
That's how i usually do it

[xxwhitelinexx]

i'dd download the sql table and update to the premod on a local tesdtsite (like xampp)
That's how i usually do it

Yep..
I'd did it..
And works..
But you must add some table like the new table as Portal Premod Xl 5 has..

[plykkegaard]

Hmm selecting [upgrade remove] in install_portal/index.php also removes table phpbb3_portal_config
I am getting an error atm

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'phpbb3.phpbb_portal_config' doesn't exist [1146]

SQL

SELECT config_value FROM phpbb_portal_config WHERE config_name = 'portal_version'

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install_portal/install_upgrade_premod.php
LINE: 123
CALL: dbal_mysqli->sql_query()

FILE: install_portal/index.php
LINE: 418
CALL: install_upgrade_premod->main()

FILE: install_portal/index.php
LINE: 290
CALL: module->load()

I can easily fix it on my test setup, just wondering if this is intended as I am not able use [upgrade premod] after [upgrade remove]?

[DaMysterious]

Hmm selecting [upgrade remove] in install_portal/index.php also removes table phpbb3_portal_config
I am getting an error atm

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'phpbb3.phpbb_portal_config' doesn't exist [1146]

SQL

SELECT config_value FROM phpbb_portal_config WHERE config_name = 'portal_version'

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install_portal/install_upgrade_premod.php
LINE: 123
CALL: dbal_mysqli->sql_query()

FILE: install_portal/index.php
LINE: 418
CALL: install_upgrade_premod->main()

FILE: install_portal/index.php
LINE: 290
CALL: module->load()

I can easily fix it on my test setup, just wondering if this is intended as I am not able use [upgrade premod] after [upgrade remove]?

I give it up .
Quote from this message.

Tab eight "UPGRADE REMOVE" is for removing those entries including them from the standard installation without leaving any remnant. Attention! Tab eight will de-install the portal premod completely even as tab four does for a Portal XL 5.0 Plain set-up.

[plykkegaard]

I give it up .
Quote from this message.

Tab eight "UPGRADE REMOVE" is for removing those entries including them from the standard installation without leaving any remnant. Attention! Tab eight will de-install the portal premod completely even as tab four does for a Portal XL 5.0 Plain set-up.

Ups sorry, I'll make sure to check with the documentation next time I mess something up

- Peter

[xxwhitelinexx]

Hey..
In this premod..
Why not have more crawler_linker.php?

[DaMysterious]

Why not have more crawler_linker.php?

Tskkkk, I simply forgot it .

A version for plain phpBB3 is here.

Distribution is updated!
If you like to have it afterwards, grab it below.

[xxwhitelinexx]

Why not have more crawler_linker.php?

Tskkkk, I simply forgot it .

A version for plain phpBB3 is here.

Distribution is updated!
If you like to have it afterwards, grab it below.

Okay thanks DM...

[plykkegaard]

Opps I go a division by zero after I have deleted a forum

Code: Select all

[phpBB Debug] PHP Notice: in file /portal/block/stat_adv.php on line 309: Division by zero

The forum I deleted was the "standard" forum which is created during install

I will see if I can find the problem

I made this correction in stat_adv.php for the old portal version back in september as you'll get the division by zero on a clean forum (no topics at all)

Code: Select all

$topics_per_day = ($$board_days == 0)  ? 0 : round($total_topics / $board_days,   0);
$posts_per_day = ($board_days == 0)  ? 0 : round($total_posts  / $board_days,   0);
$users_per_day = ($board_days == 0)  ? 0 : round($total_users  / $board_days,   0);
$topics_per_user = ($total_users == 0)  ? 0 : round($total_topics / $total_users,  0);
$posts_per_user = ($total_users == 0)  ? 0 : round($total_posts  / $total_users,  0);
$posts_per_topic = ($total_topics == 0) ? 0 : round($total_posts  / $total_topics, 0); 

It was not working correctly after topics were added and I reverted the changes a week later
Original code:

Code: Select all

$topics_per_day = round($total_topics / $board_days, 0);
$posts_per_day = round($total_posts / $board_days, 0);
$users_per_day = round($total_users / $board_days, 0);
$topics_per_user = round($total_topics / $total_users, 0);
$posts_per_user = round($total_posts / $total_users, 0);
$posts_per_topic = round($total_posts  / $total_topics, 0); 

rgds/Peter

[DaMysterious]

Mmmm, try this

Code: Select all

$topics_per_day = ($total_users == 0) ? 0 : round($total_topics / $board_days, 0);
$posts_per_day = ($total_users == 0) ? 0 : round($total_posts  / $board_days, 0);
$users_per_day = ($total_users == 0) ? 0 : round($total_users  / $board_days, 0);
$topics_per_user = ($total_users == 0) ? 0 : round($total_topics / $total_users, 0);
$posts_per_user = ($total_users == 0) ? 0 : round($total_posts  / $total_users, 0);
$posts_per_topic = ($total_topics == 0) ? 0 : round($total_posts  / $total_topics, 0);