The Ultimate Guide to High Availability with MariaDB

Comments - unable to UPDATE, no errors, no update, what am I doing wrong?

 
3 years, 2 months ago Daniel Black
Re: unable to UPDATE, no errors, no update, what am I doing wrong? [Answer]

It looks like parentheses shouldn't be around the question mark.

Also sql_update_website_url_base should be just a string. Semicolons aren't needed in programming queries either (except for more complicated defining triggers/stored procedures etc).

so:

sql_update_website_url_base = "UPDATE websites SET url_base= ? WHERE entry_id = ?")

reference example.

 
3 years, 2 months ago Allan McCombs
Re: unable to UPDATE, no errors, no update, what am I doing wrong?

It feels like working today. Yesterday it complained about something near ? Today both ? and (?) are working. Thank you.

 
3 years, 2 months ago Daniel Black
Re: unable to UPDATE, no errors, no update, what am I doing wrong?

without the trailing )

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.