SQL Error after installing the shoutbox

[sergefa]

I installed EM and then tried to install the shoutbox mod but after 3 step a got the following messages
Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

Warning: ftp_put() [function.ftp-put]: Can't open that file: Permission denied in /home/sergefa/public_html/forum/admin/em_includes/em_ftp.php on line 1102

After that there is the message:
Step 3 of 3
Installation Complete!

When returning to my forum I see the shout box but inside the shoutbox there is the message:
General error
Could not get shoutbox information

DEBUG MODE

SQL Error : 1146 Table 'sergefa_phpb1.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


What am I to do now and how can I get to square one and undo all alterations?
Any help would much appreciated.
Thank you min advance!

[old]

oh boy no one helped u and i got the same probem

[3Di]

Moved from: EM SQL Parser Forum.

[Poomerio]

If this is the shoutbox MOD I'm thinking of, then go into phpMyAdmin.
Select your database you have phpBB installed on.
Click "SQL".
Enter 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 hit "Go".

- Poomie

[Chae247]

I got this same error and tried your fix and it did not work. It did install the SQL query yet the error is still there. This is the MOD installed: http://www.phpbbhacks.com/download/1255

Any other suggestions?? lol

[halofight977]

I remember installing that by hand. But I did not get that problem, so if you want you could so it by hand.