1.0.5 install problem

Having trouble installing ModphpBB3 - Post any questions or issues in here.
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

OK, I did it again. This is the error I got when I imported it last time to. Still can't log into forum either
Error
SQL query:

CREATE TABLE `phpbb_announcement_centre` (

`announcement_show` tinyint( 1 ) NOT NULL ,
`announcement_enable` tinyint( 1 ) NOT NULL ,
`announcement_enable_guests` tinyint( 1 ) NOT NULL ,
`announcement_show_birthdays` tinyint( 1 ) NOT NULL ,
`announcement_birthday_avatar` tinyint( 1 ) NOT NULL ,
`announcement_draft` text NOT NULL ,
`announcement_text` text NOT NULL ,
`announcement_text_guests` text NOT NULL ,
`announcement_title` varchar( 255 ) NOT NULL default '',
`announcement_title_guests` varchar( 255 ) NOT NULL default '',
`announcement_show_group` varchar( 255 ) NOT NULL default ''
) CHARACTER SET utf8 COLLATE utf8_bin;



MySQL said:

#1050 - Table 'phpbb_announcement_centre' already exists
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: 1.0.5 install problem

Post by LDM »

Again, that looks to have been added already. What is the error on the forum index?
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

This is the error on my index page

General Error
SQL ERROR [ mysql4 ]

Table 'theoutdo_pbb01.chat' doesn't exist [1146]

SQL

SELECT * FROM chat ORDER BY message_id DESC LIMIT 25

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: shout.php
LINE: 54
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 47
CALL: include('shout.php')
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: 1.0.5 install problem

Post by LDM »

Run this in phpmyadmin via sql tab

Code: Select all

CREATE TABLE phpbb_chat (
        message_id int(11) unsigned NOT NULL auto_increment,
        chat_id int(11) unsigned NOT NULL default '0',
        user_id int(11) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        message text NOT NULL,
        bbcode_bitfield varchar(255) NOT NULL default '',
        bbcode_uid varchar(5) NOT NULL default '',
        bbcode_options tinyint(1) unsigned NOT NULL default '7',
        time int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (message_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_chat_sessions (
        user_id mediumint(8) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        user_login int(11) unsigned NOT NULL default '0',
        user_firstpost int(11) unsigned NOT NULL default '0',
        user_lastpost int(11) unsigned NOT NULL default '0',
        user_lastupdate int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (user_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Remember to select all while copying.
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

I copied your text into note pad and saved the file as a sql file and then imported it through phpmyadmin and it said:
Import has been successfully finished, 2 queries executed

This is the error I get at my index page:
General Error
SQL ERROR [ mysql4 ]

Table 'theoutdo_pbb01.chat' doesn't exist [1146]

SQL

SELECT * FROM chat ORDER BY message_id DESC LIMIT 25

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: shout.php
LINE: 54
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 47
CALL: include('shout.php')
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: 1.0.5 install problem

Post by LDM »

Now run this one:

Code: Select all

CREATE TABLE phpbb_shoutbox (
	shout_id int(11) unsigned NOT NULL auto_increment,
	shout_user_id mediumint(8) NOT NULL,
	shout_time int(11) NOT NULL,
	shout_ip varchar(32) character set latin1 NOT NULL,
	shout_text text collate utf8_bin NOT NULL,
	shout_bbcode_bitfield varchar(255) character set latin1 NOT NULL,
	shout_bbcode_uid varchar(8) character set latin1 NOT NULL,
	shout_bbcode_flags int(11) unsigned NOT NULL default '7',
	PRIMARY KEY	(shout_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

Now I get this after running that one:
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0079 sec)
SQL query:
CREATE TABLE phpbb_shoutbox(
shout_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
shout_user_id mediumint( 8 ) NOT NULL ,
shout_time int( 11 ) NOT NULL ,
shout_ip varchar( 32 ) CHARACTER SET latin1 NOT NULL ,
shout_text text COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield varchar( 255 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_uid varchar( 8 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_flags int( 11 ) unsigned NOT NULL default '7',
PRIMARY KEY ( shout_id )
) DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: 1.0.5 install problem

Post by LDM »

Try running this:

Code: Select all

DROP TABLE IF EXISTS phpbb_shoutbox;
CREATE TABLE `phpbb_shoutbox` (
  `shout_id` int(11) unsigned NOT NULL auto_increment,
  `shout_user_id` mediumint(8) NOT NULL,
  `shout_time` int(11) NOT NULL,
  `shout_ip` varchar(32) character set latin1 NOT NULL,
  `shout_text` text collate utf8_bin NOT NULL,
  `shout_bbcode_bitfield` varchar(255) character set latin1 NOT NULL,
  `shout_bbcode_uid` varchar(8) character set latin1 NOT NULL,
  `shout_bbcode_flags` int(11) unsigned NOT NULL default '7',
  PRIMARY KEY  (`shout_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

I ran it and got this:
Import has been successfully finished, 2 queries executed.
SQL query:
DROP TABLE IF EXISTS phpbb_shoutbox;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `phpbb_shoutbox` (
`shout_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`shout_user_id` mediumint( 8 ) NOT NULL ,
`shout_time` int( 11 ) NOT NULL ,
`shout_ip` varchar( 32 ) CHARACTER SET latin1 NOT NULL ,
`shout_text` text COLLATE utf8_bin NOT NULL ,
`shout_bbcode_bitfield` varchar( 255 ) CHARACTER SET latin1 NOT NULL ,
`shout_bbcode_uid` varchar( 8 ) CHARACTER SET latin1 NOT NULL ,
`shout_bbcode_flags` int( 11 ) unsigned NOT NULL default '7',
PRIMARY KEY ( `shout_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;# MySQL returned an empty result set (i.e. zero rows).

When I go to my index page I get this:
General Error
SQL ERROR [ mysql4 ]

Table 'theoutdo_pbb01.chat' doesn't exist [1146]

SQL

SELECT * FROM chat ORDER BY message_id DESC LIMIT 25

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: shout.php
LINE: 54
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 47
CALL: include('shout.php')
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: 1.0.5 install problem

Post by LDM »

Now it looks like you haven't uploaded the modphpbb3 files? Delete everything in /cache folder other than .htaccess and see how you go. That looks like now that it's still seeing your default files and not the modded ones.
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

I uploaded all the modphpbb3 files first thing. I deleted those files already but I will check the folder again and delete anything in there besides the files you said not to. I will let you know how it goes
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

Still doing the same thing. It says this on my index page:
General Error
SQL ERROR [ mysql4 ]

Table 'theoutdo_pbb01.chat' doesn't exist [1146]

SQL

SELECT * FROM chat ORDER BY message_id DESC LIMIT 25

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: shout.php
LINE: 54
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 47
CALL: include('shout.php')
Post Reply