Shoutbox EM Help

[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

[sdteam]

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

[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

[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

[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

[sdteam]

sorry for the long reply
http://www.phpbb.com/phpBB/viewtopic.php?t=389032

[sdteam]

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

[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

[sdteam]

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

[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