Help - upgrading from phpBB+CategoriesHierarchy+IM portal+TC

[DarkRaver]

Hi

i'm trying to update my board from phpBB 2.0.22+CategoriesHierarchy+IM portal+Topic Calendar to corrent IM 1.4.1

Find some problem in the way :

final report after runing the update .script

Code: Select all

 Information  Database type    ]

Then the problems began:

[code]  Could not obtain bot data.  DEBUG MODE  SQL Error ]

Solved with table drop and created it again.
Then new erros come :S

[code]  Warning]: failed to open stream: No such file or directory in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 80  Warning: main() [function.include]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 80  Fatal error: Call to undefined function: getminicalforumsauth() in /home/mydarcom/public_html/Novo/mods/netclectic/mini_cal/mini_cal.php on line 83  

Was trying to run the fixed found [url=http]HERE[/url]
BUT
when i try to login i found another problem all accounts were locked up, so i found another post [url=http]HERE[/url] to unlock the account and nothing solved ... so i made another search and try to change data by hand using phpmyadmin i changed the phpBBSecurity_answer and phpBBSecurity_question and it seams to be working since i get "Thank you for unlocking your account. You may now login." but the login keep locked and don't let me work with anything,

Can anyone help me

Tks in advanced

[DarkRaver]

No 1 can help ?

[Helter]

what version of CH are you using?

[DarkRaver]

The versions i use:

à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¢ Categories hierarchy - 2.1.6d
à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¢ Topic calendar CH edition - 2.2.2
à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¢ phpBB - 2.0.22

[Helter]

your version of CH is one of the newer generation versions that almost re-write phpbb. Teelk might have more info on your version as he is working on an upgrade for users with a similar version. I believe that to use the current upgrade .script, you would first need to run an uninstall .script (if one exists) so that your tables conform to phpbb. Be aware that if you run it, you will loose your current forum structure.

[DarkRaver]

:S

that could be a real problem

I've got 5.000+ post and a lot of subcategories ... the downgrade to simple phpBB it not an option for me ... if there where other way to save the main struture of the forum + posts + users but all the tries didn't work the closest i get was with 140

[DarkRaver]

Once again i've try other way to upgrade my board ... but other problems came a bit diferent from the ones before ... i've upgrade it to 140 instead.

Now at least i can login to my board ...

Errors during db update

Code: Select all

CREATE TABLE `phpbb_shout` ( `shout_id` mediumint(8) unsigned NOT NULL auto_increment, `shout_username` varchar(25) NOT NULL default '', `shout_user_id` mediumint(8) NOT NULL default '0', `shout_group_id` mediumint(8) NOT NULL default '0', `shout_session_time` int(11) NOT NULL default '0', `shout_ip` varchar(8) NOT NULL default '', `shout_text` text NOT NULL, `shout_active` mediumint(8) NOT NULL default '0', `enable_bbcode` tinyint(1) NOT NULL default '0', `enable_html` tinyint(1) NOT NULL default '0', `enable_smilies` tinyint(1) NOT NULL default '0', `enable_sig` tinyint(1) NOT NULL default '0', `shout_bbcode_uid` varchar(10) NOT NULL default '', KEY `shout_id` (`shout_id`) ) TYPE=MyISAM+++ Error]

[code]Progress ]

And all seams almost right

so after the install i got some problems very close to the others before, and with the same "blocks" mini cal.

[code]     Warning]: failed to open stream: No such file or directory in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal2.php on line 82  Warning: main() [function.include]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal2.php on line 82  Fatal error: Call to undefined function: getminicalforumsauth() in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal2.php on line 85

other problem with moving the foruns to other place ...

[code]Couldn't update forums/categories table  DEBUG MODE  SQL Error ]

other problem i detected is with the 2ÂÂÂ º subcategorie's that it was ignored and treated like it was main

Ex.
Main
|
|- Sector 1
| |- Sub-sector 1
|
|- Sector 2
| |- sub-sector 1
| |- sub-sector 2
| |- Sub-Sub-Sector 1 (a)
| |- Sub-Sub-Sector 2 (a)
| |- Sub-Sub-Sub-Sector (b)

all main categories and 1ÂÂÂ º sub forum are ok but the 2ÂÂÂ ºand 3ÂÂÂ º subsector (a & b) where concidered as main so i get

Main
|
|- Sub-Sub-Sector 1 (a)
|- Sub-Sub-Sector 2 (a)
|- Sub-Sub-Sub-Sector (b)
|- Sector 1
| |- Sub-sector 1
|
|- Sector 2
|- sub-sector 1
|- sub-sector 2

[Frost]

Errors during db update

If they already exist, or dupe entries, you would have to pick and choose which ones you wouldn't lose information and change sql instructions to drop table and then add one by one for every error, and then, go and manually add new columns, key names, etc after that for ones you couldnt just drop and re-add. (Reason update .scripts are so hard) ((! and i do not suggest trying it if you don't know what you're doing !))

And all seams almost right

so after the install i got some problems very close to the others before, and with the same "blocks" mini cal.

The division by zero error means that in one of your mods, hacks, or in something that's added by the upgrade has a setting (usually a setting in the ACP) on "0" when it has to be at 1 or higher. Some can be on 0 and thus being "infinite, all, etc" but in this case it has to be set to a 1 or higher.

We could figure this one out easier if we knew what the code surrounding line 1311 of /includes/functions.php was, maybe it will tell you what mod is causing the error. Post the area around line 1311 of /includes/functions.php here.

other problem with moving the foruns to other place ...

It looks like your db didn't get updated here. If you used the update .script made for phpbb -> integramod141 on your imod 140 board this is probably why you got that error, and will prob end up getting more.

other problem i detected is with the 2ÂÂÂ º subcategorie's that it was ignored and treated like it was main

Yep. As HelterSkelter said the CH 2.1.6d and several previous versions are almost a complete rewrite of phpbb code. You can't even recognize it anymore. The 2 are no where near close so you will undoubtedly get errors, and lose a lot of your forum structure. To some the new CH mod's forum structure is better but the fact that his mod isn't compatible with barely anything kind of renders it useless to most phpbb users.

So basically you would have to do as HelterSkelter said and .. "Undo! what horrible terrors new CH mod has brought apon you [/church preacher guy] to get this to work right...

But I tried to help with the errors best I could, Teelk is the god when it comes to upgrading and sql

[DarkRaver]

ok 1 problem solved so far

and no i just run the 5 file (db_update) and only made de update to 140 ...

and where are the line you request

[Frost]

Ok.. 2 to go

The error is somewhere with Profile Control Panel
I don't ever mess with this so you'd have to ask someone who does. There is a member here who is very good with it but I can't remember his name. He's like the pcp god

But, for now you can try... (This is in imod 141, don't know if it's the same in 140. Either way you can look through PCP and have a look, remember look for settings set to 0 that need something there)

Go into ACP > P.C.P. > PCP Wizard > Validate PCP Files

And click on "Click here to automatically correct your PCP Files."

[DarkRaver]

ok i've run the pcp wizard and it goes well now other error apears

Code: Select all

    Warning]: failed to open stream: No such file or directory in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal.php on line 80  Warning: main() [function.include]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal.php on line 80  Fatal error: Call to undefined function: getminicalforumsauth() in /home/mydarcom/public_html/Teste/rato/mods/netclectic/mini_cal/mini_cal.php on line 83

[Zappa]

OK for the last error you could try the .script included in [url=http]this thread[/url] at the bottom. Kind of worked for me, I caouldn't logon but I looked at the .script and changed the entries manually and that error disapeared.

Hope it usefull...

/Zappa

[DarkRaver]

It solved some but i keep

[code]Warning]

i've tryed the pcp wizard and didn't worked

[Frost]

Hmm, attach the whole includes/functions.php here and let me look at it

In the meantime try going through the forums ACP and check all settings like you would when setting the board up. Look at everything and all the places you see the "0" make sure to the left where it says what the function does, that it says it's ok to be at 0

[DarkRaver]

ok here go the file

[Frost]

I merged your file with a fresh copy from IM 141 and it is not the same

Yours is compressed (meaning less line-breaks) as well as several instances of extra security related additions as well as additional mod inserts including austin's activity mod.

When you upgraded, did the upgrade .script come with a new functions.php?
If so you need to use the file it came with, unaltered until you can get your board free of errors

I have never looked at the update .script so I don't know but if it's an upgrade to the current IM 141, my guess is that you could simply download a fresh copy of IM 141 and steal the functions.php from it.

And of course do backups first.

Also should wait and get an admin's approval of this suggestion before trying.

[DarkRaver]

ok ...

now i'm trying to run a slow upgrade to the database tryingo to manualy add the fields that i get error on upgrade <img> ... i'll keep report on progress

[DarkRaver]

Ok finaly i made it during instalation

Code: Select all

INSERT INTO `phpbb_config` (`config_name`, `config_value`, `config_static`) VALUES ('points_reply', '1', '0'),('points_topic', '2', '0'),('points_post', '1', '0'),('points_donate', '1', '0') ,('points_name', 'Points', '0') ,('points_user_group_auth_ids', '', '0') ,('prune_shouts', '0', '0') ,('allow_news', '1', '0') ,('news_item_trim', '0', '0') ,('news_title_trim', '0', '0') ,('news_item_num', '10', '0') ,('news_path', 'images/news', '0') ,('allow_rss', '1', '0') ,('news_rss_desc', '', '0') ,('news_rss_language', 'en_us', '0') ,('news_rss_ttl', '60', '0') ,('news_rss_cat', '', '0') ,('news_rss_image', '', '0') ,('news_rss_image_desc', '', '0') ,   ('news_rss_item_count', '15', '0') ,   ('news_rss_show_abstract', '1', '0') ,   ('news_base_url', '', '0') ,   ('news_index_file', 'news_index.php', '0') ,   ('announcement_date_display', '1', '0') ,   ('announcement_date_display_over', '0', '0') ,   ('announcement_display', '1', '0') ,   ('announcement_display_over', '0', '0') ,   ('announcement_display_forum', '1', '0') ,   ('announcement_display_forum_over', '0', '0') ,   ('announcement_split', '1', '0') ,   ('announcement_split_over', '0', '0') ,   ('announcement_forum', '1', '0') ,   ('announcement_forum_over', '0', '0') ,   ('announcement_duration', '7', '0') ,   ('announcement_prune_strategy', '0', '0') ,   ('calendar_display_open', '0', '0') ,   ('calendar_display_open_over', '0', '0') ,   ('calendar_header_cells', '7', '0') ,   ('calendar_header_cells_over', '0', '0') ,   ('calendar_week_start', '1', '0') ,   ('calendar_week_start_over', '0', '0') ,   ('calendar_title_length', '30', '0') ,   ('calendar_text_length', '200', '0') ,   ('calendar_nb_row', '5', '0') ,   ('calendar_nb_row_over', '0', '0') ,   ('calendar_birthday', '1', '0') ,   ('calendar_birthday_over', '0', '0') ,   ('calendar_forum', '1', '0') ,   ('calendar_forum_over', '0', '0') ,   ('sub_forum', '1', '0') ,   ('sub_forum_over', '0', '0') ,   ('split_cat', '1', '0') ,   ('split_cat_over', '0', '0') ,   ('last_topic_title', '1', '0') ,   ('last_topic_title_over', '0', '0') ,   ('last_topic_title_length', '24', '0') ,   ('sub_level_links', '2', '0') ,   ('sub_level_links_over', '0', '0') ,   ('display_viewonline', '2', '0') ,   ('display_viewonline_over', '0', '0') ,   ('max_posts', '1', '0') ,   ('max_topics', '1', '0') ,   ('max_users', '1', '0') ,   ('last_topics_from_started', '3', '0') ,   ('last_topics_from_started_over', '0', '0') ,   ('last_topics_from_replied', '3', '0') ,   ('last_topics_from_replied_over', '0', '0') ,   ('last_topics_from_ended', '3', '0') ,   ('last_topics_from_ended_over', '0', '0') ,   ('last_topics_from_split', '1', '0') ,   ('last_topics_from_split_over', '0', '0') ,   ('last_topics_from_forum', '1', '0') ,   ('last_topics_from_forum_over', '0', '0') ,   ('default_lang_over', '0', '0') ,   ('default_style_over', '0', '0') ,   ('board_timezone_over', '0', '0') ,   ('summer_time_user', '', '0') ,   ('summer_time_user_over', '0', '0') ,   ('default_dateformat_over', '0', '0') ,   ('allow_viewonline', '', '0') ,   ('allow_viewonline_over', '0', '0') ,   ('allow_viewemail', '', '0') ,   ('allow_viewemail_over', '0', '0') ,   ('allow_viewpm', '', '0') ,   ('allow_viewpm_over', '0', '0') ,   ('allow_viewwebsite', '', '0') ,   ('allow_viewwebsite_over', '0', '0') ,   ('allow_viewmessengers', '', '0') ,   ('allow_viewmessengers_over', '0', '0') ,   ('allow_viewreal', '', '0') ,   ('allow_viewreal_over', '0', '0') ,   ('topic_notify', '', '0') ,   ('topic_notify_over', '0', '0') ,   ('pm_notify', '', '0') ,   ('pm_notify_over', '0', '0') ,   ('pm_popup', '', '0') ,   ('pm_popup_over', '0', '0') ,   ('notify_donation', '', '0') ,   ('notify_donation_over', '0', '0') ,   ('post_sig', '', '0') ,   ('post_sig_over', '0', '0') ,   ('post_bbcode', '', '0') ,   ('post_bbcode_over', '0', '0') ,   ('post_html', '', '0') ,   ('post_html_over', '0', '0') ,   ('post_smilies', '', '0') ,   ('post_smilies_over', '0', '0') ,   ('read_viewavatar', '', '0') ,   ('read_viewavatar_over', '0', '0') ,   ('read_viewsig', '', '0') ,   ('read_viewsig_over', '0', '0') ,   ('read_viewimg', '', '0') ,   ('read_viewimg_over', '0', '0') ,   ('summer_time', '1', '0') ,   ('summer_time_over', '0', '0') ,   ('robotic_register', '1', '0') ,   ('robotic_register_over', '0', '0') ,   ('forum_rules', '', '0') ,   ('forum_rules_over', '0', '0') ,   ('buddy_friend_display', '', '0') ,   ('buddy_friend_display_over', '0', '0') ,   ('buddy_ignore_display', '', '0') ,   ('buddy_ignore_display_over', '0', '0') ,   ('buddy_friend_of_display', '', '0') ,   ('buddy_friend_of_display_over', '0', '0') ,   ('buddy_ignored_by_display', '', '0') ,   ('buddy_ignored_by_display_over', '0', '0') ,   ('privmsgs_per_page', '5', '0') ,   ('privmsgs_per_page_over', '0', '0') ,   ('topics_watched_per_page', '15', '0') ,   ('topics_watched_per_page_over', '0', '0') ,   ('split_global_announce', '1', '0') ,   ('split_global_announce_over', '0', '0') ,   ('split_announce', '1', '0') ,   ('split_announce_over', '0', '0') ,   ('split_sticky', '1', '0') ,   ('split_sticky_over', '0', '0') ,   ('split_topic_split', '0', '0') ,   ('split_topic_split_over', '0', '0');  INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg', 'Upgrading the site...');INSERT INTO phpbb_config (config_name, config_value) VALUES ('integramod_version', '1.4.0' );UPDATE `phpbb_portal_config` SET `config_value` = '1' WHERE `phpbb_portal_config`.`id` =10 LIMIT 1 ;  INSERT INTO `phpbb_portal_config` (`config_name`, `config_value`) VALUES('md_except_forum_id', ''),('md_display_not_visit', '1'),('md_hours_track_users', '24'),('md_scroll_delay', '100'),('md_cat_id', '0'),('md_pics_number', '2'),('md_pics_sort', '0'),('md_pics_all', '0');    INSERT INTO phpbb_config (config_name, config_value) VALUES ('logo_image_path', 'images/logo');INSERT INTO phpbb_config (config_name, config_value) VALUES ('logo_image', 'phpbb2_logo2.png');INSERT INTO phpbb_config (config_name, config_value) VALUES ('logo_image_w', '504');INSERT INTO phpbb_config (config_name, config_value) VALUES ('logo_image_h', '110');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_calendar_version', 'TOPIC');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_limit', '10');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_days_ahead', '30');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_date_search', 'POSTS');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_link_class', 'gensmall');INSERT INTO phpbb_config (config_name, config_value) VALUES ('mini_cal_today_class', 'topicTitle');ALTER TABLE `phpbb_forums` ADD `auth_attachments` TINYINT( 2 ) NOT NULL DEFAULT '0' AFTER `auth_pollcreate`

and no error's apears for now <img> ...

The problem i got now is the users account, they are all blocked / banned and i can't unblock or unban them ... can any 1 give me an hit on this ?