Chess Variant Pages Homepage

The site has moved to a new server, and there are now some issues to fix. Please report anything needing fixing with a comment to the homepage.

Discover and Play Various Games Similar to Chess

Chess has its origins in the Arabian game of Shatranj, which goes back to the Indian game of Chaturanga.

It is also related to Xiangqi in China, to Janggi in Korea, and to Shogi in Japan.

Many other games have been inspired by or based on Chess and its relatives. All of these games are similar to Chess yet also different from it in various ways.

Thanks to computers and the internet, it is now possible to play several of these Chess variants without physical boards and pieces. This website – The Chess Variant Pages – is here for cataloging, discussing, and playing the many games that are based on, related to, or similar enough to Chess.

Learn

Explore

Custom Search

Create

Contact

Play

Download computer programs for playing Chess variants

This site is supported by advertising and by donations. You can help out by making a small donation or by using this site's affiliate links when you shop at ebay.com or Amazon.com.

Credits

Author: Fergus Duniho.

Comments

Home page of The Chess Variant Pages. Homepage of The Chess Variant Pages.

Fergus Duniho wrote on 2023-02-04 EST

That happened to me too when I signed in after trying to change my password by email. Email is not working, and I didn't get the email it sent. When I signed in from the same page where I had tried to send an email for changing my password, it said "Cannot continue, because no row in the Person table could be identified." To change your password, do it within five minutes of signing in, or ask for assistance. Since you were able to sign in to post this, you should be able to do it within five minutes of signing in. Just click on the link with your name, or select "Personal Information" from the menu with your name, and then click on Change Password.

Maurice Dekker wrote on 2023-02-04 EST

Problem when trying to change password: "Cannot continue, because no row in the Person table could be identified."

Fergus Duniho wrote on 2023-02-04 EST

I thought of one more thing that could be going on, and I updated update_row to return a warning when it happens. This function now reads the row from the database and checks its values against the values you want to update, and it adds to the SQL query only those values that are different from what is already stored in the database. So, if you tried to update a comment without changing anything, it wouldn't add any values to the query. In case this happens, it will now exit early with a warning.

Fergus Duniho wrote on 2023-02-03 EST

I successfully tried updating a couple of my comments, including one on this page, and I successfully updated the comment you referred to, though that was with a different script than you would use. So, I have not been able to repeat what you did.

Looking at the PHP error log, I see multiple errors looking like this:

Failed to prepare SQL in update_row: UPDATE `Comment` SE WHERE `CommentID` = :keyvalue

This was added to the error log by a catch clause I have in update_row().

That "SE" shouldn't be there, but there should be the word "SET" followed by a series of parameters being assigned to table columns. Since we appear to be in the same time zone, these were just over an hour and a half ago, and I was not doing any programming then.

Looking at the individual lines modifying $sql, most lines just append to it, and one uses substr to delete the last two characters. That points to one thing that happened. The $sql string could have this value if it were passed an empty array. After appending nothing to "UPDATE Comment SET ", it chopped off the last two characters and appended " WHERE CommentID = :keyvalue". I added some code to update_row to catch this error before this happens, but I'm still not sure why it happened. This is about what arguments were passed in the function call and not about how the function operated.

Adam DeWitt wrote on 2023-02-03 EST

Also, I am getting this error whenever I try to update my previous comment:

Attempting to update comment.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `CommentID` = ?' at line 1

Update of Comment with ID of 46749 failed.

Number of ratings: 34, Average rating: Good, Number of comments: 542

List all comments and ratings for this item.

Add a comment or rating for this item.

Advertising Privacy

https://server.chessvariants.com/index.html
First Created: Sunday, January 15th, 1995
Last Modified: Friday, December 11th, 2015
File Timestamp: Wed, 14 Jul 2021 17:37:01 -0400
[info] [links] [edit]