Shoutbox EM Help

Wondering why that MOD you have won't install correctly? Let's take a look
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Shoutbox EM Help

Post by sdteam »

hi i installed a mod with easy mod and it installed ok but in the shoutbox it says

Could not get shoutbox information

DEBUG MODE

SQL Error : 1146 Table 'futurecore.phpbb_shout' doesn't exist

SELECT s.*, u.user_allowsmile, u.username FROM phpbb_shout s, phpbb_users u WHERE s.shout_user_id=u.user_id ORDER BY s.shout_session_time DESC LIMIT 0, 20

Line : 98
File : shoutbox_view.php

User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Re: Shoutbox EM Help

Post by sdteam »

dose this support team even get back to you waste of my time really

User avatar
Poomerio
Registered User
Posts: 552
Joined: Tue Jan 02, 2007 7:09 pm
Location: 4(x - 20y) = 20

Re: Shoutbox EM Help

Post by Poomerio »

Sorry to seem rude, but there is only me and Nightrider that help most people out.
But quite frankly, I am in school, and Nightrider is asleep.
Run the SQL file if there was one included; no SQL command was performed in the install.

- Poomie

User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Re: Shoutbox EM Help

Post by sdteam »

hey thats kool so only 2 people run that if so DAYM need more helpers
well i dont even now how to work sql
ima basic learner just learning but with the help of the forums and good i should be able to get it done

User avatar
Poomerio
Registered User
Posts: 552
Joined: Tue Jan 02, 2007 7:09 pm
Location: 4(x - 20y) = 20

Re: Shoutbox EM Help

Post by Poomerio »

Basically me and Nightrider; but now and then, other people pop in to help out.
Provide me with a link to download this MOD and I will have a look at it.

- Poomie

User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Re: Shoutbox EM Help

Post by sdteam »


User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Re: Shoutbox EM Help

Post by sdteam »

what else do you guys help on
i have more problems in my forumer lol

User avatar
Poomerio
Registered User
Posts: 552
Joined: Tue Jan 02, 2007 7:09 pm
Location: 4(x - 20y) = 20

Re: Shoutbox EM Help

Post by Poomerio »

I'm part of 2 Support Teams for other forums also.
OK, try this.

Go into your PhpMyAdmin.
Select your database with the phpBB installed onto it.
Select "SQL".
Type in:

Code: Select all

INSERT INTO `phpbb_config` VALUES ('shoutbox_floodinterval', '3');
INSERT INTO `phpbb_config` VALUES ('display_shouts', '10');
INSERT INTO `phpbb_config` VALUES ('stored_shouts', '25');
INSERT INTO `phpbb_config` VALUES ('shoutbox_refreshtime', '4000');
INSERT INTO `phpbb_config` VALUES ('shout_allow_guest', '1');
CREATE TABLE phpbb_shoutbox (
  shout_id MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
	user_id MEDIUMINT(8) NOT NULL,
  shouter_name VARCHAR(30) NOT NULL DEFAULT 'guest',
  shout_text TEXT NOT NULL,
	shouter_ip VARCHAR(8) NOT NULL DEFAULT '',
  shout_uid VARCHAR(10) NOT NULL DEFAULT '',
	shout_time INT(11) NOT NULL,
  PRIMARY KEY ( shout_id )
);
CREATE TABLE `phpbb_shoutbox_sessions` (
  `session_id` int(10) NOT NULL auto_increment,
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_username` varchar(25) NOT NULL default '',
  `session_ip` varchar(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`session_id`)
);
Then press Go.

But I couldn't really give much more support for an Alpha MOD.

- Poomie

User avatar
sdteam
Registered User
Posts: 18
Joined: Tue Mar 06, 2007 8:31 am

Re: Shoutbox EM Help

Post by sdteam »

that sql thing i have no idea about how to make the tables or alter them

User avatar
Poomerio
Registered User
Posts: 552
Joined: Tue Jan 02, 2007 7:09 pm
Location: 4(x - 20y) = 20

Re: Shoutbox EM Help

Post by Poomerio »

I told you how.
Go into phpMyAdmin
Select the database phpBbw as installed on.
Then press "SQL"
Insert my code into there and press GO.

- Poomie

Locked