Shoutbox broken...
Asked Modified Viewed 1,475 times
asked
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....
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....
DarkMindZ
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
i will look into it and let you know :)
DarkMindZ
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
oh lol thats weird :s so by uninstall u mean delete and re upload a new one?
answered
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... :|
But maybe pruning the shoutbox will help, I don't know... :|
DarkMindZ
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
yea i did not think of that.. maybe,, try it :)
answered
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.
We definitely did have over 65000 shouts when it "broke" so I am guessing that was it.
answered
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.
And yes, by uninstall I do mean delete and reupload a new one.
DarkMindZ
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
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
answered
When you clean the shout table, make sure you also reset the auto_increment value
answered
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?
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?
answered
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...
answered
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;");
?> answered
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?
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?
answered
You can change the data type for shout_id in phpMyadmin.
Types will give you:
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.
Category Forum
Official Core Support - 6Labels
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