[SOLVED]phpbb to Integramod Update...

[napukjon]

Upgraded my forum back to Integramod....followed the instructions, and seemed to work fine. Getting Error messages when im not logged in saying files are missing, like some for the Mini Cal, and a block for the forum.

When i log in, it says as usual asking me to fill in information as its my first visit since the upgrade, which is all fine and dandy, but when i click any link it takes me back to that page, and doesnt let me go any further.

This is the error message i get when logged out looking at the forum...

Warning: portal_parse_blocks(): Unable to access ./blocks/blocks_imp_forum.php in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(./blocks/blocks_imp_forum.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(): Unable to access ./blocks/blocks_imp_forum.php in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(./blocks/blocks_imp_forum.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(): Unable to access ./blocks/blocks_imp_forum.php in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(./blocks/blocks_imp_forum.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Warning: portal_parse_blocks(): Failed opening './blocks/blocks_imp_forum.php' for inclusion (include_path='.:/usr/local/psa/apache/share/pear') in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions_portal.php on line 233

Any help would be greatly appreciated!

[Helter]

not sure what forum_block is, but it was appearantly installed on your old forum db. Try to upload it from your old forum to your new one. Be sure to upload the php files for it also

[napukjon]

Ok cheers, will go have a look!

[napukjon]

Code: Select all

include($phpbb_root_path . 'blocks/' . $block_info[$b_counter]['blockfile'] . '.' . $phpEx);

Well thats the line its on about...and i didnt have a portal on m old forum or database...just XS Nav Menu!

[napukjon]

im giving it another go, to see if it was something that i had done wrong!

[napukjon]

Still even when i put a fresh phpbb in, i cant get passed the security questions bit....When i click on them or go to go into ym profile, it stays on that page....the URL changes, just not the page....cant even get into ACP

Any help would be greatly appeciated!

[Helter]

just for clarification..are you getting through the install, an getting stuck when you are asked to update your profile? or are you getting stuck in the install when your aske to name the security fields?

[napukjon]

Im getting stuck when asked to update my profile. It wont let me go any further...install works fine....just when i finish the install, and it asked me to fill in the required fields, it wont let me go to my profile or any where....and Also says when i log out and go to the forum that mini_cal.php isnt there, but it is.

[napukjon]

I entered the data it was asking for manually into the Database, and im now in....

Only other problem i have is that its now saying it cant find mini_cal.php or mini_cal2.php

[napukjon]

Right.... <img> Managed to get that problem fixed...but now i dont know what to do about the profile fields thing. My members wont be able to insert there data like i have....any suggestions

[napukjon]

Also getting these error messages on my portal page

Warning: Division by zero in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions.php on line 1285

Warning: Division by zero in /usr/local/psa/home/vhosts/napuk.co.uk/subdomains/community/httpdocs/includes/functions.php on line 1292

aswell as this when i go to look at peoples profiles...

phpBB : Critical Error

Error Getting Photo Information!

DEBUG MODE

SQL Error : 1064 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 '' at line 1

[Helter]

what is your php version?
I cannot re-create any of your error messages.

it looks like your running php 4.4.2. so im stumped. Did you completely overwrite all your files with the ones from the update zip and set all chmods correctly? Im guessing it may be a chmod issue, or you have existing db fields, with incompatible data in them. the insert command will error if there is already existing data. If this is the case, Ill see if Mike has time to look and see if we can replace some of the "inserts" with "updates" in the update scripts

[napukjon]

Yeah, did everything as it said, uploaded and overwrote as instructed.... I did have some other tables in my DB from my previous site, and this i think brought up errors, but one im not familiar with although have seen...

It said something along the lines of

Error... Column does not match count at row 1

Or something along those lines....

[Helter]

you can run the updates again and look for that error. Of coarse, you will recieve alot of table already exists errors, but those you can ignore.

[napukjon]

Ok will have a go at it now!

[napukjon]

# INSERT INTO `phpbb_extensions` VALUES (7, 2, 'gtar', '')
+++ Error: Duplicate entry '7' for key 1

# INSERT INTO `phpbb_extensions` VALUES (8, 2, 'gz', '')
+++ Error: Duplicate entry '8' for key 1

# INSERT INTO `phpbb_extensions` VALUES (9, 2, 'tar', '')
+++ Error: Duplicate entry '9' for key 1

# INSERT INTO `phpbb_extensions` VALUES (10, 2, 'zip', '')
+++ Error: Duplicate entry '10' for key 1

# INSERT INTO `phpbb_extensions` VALUES (11, 2, 'rar', '')
+++ Error: Duplicate entry '11' for key 1

# INSERT INTO `phpbb_extensions` VALUES (12, 2, 'ace', '')
+++ Error: Duplicate entry '12' for key 1

# INSERT INTO `phpbb_extensions` VALUES (13, 3, 'txt', '')
+++ Error: Duplicate entry '13' for key 1

# INSERT INTO `phpbb_extensions` VALUES (14, 3, 'c', '')
+++ Error: Duplicate entry '14' for key 1

# INSERT INTO `phpbb_extensions` VALUES (15, 3, 'h', '')
+++ Error: Duplicate entry '15' for key 1

# INSERT INTO `phpbb_extensions` VALUES (16, 3, 'cpp', '')
+++ Error: Duplicate entry '16' for key 1

# INSERT INTO `phpbb_extensions` VALUES (17, 3, 'hpp', '')
+++ Error: Duplicate entry '17' for key 1

# INSERT INTO `phpbb_extensions` VALUES (18, 3, 'diz', '')
+++ Error: Duplicate entry '18' for key 1

# INSERT INTO `phpbb_extensions` VALUES (19, 4, 'xls', '')
+++ Error: Duplicate entry '19' for key 1

# INSERT INTO `phpbb_extensions` VALUES (20, 4, 'doc', '')
+++ Error: Duplicate entry '20' for key 1

# INSERT INTO `phpbb_extensions` VALUES (21, 4, 'dot', '')
+++ Error: Duplicate entry '21' for key 1

# INSERT INTO `phpbb_extensions` VALUES (22, 4, 'pdf', '')
+++ Error: Duplicate entry '22' for key 1

Just wondering if these ok, and due to the fact i already had the tables?

# INSERT INTO `phpbb_config` VALUES ('points_reply', '1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('points_topic', '2')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('points_post', '1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('points_donate', '1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('points_name', 'Points')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('points_user_group_auth_ids', '')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('prune_shouts', '0')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('allow_news', '1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_item_trim', '0')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_title_trim', '0')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_item_num', '10')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_path', 'images/news')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('allow_rss', '1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_rss_desc', '')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_rss_language', 'en_us')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('news_rss_ttl', '60')
+++ Error: Column count doesn't match value count at row 1

And this is what i was getting i didnt understand, but there were lots more of them.

[napukjon]

Still getting stuck when being asked for security questions to be filled in.

[Helter]

the first set of errors are to be expected since your re-running your querries, the second set though are deal breakers "Column count doesn't match*" errors means that you must have installed a mod that has altered the tables somehow. I dont know nearly enough db syntax to tech this second hand. If you would like, you can pm me with a link to a copy of your db and Ill try to edit it

[napukjon]

Sent PM <img>

[napukjon]

Was just wondering if there was any progress on this!? <img>

[Helter]

sorry, Im not at home. Im on a business trip till thurs and this pos comp wont run most of my software. Ill look at it as soon as I get home

[napukjon]

Im gonna go and try and have a look at the database my self see whats there that shouldnt be, and if i can fix it up <img>

[napukjon]

This is starting to get right on my nerves now! I always get stuck at the same spot!

[napukjon]

Managed to get this fixed and sorted....finally...dont know what i did wrong, must have been something to do with my database cocking things up!