Unexpected error

Using Concrete / Help
1

I don’t have a clue. Can anyone help ?

An unexpected error occurred.

An exception occurred while executing ‘ALTER TABLE AosAnimations CHANGE startoffset offset INT NOT NULL’: 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 ‘offset INT NOT NULL’ at line 1

2

The error you’re encountering is due to the use of the word offset as a column name in your ALTER TABLE statement. In MariaDB (and MySQL), OFFSET is a reserved keyword used in SELECT queries for pagination, which causes a syntax conflict when used unquoted in DDL statements.

You need to quote the column name offset using backticks to avoid the conflict:

ALTER TABLE AosAnimations CHANGE startoffset `offset` INT NOT NULL;
3

Hi mate
If you had written the reply in mandarin it wouldn’t be more complicated. Straight over the top of my head that one but thanks for answering David. I think I’ll look for an alternative add-on.
Terry

4

Hi Terry
Get in touch with the developer and ask him to take a look in his code for you.

5

I have. Thanks David