1.0.5 install problem
1.0.5 install problem
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?
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?
Re: 1.0.5 install problem
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
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
Re: 1.0.5 install problem
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
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.
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.
The flags looks like it has already been installed maybe prior so ignore that unless you get an error on accessing the board after.
Re: 1.0.5 install problem
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
Re: 1.0.5 install problem
That error 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.
Code: Select all
Table 'flags' already exists
Re: 1.0.5 install problem
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')
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
Did you run that upgrade.sql in your phpmyadmin. That error means the shoutbox tables haven't been entered.
Re: 1.0.5 install problem
Yes I did run thatLDM wrote:Did you run that upgrade.sql in your phpmyadmin. That error means the shoutbox tables haven't been entered.
Re: 1.0.5 install problem
Would it hurt to run it again
Re: 1.0.5 install problem
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.
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')