Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 6 Support
  4. Official Core Support - 6
  5. Shoutbox broken...

Shoutbox broken...

Asked Modified Viewed 1,471 times
Back to Forum Index Previous Topic Next Topic
Print
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
asked
Junior Member

Hello everyone -

I have had an issue for about a month yet that I can't seem to fix on my own. All of the sudden my shoutbox just stopped working. I did not make any changes to the code or database in this time so I cannot trace the issue back to that. I don't know if it's possible to break the shoutbox by using it... in which case I have no clue what members may have inputted.

By "broken" I mean that typing a comment, then hitting 'shout' does not result in the comment showing up.

I tried to uninstall, then reinstall the shoutbox - no luck... then I went searching for a "different" shoutbox, tried a slightly modded one, no luck.

Site is found at www.jeffbuttle.com

I'd really appreciate some help because the shoutbox was our most used feature....
0 replies

13 posts

W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

You can change the data type for shout_id in phpMyadmin.

Types will give you:

Quote

TINYINT( ) -128 to 127 normal
0 to 255 UNSIGNED.
SMALLINT( ) -32768 to 32767 normal
0 to 65535 UNSIGNED.
MEDIUMINT( ) -8388608 to 8388607 normal
0 to 16777215 UNSIGNED.
INT( ) -2147483648 to 2147483647 normal
0 to 4294967295 UNSIGNED.
BIGINT( ) -9223372036854775808 to 9223372036854775807 normal
0 to 18446744073709551615 UNSIGNED.

0 replies
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
answered
Junior Member

Thanks sveinungs... that worked!!

So I take it I'm going to have to repeat this process every time we reach 65000 shouts? If I keep pruning so as to not reach that total, will things be ok?
0 replies
S
Sveinungs
S
  • Veteran Member, joined since
  • Contributed 935 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

You could try to preview this code in custom page. It will drop and create new table for shoutbox. It should reset the darn thingie... :)

Code Download source
<?php
   $result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."shoutbox");
   $result = dbquery("CREATE TABLE ".$db_prefix."shoutbox (
   shout_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
   shout_name VARCHAR(50) NOT NULL DEFAULT '',
   shout_message VARCHAR(200) NOT NULL DEFAULT '',
   shout_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
   shout_ip VARCHAR(20) NOT NULL DEFAULT '0.0.0.0',
   PRIMARY KEY (shout_id)
   ) TYPE=MyISAM;");
?>
0 replies
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
answered
Junior Member

DarkMindZ - that's not it. I deleted, then reuploaded from "fresh" core files. No dice. I'm fairly convinced it's a database issue, not an issue with the shoutbox itself. Maybe what Matonor is suggesting is the answer...
0 replies
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
answered
Junior Member

I'll do that DarkMindZ.

Matonor - How do I reset the auto_increment value? I cleaned the shout table using the Shoutbox tool provided in the admin panel, but there is no other options there. Do I do it through phpMyAdmin or? I'm definitely not a php expert, but I'm fairly comfortable with it if I know where I'm looking.... can you point me in the right direction?

0 replies
M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

When you clean the shout table, make sure you also reset the auto_increment value
0 replies
D
DarkMindZ
D
DarkMindZ 10
--= I Learn The Rules To Break Them =--


--=[ www.darkmindz.com ]=--
  • Member, joined since
  • Contributed 78 posts on the community forums.
  • Started 6 threads in the forums
answered
Member

dame shoutbox :o ,its in the shoutbox it self.. just download a new one, but not the same one,, get the original one from the core files and test it and let me know
0 replies
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
answered
Junior Member

Darn.. I spoke too soon!!! A 'test' shout did show up (as you can see), but subsequent shouts are not showing up now...

And yes, by uninstall I do mean delete and reupload a new one.
0 replies
E
EricaLee
E
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 3 threads in the forums
  • Started this discussions
answered
Junior Member

Weird.. I had pruned them back to about 3000 shouts, and it didn't help.. but just now I deleted ALL shouts and it seems to be working again. Strange, but I'll take it!!

We definitely did have over 65000 shouts when it "broke" so I am guessing that was it.
0 replies
D
DarkMindZ
D
DarkMindZ 10
--= I Learn The Rules To Break Them =--


--=[ www.darkmindz.com ]=--
  • Member, joined since
  • Contributed 78 posts on the community forums.
  • Started 6 threads in the forums
answered
Member

yea i did not think of that.. maybe,, try it :)
0 replies
S
Sveinungs
S
  • Veteran Member, joined since
  • Contributed 935 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

It is a bit weird, indeed. The "shout_id" is smallint(5), so you'll have to have more than 65 000 shouts for that to run out, right?
But maybe pruning the shoutbox will help, I don't know... :|
0 replies
D
DarkMindZ
D
DarkMindZ 10
--= I Learn The Rules To Break Them =--


--=[ www.darkmindz.com ]=--
  • Member, joined since
  • Contributed 78 posts on the community forums.
  • Started 6 threads in the forums
answered
Member

oh lol thats weird :s so by uninstall u mean delete and re upload a new one?
0 replies
D
DarkMindZ
D
DarkMindZ 10
--= I Learn The Rules To Break Them =--


--=[ www.darkmindz.com ]=--
  • Member, joined since
  • Contributed 78 posts on the community forums.
  • Started 6 threads in the forums
answered
Member

i will look into it and let you know :)
0 replies

Category Forum

Official Core Support - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 13 posts
  • Votes 0 votes
  • Topic users 5 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet