Add customer address error in JSON API

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
traiyani75
Advanced
Posts: 114
Joined: 08 Nov 2019, 11:56

Add customer address error in JSON API

Post by traiyani75 » 10 Apr 2020, 06:24

We are using JSON API into mobile applications. But after the last update, we start getting an error on adding customer address
"title": "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens: \n\t\t\t\t\t\tINSERT INTO \"users_address\" ( \n\t\t\t\t\t\t\t\"parentid\", \"company\", \"vatid\", \"salutation\", \"title\",\n\t\t\t\t\t\t\t\"firstname\", \"lastname\", \"address1\", \"address2\", \"address3\",\n\t\t\t\t\t\t\t\"postal\", \"city\", \"state\", \"countryid\", \"langid\", \"telephone\",\n\t\t\t\t\t\t\t\"email\", \"telefax\", \"website\", \"longitude\", \"latitude\",\n\t\t\t\t\t\t\t\"pos\", \"mtime\", \"editor\", \"siteid\", \"ctime\"\n\t\t\t\t\t\t) VALUES ( \n\t\t\t\t\t\t\t?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?\n\t\t\t\t\t\t)\n\t\t\t\t\t",
This is error which we are getting now. Please suggest

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Add customer address error in JSON API

Post by aimeos » 11 Apr 2020, 07:51

If you use the dev-master version, the birthday column is missing in your custom SQL
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply