Login or Register  • Home • Downloads • Your Account • Forums •

Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in SQL error View next topic View previous topic   Web RavenPHPScripts (This Site)      Ravens PHP Scripts And Web Hosting Forum Index » phpnuke 6.8 Author Message southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 10:08 pm I installed a chatbox in my forum and now there is no forum, just the SQL errors, or rather two errors: Code: General Error   Could not check session for Ghosts DEBUG MODE SQL Error : 1146 Table 'southern_nuke1.chatbox_session' doesn't exist DELETE FROM chatbox_session WHERE lastactive < '1077420792' Line : 38 File : /home/southern/public_html/modules/Forums/chatbox_front.php I commented out the GHOST line in chatbox_front.php and refreshed, and the second error showed: Code: SQL Error : 1146 Table 'southern_nuke1.chatbox_session' doesn't exist SELECT * FROM chatbox_session Line : 45 File : /home/southern/public_html/modules/Forums/chatbox_front.php It seems the prob is that an expected table doesn't exist. I used the Import SQL function in PHPMyAdmin. Any ideas? The install.txt: ############################################################## ## MOD Title: ChatBox ## MOD Author: Smartor < Only registered users can see links on this board! Get registered or login to the forums! > (Hoang Ngoc Tu) Only registered users can see links on this board! Get registered or login to the forums! ## MOD Description: This will add a LIVE chatbox on your phpBB2 ## Only registered users can chat. Admin can take ## control chatroom by some commands(/KICK username, /CLEAR). Smilies enabled. ## Only tested with phpBB 2.0.x/MySQL ## MOD Version: 1.1.9e ## ## Installation Level: easy ## Installation Time: 10 Minutes ## Files To Edit: 3 ## index.php ## templates/subSilver/index_body.tpl ## language/lang_english/lang_main.php ## ## Included Files: 10 ## chatbox_db_install.php (only required for DB install) ## chatbox_front.php ## chatbox_mod/chatbox.css ## chatbox_mod/chatbox.php ## chatbox_mod/chatbox_config.php ## chatbox_mod/chatbox_drop.php ## chatbox_mod/chatbox_function.php ## chatbox_mod/messenger_list.php ## chatbox_mod/messenger_send.php ## chatbox_mod/messenger_view.php ############################################################## ## This MOD is released under the GPL License. ## Intellectual Property is retained by the MOD Author(s) listed above ############################################################## ## Author Notes: ## ############################################################## ## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD ############################################################## # #-----[ OPEN ]--------------------------------------------- # index.php # #-----[ FIND ]--------------------------------------------- # $template->assign_vars(array( 'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts), 'TOTAL_USERS' => sprintf($l_total_user_s, $total_users), 'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'), # #-----[ BEFORE, ADD ]-------------------------------------- # // ChatBox Mod require_once($phpbb_root_path . 'chatbox_front.php'); # #-----[ FIND ]--------------------------------------------- # 'L_MARK_FORUMS_READ' => $lang['Mark_all_forums'], # #-----[ AFTER, ADD ]-------------------------------------- # // ChatBox Mod 'TOTAL_CHATTERS_ONLINE' => sprintf($lang['How_Many_Chatters'], $howmanychat), 'CHATTERS_LIST' => sprintf($lang['Who_Are_Chatting' ], $chatters), 'L_CLICK_TO_JOIN_CHAT' => $lang['Click_to_join_chat'], 'S_JOIN_CHAT' => append_sid("chatbox_mod/chatbox.$phpEx"), 'CHATBOX_NAME' => $userdata['user_id'] . '_ChatBox', // To make easier to test on my PC 'L_LOGIN_TO_JOIN_CHAT' => $lang['Login_to_join_chat'], # #-----[ OPEN ]--------------------------------------------- # language/lang_english/lang_main.php # #-----[ FIND ]--------------------------------------------- # // // That's all Folks! # #-----[ BEFORE, ADD ]-------------------------------------- # // ChatBox Mod $lang['How_Many_Chatters'] = 'There are <B>%d</B> user(s) on chat now'; $lang['Who_Are_Chatting' ] = '<B>%s</B>'; $lang['Click_to_join_chat'] = 'Click to join chat'; $lang['ChatBox'] = 'ChatBox'; $lang['log_out_chat'] = 'You have successfully logged out from chat on '; $lang['Send'] = 'Send'; $lang['Login_to_join_chat'] = 'Login to join chat'; # #-----[ OPEN ]-------------------------------------------- # templates/subSilver/index_body.tpl # #-----[ FIND ]-------------------------------------------- # <td class="row1" align="center" valign="middle" rowspan="2"><img src="templates/subSilver/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" /></td> # #-----[ REPLACE WITH ]------------------------------------ # <td class="row1" align="center" valign="middle" rowspan="3"><img src="templates/subSilver/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" /></td> # #-----[ FIND ]--------------------------------------------- # <tr> <td class="row1" align="left"><span class="gensmall">{TOTAL_USERS_ONLINE} &nbsp; [ {L_WHOSONLINE_ADMIN} ] &nbsp; [ {L_WHOSONLINE_MOD} ]<br />{RECORD_USERS}<br />{LOGGED_IN_USER_LIST}</span></td> </tr> # #-----[ AFTER, ADD ]-------------------------------------- # <tr> <td class="row1" align="left"><span class="gensmall">{TOTAL_CHATTERS_ONLINE}&nbsp;&nbsp;&nbsp; <!-- BEGIN switch_user_logged_out --> [ {L_LOGIN_TO_JOIN_CHAT} ] <!-- END switch_user_logged_out --> <!-- BEGIN switch_user_logged_in --> [ <a href="javascript:void(0);" onClick="window.open('{S_JOIN_CHAT}','{CHATBOX_NAME}','scrollbars=no,width=540,height=450')">{L_CLICK_TO_JOIN_CHAT}</a> ] <!-- END switch_user_logged_in --> <br />{CHATTERS_LIST} </span> </td> </tr> # #-----[ COPY ]-------------------------------------------- # copy chatbox_front.php to chatbox_front.php copy chatbox_mod/*.* to chatbox_mod/ # #-----[ SQL ]--------------------------------------------- # Run these folloing queries manually or run chatbox_db_install.php once # Afterthat please remove your chatbox_db_install.php immediately # CREATE TABLE nuke_chatbox ( id int(11) NOT NULL auto_increment, name varchar(99) NOT NULL, msg varchar(255) NOT NULL, timestamp int(10) unsigned NOT NULL, PRIMARY KEY (id)); CREATE TABLE nuke_chatbox_session ( username varchar(99) NOT NULL, lastactive int(10) DEFAULT '0' NOT NULL, laststatus varchar(8) NOT NULL, UNIQUE username (username)); # #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ # # EoM Raven Site Admin/Owner Joined: Aug 27, 2002 Posts: 14925 Location: Kansas Posted: Sat Feb 21, 2004 10:40 pm If you are using phpmyadmin, look to see if the two tables exist. If they don't then your install didn't work. Did you try the install that the author provides (chatbox_db_install.php )? Or. just use phpmyadmin, go to the SQL window, copy and paste this code Code: CREATE TABLE nuke_chatbox ( id int(11) NOT NULL auto_increment, name varchar(99) NOT NULL, msg varchar(255) NOT NULL, timestamp int(10) unsigned NOT NULL, PRIMARY KEY (id)); CREATE TABLE nuke_chatbox_session ( username varchar(99) NOT NULL, lastactive int(10) DEFAULT '0' NOT NULL, laststatus varchar(8) NOT NULL, UNIQUE username (username)); and click GO. southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 10:54 pm Yes, I used the SQL function in PHPMyAdmin and clicked Go just the same as I've done and there was no error. SQL said the import succeeded. I have now examined the chatbox_front.php and I noticed a period after $table_chatbox_session_name: Code: <?php /***************************************************************************  *                      chatbox_front.php  *                     -------------------  *   begin            :   Sun July 07 2002  *   copyright         :   (C) 2002 Smartor  *   email            :   smartor_xp@hotmail.com  *  *   $Id: chatbox_front.php, v1.2.0 2002/11/11 17:54:51 ngoctu 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.  *  ***************************************************************************/ if ( !defined('IN_PHPBB') ) {    die("Hacking attempt"); } error_reporting(E_ERROR | E_WARNING | E_PARSE); set_magic_quotes_runtime(0); include_once($phpbb_root_path . 'config.'.$phpEx); $table_chatbox_session_name = $table_prefix . 'chatbox_session'; // Kill Ghosts //$sql = "DELETE FROM " . [b]$table_chatbox_session_name .[/b] " WHERE lastactive < '" . (time() - //300) . "'"; //if (!$result = $db->sql_query($sql)) //{ //   message_die(GENERAL_ERROR, "Could not check session for Ghosts", "", __LINE__, //__FILE__, $sql); //} // Get all remain sessions $sql = 'SELECT * FROM ' . $table_chatbox_session_name; if (!$sol = $db->sql_query($sql)) {    message_die(GENERAL_ERROR, "Could not query ChatBox Session information", "", __LINE__, __FILE__, $sql); } $howmanychat = $db->sql_numrows($sol); // Return this $isimler[0] = $howmanychat; $i = 1; while ($record = $db->sql_fetchrow($sol)) {    $isimler[$i++] = $record['username']; } $chatters = $isimler[1]; for($s = 2; $s <= $isimler[0]; $s++) {    $chatters .= ", $isimler[$s]"; // Return this } ?> I'm wondering whether this period might have been interpreted as part of a table name, in which case the table wouldn't exist. Thanks, I'll go try that SQL import again, and if still no forum I'll run the install.php... Last edited by southern on Sat Feb 21, 2004 10:58 pm; edited 1 time in total Raven Site Admin/Owner Joined: Aug 27, 2002 Posts: 14925 Location: Kansas Posted: Sat Feb 21, 2004 10:57 pm No. The period is a concatenation operator, ie. joining 2 expressions. southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 11:07 pm OK, I waited for your reply before re-running the SQL import witth your code. I'll go do that now. southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 11:29 pm I looked at my nuke tables in PHPMyAdmin and there are two chatbox tables:nuke_chatbox and nuke_chatbox_session... should I still re-run the SQL import or try the install php file? Or perhaps it'd be quicker if I just PMed you my admin password? Could it be a chmod issue? Last edited by southern on Sat Feb 21, 2004 11:31 pm; edited 1 time in total Raven Site Admin/Owner Joined: Aug 27, 2002 Posts: 14925 Location: Kansas Posted: Sat Feb 21, 2004 11:31 pm Drop the tables and try the import script. southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 11:46 pm Run the install php file? OK... does it matter that the chatbox tables are listed in the SQL database? southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sat Feb 21, 2004 11:54 pm OK... got these errors: Code: Warning: main(includes/constants.php): failed to open stream: No such file or directory in /home/southern/public_html/modules/Forums/common.php on line 168 Warning: main(): Failed opening 'includes/constants.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/southern/public_html/modules/Forums/common.php on line 168 Warning: main(includes/template.php): failed to open stream: No such file or directory in /home/southern/public_html/modules/Forums/common.php on line 169 Warning: main(): Failed opening 'includes/template.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/southern/public_html/modules/Forums/common.php on line 169 Warning: main(includes/sessions.php): failed to open stream: No such file or directory in /home/southern/public_html/modules/Forums/common.php on line 170 Warning: main(): Failed opening 'includes/sessions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/southern/public_html/modules/Forums/common.php on line 170 Warning: main(includes/auth.php): failed to open stream: No such file or directory in /home/southern/public_html/modules/Forums/common.php on line 171 Warning: main(): Failed opening 'includes/auth.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/southern/public_html/modules/Forums/common.php on line 171 Warning: main(includes/functions.php): failed to open stream: No such file or directory in /home/southern/public_html/modules/Forums/common.php on line 172 Warning: main(): Failed opening 'includes/functions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/southern/public_html/modules/Forums/common.php on line 172 Fatal error: Call to undefined function: append_sid() in /home/southern/public_html/modules/Forums/common.php on line 181 Now I wonder if I put the files in the right directories. I put chatbox_mod in modules/Forums/ southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Sun Feb 22, 2004 8:53 am Took off the thing last night through PHPMyAdmin drop tables... Live and learn. At least my forum is back. Thanks for the suggestions, Raven, I assume now this version of chatbox doesn't work with my version of phpbb. southern Client Joined: Jan 29, 2004 Posts: 530 Location: Texas Posted: Mon Nov 29, 2004 9:39 am A visitor asked my advice about this error: Code: Warning: main(./includes/constants.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 119 Warning: main(): Failed opening './includes/constants.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 119 Warning: main(./includes/template.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 120 Warning: main(): Failed opening './includes/template.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 120 Warning: main(./includes/sessions.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 121 Warning: main(): Failed opening './includes/sessions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 121 Warning: main(./includes/auth.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 122 Warning: main(): Failed opening './includes/auth.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 122 Warning: main(./includes/functions.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 123 Warning: main(): Failed opening './includes/functions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 123 Warning: main(./includes/db.php): failed to open stream: No such file or directory in /home/xdonlin/public_html/forum/common.php on line 124 Warning: main(): Failed opening './includes/db.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xdonlin/public_html/forum/common.php on line 124 Fatal error: Call to undefined function: append_sid() in /home/xdonlin/public_html/forum/common.php on line 132 What should I tell him? He apparently knows about this forum but contacted me through feedback... Quote: Sender's Name: Marcelo Souza Sender's Email: marcelo at 3donline dot com dot br Message: Hi there Man. I got a crazy error on my forum today, and i could not contact a friend of mine who knows more about PHP...I saw that you have the similar error some times ago...I saw it on this link : Only registered users can see links on this board! Get registered or login to the forums! If you could help me in some way...I will be very thankful. My english is not too good. I am from Brazil, and my forum is about computer animation. I own it alone and try to keep it on air without any great investment. The site is on air for about 7 years and the forum, for about 1 year, with more than 4000 users... I can\'t leave it offline. So...I have the idea to ask you for a little tip, or help, to put it back online. Just any clue about this error, will be very valuable for me. Thanks a lot man ! Take care... Look at my error : Only registered users can see links on this board! Get registered or login to the forums! Looks similar to your problem, and i read that you solved it, right ? Thanks again.: ) Display posts from previous:   All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First        Ravens PHP Scripts And Web Hosting Forum Index » phpnuke 6.8  Jump to:  Select a forum Read Me First!!!----------------Board Rules and Regulations Web Hosting Services----------------RWH GeneralRWH Pre Sale QuestionsRWH Client Center Application OnlyRWH OtherFAQ - PHP5 w/phpSuExec Conversion From PHP4PHP5 Conversion Issues From PHP4 Recommended Reading----------------Reading - AnnouncementsReading - Digital BooksReading - Hard/Soft cover BooksReading - Digital MagazinesReading - Printed Magazines RavenNuke(tm) Addons----------------FCKeditor/WYSIWYG IssuesnukeFeed/FeedCreatorForum Attachment ModnukeSEOShortLinks/TegoNukeNukePie/SimplePie RavenNuke(tm) v2.20.x----------------RN v2.20.00 - AnnouncementsRN v2.20.00 - All IssuesRN v2.20.00 - Feedback RavenNuke(tm) v2.10.01----------------RN v2.10.01 - All IssuesRN v2.10.01 - Feedback RavenNuke(tm) v2.10.00----------------RN AnnouncementsRN FAQRN Bug FixesRN Not BugsRN Documentation Issues/SuggestionsRN Enhancement Requests and SuggestionsRN NSN Groups IssuesRN Themes IssuesRN NukeSentinel(tm) issuesRN Installer/Setup IssuesRN Bug Reports - Other IssuesRN Conversion Issues From v2.02RN Conversion Issues From Standard phpNukeRN The Good, The Bad, The Ugly Site Specific Stuff----------------READ ME FIRSTAnnouncementsRaven's v7.0 Customized DistroHack Attempt ScriptRaven's Customized Distribution PacksBUGS/FIXES - Raven's v7.3 Customized DistroCache Lite Admin ModuleNuke Tool Box (TM)Captcha SecurityRaven's RavenNuke(tm) v1.x DistroRaven's RavenNuke(tm) v2.00.00 - v2.02.00 DistroWYSIWYG - Raven's RavenNuke(tm) v2.x DistroUpgrade Pack For RavenNuke(tm) v1.05.00 to v2.02.00Raven's Collapsing Forums BlockGT - Raven's RavenNuke(tm) v2.x DistroRaven's RavenNuke(tm) v2.02.02 DistroPost Fixes - Raven's RavenNuke(tm) v2.02.02 DistroRaven's RavenNuke(tm) v2.10.00Public Testing of RavenNuke(tm) v2.10.00HtAccesser Security----------------Security - PHP NukeSecurity - OtherNukeSentinel(tm) v2.6.xNukeSentinel(tm) v2.5.xNukeSentinel(tm) v2.4.xNukeSentinel(tm)NukeSentinel(tm) Bug ReportsNukeSentinel(tm) Enhancement RequestsNukeSentinel(tm) AnnouncementsEasy IP Ban Reference [eC-IPBR]PHP-Nuke Patched Series By Chatserv Information About Forums----------------Old Forum EntriesPHPBBBB2NukePunBB PHP-Portal Project (Not General phpnuke!)----------------AnnouncementsGeneral - PHP Portal ProjectDevelopersDesign Discussions Scripts - General----------------Post Release FixesBug FixesGeneral/Other StuffHow To'sInstallation HelpPost Installation HelpGT - Next Gen and StandardSeeking applications ...ThemesBlocksModulesMaking Nuke Efficientphpnuke 8.1phpnuke 8.0phpnuke 7.9phpnuke 7.8phpnuke 7.7phpnuke 7.6phpnuke 7.6 Bugs/Fixesphpnuke 7.5phpnuke 7.4phpnuke 7.3phpnuke 7.2phpnuke 7.1phpnuke 7.0phpnuke 6.9phpnuke 6.8Bug Fixes for phpnuke 6.5phpnuke 6.5CNB Your AccountM2FBrowser Specific IssuesUpgrading NukeNuke Treasury Other CMS/Portal Applications----------------Post NukeNuke PlatinumNuke Evolution PHPBB----------------Stand Alonew/Nuke 6.5w/Nuke 6.9BBtoNuke ModsBBtoNuke Programming----------------PHPMySQLFor HireApacheHTMLCSSJavaScript Guestbook Application (KISGB)----------------KISGB General Support Stock Quote Application (KISSQ)----------------KISSQ General Support NSN Scripts----------------NSN NewsNSN GroupsNSN OtherNSN Gr Downloads - a.k.a NukeDepository 6.5 Hacks----------------Old Articles Hack Nuke News Module Hack To Allow Ordering of Articles----------------News Module Hack - AnnouncementsNews Module Hack - BugsNews Module Hack - Enhancement RequestsNews Module Hack - Discussion Other Stuff----------------Other - DiscussionOther - Sites To VisitOther - Chit ChatOther - PoliticsOther - Movie ReviewsOther - The Wastelands of NukeworldOther - Book ReviewsOther - Humor Religion----------------Religion - GeneralPrayer/Praise Requests Potpourri----------------Rants & Raves Guest Editorials----------------My Turn - James R. Sanders  View next topic View previous topic You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Forums ©

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2008 by Raven
Proud to be listed at Lobo Links Web Directory

You can syndicate our news using the file



Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Recoded To 100% W3C CSS & HTML 4.01 Transitional Compliance by Raven and 64bitguy ::
:: :: ::

zerosum