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

1.0.5 install problem

Post by nascarnut »

I am installing this over my current board. I have tried three times now. It seems that my problem is once I upload the modded version over the top of mine and then upload the four directories included in your zip file and when I run the first one in my browser it says:
Open these files:

You are not authorized to use this script.

Please note to use the script the following requirements must be met. First you must be logged in to the site and second you must have the user type founder. If you are logged in and are the founder then you have incorrect cookie settings in the acp. Please check the cookie domain setting. If your site url is http://www.example.com then the cookie domain should be .example.com.

Now I made sure the cookie setting was correct and I am logged in as admin. It seems that I am getting logged out after I upload the modded version. Any ideas what to do for this?
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

Well I just gave it another go and here are the results.
Ok I got the arcade to install with out a hitch now. But the gallery install and wwh install just load up my forum index with this message:

Please delete, move or rename the install directory before you use your board. If this directory is still present, only the Administration Control Panel (ACP) will be accessible.
I never get to install them.

When I tried to install the cf install I get this:

install/cf_install.php

Notice: Undefined property: dbal_mysql::$mysql_version in /home7/theoutdo/public_html/forum/install/cf_install.php on line 321

Fatal error: SQL ERROR [ mysql4 ]

Table 'flags' already exists [1050]

SQL

CREATE TABLE flags ( flag_id mediumint(8) UNSIGNED NOT NULL auto_increment, flag_country blob NOT NULL, flag_code blob NOT NULL, flag_image varbinary(255) DEFAULT '' NOT NULL, PRIMARY KEY (flag_id) );

BACKTRACE


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

FILE: install/cf_install.php
LINE: 440
CALL: dbal_mysql->sql_query()


in /home7/theoutdo/public_html/forum/includes/db/dbal.php on line 657
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 »

Firstly, your logging out issue looks to me like your browser isn't accepting cookies. One way would be login as admin, then run the file install to run those database tables (while still on the old board), then go and run the upgrade.sql in phpmyadmin, then upload the files to server. Delete cookies in your browser and board.

You get that

Code: Select all

Please delete, move or rename the install directory before you use your board. If this directory is still present, only the Administration Control Panel (ACP) will be accessible.
when you try to access your board with the files still on the server. You are not accessing the board, you need to go to the correct address of yourforum/install/install.php when they have run, then delete them.

The flags looks like it has already been installed maybe prior so ignore that unless you get an error on accessing the board after.
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

Well I got the first three to install now by deleting the install directory and then running them. Still can't get the install cf to work just keep giving me the error I posted above
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 »

That error

Code: Select all

Table 'flags' already exists
says to me that the sql is already in there so no need to worry about that yet unless the flag mod doesn't work when you have converted it.
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 went through the rest of the steps without a hitch. Now when I load up my forum I get this message:
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 »

Did you run that upgrade.sql in your phpmyadmin. That error means the shoutbox tables haven't been entered.
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

LDM wrote:Did you run that upgrade.sql in your phpmyadmin. That error means the shoutbox tables haven't been entered.
Yes I did run that
nascarnut
Forum Member
Forum Member
Posts: 32
Joined: Fri Jan 16, 2009 10:58 pm

Re: 1.0.5 install problem

Post by nascarnut »

Would it hurt to run it again
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 »

Back up first, but it should be fine as it will only add the tables that are not there and tell you they already exist if they are there.
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')
Post Reply