Page 2 of 2
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 1:37 am
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;
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 1:40 am
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;
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 1:55 am
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;
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 2:22 am
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')
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 2:57 am
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.
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 3:07 am
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
Re: 1.0.5 install problem
Posted: Wed Feb 18, 2009 3:09 am
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')