SQL Error after installing the shoutbox

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
sergefa
Posts: 39
Joined: Fri Jul 14, 2006 8:22 pm
Location: Krymsk, Krasnodarsky Kray, Russia
Contact:

SQL Error after installing the shoutbox

Post by sergefa » Fri Jul 14, 2006 8:40 pm

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
Registered User
Posts: 3
Joined: Fri Feb 09, 2007 4:16 pm

Re: SQL Error after installing the shoutbox

Post by old » Fri Feb 09, 2007 4:47 pm

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

User avatar
3Di
Registered User
Posts: 695
Joined: Tue Nov 01, 2005 9:50 pm
Location: Milano (I) Frankfurt (D)
Contact:

Re: SQL Error after installing the shoutbox

Post by 3Di » Sat Mar 10, 2007 11:21 pm

Moved from: EM SQL Parser Forum.
Want to compensate me for my interest? Don't ask me, just do it
I'm available for custom phpBB jobs, you can PM me the details.
New: my Live Board, Extensions and Tools for phpBB - Men at works.

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

Re: SQL Error after installing the shoutbox

Post by Poomerio » Sun Mar 11, 2007 11:42 am

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
Registered User
Posts: 1
Joined: Sun Mar 25, 2007 6:46 pm

Re: SQL Error after installing the shoutbox

Post by Chae247 » Mon Mar 26, 2007 1:53 am

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
Registered User
Posts: 17
Joined: Wed Mar 07, 2007 6:20 am
Location: I forgot..
Contact:

Re: SQL Error after installing the shoutbox

Post by halofight977 » Mon Apr 02, 2007 5:47 am

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

Locked