Adding FireFox in 7.6 bugged during update. Here is the fix.

Hangin' Around Joined: Nov 27, 2004 Posts: 37 Location: MN

When running the update file from 7.5 to 7.6, the sql row to add firefox fails. The sql query is incorrect.

Open file: upgrades/7.x/upgrade75-76.php

Bad code:

Code:

$db->sql_query("INSERT INTO ".$prefix."_counter VALUES (type='browser', var='FireFox', count='0')");

Replace it with this:

Code:

$db->sql_query("INSERT INTO ".$prefix."_counter (type, var, count) VALUES ('browser', 'FireFox', 0)");

Then run/re-run the sql update file. There is no harm done to the other areas of nuke when rerunning file. Unless you have since upgraded to somethign higher than 7.6. (7.6 is current as of this post). In that case, mark out with // the other lines that affect the sql.

Note, this is not affected in a full install.

Posted: Tue Nov 30, 2004 2:33 am

You might want to change the title of this post to something like:

"Statistics Module SQL Bug During Upgrade - Gecko Browsers"

I only say this as I was confused about what this post was about, but then again, I've been up for 20 hours.

I use my own statistics module (as I wrote it as the first solution to detect Firefox, Safari and Mozilla browsers for PHP-Nuke), but I guess we have grown to expect other new bugs now that FB has finally gotten around to simply adding Firefox... 6 or 7 months after the rest of us added it.

Smile

Thanks for the heads up.
The bug does not exist in new installations, just upgrades.