IntegraMOD

Posted: **Fri Jul 07, 2006 11:13 pm**

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!

Posted: **Fri Jul 07, 2006 11:42 pm**

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

Posted: **Fri Jul 07, 2006 11:52 pm**

Ok cheers, will go have a look!

Posted: **Sat Jul 08, 2006 12:08 am**

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!

Posted: **Sat Jul 08, 2006 1:49 am**

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

Posted: **Sat Jul 08, 2006 10:38 am**

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!

Posted: **Sat Jul 08, 2006 3:19 pm**

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?

Posted: **Sun Jul 09, 2006 12:58 am**

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.

Posted: **Sun Jul 09, 2006 1:54 am**

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

Posted: **Sun Jul 09, 2006 1:59 am**

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

Posted: **Sun Jul 09, 2006 2:08 am**

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

Posted: **Mon Jul 10, 2006 4:24 pm**

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

Posted: **Tue Jul 11, 2006 12:58 am**

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....

Posted: **Tue Jul 11, 2006 1:17 am**

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.

Posted: **Tue Jul 11, 2006 1:23 am**

Ok will have a go at it now!

Posted: **Tue Jul 11, 2006 1:28 am**

# 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.

Posted: **Tue Jul 11, 2006 3:36 am**

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

Posted: **Tue Jul 11, 2006 9:11 pm**

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

Posted: **Sun Jul 16, 2006 2:27 am**

Sent PM <img>

Posted: **Tue Jul 18, 2006 1:09 am**

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

Posted: **Tue Jul 18, 2006 1:28 am**

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

Posted: **Wed Jul 26, 2006 12:49 am**

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>

Posted: **Wed Jul 26, 2006 2:50 am**

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

Posted: **Fri Aug 04, 2006 6:28 am**

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!

IntegraMOD

[SOLVED]phpbb to Integramod Update...

[SOLVED]phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...

Re: phpbb to Integramod Update...