Re: The number of attributes is larger than the number of attribute values provided (500)
Posted by: Dennis Lim
Date: August 03, 2022 01:04AM

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,

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.