1.0.5 install problem

Having trouble installing ModphpBB3 - Post any questions or issues in here.
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