MySQL error 1064

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi, i have this error

Error retrieving Account list:  Query Failed:  SELECT  accounts.* ,accounts_cstm.additional_c,accounts_cstm.adresa_robotodavtsya_c,accounts_cstm.adress_c,accounts_cstm.b2_id_c,accounts_cstm.bcz_id_c,accounts_cstm.channel_of_attraction_c,accounts_cstm.client_type_pole_c,accounts_cstm.data_c,accounts_cstm.data_foto_pasport_c,accounts_cstm.data_pochatku_prozhyvannya_c,accounts_cstm.data_pochatku_roboty_c,accounts_cstm.date_of_birth_c,accounts_cstm.date_of_issue_c,accounts_cstm.dodatkovyy_dokhid_c,accounts_cstm.fio_c,accounts_cstm.galuzi_robotodavtsiv_c,accounts_cstm.gender_list_c,accounts_cstm.gromadianstvo_c,accounts_cstm.inshuj_dok_c,accounts_cstm.job_c,accounts_cstm.kilkist_utrumantsiv_c,accounts_cstm.kod_edrpou_c,accounts_cstm.language_c,accounts_cstm.narodgenia_c,accounts_cstm.nazvabanku1_c,accounts_cstm.nazvabanku2_c,accounts_cstm.nazvabanku_c,accounts_cstm.no_c,accounts_cstm.ostnovnyy_dokhid_c,accounts_cstm.osvita_c,accounts_cstm.otdelenie_c,accounts_cstm.passport_c,accounts_cstm.password_c,accounts_cstm.phone_home_c,accounts_cstm.pochatkovasuma1_c,accounts_cstm.pochatkovasuma2_c,accounts_cstm.pochatkovasuma_c,accounts_cstm.posada_c,accounts_cstm.posada_text_c,accounts_cstm.propiska_c,accounts_cstm.prostrochka_c,accounts_cstm.recommendation_c,accounts_cstm.rezhum_robotu_c,accounts_cstm.series_c,accounts_cstm.shchomisyachnyyplatizh1_c,accounts_cstm.shchomisyachnyyplatizh2_c,accounts_cstm.shchomisyachnyyplatizh_c,accounts_cstm.simeynyy_stan_c,accounts_cstm.status_c,accounts_cstm.status_prozhyvannya_c,accounts_cstm.vip_c,accounts_cstm.vytraty_pozychalnyka_c,accounts_cstm.jjwg_maps_address_c,accounts_cstm.jjwg_maps_geocode_status_c,accounts_cstm.jjwg_maps_lat_c,accounts_cstm.jjwg_maps_lng_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner  , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner  , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod , jt3.name parent_name , jt3.assigned_user_id parent_name_owner  , 'Accounts' parent_name_mod , jt4.name campaign_name , jt4.assigned_user_id campaign_name_owner  , 'Campaigns' campaign_name_mod FROM accounts  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c   LEFT JOIN  users jt0 ON accounts.modified_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0  LEFT JOIN  users jt1 ON accounts.created_by=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0  LEFT JOIN  users jt2 ON accounts.assigned_user_id=jt2.id AND jt2.deleted=0

 AND jt2.deleted=0  LEFT JOIN  accounts jt3 ON accounts.parent_id=jt3.id AND jt3.deleted=0

 AND jt3.deleted=0  LEFT JOIN  campaigns jt4 ON accounts.campaign_id=jt4.id AND jt4.deleted=0

 AND jt4.deleted=0 where (accounts.phone_office = '380563703642') AND accounts.deleted=0 LIMIT 0,-98: MySQL error 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 '-98' at line 11

How do i fix this LIMIT error -98?

#2

Hi,
Please provide additional info to help you.

  1. SuiteCRM Version
  2. PHP Version
  3. MySQL Version

and Exact View like list view of accounts?

#3
  1. SuiteCRM - version 7.11.3
  2. PHP - version 5.6
  3. MariaDB 5.5
    I’m trying to get this account by API request, 3cx integraion …
#4

So there is any suggestion about this error - Limit 0, -98 ?

#5

It’s been a while since this question was posted, but I ran into the same problem today and a quick search led me to this unanswered thread.
The solution I found was adding pagination parameters, here is an example of my cURL request:

curl -g '{SUITECRM-URL}/Api/index.php/V8/module/Contacts?fields[Contacts]=id,name&page[number]=1&page[size]=100' -H "Authorization: Bearer TOKEN"

I didn’t need pagination, but this avoided the absurd “-98” limit, I don’t know why.

Note: Depending on your PHP configuration, you may need the “index.php” on the URL or not.

1 Like
#6

Thanks) Better late than never)