Re: The number of attributes is larger than the number of attribute values provided (500)

[Dennis Lim]

Hi,

Sorry for late reply. Just came bank from out of town work.


Again, if I'm to help you with this, I'll need answers to ...

- if this error occurs with queries on some or all other schemas, tables & queries

So far, it has worked a several schemas, tables and queries. And so far, only this particular sql statement shows this error. I hope it is only this.


- if it occurs in MySQL WorkBench connected to your DB via ODBC, if so with other dbs, tables & queries

The statement works in Workbench.


- if a try/catch loop with traceback in VFP yields more info on the error

This is what comes out in VFP also:

DIAG [01000] [MySQL][ODBC 8.0(w)Driver][mysqld-8.0.30]The number of attributes is larger than the number of attribute values provided (500)


- whether issuing the MySQL cmd ...

set names utf8mb4;

If ran "set names utf8mb4" in VFP (via ODBC obviously) and it returns this:

[MySQL][ODBC 8.0(w)Driver][mysqld-8.0.30]SET NAMES not allowed by driver


Best Regards,