Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

SOLVED - Missing SQL Tables After Upgrade From Phpbb2

Reply to topic

 

Rene
Quote
Posts: 124
Tue 06 Nov, 2007 13:40
Subject: SOLVED - Missing SQL Tables After Upgrade From Phpbb2
HI,

I just upgraded my phpbb2 to IP as described in the FAQ.

When I visit my site now, I get these errors.

Code: [Download] [Hide] [Select]
Critical Error!
message_die() was called multiple times.
Error #1

Line : 60
File : /var/www/vhosts/bauwagencrew.net/httpdocs/ip/ctracker/classes/class_ct_database.php
SQL : SELECT * FROM phpbb_ctracker_config
Error #2
Could not obtain ban information

Line : 158
File : /var/www/vhosts/bauwagencrew.net/httpdocs/ip/includes/sessions.php
SQL : SELECT ban_ip, ban_userid, ban_email, ban_email, ban_expire_time, ban_priv_reason, ban_pub_reason_mode, ban_pub_reason FROM phpbb_banlist WHERE ban_ip IN ('91e42138', '91e421ff', '91e4ffff', '91ffffff') OR ban_userid = -1


In my DB are only 41 Tables. Whats the problem here? I think the update_to_ip.php has only created a few tables but not all. -

Last edited by Rene on Tue 06 Nov, 2007 17:02; edited 1 time in total
Profile PM  
Rene
Quote
Posts: 124
Tue 06 Nov, 2007 16:09
Subject: Re: Missing SQL Tables After Upgrade From Phpbb2
I made a new fresh IP installation and imported an backup of my old phpbb2 database as described by novice in this thread (last post)

http://www.icyphoenix.com/viewtopic.php?t=2804

Now, the error is: :(

Code: [Download] [Hide] [Select]
SQL Error : 1054 Unknown column 'ban_expire_time' in 'field list'

SELECT ban_ip, ban_userid, ban_email, ban_email, ban_expire_time, ban_priv_reason, ban_pub_reason_mode, ban_pub_reason FROM ip_banlist WHERE ban_ip IN ('91e42138', '91e421ff', '91e4ffff', '91ffffff') OR ban_userid = -1

Line : 158
File : sessions.php


Does anyone know whats the problem here? I only imported phpbb2 backup via phpmyadmin.

EDIT: The problem described here is not solved realy. http://www.icyphoenix.com/viewtopic.php?t=2170

I got the same errors again and again! The Install Documentation is wrong at this point!

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

My Board is running now!

When yout lock the side before executing update_to_ip.php no changes on the database are made. So you run in problems.

Profile PM  
Reply to topic
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.3245s (PHP: 8% SQL: 92%)
SQL queries: 10 - Debug Off - GZIP Enabled