Hi Guys,
I moved my forums onto a new tower. I copied and pasted the forum and the sql folders over. The forums (phpBB2.0.19) are pretty much up and running okay, as is the database (Mysql5.0). The problem is with the shoutbox.
It was working fine in previous setup, but I cannot get it to work properly here. There is no previous entries listed, and when I put in a new shoutbox entry the screen goes white.
I tried running shoutbox_install.php and this the errors that I am getting.
Anyone can tell me what I need to do to fix?
Thanks in advance,
Heeter
Shoutbox Mod problem, changed server
Moderator: CricketMX Forum Moderators
Did you apply the changes to constants.php? Looks like you didn't:)
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
Hi Battye,
Yes I did mod the constants.php file.
Same error.
Thanks,
Heeter
Yes I did mod the constants.php file.
Code: Select all
// Shoutbox MOD
define('SHOUTBOX_TABLE', $table_prefix.'shoutbox');
Same error.
Thanks,
Heeter
Last edited by Heeter on Thu Jul 13, 2006 1:54 pm, edited 1 time in total.
Could you please paste the contents of shoutbox_install.php here?
Don't forget to use the
Don't forget to use the
Code: Select all
tag.
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
Code: Select all
http://hcctech.ca/forums/index.php
Here is the sboutbox_install.php
Code: Select all
<?php
/***************************************************************************
* shoutbox_install.php
* -------------------
* begin : Sat, Oct 26, 2005
* copyright : (C) 2005 Battye @ CricketMX.com
* email : cricketmx@hotmail.com
*
* $Id: shoutbox.php, v1 (October 2005) battye Exp $
*
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//include($phpbb_root_path . 'config.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
$sql = array();
$sql[] = "CREATE TABLE `" . SHOUTBOX_TABLE . "` (
`shoutbox_id` int(5) NOT NULL default '0',
`shoutbox_datetime` VARCHAR( 255 ) NOT NULL default '',
`shoutbox_text` varchar(255) NOT NULL default '',
`shoutbox_author` int(5) NOT NULL default '0'
);";
$sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('guest_shoutbox', '0')";
$sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('rows_shoutbox', '5')";
for ($i = 0; $i < count($sql); $i++)
{
if( !$db->sql_query($sql[$i]) )
{
echo $i . ': The shoutbox table / rows could not be created (' . $sql[$i] . ')( ' . $db->sql_error() . ' )<br />';
}
}
message_die(GENERAL_MESSAGE, $lang['Shoutbox_table_made']);
?>
Heeter
Try changing:
To
If that doesn't work, try:
Code: Select all
$sql = array();
$sql[] = "CREATE TABLE `" . SHOUTBOX_TABLE . "` (
`shoutbox_id` int(5) NOT NULL default '0',
`shoutbox_datetime` VARCHAR( 255 ) NOT NULL default '',
`shoutbox_text` varchar(255) NOT NULL default '',
`shoutbox_author` int(5) NOT NULL default '0'
);";
Code: Select all
$sql = array();
$sql[] = "CREATE TABLE " . SHOUTBOX_TABLE . " (
`shoutbox_id` int(5) NOT NULL default '0',
`shoutbox_datetime` VARCHAR( 255 ) NOT NULL default '',
`shoutbox_text` varchar(255) NOT NULL default '',
`shoutbox_author` int(5) NOT NULL default '0'
);";
Code: Select all
$sql = array();
$sql[] = "CREATE TABLE phpbb_shoutbox (
`shoutbox_id` int(5) NOT NULL default '0',
`shoutbox_datetime` VARCHAR( 255 ) NOT NULL default '',
`shoutbox_text` varchar(255) NOT NULL default '',
`shoutbox_author` int(5) NOT NULL default '0'
);";
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
If I was to do a fresh install of 2.0.19, then did a restore backup through the admin panel, then fresh installed 0.1.3 Shoutbox, would it work, or work the restore backup put shoutbox 0.1.2 back in? cause it was in the restore backup that this started happening.
Hope you understand what I am asking. LOLOL
Heeter
Hope you understand what I am asking. LOLOL
Heeter
I was referring to the first error regarding shoutbox_install.php.. are you sure that when you try the code changes above you get the same error?Heeter wrote:If I was to do a fresh install of 2.0.19, then did a restore backup through the admin panel, then fresh installed 0.1.3 Shoutbox, would it work, or work the restore backup put shoutbox 0.1.2 back in? cause it was in the restore backup that this started happening.
Hope you understand what I am asking. LOLOL
Heeter
In particular I'm referring to the very first error where it says CREATE TABLE `SHOUTBOX_TABLE` ....
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
On index.php you should find a few instances of:
Replace them with
Code: Select all
" . SHOUTBOX_TABLE . "
Code: Select all
phpbb_shoutbox
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)