Known bug issues (Updated March 26th, 2006)

[Alkora]

Below is a list of bugs we KNOW about:

1.) Pageview/Imageview counters offline
Explanation: Has been disabled to stop counters from continuing on just by refreshing the page
Attempts to solve issue:
Tried using php sessions -> caused server to halt
Tried storing in DB -> caused database lag
Tried storing in cookie -> seemed to be the cause of the logout bug that occured a while back...I've been reluctant to try this again
Open to suggestions

2.) sql errors on submissions/comments/favs
Explanation: The user table is continually locking up and timing out, suspect innodb table structure?
Open to suggestions

3.) DOC/RTF file not shown
Explanation: Reading straight from the file obviously won't work right, I tried to search for a way to display these files properly, but was not entirely successful
Open to suggestions

4.) Thumbnail issues on user pages
Explanation: Some have noticed overly large images for their latest submission or featured work. This is NOT a thumbnail, this is actually a smaller version of your primary piece.
Suggested resolution: Tune down the image size for smaller versions, OR change the template to display the thumbnail instead.
Open to suggestions

5.) Message center comments
Explanation: submission or journal replies show up as "No Subject". This is because they are replies to a comment in the thread of a submission or journal, no subject refers to the comments subject, not the image or journal subject.
Suggested resolution: Change to have the subject be from the submission or journal instead.
Open to suggestions

[uncia2000]

Heya Jheryn,

Very good to see your master list for top-priority bugs.

D'you want replies/thoughts here and keep updating your first post/tidying up other posts, accordingly?

=
Re. #1 & #2 on the list. Good; InnoDB is new to me so you'll have to bear with me.
The explanation in the Overview (http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html) answers my previous question re. row-level locking (= one less possible issue).

I'm still unsure 'bout the mass of conditions on the SELECT and the logical transactions (e.g. lack of COMMIT points?) on the count UPDATES, amongst other possibilities. Still flying blind here, though.
*
Have you EXPLAIN (http://dev.mysql.com/doc/refman/5.0/en/explain.html)ed the data access paths to check point one and done a SHOW ENGINE (http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html) to check for over-running UPDATE locks on the count increments, confirming other locks are READ rather than UPDATE, etc., which could be blocking/stalling the system to check point two?

[Pico]

What about all the other bugs people have mentioned ?

[uncia2000]

What about all the other bugs people have mentioned ?
*points above*

"top-priority bugs" (I think)

And we'd be more than happy to see those resolved :)

[ArcturusWhoCannotLogin]

What about all the other bugs people have mentioned ?
*points above*

"top-priority bugs" (I think)

And we'd be more than happy to see those resolved :)

It does say 'Below is a list of bugs we KNOW about:' and not 'Below is a list of top-priority bugs:', so um..

[Myr]

What about all the other bugs people have mentioned ?It does say 'Below is a list of bugs we KNOW about:' and not 'Below is a list of top-priority bugs:', so um..The list of bugs in this thread does not match the lists in the administrator communications panel. I've been personally submitting reports (so have the other admins) on them through user feedback, and I've already seen some get fixed including the one I stumbled on. Some of the fixes are small and don't get a public notice and some of the fixes are big (like the reset password one) and get a public notice. What this list looks like is bugs/problems that are giving Jheryn some trouble or are confusing to users. He appears to be reaching out for suggestions and/or ideas/code help to solve some of the issues while explaining others.

Just my thoughts. >^.=.^<

[nrr]

1.) Pageview/Imageview counters offline
Explanation: Has been disabled to stop counters from continuing on just by refreshing the page
Attempts to solve issue:
Tried using php sessions -> caused server to halt
Tried storing in DB -> caused database lag
Tried storing in cookie -> seemed to be the cause of the logout bug that occured a while back...I've been reluctant to try this again
Open to suggestions
Table definitions:
CREATE TABLE submission_viewcounts (
user_id BIGINT UNSIGNED NOT NULL,
submission_id BIGINT UNSIGNED NOT NULL,
count_timestamp INT NOT NULL,
PRIMARY KEY (user_id, submission_id, count_timestamp)
);
CREATE TABLE submission_anon_viewcounts (
submission_id BIGINT UNSIGNED NOT NULL,
count_timestamp INT NOT NULL,
remote_ip CHAR(15),
PRIMARY KEY (submission_id, count_timestamp, remote_ip)
);
CREATE TABLE userpage_viewcounts (
viewer_id BIGINT UNSIGNED NOT NULL,
target_id BIGINT UNSIGNED NOT NULL,
count_timestamp INT NOT NULL,
PRIMARY KEY (viewer_id, target_id, count_timestamp)
);
CREATE TABLE userpage_anon_viewcounts (
target_id BIGINT UNSIGNED NOT NULL,
count_timestamp INT NOT NULL,
remote_ip CHAR(15),
PRIMARY KEY (target_id, count_timestamp, remote_ip)
);
An example to make it work:
/* on each request: */
/* initialize some stuff here */
$submission_id = 1;
$t = time();
$t -= $t % 86400; /* give it 24-hour granularity */

if (is_numeric($_GET["sid"]) and !is_null($_GET["sid"]))
{
$submission_id = (int)$_GET["sid"];
}

if ($session = get_remote())
{
mysql_query("REPLACE INTO submission_viewcounts VALUES "
. "(" . (int)$session["user_id"] . ", "
. (int)$submission_id . ", "
. (int)$t . ")");
} else
{
mysql_query("REPLACE INTO submission_anon_viewcounts VALUES "
. "(" . (int)$submission_id . ", "
. (int)$t . ", '"
. (string)$_SERVER["REMOTE_ADDR"] . "')");
}

$rs = array();
$q = mysql_query("SELECT COUNT(*) FROM submission_viewcounts UNION "
. "SELECT COUNT(*) FROM submission_anon_viewcounts");
/* this will return a set with two rows, so act accordingly */
$rs[] = mysql_fetchrow($q);
$rs[] = mysql_fetchrow($q);
$submission_viewcount = $rs[0][0] + $rs[1][0];
Here's how $session is defined, using C types, after calling get_remote():
$session = array("user_id" => uint64, "id" => uint64, "auth" => char[10]);
QED.

[Xax]

Okay, so I'm sure nrr (yes. yes he does. beaten!) or someone else will have lots of wonderful suggestions about the more esoteric coding parts, but here's the part I have advice on:

3.) DOC/RTF file not shown
Explanation: Reading straight from the file obviously won't work right, I tried to search for a way to display these files properly, but was not entirely successful
Open to suggestions
I am still of the opinion that .doc and .rtf suck exactly because they're hard to read, both for servers and for users, so I'd suggest forbidding new uploads with them (on the writing submit screen, have a little guide on how to save your Word documents as plaintext, it's not that hard) and then when the file is actually submitted, use some PHP reading function to prevent that oh-so-wonderful table stretching glitch. You'd want to display them as HTML because .txt files don't word wrap in most browsers, and that's just annoying to read.

One of the problems I've seen around on the site is that no one bothers to read the stuff submitted in .doc or .rtf form because the site can't read it and they'd have to download and open the writing themselves. Allowing only plaintext would fix that problem, because already most people do know how to save their files as plaintext, they just don't if they don't have to.

If people complain about absolutely /needing/ bold or italics or whatever other text-styling things, then you might want to consider adding the ability to submit .htm documents. I know you've had problems with injection in the past, but hopefully with all these new coders you could set something up that would strip out all javascript & other undesirables from the submitted document.

[Myr]

What about open documents (.odt)? They may be easier to read than .doc files and Open Office can convert from .doc to .odt no problem.

[Xax]

I know (think) Abiword's .abi extension is just XML, which could lead to some nice display stuff going on there... but really, most people who use OpenOffice use it because you can use it like Word, and that means more .doc files.

Plaintext is best for basic English, HTML + Unicode is best for multilingual text, and all the other formats are just confusing and annoying.

[Pico]

The list of bugs in this thread does not match the lists in the administrator communications panel. I've been personally submitting reports (so have the other admins) on them through user feedback, and I've already seen some get fixed including the one I stumbled on. Some of the fixes are small and don't get a public notice and some of the fixes are big (like the reset password one) and get a public notice. What this list looks like is bugs/problems that are giving Jheryn some trouble or are confusing to users. He appears to be reaching out for suggestions and/or ideas/code help to solve some of the issues while explaining others.

Just my thoughts. >^.=.^<
Yeah I guess, but there's a lot more than 5 that should at least be addressed, not necessarily fixed immediately but put into a public list so we can see what's being acknowledged and/or worked on.

[Almafeta]

3.) DOC/RTF file not shown
Explanation: Reading straight from the file obviously won't work right, I tried to search for a way to display these files properly, but was not entirely successful
Open to suggestions

Since RTF is a tagged text format like HTML, couldn't you just use a script to replace RTF's codes (such as par with <p>, b for <b>, b0 for </b>, and so on) with the appropriate HTML codes, automatically discarding irrelevant tags (metadata, pictures, proprietary tags that non-MS programs add)? The specification for RTF is here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnrtfspec/html/rtfspec.asp), and considering how close it is to HTML in syntax, it can't be that hard to write up a proper converter.

[nrr]

[...] it can't be that hard to write up a proper converter.
It's pretty trivial to validate RTF as well, given that spec.

[Sandragon]

I have post art without problem but right now when i post its do that little borring x .... and everybody seem to are able to post art ....and... my net work nicely cauz im able to surf on other site ...what happen to lil meh? ;__; ...

[Rouge2]

Warning: file(./templates/default_old/sidebar.htm): failed to open stream: No such file or directory in /usr/data/furaffinity/public_html/system/functions.sys on line 14

Warning: implode(): Bad arguments. in /usr/data/furaffinity/public_html/system/functions.sys on line 14

[cesarin]

plz dont forget that the fact that randomly, watches are removed!

[Trinitykat]

I'm not sure if this is the place to ask about it but I can't change my avitar picture its ether the one I have now or none, I keep trying to upload a new one but the system just replaces it with my old one what should I do?

[BlackWind_Zero]

hello i'd like to make a brief note to all that what ever problem is happening in the gallery that shows the error lock engaged 504 message is begining to show itself in the forums too after a post or before adding a new post just so you know. I miss logging in daily to view artwork and talk to my friends :( here is an error message
HTTP ERROR: 504

Gateway Timeout

RequestURI=http://www.furaffinity.net/login/

[yak]

That issue should be fixed now..
If you are still having problems with that, please update this thread and specify a time then this occured, either in GMT, or EST