Error when clicking on metreboard

[jainser]

Is this something I should we worried about!! :lol:
[i]Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1' at line 1 in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php:38 Stack trace: #0 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(38): mysqli_query(Object(mysqli), 'SELECT member_i...') #1 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(94): phpmysqli->query('SELECT member_i...', 1, false) #2 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(100): phpmysqli->row(Array) #3 /home/fssandbox/www/www/meterboard3/mb3-class-Rower.php(185): phpmysqli->get('mb2_Members', 'member_id', '`member_C2id` =...') #4 /home/fssandbox/www/www/meterboard3/mb3-main-board.php(71): Rower->getMemberIDFromC2ID(NULL) #5 /home/fssandbox/www/www/meterboard3/index.php(42): require_once('/home/fssandbox...') #6 {main} thrown in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php on line 38[/i]

[JonT]

Thanks for the message.

I am not getting an error when I go to the Meterboard. Can you tell me a bit more about what you were doing when this happened? What link did you follow to get to the board? Were you trying to view the whole board or the profile of yourself or another rower? Do you still see the error when you follow this link?

Is anyone who reads this getting an error?

Jon


Sent from my iPhone using Tapatalk

[jainser]

Hey Jon, Yes still get the error when i follow the link. Happens at work on windows and home on mac (if that helps)

[Ian Bee]

For info, no error when using android/chrome with either the banner link or your post link.

[plummy]

No error just now when clicking on the meterboard

[JonT]

Thanks Ian and Plummy for confirming. A bit of a puzzle this one.

Jainser, I will send you a message.

[fkoene]

Is this something I should we worried about!!
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1' at line 1 in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php:38 Stack trace: #0 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(38): mysqli_query(Object(mysqli), 'SELECT member_i...') #1 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(94): phpmysqli->query('SELECT member_i...', 1, false) #2 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(100): phpmysqli->row(Array) #3 /home/fssandbox/www/www/meterboard3/mb3-class-Rower.php(185): phpmysqli->get('mb2_Members', 'member_id', '`member_C2id` =...') #4 /home/fssandbox/www/www/meterboard3/mb3-main-board.php(71): Rower->getMemberIDFromC2ID(NULL) #5 /home/fssandbox/www/www/meterboard3/index.php(42): require_once('/home/fssandbox...') #6 {main} thrown in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php on line 38

Does it make a difference whether you're logged in or not?
In my case both options work okay, strange thing this indeed.

[Huw Thomas]

If you mouseover Meterboard on Mac you get an exploding menu

Screenshot 2026-02-18 at 23.24.01.png (211.13 KiB) Viewed 343 times

If you click on lifetime millionaires in the expanded dropdown bit it works fine

If you click on the blue menu Meterboard rather than the the dropdown bit you get

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1' at line 1 in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php:38 Stack trace: #0 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(38): mysqli_query(Object(mysqli), 'SELECT member_i...') #1 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(94): phpmysqli->query('SELECT member_i...', 1, false) #2 /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php(100): phpmysqli->row(Array) #3 /home/fssandbox/www/www/meterboard3/mb3-class-Rower.php(185): phpmysqli->get('mb2_Members', 'member_id', '`member_C2id` =...') #4 /home/fssandbox/www/www/meterboard3/mb3-main-board.php(71): Rower->getMemberIDFromC2ID(NULL) #5 /home/fssandbox/www/www/meterboard3/index.php(42): require_once('/home/fssandbox...') #6 {main} thrown in /home/fssandbox/www/www/meterboard3/mb2-phpmysqli.php on line 38

[JonT]

I’ll take a look.


Sent from my iPhone using Tapatalk

[JonT]

Huw can you click on your profile picture (top right of the forum). Select User Control Panel. Select Profile and fill in your Concept2 Ranking id (which I think is blank). Then tell me if that fixes the issue.

If that is the problem then I need to fix the code so that it doesn't implode if someone has not entered their C2 id here. The meterboard doesn't actually need that field, but for some reason fails if it is empty.

Jon

[Huw Thomas]

Huw can you click on your profile picture (top right of the forum). Select User Control Panel. Select Profile and fill in your Concept2 Ranking id (which I think is blank). Then tell me if that fixes the issue.

If that is the problem then I need to fix the code so that it doesn't implode if someone has not entered their C2 id here. The meterboard doesn't actually need that field, but for some reason fails if it is empty.

Jon

yep that fixed it

[JonT]

I have finally got around to navigating the labyrinth of the meterboard code and making a change which I hope means that this will not happen again, even if the C2 id has not been set in the user profile of the forum. Shout if I have inadvertently broken something along the way.

Jon