 | My Arcade Errors :) |  |
 Posted: 09/01/2007 9:41 AM |
 |
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
 |
I installed the newer version on www.babydreamz.net/PRACTICEBOARD all went in ok but when I click on a game I get these errors in my popup window.  
| Code:
|
Warning: main(./includes/class_message.php): failed to open stream: No such file or directory in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php on line 57
Warning: main(./includes/class_message.php): failed to open stream: No such file or directory in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php on line 57
Warning: main(./includes/class_message.php): failed to open stream: No such file or directory in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php on line 57
Warning: main(): Failed opening './includes/class_message.php' for inclusion (include_path='.:/usr/local/lib/php:/usr/local/share/pear') in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php on line 57
Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php :57) in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/includes/pag e_header.php on line 884
Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php :57) in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/includes/pag e_header.php on line 886
Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/activity.php :57) in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/includes/pag e_header.php on line 887
Error creating new session
DEBUG MODE
SQL Error : 1054 Unknown column 'user_id' in 'where clause'
UPDATE phpbb_ina_sessions SET start_time = '1188657231', page = '-13', game_name = 'squid_hunter', arcade_hash = 'f759be7232981dc0437be8f58b53bd95', user_win = '', tour_id = 0 WHERE user_id = '2'
Line : 217
File : functions_arcade.php
|
|
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/01/2007 11:42 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:37 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, the first problem with the class_message.php is a known problem addressed in the following link:
HOW TO CORRECT MOST COMMON ERRORS
The reason why this happens is that the MOD author incorrectly assumes that Ptirhiik's Category Hiearchy MOD is installed. Not surprisingly, Ptirhiik assisted in the creation of this MOD. So this is how you correct the problem:
OPEN
activity.php
FIND & DELETE
| Code:
|
if ( CH_CURRENT_VERSION >= '2.1.6' )
{
include($phpbb_root_path . 'includes/class_message.'.$phpEx);
}
|
OPEN
arcade_comment.php
FIND & DELETE
| Code:
|
if ( CH_CURRENT_VERSION >= '2.1.6' )
{
include($phpbb_root_path . 'includes/class_message.'.$phpEx);
}
|
The second problem may be caused because you had the Activity MOD Plus installed. It may have already created an obsolete version of the phpbb_ina_sessions table, which wasn't updated when you installed 2.1.8. You may want to delete the phpbb_ina_sessions table and rerun the Database update in your ACP...
 |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 7:03 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
|
I'm confused!
I did the first thing ok, but I realised I was rnning my practice board off of my live database  so tried to create a new test database using my live board, but I got message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?
Tried to fix that but couldn't so went back to my live databse and deleted the table you said and ran the update again and now I get this error..
| Code:
|
Error creating new session
DEBUG MODE
SQL Error : 1146 Table 'babydre_a.phpbb_ina_sessions' doesn't exist
UPDATE phpbb_ina_sessions SET start_time = '1188734575', page = '-13', game_name = 'trickyclickyball2', arcade_hash = 'b0502ca48b543d660bf7c3d79e2213c4', user_win = '', tour_id = 0 WHERE user_id = '2'
Line : 217
File : functions_arcade.php
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 2:05 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:37 AM
Location: St Pete, FL
|
|
|
|
|
|
phpMyAdmin - Cloning the Database
PhpMyAdmin has a handy tool that can be used to clone your database in a very short amount of time....
To easily clone your database, first create a new database in MySql. Make sure you assign a username that can access it with FULL privileges...
Then do this in phpMyAdmin. Select your current Live database in the left panel:
Click on the Operations tab in the right panel:
Enter the name of the new Practice database that you created, select structure and data. Then press the Go button:
Your new Practice database should be popuplated now. Then you would need to make sure that the config.php file settings for the Practice board point to the new database...
 |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 2:17 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
|
Oh yes I remember you telling me that before but I couldn't do it with my old host!
Will give that a go then
Thanks! |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 2:28 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:37 AM
Location: St Pete, FL
|
|
|
|
|
|
The cloning process won't take very long. It is a neat feature in phpMyAdmin...
 |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 3:53 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
|
hmmm I tried to do it and I got a message saying it had been disabled but I tried it anyway, just to see and I got this at the end..but the tables all appear to be in the new database
| Code:
|
Error
SQL query:
CREATE TABLE `babydre_bdztest`.`phpbb_auth_access` (
`group_id` mediumint( 8 ) NOT NULL default '0',
`forum_id` smallint( 5 ) unsigned NOT NULL default '0',
`auth_view` tinyint( 1 ) NOT NULL default '0',
`auth_read` tinyint( 1 ) NOT NULL default '0',
`auth_post` tinyint( 1 ) NOT NULL default '0',
`auth_reply` tinyint( 1 ) NOT NULL default '0',
`auth_edit` tinyint( 1 ) NOT NULL default '0',
`auth_delete` tinyint( 1 ) NOT NULL default '0',
`auth_sticky` tinyint( 1 ) NOT NULL default '0',
`auth_announce` tinyint( 1 ) NOT NULL default '0',
`auth_vote` tinyint( 1 ) NOT NULL default '0',
`auth_pollcreate` tinyint( 1 ) NOT NULL default '0',
`auth_attachments` tinyint( 1 ) NOT NULL default '0',
`auth_mod` tinyint( 1 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `forum_id` ( `forum_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said:
#1050 - Table 'phpbb_auth_access' already exists
|
It all seems to be ok except I still have the error I had before (above) when trying to play a game and now I tried to log in I got
| Code:
|
Parse error: parse error, unexpected T_ELSE in /hsphere/local/home/babydrea/babydreamz.net/PRACTICEBOARD/login.php on line 183
|
|
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 4:59 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
|
I've stopped it connecting to the databse for now, I'm off to bed and one of my members manged to get taken there  |
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/02/2007 5:34 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:37 AM
Location: St Pete, FL
|
|
|
|
|
|
The Parse error that you are seeing in the login.php file is caused by your MPS MOD, not the Arcade MOD. There is a section of code added that didn't come from the 0.3.1 version of the MOD. Did you install add-ons for it? I cannot find this code in the MPS 0.3.1 MOD script and this is what is causing the parse error:
| Code:
|
// BEGIN MPS MOD
if ($board_config['allow_mps'] == 1)
{
$sql = "SELECT *
FROM " . MPS_TABLE . "
WHERE mps_id = " .$row['user_id'];
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, $lang['MPS_no_query'], '', __LINE__, __FILE__, $sql);
}
$mps_info = $db->sql_fetchrow($result);
if ( $board_config['force_mps'] == 1 && !$mps_info )
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
redirect(append_sid($url, true));
}
else if ($board_config['force_mps_home'] == 1 && $mps_info)
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
redirect(append_sid($url, true));
}
else if ($mps_info['mps_home_page'] == 1 && $mps_info)
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
redirect(append_sid($url, true));
}
else
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
redirect(append_sid($url, true));
}
}
else
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "portal.$phpEx";
redirect(append_sid($url, true));
// END MPS MOD
|
|
|
|
|
|
| Back to Top |
|
|
| Re: My Arcade Errors :) | |
| Posted: 09/03/2007 6:38 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:37 AM
|
|
|
|
|
|
There are a list of bug fixes to go through, so that might well fix it. It ran ok with the profile mod, it only came up with problems after I added the new arcade mod
I'll get there! |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
