1.0.5 install problem
Re: 1.0.5 install problem
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
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
Re: 1.0.5 install problem
Again, that looks to have been added already. What is the error on the forum index?
Re: 1.0.5 install problem
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')
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
Run this in phpmyadmin via sql tab
Remember to select all while copying.
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;
Re: 1.0.5 install problem
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')
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')
Re: 1.0.5 install problem
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
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;
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
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
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')
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
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
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
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')
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')