Just upgraded and now I am getting 2 things when I try going to shoutbox.php
Division by zero from functions.php
and a cute lil sql error
Invalid SQL:
SELECT s.*, u.username AS absusername
FROM shoutbox_posts s
LEFT JOIN user u ON s.userid=u.userid
ORDER BY time DESC LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 7
mysql error number: 1064
Mind giving me a hand? Ran each upgrader step by step and did the index.php edit for the last bit (upgrade to 1.03) - no clue what's causing this
On RC4 btw
'B' must be my unlucky letter - this is the second time I've taken a release into letters and the second time I've had to go to 'C' because 'B' ++++ed something up.
I have 2 problems, small template based I am guessing but not to sure. my site is at http://www.ewevolved.com/forums now in the shoutbox I set it for the box to have only one shout is there anyway to make the box smaller though cause it's too big right now. Also on the shoutbox page itself the copyright stuff is on the right side at the top how can I fix this. Thanks for the help.
My server guys have thrown a hissy fit over this hack and I had to take it down. They say the tables aren't indexed properly.
You should consider also to create a seperate small shoutbox.php-file for the iframe. The iframe gets battered with refreshes on my site, and the smaller the script, the better.
On my site, http://www.xblgamers.com/forums, anytime we shout, the entire page reloads and kicks us to the top of the forums. Rather than just refreshing the SB. Plus the shoutbox.php is f'd looking and the buttons to the right of the "Shout Now!" are missing. Our main programmer did something last week. Not exactly sure what he did, so I'm asking you guys if you can figure out what the problems seem to be.
On my site, http://www.xblgamers.com/forums, anytime we shout, the entire page reloads and kicks us to the top of the forums. Rather than just refreshing the SB. Plus the shoutbox.php is f'd looking and the buttons to the right of the "Shout Now!" are missing. Our main programmer did something last week. Not exactly sure what he did, so I'm asking you guys if you can figure out what the problems seem to be.
Thanks!
First of all - the phrases aren't working. Go into the phrase manager and edit a phrase and save and see if it helps.
About it going back to the top of the forums - that's a problem that came when I removed to text box out of the iframe so it wouldn't be refreshed with the shouts. I don't know how to make it submit to the iframe without being in the iframe, so I dunno how to fix it.
My server guys have thrown a hissy fit over this hack and I had to take it down. They say the tables aren't indexed properly.
You should consider also to create a seperate small shoutbox.php-file for the iframe. The iframe gets battered with refreshes on my site, and the smaller the script, the better.
Run these queries and see if it helps then.
[sql]ALTER TABLE `shoutbox_posts` ADD INDEX ( `userid` ) ;
ALTER TABLE `shoutbox_posts` ADD INDEX ( `time` ) ;[/sql]
About the iframe shoutbox.php - I'll look into it.
[HTL] & [Normal] Shoutbox Hack - 1.03d Details »»
About Developer
Supported 
02-22-2004, 09:10 PM
